Please provide the following information and Tammi Nott will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.tammitalkshomes.com/agent/18909/tammi-nott/property/link/fresno/637472/41409-Miami-Way/Oakhurst/https://www.tammitalkshomes.com/images/props/fresno/full/637472.jpgLondon Properties Oakhurst Real Estate | 41409 Miami Way
Endless possibilities await with this ranch-style property, ready for your personal touch! While the home itself needs TLC, the land is absolutely stunning. Tucked away at the end of a quiet street and surrounded by other charming country properties, this acreage is a true gem. Gorgeous mature Cedars, Oaks, and Pines create a peaceful, park-like setting, and Miami Creek runs through part of the property, adding to its natural beauty. Ideal for horses or livestock, there's plenty of usable space to create the ranch you've been dreaming of. A large, detached garage offers the perfect setup for a craftsman or hobbyist, and the separate apartment in front of the garage provides rental income or private accommodations for family and guests. If you've been searching for a diamond in the rough with extraordinary land and unlimited potential, this is it!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1967
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$229
Price Per Acre
$50,000
Days On Market
8
Cumulative Days On Market
8
County
Madera
Leased Equipment
Propane, Solar Panels
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Pamela
Directions
From Oakhurst head out Hwy 49 and turn right on Pamela and then head straight forward to Miami. Property is at the very end on the right.
Style
Ranch
Heating & Cooling
Central Heating
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Eating Area, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Other
Pool
No
Pool
No
Patio Features
Covered, Uncovered, Enclosed, Concrete
Yard
Fenced, Mature Landscape
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
Yes
Solar Type
Lease
Parking Features
Potential RV Parking
Garage Type
Detached
Garage Spaces
2
APN
055 360 030
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
72877
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1385 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1885 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` = 1685652 OR `props-main`.`id` = 1685657 OR `props-main`.`id` = 1683786 OR `props-main`.`id` = 1649970 OR `props-main`.`id` = 1649939 OR `props-main`.`id` = 1652674 OR `props-main`.`id` = 1685769 OR `props-main`.`id` = 1687574 OR `props-main`.`id` = 1650742 OR `props-main`.`id` = 1650743 OR `props-main`.`id` = 1687607 OR `props-main`.`id` = 1666178 OR `props-main`.`id` = 1685358 OR `props-main`.`id` = 1685382 OR `props-main`.`id` = 1668479 OR `props-main`.`id` = 1668859 OR `props-main`.`id` = 1679341 OR `props-main`.`id` = 1611781 OR `props-main`.`id` = 1611780 OR `props-main`.`id` = 1666256 OR `props-main`.`id` = 1687614 OR `props-main`.`id` = 1646146 OR `props-main`.`id` = 1686974 OR `props-main`.`id` = 1664210 OR `props-main`.`id` = 1686922 OR `props-main`.`id` = 1686043 OR `props-main`.`id` = 1686688 OR `props-main`.`id` = 1673997 OR `props-main`.`id` = 1674621 OR `props-main`.`id` = 1653133 OR `props-main`.`id` = 1682052 OR `props-main`.`id` = 1678525 OR `props-main`.`id` = 1687678 OR `props-main`.`id` = 1687223 OR `props-main`.`id` = 1658817 OR `props-main`.`id` = 1658790 OR `props-main`.`id` = 1673165 OR `props-main`.`id` = 1673159 OR `props-main`.`id` = 1687202 OR `props-main`.`id` = 1671600 OR `props-main`.`id` = 1687631 OR `props-main`.`id` = 1687251 OR `props-main`.`id` = 1679666 OR `props-main`.`id` = 1679602 OR `props-main`.`id` = 1679606 OR `props-main`.`id` = 1687666 OR `props-main`.`id` = 1674063 OR `props-main`.`id` = 1678297 OR `props-main`.`id` = 1678304 OR `props-main`.`id` = 1674578 OR `props-main`.`id` = 1660701 OR `props-main`.`id` = 1611124 OR `props-main`.`id` = 1611151 OR `props-main`.`id` = 1611455)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637472' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-10-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();
0
Courtesy of Donna Pride, London Properties, Ltd. - [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.
