Breathtaking home with access to the largest amenity center in North Texas! Inviting 42” front entry door, lovely vaulted ceilings and elegant crown moulding. Cozy corner fireplace with gas logs. Stunning hardwood flooring throughout and ceramic tile flooring in all baths and utility room. Luxurious master bath features a framed mirror, large shower and separate garden tub. Gourmet kitchen includes modern built-in stainless steel appliances, gorgeous granite countertops and an undermount kitchen sink. Home also includes rounded corners, security system, fully sodded yard, zone irrigation system, low-E vinyl windows, radiant barrier decking, high efficiency tankless gas water heater, ENERGY STAR 3.0® certified.
Single-familyProperty Type
2017Year Built
9,583 sq ftLot Size
$232Est. Price/Sq.Ft.
3 car garageParking
Listed by Jimmy Brownlee• K. Hovnanian Homes-DFW, L.L.C.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
5
Baths
5.5
Stories
2
Lot width
—
Lot depth
—
Lot size
9,827 Sq. Ft.
Year renovated
2017
Sq. Ft.
4,324
Year built
2017
Style
Single Family Residential
County
Collin County
APN
R-11034-00F-0040-1
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 19, 2026.
PD
Planned Development District
The planned development district is established to permit flexibility and encourage a more creative, efficient, and aesthetically desirable design and placement of buildings, open spaces, and circulation patterns by allowing a mixture or combination of uses, and utilizing special site features such as topography, size, and shape. A planned development district may be used to permit new or innovative concepts in land utilization not permitted by a single zoning district within this zoning ordinance. While greater flexibility is given to allow special conditions or restrictions that would not otherwise allow certain development to occur, the requirements established herein ensure against misuse of increased flexibility.
Permitted uses
Include but are not limited to:
Greenhouse / nursery
Bank
General retail
Restaurant
Hospital / medical center
Hotel / motel
Office
Public service
Amusement facility
Property details
Parking
Parking Information
Carport Spaces: 0
Covered Spaces: 3
Open Parking Spaces: 0
Parking Features: Garage, Garage Door Opener, Garage Faces Front
Parking & Garage
Has Garage
Has Attached Garage
Garage Spaces: 3
Garage Width: 20
Garage Length: 20
Interior
Virtual Tour
Bathroom Information
Bathrooms Full: 5
Bathrooms Half: 1
Bathrooms Total Decimal: 5.1
Bathrooms Total Integer: 6
Bedroom Information
Bedrooms Total: 5
Fireplace Information
Fireplaces Total: 1
Fireplace Features: Gas Logs, Heatilator
Heating & Cooling
Cooling: Ceiling Fan(s), Central Air, Electric
Heating: Central, Natural Gas
Interior Features
Appliances: Dishwasher, Disposal, Electric Oven, Gas Cooktop, Microwave, Plumbed For Gas in Kitchen, Plumbed for Ice Maker
Number Of Living Areas: 1
Number Of Dining Areas: 2
Living Area: 4321.00
Levels: Two
Flooring: Carpet, Ceramic Tile, Wood
Interior Features: Cable TV Available, Decorative Lighting, Sound System Wiring, Vaulted Ceiling(s)
Window Features: Bay Window(s)
Exterior
Building Information
Roof: Composition
Construction Materials: Brick, Rock/Stone
Foundation Details: Slab
Exterior Features
Exterior Features: Covered Porch(es), Gutters
Fencing: Wood
Farm Information
Barns Count: 0
Lot Information
Lot Features: Few Trees, Interior Lot, Landscaped, Lrg. Backyard Grass, Sprinkler System, Subdivision
Green Energy Efficient: Appliances, HVAC, Insulation, Rain / Freeze Sensors, Thermostat, Windows
Energy Saving Features: High Efficiency Water Heater
Location
HOA Information
Association Fee Includes: Maintenance Structure, Management Fees
Association Type: Mandatory
Association Fee: 139
Association Fee Frequency: Monthly
HOA Management Company: See Sales Consultant
HOA Management Company Phone: 0
School Information
Elementary School: Cynthia A Cockrell
Elementary School Name: Cynthia A Cockrell
High School: Prosper
High School Name: Prosper
Middle Or Junior School: Reynolds
Middle School Name: Reynolds
School District: Prosper ISD
Location Information
County Or Parish: Collin
Directions: Go north on Preston Rd. past US Hwy 380. Turn right on frontier Pkwy. and left on Waterview Trail or go north on Dallas N. Tollway to US Hwy 380 and turn right on Custer. Turn left on Frontier Pkwy to the community on the right.
Latitude: 33.26567800
Longitude: -96.74244600
Subdivision Name: Mustang Lakes Waterview
Community Information
Community Features: Club House, Community Pool, Greenbelt, Jogging Path/Bike Path, Lake, Park, Playground, Tennis Court(s)
Public facts
Beds: 5
Baths: 5.5
Sq. Ft.: 4,324
Stories: 2.0
Lot Size: 9,827 square feet
Style: Single Family Residential
Year Built: 2017
Year Renovated: 2017
County: Collin County
APN: R-11034-00F-0040-1
Home facts updated by county records on Sep 18, 2026
Other
Green Verification Information
Green Verification Count: 2
Listing Information
Listing Agreement: Exclusive Agency
Listing Id: 13574944
Listing Key Numeric: 69248750
Listing Terms: Not Assumable
Mls Status: Closed
Originating System Name: North Texas Real Estate Information Systems
Photos Count: 26
Possession: Closing/Funding
Seller Contributions: 4000
Standard Status: Closed
Third Party Assistance Program Y: No
Transaction Type: For Sale
Listing Date Information
Days On Market: 150
Cumulative Days On Market: 150
Close Date: 2017-09-29
Purchase Contract Date: 2017-09-10
Listing Contract Date: 2017-04-07
Off Market Date: 2017-09-10
Price Change Timestamp: 2017-09-01T08:32:39.243
Status Change Timestamp: 2017-10-02T11:58:22.970
Listing Price Information
Original List Price: 595900.00
Previous List Price: 564900.00
List Price: 559900.00
RATIO Close Price By Lot Size Ac: 2386363.63636
RATIO Current Price By Lot Size: 2386363.63636
Around this home
Schools
Sam Johnson Elementary School
Public K-5 • Assigned • 0.3mi
9/10
Walnut Grove High School
Public 9-12 • Assigned • 2.7mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
4/10 Fire Factor
2% chance of being in a wildfire in next 30 years
7/10 Heat Factor
7 days above 109° expected this year, 23 days in 30 years
6/10 Wind Factor
27% chance of strong winds in next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Celina, TX • 75009
Average low and high temperatures (°F)
53
32
64
40
75
52
77
59
83
64
90
74
94
75
93
74
89
68
84
61
71
50
61
42
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.9 hours in
June and 5.5 hours in December, placing it above the
U.S. average for solar exposure.
9.9 hrs
5.5 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$953,000 – $1.15M
Reach more buyers when you sell with Redfin. Save up to $10,029 in fees.3 minutes to get started.