Courtesy of Madeline Preheim, Sierra Crest Properties - [email protected]
Private Landscape Yard, Covered Deck In Back - Sun Room/Office is a Popout. Side room could be used as an office or additional bedroom. Park Is In Auberry Above The Fog. Ceiling Fans And Built In Hutch Adds To Ambiance. Home is sold as is and needs some repairs.
Property Type
Residential
Property Subtype 1
Mobile Home
Property Subtype 2
Single Family Residence
Property Subtype 3
Manufactured Home
Year Built
1981
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$61
Days On London
20
Cumulative Days On London
20
County
Fresno
REO / Bank Owned
No
Cross Street Address
Lodge
Directions
Take 168 or Auberry Road to where Auberry Road turns North or left. Park is on the corner of Auberry Road and Lodge/168. Park is on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 56050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 61950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 710 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1210 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` = 1732092 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` = 1744350 OR `props-main`.`id` = 1744824 OR `props-main`.`id` = 1727445 OR `props-main`.`id` = 1727457 OR `props-main`.`id` = 305534 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`) != 'fresno650708' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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 weeks ago Fresno MLS last checked for updates 24 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.
