Courtesy of Kristine De Luca, Piccolo Real Estate Inc. - [email protected]
Welcome to this cute and move-in-ready 2-bedroom, 2-bath home in Sandy Creek Park! Newer carpet and roof offer a great start, while the corner location provides additional outdoor yard space ready for your personal touch. Conveniently located close to local amenities, this home offers an affordable opportunity to begin your homeownership journey. Buyer to verify park rules, regulations, residency requirements, space rent, and obtain park approval for any alterations or improvements. Come take a look and see what Space 32 has to offer!
Property Type
Residential
Property Subtype 1
Mobile Home
Property Subtype 2
Single Family Residence
Year Built
1992
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$52
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
HWY 168 & Auberry Rd
Directions
HWY 168 through Prather, left on Auberry Rd, left into park, 1st right to 4th mobile on right
Make or Model
SHM6503
Mobile Home Type
Mobile
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Eating Area, Breakfast Bar, Refrigerator
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) >= 806 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1306 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` = 1696683 OR `props-main`.`id` = 1696974 OR `props-main`.`id` = 1723684 OR `props-main`.`id` = 1696975 OR `props-main`.`id` = 1703358 OR `props-main`.`id` = 1746237 OR `props-main`.`id` = 1713593 OR `props-main`.`id` = 1736633 OR `props-main`.`id` = 1689072 OR `props-main`.`id` = 1721410 OR `props-main`.`id` = 1723247 OR `props-main`.`id` = 1727445 OR `props-main`.`id` = 1727457 OR `props-main`.`id` = 305534 OR `props-main`.`id` = 1760454 OR `props-main`.`id` = 1739477 OR `props-main`.`id` = 1745420 OR `props-main`.`id` = 1732123 OR `props-main`.`id` = 1725255 OR `props-main`.`id` = 1726810 OR `props-main`.`id` = 1745806 OR `props-main`.`id` = 1739011 OR `props-main`.`id` = 1728054 OR `props-main`.`id` = 1721653 OR `props-main`.`id` = 1744042 OR `props-main`.`id` = 1744028 OR `props-main`.`id` = 1745045)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno653293' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
0
Last modified 2 hours ago Fresno MLS last checked for updates 12 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.
