Country home in Madera Ranchos offering 4 bedrooms and 3 full bathrooms, including an isolated bedroom and bath, ideal for guests or multigenerational living. Open floor plan with laminate flooring throughout main living areas. Detached possible ADU in the backyard, plus a covered patio and built-in pizza oven, perfect for entertaining. Located on a quiet street within the Golden Valley School District, with easy access to Riverstone walking trails.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1987
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$268
Price Per Acre
$1,090,000
Days On Market
1
Cumulative Days On Market
1
County
Madera
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Avenue 12
Directions
Avenue 12 to Topper
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed, Other/See Remarks
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank
Solar
No
Parking Features
Potential RV Parking
Garage Type
Attached
Garage Spaces
2
APN
049 371 007 000
School District
Golden Valley
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) >= 517750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 572250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1781 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2281 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` = 1698969 OR `props-main`.`id` = 1666285 OR `props-main`.`id` = 1691991 OR `props-main`.`id` = 1679767 OR `props-main`.`id` = 1698666 OR `props-main`.`id` = 1695474 OR `props-main`.`id` = 1695495 OR `props-main`.`id` = 1695500 OR `props-main`.`id` = 1701208 OR `props-main`.`id` = 1691983 OR `props-main`.`id` = 1691979 OR `props-main`.`id` = 1660890 OR `props-main`.`id` = 1686299 OR `props-main`.`id` = 1701119 OR `props-main`.`id` = 1697249)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641576' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-03' 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
Courtesy of Teddi Peters, Coldwell Banker Preferred Realtors - [email protected] Last modified 6 hours ago Fresno MLS last checked for updates 2 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.
