Welcome to this beautifully maintained Country Club Estate home, offering the perfect blend of comfortable country living and modern convenience. From the moment you pull up, the circle driveway, mature landscaping, and classic brick detailing create undeniable curb appealcomplemented by a spacious 3-car garage and dedicated RV parking. Inside, you are greeted by an open floor plan designed for seamless entertaining, centered around a well-appointed kitchen boasting an abundance of storage space and a central island. The pride of ownership shines both inside and out, featuring a fully fenced yard with a drip irrigation system and thoughtful landscape lighting. Impeccably cared for throughout, this property is truly ready for you to move in and make it your own!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1988
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$247
Days On London
22
Cumulative Days On London
22
County
Madera
Leased Equipment
Propane
REO / Bank Owned
No
Cross Street Address
Road 27
Directions
Ave 17 to Road 27 north to Avenue 18 1/4
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Disposal, Dishwasher, Breakfast Bar
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
# of Fireplaces
1
Exterior
Stucco, Block
Pool
No
Pool
No
Yard
Sprinklers Auto
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
036 273 004
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) >= 531999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 587998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2020 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2520 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` = 1708420 OR `props-main`.`id` = 1728189 OR `props-main`.`id` = 1731474 OR `props-main`.`id` = 1707164 OR `props-main`.`id` = 1726091 OR `props-main`.`id` = 1727910 OR `props-main`.`id` = 1731728 OR `props-main`.`id` = 1713589 OR `props-main`.`id` = 1719845 OR `props-main`.`id` = 1723165 OR `props-main`.`id` = 1726656 OR `props-main`.`id` = 1726647 OR `props-main`.`id` = 1726654 OR `props-main`.`id` = 1724637 OR `props-main`.`id` = 1724638 OR `props-main`.`id` = 1724641 OR `props-main`.`id` = 1724469 OR `props-main`.`id` = 1724640 OR `props-main`.`id` = 1724468 OR `props-main`.`id` = 1729323 OR `props-main`.`id` = 1731771 OR `props-main`.`id` = 1696299 OR `props-main`.`id` = 1713881 OR `props-main`.`id` = 1731082 OR `props-main`.`id` = 1731083 OR `props-main`.`id` = 1695771 OR `props-main`.`id` = 1728111 OR `props-main`.`id` = 1688382 OR `props-main`.`id` = 1679800 OR `props-main`.`id` = 1727884 OR `props-main`.`id` = 1730665 OR `props-main`.`id` = 1731722 OR `props-main`.`id` = 1691000 OR `props-main`.`id` = 1690972 OR `props-main`.`id` = 1728558 OR `props-main`.`id` = 1728562 OR `props-main`.`id` = 1731726 OR `props-main`.`id` = 1729705 OR `props-main`.`id` = 1729873 OR `props-main`.`id` = 1731767 OR `props-main`.`id` = 1729176 OR `props-main`.`id` = 1729060 OR `props-main`.`id` = 1666451)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649063' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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 day ago Fresno MLS last checked for updates 26 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.
