Severity: 8192
Message: strstr(): Passing null to parameter #1 ($haystack) of type string is deprecated
Filename: controllers/listing.php
Line Number: 120
Henderson > 89044 > Madeira Canyon > 2704 Chateau Clermont St
Breathtaking location in gated Madeira Canyon, nestled next to Sloan Canyon Preserve on two sides of the property with majestic mountain views! This tranquil location on a culdesac has no direct neighbors. Property has been completely upgraded with modern front gates, new exterior and interior paint, Pebble Tec driveway, and solar power that averages $19/mo for electric bills. The kitchen has had a complete remodel w/ chic white cabinets and luxurious quartz counters and new double ovens. The home exudes an inviting aura with its open floor plan, illuminated by natural light, enhanced by elegant shutters, ceramic tile flooring and spacious layout. Sitting on 1/3 acre the exterior of the property is meant to be enjoyed with a refreshing pool with sheer descent waterfalls & fire features, built in BBQ, covered patio and the most spectacular mountain views. The casita, accessed from the courtyard, features a built in Murphy Bed, walk in closet and full bath. Flawless condition, turn key.
Severity: 8192
Message: strstr(): Passing null to parameter #1 ($haystack) of type string is deprecated
Filename: VHV/listing.php
Line Number: 623
Breathtaking location in gated Madeira Canyon, nestled next to Sloan Canyon Preserve on two sides of the property with majestic mountain views! This tranquil location on a culdesac has no direct neighbors. Property has been completely upgraded with modern front gates, new exterior and interior paint, Pebble Tec driveway, and solar power that averages $19/mo for electric bills. The kitchen has had a complete remodel w/ chic white cabinets and luxurious quartz counters and new double ovens. The home exudes an inviting aura with its open floor plan, illuminated by natural light, enhanced by elegant shutters, ceramic tile flooring and spacious layout. Sitting on 1/3 acre the exterior of the property is meant to be enjoyed with a refreshing pool with sheer descent waterfalls & fire features, built in BBQ, covered patio and the most spectacular mountain views. The casita, accessed from the courtyard, features a built in Murphy Bed, walk in closet and full bath. Flawless condition, turn key.
Severity: 8192
Message: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: VHV/listing.php
Line Number: 1234
Severity: 8192
Message: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: VHV/listing.php
Line Number: 1235
Directions to 2704 Chateau Clermont St: From Eastern go South to Anthem Parkway. West on Bicentennial. South on Anthem Highlands. East on Democracy to Chateau Clermont in Videiras gated community in Madeira Canyon
Severity: 8192
Message: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: VHV/listing.php
Line Number: 1241
Severity: 8192
Message: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: VHV/listing.php
Line Number: 1249
Low Cost Financing Available
only takes about 60 seconds & will not affect your credit
Severity: 8192
Message: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated
Filename: VHV/listing.php
Line Number: 1460
Please enter your information to login or Sign up here.
Please enter your email and we'll send you an email message with your password.
Already have account? Sign in.
Already have an account? Sign in.