Better than new construction with approximately $45,000 in luxurious upgrades, window coverings with some built-in shutters, great backyard already installed & very close proximity to the Ranch House community pool/spas/clubhouse!divWelcome to this charmingly stunning 3 Bedroom, 2 Bath Home in Award-Winning Tesoro Viejo!brDiscover your dream home in this highly sought-after active community! This beautifully designed, extremely well maintained residence features 3 spacious bedrooms & 2 full baths, with the primary suite isolated from the guest bedrooms & bathroom. Again, this home showcases over $45,000 in upgrades! Enjoy the elegance of plank tile floors throughout the living spaces with cozy carpet in the bedrooms, all creating a seamless flow in this modern space.brThe home offers the convenience of indoor laundry and a thoughtfully designed easy-care backyard, perfect for outdoor gatherings or peaceful relaxation. Located just a stone's throw away from the famed community Ranch House with an unbelievable pool, 2 spas & entertaining facilities, providing the perfect balance of leisure & resort living lifestyle. Plus, enjoy access to scenic trails right at your doorstep.brBuilt in 2022, this home combines modern amenities with a welcoming community feel. Don't miss your chance to be part of this exceptional neighborhood!/div
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$311
Price Per Acre
$5,500,000
Days On Market
0
Cumulative Days On Market
0
County
Madera
Reports Available
NHD, Prelim Title Report
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Treasure Hills Drive & Terrace
Directions
Highway 41 headed north, turn right at Tesoro Viejo Blvd., at round-about take 3rd exit onto Treasure Hills Drive. At school, turn left into Terrace Road, turn left on Orchard Hills Road, follow around, home on right.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Pool, Spa, Club House, Exercise Room, Green Area, Playground, Landscape Maint, Other/None
HOA Dues
207.50
Frequency
monthly
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Spring Valley
School Type 3
Grade School
School Name 3
Spring Valley
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 418000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 462000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1165 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1665 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1696862 OR `props-main`.`id` = 1691781 OR `props-main`.`id` = 1636330 OR `props-main`.`id` = 1683083 OR `props-main`.`id` = 1691114 OR `props-main`.`id` = 1691255 OR `props-main`.`id` = 1691700 OR `props-main`.`id` = 1678785 OR `props-main`.`id` = 1683821 OR `props-main`.`id` = 1686409 OR `props-main`.`id` = 1656927 OR `props-main`.`id` = 1679969 OR `props-main`.`id` = 1682059 OR `props-main`.`id` = 1683325 OR `props-main`.`id` = 1698975 OR `props-main`.`id` = 1684863 OR `props-main`.`id` = 1699174 OR `props-main`.`id` = 1696836 OR `props-main`.`id` = 1695400 OR `props-main`.`id` = 1685313 OR `props-main`.`id` = 1674966 OR `props-main`.`id` = 1678853 OR `props-main`.`id` = 1679056 OR `props-main`.`id` = 1691022 OR `props-main`.`id` = 1657513 OR `props-main`.`id` = 1695893 OR `props-main`.`id` = 1693967 OR `props-main`.`id` = 1698070 OR `props-main`.`id` = 1699189 OR `props-main`.`id` = 1692547 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1695769 OR `props-main`.`id` = 1687049 OR `props-main`.`id` = 1695774 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641374' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-26' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
6
Similar Properties
$450,000
3
2.5
1,581
0.09
4313 Horizon Dr
Madera, CA 93636
$430,000
3
2
1,510
0.08
4035 Braden
Madera, CA 93636
$429,900
3
2.5
1,602
0.08
724 Arrowhead Dr
Madera, CA 93636
$429,900
3
2.5
1,651
0.04
554 Mccaffrey Way
Madera, CA 93636
Courtesy of Lisa Garver, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 14 minutes ago
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
