Courtesy of Tracee Chiodo, Western Pioneer Properties - [email protected]
Motivated Seller Bring all offers! Come home to your own private paradise! This beautiful 2.3-acre property offers elevated privacy, peaceful surroundings, and panoramic Central Sierra mountain views.Enjoy the sparkling pool, spacious patio, new wrought-iron fencing, park-like grounds, and a dirt bike/ATV track. Inside, the home features a spacious kitchen with a large breakfast bar, new double oven. The fourth bedroom/bonus room includes a half bath and direct access to the pool and patio perfect for entertaining.The primary suite offers a large walk-in closet, while the living room features a cozy wood-burning stove. Additional highlights include owned solar, private well and septic, an attached two-car garage with bonus room, and a detached one-car shop/garage.A rare opportunity for space, privacy, mountain views, and resort-style living on 2.3 acres.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1990
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$277
Price Per Acre
$252,174
Days On London
3
Cumulative Days On London
3
County
Madera
Leased Equipment
Propane
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Sunnyside Ave
Directions
Take CA-99 North toward Madera. Exit toward Sunnyside Ave and head east. Continue to Claremont Rd, then turn onto Claremont Rd and continue to 19581.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
F/S Range/Oven, Built In Range/Oven, Electric Appliances, Dishwasher, Eating Area, Breakfast Bar, Pantry
Primary Bedroom Level
Main
Extra Rooms
Den/Study
Flooring
Tile, Hardwood
# of Fireplaces
1
Fireplace Type
Free Standing
Exterior
Stucco, Wood
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Patio Features
Covered, Enclosed, Concrete
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Solar
Yes
Solar Type
Owned
Parking Features
Existing RV Parking, Work/Shop Area
Are there garage spaces?
Yes
Garage Type
Detached
Garage Spaces
3
APN
031 464 006 000
School District
Madera Unified
School Type 1
High School
School Name 1
Matilda
School Type 2
Junior High School
School Name 2
Jack G. Desmond
School Type 3
Grade School
School Name 3
Pershing
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 551000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 609000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1845 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2345 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` = 1718654 OR `props-main`.`id` = 1780902 OR `props-main`.`id` = 1737122 OR `props-main`.`id` = 1740366 OR `props-main`.`id` = 1767952 OR `props-main`.`id` = 1758922 OR `props-main`.`id` = 1755517 OR `props-main`.`id` = 1730640)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655760' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-24' 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 1 hour ago Fresno MLS last checked for updates 17 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.
