Here's your opportunity to own a brand new home with solar power in the award-winning Tesoro Viejo communitywhere lifestyle and comfort come together. This vibrant neighborhood offers top-tier amenities including the resort-style Ranch House clubhouse with a sparkling pool, multiple scenic parks, Axis Coffee & Eatery, and miles of hiking and biking trails for outdoor enjoyment. Step inside to discover a bright, open-concept layout perfect for modern living. The stylish kitchen features a central island, sleek finishes, and opens seamlessly into the spacious living and dining areasideal for entertaining or everyday living. The thoughtfully designed split floor plan offers privacy and functionality, with guest bedrooms and a full bathroom located at the front of the home, while the luxurious Primary suite is tucked away in the back. The Primary retreat includes a large walk-in closet and an en-suite bathroom for ultimate relaxation. Enjoy outdoor living in the finished backyard, complete with a generous patio spaceready for gatherings or quiet evenings under the stars. No need to wait for new constructionthis move-in ready home is available now. Don't miss your chance to become part of the Tesoro Viejo lifestyle. Schedule your tour today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2025
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$286
Price Per Acre
$5,785,714
Days On Market
77
Cumulative Days On Market
206
County
Madera
REO / Bank Owned
No
Cross Street Address
41/Tesoro Viejo Blvd
Directions
From Hwy 41 and Tesoro Viejo Blvd, head East on Tesoro Viejo Blvd. Take first exit on roundabout. Left on Brayden. Left on Ash.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, In Closet
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Garage Type
Attached
Garage Spaces
2
APN
081 442 013 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Security Guard, Playground, Landscape Maint, Other/None
HOA Dues
200.00
Frequency
monthly
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Hillside
School Type 3
Grade School
School Name 3
Hillside
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 384750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 425250 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` = 1690899 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` = 1684859 OR `props-main`.`id` = 1683571 OR `props-main`.`id` = 1682059 OR `props-main`.`id` = 1683325 OR `props-main`.`id` = 1689718 OR `props-main`.`id` = 1684863 OR `props-main`.`id` = 1671621 OR `props-main`.`id` = 1663724 OR `props-main`.`id` = 1660730 OR `props-main`.`id` = 1685313 OR `props-main`.`id` = 1674966 OR `props-main`.`id` = 1678853 OR `props-main`.`id` = 1683597 OR `props-main`.`id` = 1679056 OR `props-main`.`id` = 1691022 OR `props-main`.`id` = 1657513 OR `props-main`.`id` = 1693967 OR `props-main`.`id` = 1691515 OR `props-main`.`id` = 1691871 OR `props-main`.`id` = 1692547 OR `props-main`.`id` = 1687049)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636395' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-18' 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();
2
Similar Properties
$404,490
3
2.5
1,456
0.07
765 Laina Ave
Madera, CA 93636
$385,790
3
2.5
1,227
0.07
768 Laina Ave
Madera, CA 93636
Courtesy of Braithan Stoltenberg, eXp Realty of California, Inc. - [email protected] Last modified 1 month ago Fresno MLS last checked for updates 19 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.
