Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/654000/37033-Dunlap-Rd/Yokuts-Valley/https://www.londonproperties.com/images/camerashy.pngLondon Properties Yokuts Valley Real Estate | 37033 Dunlap Rd
Very nice older manufactured home only 1 mile from Hwy 180. This property has a Dunlap Road address but is on a dirt cul-de-sac known locally as Blue Oak Lane. The home is a 1974 model on permanent foundation and is in good condition with covered front and rear decks. Home is 3br2ba with isolated master. 3rd bedroom currently used as office. Open floorplan with dining off of kitchen and large living room.This is a nice parcel with the home sited well off the road for outstanding privacy. The well is only 100 feet deep and an exceptional 100 GPM. There is also a generator for the very occasional power outage. That's a nice feature when living in the mountains.The property is mostly fenced with some cross fencing. The seller has made mulitple garden areas and planted a multitude of conifers that are now mature plus a nice coverage of mature oaks of multiple varieties. Additional improvements include an above ground pool, parking shade for 2 cars, and a nice patio deck along the seasonal creek. All-in-all, this is a truly serene setting with a very affordable price.This isn't a fancy property, but,over a 40 year period, the owners have made it a very comfortable place to call home. This is a great location only 1.5 miles from the local store, gas station, and coffee shop and only 3 miles to Dunlap School.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Manufactured Home
Year Built
1974
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$174
Price Per Acre
$50,201
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Isolated Bedroom, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Highway 180
Directions
Highway 180 to Dunlap Road, south 1 mile to Blue Oak, right 200 yards to property on right (no sign)
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Evaporative Cool, Floor or Wall Unit
Laundry
Utility Room, Gas Hook Up
Roofing
Metal, Rolled/Hot Mop
Foundation
Wood Subfloor
Detached Structures
Shed, Other/See Remarks
Kitchen
F/S Range/Oven, Gas Appliances, Pantry, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 237500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 262500 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` = 1729498 OR `props-main`.`id` = 1755657 OR `props-main`.`id` = 1757174 OR `props-main`.`id` = 1720642 OR `props-main`.`id` = 1698053 OR `props-main`.`id` = 1762815 OR `props-main`.`id` = 1682233 OR `props-main`.`id` = 1701802 OR `props-main`.`id` = 1718307 OR `props-main`.`id` = 1757714 OR `props-main`.`id` = 1765286 OR `props-main`.`id` = 1612130 OR `props-main`.`id` = 1727410)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654000' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-21' 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 2 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.
