Executive home in move-in condition located in the desirable Lake Madera Country Estates. This nearly 2-acre flat corner lot is zoned for horses and your own mini farm. Also approved for up to three structures an existing home, an ADU with garage, plus the ability to add an additional single-family residence per county guidelines.
The home features fresh interior and exterior paint, new carpet, new flooring, and updated bathrooms each upgraded with a modern shower tower. Enjoy an expansive living room with vaulted ceilings, offering the perfect space for gatherings and entertaining.
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
$278,824
Days On Market
55
Cumulative Days On Market
107
County
Madera
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Del Mar Rd
Directions
99 N exit Gateway Dr, rt on Olive, lft on Tozer St, rt on Raymond Rd, rt on Ave 21, rt on Del Mar, lft on Ave 20 1/2
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
In Closet
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Dishwasher
Dining Room Features
Family Room/Area
Primary Bedroom Level
Main
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Wood
Pool
No
Pool
No
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking
Garage Type
Attached
Garage Spaces
3
Site Amenities
Corner
APN
031 353 001 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
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 450300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 497700 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) >= 1460 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1960 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` = 1690995 OR `props-main`.`id` = 1690850 OR `props-main`.`id` = 1698803 OR `props-main`.`id` = 1695277 OR `props-main`.`id` = 1693536 OR `props-main`.`id` = 1683668 OR `props-main`.`id` = 1683913 OR `props-main`.`id` = 1692539 OR `props-main`.`id` = 1683680 OR `props-main`.`id` = 1696901 OR `props-main`.`id` = 1591884 OR `props-main`.`id` = 1691038 OR `props-main`.`id` = 1679716 OR `props-main`.`id` = 1693542 OR `props-main`.`id` = 1679713 OR `props-main`.`id` = 1677466 OR `props-main`.`id` = 1679668)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639441' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-06' 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 Richard Jackson, Real Broker - [email protected] Last modified 1 week 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.
