This home is the least expensive cost per sq ft listing in Tesoro Viejo! Owned Solar Junior Suite Over $80,000 in Upgrades This fabulous like new 4 plus bedrooms and 3.5 bathrooms very desirable Ivy Collection Hickory Model is priced for immediate sale, and sellers are very motivated. This outstanding floor plan with a junior suite downstairs and a primary suite upstairs is a well designed home for a wonderful lifestyle for every member of the family. The entryway features a beautiful chandelier that welcomes you to a very spacious great room. The kitchen is a chef's dream come true with a huge eating island for your entertaining and everyday dining needs. Enjoy the beautiful designer granite countertops with decorative backsplash, upgraded hood over the gas cooktop, and a very large walk in pantry. (The refrigerator is included.) In addition there is a very large dining room area. Nearby is a special well utilized area and a very handy and functional home management room for office space, game room area or homework with outstanding spacious cabinetry. The very desirable junior suite is downstairs with loads of privacy and its own full bathroom. The upgraded staircase leads to the three bedrooms and 2 bathrooms upstairs including the huge primary suite with a fabulous walk-in closet, fabulous designer bathroom with shower and separate tub. The handy laundry room nearby has even a view to the front of the home where you can watch children walk to school. (Washer and dryer are included.) The large easy care rear yard is well designed with an extended covered patio and grass areas for hours of enjoyment and play. The grass in the front of this home is synthetic lawn. The extended driveway with concrete areas with three car garages are completely finished and textured including beautiful epoxy flooring for easy care and maintenance. Included is one very large hanging mounted storage unit. This home is in one of the most desirable locations at Tesoro Viejo in close walking distance to the school (K-8), the amazing Ranch house with swimming pools and spas etc. plus great walking trails, parks and weekly farmer's markets, restaurants and more.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2021
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
front
Price Per Square Foot
$224
Days On London
144
Cumulative Days On London
144
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Directions
Take Highway 41 North to Ave 15 onto Tesoro Viejo Blvd. Follow signs at roundabout and go past Ranchhouse to the very desirable Treasure Hills Drive to your new home.
Room Type
Office, Family Room
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside, Electric Dryer Hookup
Window Features
Double Pane Windows
Main Level Bedrooms
1
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
Community
Pool Private Y/N
No
Spa Y/N
Yes
Spa Features
Community
Patio Y/N
Yes
Patio And Porch Features
Covered, Concrete
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Sprinklers In Front, 0-1 Unit/Acre, Sprinklers Drip System, Sprinklers In Rear
Lot Size Area
6969.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Sprinklers Y/N
Yes
Common Interest
None
Parcel Number
081270047
Additional Parcels Y/N
No
Community Features
Street Lights
Association Amenities
Hiking Trails, Gym/Ex Room, Playground, Pool, Clubhouse, Spa/Hot Tub
Senior Community Y/N
No
Association Y/N
Yes
Association Name
unknown
Association Management Name
unknown
Association Fee
210.00
Association Fee Frequency
Monthly
High School District
Chawanakee Unified
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
None
Tax Lot
322
Tax Tract Number
273
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 712452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 787447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3103 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3603 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` = 1736482 OR `props-main`.`id` = 1732247 OR `props-main`.`id` = 1744711 OR `props-main`.`id` = 1717685 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1718634 OR `props-main`.`id` = 1718647 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1750021 OR `props-main`.`id` = 1750010 OR `props-main`.`id` = 1729258 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1738120 OR `props-main`.`id` = 1744674 OR `props-main`.`id` = 1746486 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1721662 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1754293 OR `props-main`.`id` = 1754307 OR `props-main`.`id` = 1758018 OR `props-main`.`id` = 1754791 OR `props-main`.`id` = 1747675 OR `props-main`.`id` = 1760687 OR `props-main`.`id` = 1761073 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1722288 OR `props-main`.`id` = 1756086 OR `props-main`.`id` = 1753967 OR `props-main`.`id` = 1746080 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1737523 OR `props-main`.`id` = 1734042 OR `props-main`.`id` = 1741269 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1726279 OR `props-main`.`id` = 1723560 OR `props-main`.`id` = 1755711 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1749113 OR `props-main`.`id` = 1746844 OR `props-main`.`id` = 1722102 OR `props-main`.`id` = 1731610 OR `props-main`.`id` = 1752920 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1750050 OR `props-main`.`id` = 1755604 OR `props-main`.`id` = 1737137 OR `props-main`.`id` = 1737138 OR `props-main`.`id` = 1749063 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26062291' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-14' 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();
0
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.
