Courtesy of Ana Champion, HomeSmart PV and Associates - [email protected]
Escape to serenity in this beautiful 3-bedroom, 2-bathroom country home, offering 1800 sqft of warm and cozy living space along with a separate living room or formal dining room. The primary bathroom is a true retreat, featuring a jetted tub and a spacious walk-in closet. Step outside to discover a newer patio deck with a refreshing tub/pool, perfect for cooling down on hot days, all while overlooking picturesque citrus trees.Situated on a generous 1.13-acre lot, this property provides ample room for relaxation and outdoor enjoyment.Embrace the quiet and peaceful atmosphere of this charming home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2008
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$314
Price Per Acre
$500,000
Days On London
0
Cumulative Days On London
0
County
Madera
Reports Available
NHD, Prelim Title Report
REO / Bank Owned
No
Cross Street Address
Elmwood
Directions
From Road 28 1/2 make a right on Ave 22
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Gas Appliances, Dishwasher
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Jetted Tub
Extra Rooms
Family Room
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered, Wood Deck
Yard
Fenced
Gas & Electric
Propane
Sewer / Water
Private Well
Solar
No
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
031 571 003 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
Berenda
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 536750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 593250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1550 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2050 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` = 1752194 OR `props-main`.`id` = 1734560 OR `props-main`.`id` = 1752204 OR `props-main`.`id` = 1591884 OR `props-main`.`id` = 1752223 OR `props-main`.`id` = 1730640 OR `props-main`.`id` = 1730648 OR `props-main`.`id` = 1731621 OR `props-main`.`id` = 1723687 OR `props-main`.`id` = 1723583 OR `props-main`.`id` = 1723578 OR `props-main`.`id` = 1677466 OR `props-main`.`id` = 1725993 OR `props-main`.`id` = 1749439 OR `props-main`.`id` = 1722379 OR `props-main`.`id` = 1753347 OR `props-main`.`id` = 1752889 OR `props-main`.`id` = 1723923 OR `props-main`.`id` = 1724658 OR `props-main`.`id` = 1722076 OR `props-main`.`id` = 1756158 OR `props-main`.`id` = 1749259 OR `props-main`.`id` = 1751580 OR `props-main`.`id` = 1736406 OR `props-main`.`id` = 1698813)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653056' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-01' 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();
3
Similar Properties
$569,000
3
2.5
1,952
1.02
22052 Melrose Ct
Madera, CA 93638
$560,000
4
3
1,900
2.00
21466 Forest Glen Rd
Madera, CA 93638
$549,999
3
2
1,952
2.00
20689 Olympia Rd
Madera, CA 93638
Last modified 1 hour ago Fresno MLS last checked for updates 1 minute 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.
