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
$239
Days On London
0
Cumulative Days On London
0
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) >= 759952.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 839947.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` = 1716851 OR `props-main`.`id` = 1716815 OR `props-main`.`id` = 1691781 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1703559 OR `props-main`.`id` = 1712665 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1704446 OR `props-main`.`id` = 1691700 OR `props-main`.`id` = 1704550 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1702519 OR `props-main`.`id` = 1716679 OR `props-main`.`id` = 1712454 OR `props-main`.`id` = 1707208 OR `props-main`.`id` = 1707209 OR `props-main`.`id` = 1712496 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1704029 OR `props-main`.`id` = 1704141 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1704028 OR `props-main`.`id` = 1699174 OR `props-main`.`id` = 1710037 OR `props-main`.`id` = 1710046 OR `props-main`.`id` = 1704143 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1714903 OR `props-main`.`id` = 1703951 OR `props-main`.`id` = 1707243 OR `props-main`.`id` = 1705618 OR `props-main`.`id` = 1705650 OR `props-main`.`id` = 1705812 OR `props-main`.`id` = 1709799 OR `props-main`.`id` = 1709808 OR `props-main`.`id` = 1703158 OR `props-main`.`id` = 1716265 OR `props-main`.`id` = 1716633 OR `props-main`.`id` = 1716044 OR `props-main`.`id` = 1713322 OR `props-main`.`id` = 1715532 OR `props-main`.`id` = 1714962 OR `props-main`.`id` = 1693967 OR `props-main`.`id` = 1711407 OR `props-main`.`id` = 1701823 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1699189 OR `props-main`.`id` = 1711144 OR `props-main`.`id` = 1715813 OR `props-main`.`id` = 1692547 OR `props-main`.`id` = 1704393 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1695769 OR `props-main`.`id` = 1702888 OR `props-main`.`id` = 1716716 OR `props-main`.`id` = 1712592 OR `props-main`.`id` = 1695774 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsFR26062291' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-23' 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.
