Enjoy peaceful country living with beautiful views of the mountains! Conveniently located off of HWY 145 with easy access to shopping and about 25 minutes to Valley Children's Hospital and Fresno. This unique property features a Beautiful custom home with an attached ADU! Situated on 1.21! Main home has open floor concept with vaulted ceilings, 3 bedroom, an office space/den, and two bathrooms. ADU has 1 bedroom, 1 bath, open kitchen and living room space, private side entry, and own patio space....making it a perfect retreat for extended family or a potential rental. Now step out to the stunning back yard featuring a sparkling pool and outdoor kitchen and bar! Plenty of room for entertaining, dinning or just enjoying the space with the family! Outdoor space also features a batting cage, area for basketball, dog pen, chicken coop, and plenty of parking, including RV parking.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$408
Price Per Acre
$603,223
Days On London
1
Cumulative Days On London
1
County
Madera
Leased Equipment
Propane
Special Features
Isolated Bedroom, Isolated Bathroom, Security System
REO / Bank Owned
No
Cross Street Address
Road 29
Directions
From 99 North exit Gateway Drive to Yosemite Avenue, Left on Yosemite Avenue (turns into HWY 145)to Road 29, right on Road 29 and first left to Avenue 16 1/4. Home is second home to the right.
Special Disclosure
Agent/Owner Related
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Detached Structures
Kennel
Primary Bedroom Level
Main
Bath Features
Shower
Extra Rooms
Den/Study
# of Fireplaces
1
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C
Solar
Yes
Solar Type
Owned with Balance
Parking Features
Existing RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
035 040 076 000
Zoning
RRS
School District
Madera Unified
School Type 1
High School
School Name 1
Madera South
School Type 2
Junior High School
School Name 2
Martin Luther King
School Type 3
Grade School
School Name 3
Millview
Seller Will Consider
Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 693405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 766395 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) >= 1540 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2040 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` = 1674557 OR `props-main`.`id` = 1674537 OR `props-main`.`id` = 1732857 OR `props-main`.`id` = 1724172 OR `props-main`.`id` = 1742348 OR `props-main`.`id` = 1724400 OR `props-main`.`id` = 1724445 OR `props-main`.`id` = 1716451 OR `props-main`.`id` = 1704476 OR `props-main`.`id` = 1732270 OR `props-main`.`id` = 1727267 OR `props-main`.`id` = 1718850 OR `props-main`.`id` = 1713047 OR `props-main`.`id` = 1705385 OR `props-main`.`id` = 1731519 OR `props-main`.`id` = 1741058 OR `props-main`.`id` = 1726127 OR `props-main`.`id` = 1678202 OR `props-main`.`id` = 1722825 OR `props-main`.`id` = 1716356 OR `props-main`.`id` = 1719322 OR `props-main`.`id` = 1726230 OR `props-main`.`id` = 1719318 OR `props-main`.`id` = 1726903 OR `props-main`.`id` = 1724979 OR `props-main`.`id` = 1737647 OR `props-main`.`id` = 1695501 OR `props-main`.`id` = 1695363 OR `props-main`.`id` = 1714480 OR `props-main`.`id` = 1727714 OR `props-main`.`id` = 1741368 OR `props-main`.`id` = 1677972 OR `props-main`.`id` = 1679099 OR `props-main`.`id` = 1728096 OR `props-main`.`id` = 1679100 OR `props-main`.`id` = 1678504 OR `props-main`.`id` = 1734696 OR `props-main`.`id` = 1719557 OR `props-main`.`id` = 1744397 OR `props-main`.`id` = 1728343 OR `props-main`.`id` = 1720550 OR `props-main`.`id` = 1707164 OR `props-main`.`id` = 1726091 OR `props-main`.`id` = 1721097 OR `props-main`.`id` = 1738976 OR `props-main`.`id` = 1739070 OR `props-main`.`id` = 1627559 OR `props-main`.`id` = 1709618)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651245' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-30' 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 3 hours ago Fresno MLS last checked for updates 44 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.
