Courtesy of Rene Christenson, Century 21 Ditton Realty - [email protected]
Great opportunity to purchase a mobile home in an all ages welcome park located in North Fork. This home overlooks a meadow with views of mountains in the distance. New deck. Needs a little TLC. Enjoy nearby Bass Lake and Manzanita Lake with a easy commute to shopping and medical care in Fresno.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built
1972
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$44
Price Per Acre
$599,129
Days On London
0
Cumulative Days On London
0
County
Madera
REO / Bank Owned
No
Cross Street Address
Road 200
Directions
Road 200 to Road 224. Just before Horn road is the park.
Heating & Cooling
None
Laundry
Inside, Utility Room
Roofing
Metal
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower, Tub
Basement
None
Flooring
Carpet, Laminate
Exterior
Other
Pool
No
Pool
No
Patio Features
Wood Deck
Yard
Mature Landscape
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Community Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Carport
Are there garage spaces?
No
Carport Spaces
1
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
North Fork
School Type 3
Grade School
School Name 3
North Fork
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 52250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 57750 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) >= 998 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1498 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` = 1754454 OR `props-main`.`id` = 1749997 OR `props-main`.`id` = 1749982 OR `props-main`.`id` = 1663599 OR `props-main`.`id` = 1788189 OR `props-main`.`id` = 1788168 OR `props-main`.`id` = 1723231 OR `props-main`.`id` = 1788213 OR `props-main`.`id` = 1788211 OR `props-main`.`id` = 1750695 OR `props-main`.`id` = 1746580 OR `props-main`.`id` = 1792721 OR `props-main`.`id` = 1768500 OR `props-main`.`id` = 1704054 OR `props-main`.`id` = 1725656 OR `props-main`.`id` = 1785004 OR `props-main`.`id` = 1784962 OR `props-main`.`id` = 1784988 OR `props-main`.`id` = 1777960 OR `props-main`.`id` = 1776600 OR `props-main`.`id` = 1787207 OR `props-main`.`id` = 1744636)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656865' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-17' 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 1 hour ago Fresno MLS last checked for updates 21 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.
