Modern design. Great location. Located on a calm cul-de-sac. Premium corner lot with oversized yard. Tons of upgrades. Newer construction (built in November 2022).This magnificent home is packed with many upgrades! Host memorable dinner parties in the expansive two-story great room. The owner’s suite located on the main floor is a private sanctuary, featuring a spa-like bathroom with dual vanities, a large soaking tub, and an oversized shower. A dedicated study on the main floor for working from home, while the upstairs loft is perfect for family time and is fully wired for surround audio system! Three additional bedrooms upstairs, including one bedroom with its own ensuite bathroom and walk-in closet, complete the layout.
Single-familyProperty Type
2022Year Built
6,752 sq ftLot Size
$257Est. Price/Sq.Ft.
2 car garageParking
Listed by Steven Koleno• Beycome Brokerage Realty LLC
Contact: 804-656-5007
Bought with Sumedha Gokhale• D&B Brokerage Services LLC
*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
Permits
Beds
6
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
6,754 Sq. Ft.
Year renovated
2022
Sq. Ft.
3,211
Year built
2022
Style
Single Family Residential
County
Collin County
APN
R-11834-00B-0390-1
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 6, 2026.
PH
PD-238
Patio Home District
The PH Patio Home District is provided to allow for development of zero-lot line homes in a modified residential district, which encourages greater use of the side yard areas. Clustered lot patterns with a common usable open space system can be incorporated as an integral part of the development.
Zone overlays
Permitted uses
Include but are not limited to:
Agriculture
Ranch
Housing-Single unit
Infrastructure-Other
Office
Public service
Educational/school
Golf related
Sports arena / stadium
Park & open space
Nov 17, 2022 • Final
Building
Construct a new two-story residential building.
New construction
Permit history is from public records and may be incomplete or inaccurate. Redfin and its agents make no representations about the property condition or permit status. Buyers should independently verify all information.
Property details
Parking
Parking Information
Carport Spaces: 0
Covered Spaces: 2
Parking Features: See Remarks
Parking & Garage
Has Garage
Has Attached Garage
Garage Spaces: 2
Interior
Virtual Tour
Bathroom Information
Bathrooms Full: 3
Bathrooms Half: 1
Bathrooms Total Decimal: 3.1
Bathrooms Total Integer: 4
Bedroom Information
Bedrooms Total: 4
Fireplace Information
Fireplaces Total: 0
Interior Features
Room Count: 11
Appliances: Dishwasher, Disposal, Gas Cooktop, Gas Range, Gas Water Heater, Microwave, Plumbed For Gas in Kitchen, Tankless Water Heater, Vented Exhaust Fan
Number Of Living Areas: 0
Number Of Dining Areas: 1
Living Area: 3211.00
Levels: Two
Interior Features: Cable TV Available, Double Vanity, Flat Screen Wiring, High Speed Internet Available, Kitchen Island, Loft, Open Floorplan, Sound System Wiring, Walk-In Closet(s), Wired for Data
Room 1 Information
Room Type: Primary Bedrm
Room Level: 1
Room Dimensions: 15 x 17
Room Length: 15.00
Room Width: 17.00
Room 2 Information
Room Type: Primary Bathrm
Room Level: 1
Room Dimensions: 8 x 14
Room Length: 8.00
Room Width: 14.00
Room 3 Information
Room Type: Kitchen
Room Level: 1
Room Dimensions: 10 x 15
Room Length: 10.00
Room Width: 15.00
Room 4 Information
Room Type: Office
Room Level: 1
Room Dimensions: 12 x 12
Room Length: 12.00
Room Width: 12.00
Room 5 Information
Room Type: Laundry
Room Level: 1
Room Dimensions: 6 x 12
Room Length: 6.00
Room Width: 12.00
Room 6 Information
Room Type: Half Bath
Room Level: 1
Room Dimensions: 5 x 5
Room Length: 5.00
Room Width: 5.00
Room 7 Information
Room Type: Bedroom
Room Level: 2
Room Dimensions: 12 x 14
Room Length: 12.00
Room Width: 14.00
Room 8 Information
Room Type: Bedroom
Room Level: 2
Room Dimensions: 13 x 8
Room Length: 13.00
Room Width: 8.00
Room 9 Information
Room Type: Bedroom
Room Level: 2
Room Dimensions: 12 x 14
Room Length: 12.00
Room Width: 14.00
Room 10 Information
Room Type: Bathroom
Room Level: 2
Room Dimensions: 12 x 14
Room Length: 12.00
Room Width: 14.00
Room 11 Information
Room Type: Great Room
Room Level: 1
Room Dimensions: 25 x 16
Room Length: 25.00
Room Width: 16.00
Exterior
Lot Information
Lot Size: Less Than .5 Acre (not Zero)
Lot Size Acres: 0.1550
Lot Size Area: 0.1550
Lot Size Square Feet: 6751.8000
Lot Size Units: Acres
Parcel Number: R1183400B03901
RATIO List Price By Lot Size Acr: 5677412.90323
Will Subdivide: No
Property Information
Property Type: Residential
Property Sub Type: Single Family Residence
Accessibility Features YN: No
Property Attached YN: No
Multi Parcel IDYN: No
Property Key: 48085|R1183400B03901|1|266214636
Property Match: APN
US Property MUI: 411521995
Building Information
Year Built: 2022
Smart Home Features Appor Pass Y: No
Financial
Tax Information
Tax Block: B
Tax Legal Description: THE RETREAT AT STONEBRIAR PHASE 2 (CFR), BLK
Tax Lot: 39
Unexempt Taxes: 13116
Financial Information
Buyer Financing: Conventional
Loan Type: Treat As Clear
Second Mortgage YN: No
Utilities
Utility Information
Municipal Utility District YN: No
Utilities: City Sewer, City Water
Location
HOA Information
Association Fee Includes: Maintenance Grounds
Association Type: Mandatory
Association Fee: 81
Association Fee Frequency: Monthly
HOA Management Company: Essex Association Management
HOA Management Company Phone: 971-272-5396
School Information
Elementary School: Smith
Elementary School Name: Smith
High School Name: Lebanon Trail
Middle School Name: Clark
School District: Frisco ISD
Location Information
County Or Parish: Collin
Country: United States
Directions: Head north on Preston Rd, turn right onto Main St, then left onto Legacy Dr, and finally right onto Stillhouse Rd.
Latitude: 33.10665900
Longitude: -96.79235900
Geocode Confidence: High
Subdivision Name: The Retreat At Stonebriar Ph 2
Public facts
Beds: 6
Baths: 3.5
Sq. Ft.: 3,211
Stories: 2.0
Lot Size: 6,754 square feet
Style: Single Family Residential
Year Built: 2022
Year Renovated: 2022
County: Collin County
APN: R-11834-00B-0390-1
Home facts updated by county records on Nov 6, 2026