Courtesy of Donna Pride, London Properties, Ltd. - [email protected]
Looking for a home that truly has it all? Look no further! This exceptionally well-cared-for property shines inside and out, offering a wonderful blend of comfort, entertaining space, privacy, and versatility in a highly desirable neighborhood. The inviting open floor plan is ideal for gathering with family and friends, while the thoughtfully upgraded kitchen adds both style and functionality. The primary bathroom provides a relaxing retreat at the end of the day.Step outside and discover exceptional outdoor living! The fully fenced backyard offers privacy and peace of mind for pets or little ones, while the impressive outdoor kitchen is sure to become a favorite gathering spot. Enjoy it all beneath the massive covered patio featuring soaring wood ceilingsan ideal setting for year-round entertaining and relaxation.Adding even more versatility is the separate car/garage, perfect for storing toys, vehicles, or creating a dedicated hobby space. Beautifully maintained and thoughtfully enhanced throughout, this is a quality home with the features, spaces, and lifestyle buyers are looking for!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$284
Price Per Acre
$199,045
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Propane, Solar Panels
REO / Bank Owned
No
Cross Street Address
Opah
Directions
From Oakhurst take Hwy 49 out, right on Opah to Loch Lomond
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Tile
# of Fireplaces
1
Fireplace Type
Masonry
Exterior
Stucco
Pool
No
Pool
No
Patio Features
Covered, Concrete
Yard
Sprinklers Back, Sprinklers Auto, Fenced, Mature Landscape, Drip System
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Lease
Parking Features
Existing RV Parking, Work/Shop Area, Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
057 563 004
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Oak Creek
School Type 3
Grade School
School Name 3
Oakhurst
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 593750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 656250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1950 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2450 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` = 1720604 OR `props-main`.`id` = 1770965 OR `props-main`.`id` = 1750719 OR `props-main`.`id` = 1750754 OR `props-main`.`id` = 1765596 OR `props-main`.`id` = 1731954 OR `props-main`.`id` = 1757216 OR `props-main`.`id` = 1719504 OR `props-main`.`id` = 1719519 OR `props-main`.`id` = 1751699 OR `props-main`.`id` = 1752617 OR `props-main`.`id` = 1721209 OR `props-main`.`id` = 1721232 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1738609 OR `props-main`.`id` = 1751538 OR `props-main`.`id` = 1774029 OR `props-main`.`id` = 1766021 OR `props-main`.`id` = 1765300 OR `props-main`.`id` = 1720583 OR `props-main`.`id` = 1720584 OR `props-main`.`id` = 1722180 OR `props-main`.`id` = 1722176 OR `props-main`.`id` = 1744349 OR `props-main`.`id` = 1743536 OR `props-main`.`id` = 1727959 OR `props-main`.`id` = 1728008 OR `props-main`.`id` = 1735412)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654986' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-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();
1
Similar Properties
$600,000
4
3
2,100
0.97
40403 Road 425a
Oakhurst, CA 93644
Last modified 2 hours ago Fresno MLS last checked for updates 30 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.
