Courtesy of Amanda Santana, Realty Unlimited Group - [email protected]
Custom home on large lot with pool, solar and country views! Welcome to 12589 Road 37 1/2, Madera, a distinctive custom home offering privacy, space and an inviting country setting. Situated on a large, usable lot, this property provides plenty of room to enjoy the outdoors while taking in the peaceful surrounding agricultural landscape.The property features a private swimming pool, gated entry, extensive concrete driveway, attached 2-car garage, mature trees, established landscaping and multiple outdoor areas perfect for entertaining or relaxing. Solar panels add an energy-efficient feature to the home.The custom design and brick exterior accents give the home character, while the spacious grounds provide endless possibilities for the new owner. A shed/outbuilding provides additional storage and utility.The property also has a current 2-year roof certification, offering additional peace of mind.IMPORTANT: PROPERTY IS TENANT OCCUPIED. PLEASE DO NOT DISTURB THE TENANTS. All showings must be scheduled in advance through the listing agent and are subject to proper notice.A rare opportunity to own a custom Madera property with a large lot, pool, solar, gated entry, mature landscaping, ample parking and a beautiful country setting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1992
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$266
Price Per Acre
$366,972
Days On London
0
Cumulative Days On London
0
County
Madera
Reports Available
Roof, Well
Leased Equipment
Propane
Special Features
Security Gate
REO / Bank Owned
No
Cross Street Address
Mrytlewood Dr/ Rd 37 1/2
Directions
180 W to 41 N exit ave 12 make left right on rd 37 1/2 property will be on the right
Heating & Cooling
Central Heat & Cool, Evaporative Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Flooring
Carpet, Tile, Other
# of Fireplaces
1
Exterior
Brick
Pool
Yes
Pool
Yes
Pool Type
In Ground
Gas & Electric
Public Utilities, Propane
Sewer / Water
Public Water, Septic Tank
Solar
Yes
Solar Type
Other
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
049 130 018 000
School District
Madera Unified
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Webster
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 759999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 839998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2763 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3263 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` = 1720193 OR `props-main`.`id` = 1741841 OR `props-main`.`id` = 1761406 OR `props-main`.`id` = 1728934 OR `props-main`.`id` = 1761507 OR `props-main`.`id` = 1679767 OR `props-main`.`id` = 1761599 OR `props-main`.`id` = 1754526 OR `props-main`.`id` = 1741762 OR `props-main`.`id` = 1752918 OR `props-main`.`id` = 1740256 OR `props-main`.`id` = 1764569 OR `props-main`.`id` = 1764580 OR `props-main`.`id` = 1765693 OR `props-main`.`id` = 1748400 OR `props-main`.`id` = 1744761)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654107' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-21' 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
Last modified 2 hours ago Fresno MLS last checked for updates 1 hour 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.
