CONTRACTORS DREAM, Bring your paint brush, ladder and roll up your sleeves. Offering 2 Mobile homes W/permanent foundations on 7.73 Acres. All useable land with several other building pads. Needs TLC, the work you put into this lovely piece of property will pay off in spades. The possibilities are endless. One Mobile is 3 Bedrooms, 2 Baths, second Mobile is 4 Bedrooms, 2 Baths. They both are in need of repairs, both have permanent foundations, Well on property, 2 electric meters, rental potential or live in one rent other or could be a family member. Priced to sell, call your Realtor Today!!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1985
Region
Mountain
# of Stories
Single Story
Price Per Square Foot
$125
Price Per Acre
$257,143
Days On London
1
Cumulative Days On London
1
County
Madera
Special Features
Horses Allowed
REO / Bank Owned
No
Cross Street Address
Douglas Rd.So.
Directions
Road 415 to Trabuco Road to Wells to Property on left past Douglas Rd So. Look for sign.
Special Disclosure
See Remrks/Attchmnts
Style
Ranch
Heating & Cooling
Other
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Flooring
Carpet, Laminate
# of Fireplaces
1
Fireplace Type
Free Standing, Pellet
Exterior
Metal, Vinyl
Pool
No
Pool
No
Spa
No
Yard
Other
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Potential RV Parking, Circular Driveway
Are there garage spaces?
No
APN
054 225 008 000
School District
Yosemite
School Type 1
High School
School Name 1
Yosemite
School Type 2
Junior High School
School Name 2
Coarsegold
School Type 3
Grade School
School Name 3
Coarsegold
Seller Will Consider
Cash
1st Loan Type
Free & Clear
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 171000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 189000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1190 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1690 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` = 1716499 OR `props-main`.`id` = 1716519 OR `props-main`.`id` = 1702468 OR `props-main`.`id` = 1702471 OR `props-main`.`id` = 1724279 OR `props-main`.`id` = 1718679 OR `props-main`.`id` = 1724058 OR `props-main`.`id` = 1724051 OR `props-main`.`id` = 1709161 OR `props-main`.`id` = 1716663 OR `props-main`.`id` = 1715686 OR `props-main`.`id` = 1708200 OR `props-main`.`id` = 1715741 OR `props-main`.`id` = 1715743 OR `props-main`.`id` = 1714957 OR `props-main`.`id` = 1712335 OR `props-main`.`id` = 1715727 OR `props-main`.`id` = 1663260 OR `props-main`.`id` = 1663264)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647905' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-29' 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 Virginia Morton, Century 21 Select Real Estate - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 41 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.
