Welcome to this beautifully maintained one-bedroom and one-bath mobile home offering comfort and convenience in the heart of Clovis. Perfect for the first time home buyer or someone looking to downsize. Don't miss out on this Mobile home located in the Shaw-Clovis Mobile home park.
Property Type
Residential
Property Subtype 1
Mobile Home
Property Subtype 2
Single Family Residence
Year Built
1985
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$142
Days On Market
9
Cumulative Days On Market
9
County
Fresno
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Shaw
Directions
Shaw East to Helm make a right and entrance is on the right. Make the first right and the home is on the right.
Unit Description
Ground Floor
Style
Bungalow
Make or Model
Champion
Mobile Home Type
Single Wide
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shed
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Eating Area, Breakfast Bar, Refrigerator
Primary Bedroom Level
Main
Bath Features
Shower
Disabled Features
Limited Whl Chr Acc, Hand Rails, Bathroom Fixtures
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 75525 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 83475 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '1' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 310 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 810 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` = 1685782 OR `props-main`.`id` = 180610 OR `props-main`.`id` = 1632076 OR `props-main`.`id` = 1678786 OR `props-main`.`id` = 1680609 OR `props-main`.`id` = 1686095 OR `props-main`.`id` = 1685898 OR `props-main`.`id` = 1685922 OR `props-main`.`id` = 1679178 OR `props-main`.`id` = 1681864 OR `props-main`.`id` = 1679179 OR `props-main`.`id` = 1673311 OR `props-main`.`id` = 1673635 OR `props-main`.`id` = 1683193 OR `props-main`.`id` = 1683288 OR `props-main`.`id` = 1685375 OR `props-main`.`id` = 1681432 OR `props-main`.`id` = 1681145 OR `props-main`.`id` = 86628 OR `props-main`.`id` = 1683053 OR `props-main`.`id` = 1685975 OR `props-main`.`id` = 1678226 OR `props-main`.`id` = 1685123 OR `props-main`.`id` = 1676891 OR `props-main`.`id` = 1680430 OR `props-main`.`id` = 1684424 OR `props-main`.`id` = 1666457 OR `props-main`.`id` = 1666460 OR `props-main`.`id` = 1680814 OR `props-main`.`id` = 1685146 OR `props-main`.`id` = 1685644 OR `props-main`.`id` = 1663934 OR `props-main`.`id` = 1684944 OR `props-main`.`id` = 1678175 OR `props-main`.`id` = 1683115 OR `props-main`.`id` = 1676351 OR `props-main`.`id` = 1683108 OR `props-main`.`id` = 1682196 OR `props-main`.`id` = 1642538 OR `props-main`.`id` = 1676568 OR `props-main`.`id` = 1684202 OR `props-main`.`id` = 1667572 OR `props-main`.`id` = 1683686 OR `props-main`.`id` = 1684908 OR `props-main`.`id` = 1683119 OR `props-main`.`id` = 1674697 OR `props-main`.`id` = 1673696 OR `props-main`.`id` = 1678114 OR `props-main`.`id` = 1685447 OR `props-main`.`id` = 1685024 OR `props-main`.`id` = 1642537 OR `props-main`.`id` = 1686163 OR `props-main`.`id` = 248876 OR `props-main`.`id` = 261479 OR `props-main`.`id` = 1684953 OR `props-main`.`id` = 1685930 OR `props-main`.`id` = 1661800 OR `props-main`.`id` = 1674168 OR `props-main`.`id` = 1685251 OR `props-main`.`id` = 1685023 OR `props-main`.`id` = 1671754 OR `props-main`.`id` = 1654023 OR `props-main`.`id` = 1683425 OR `props-main`.`id` = 1658333 OR `props-main`.`id` = 1677852 OR `props-main`.`id` = 1680455 OR `props-main`.`id` = 1684421 OR `props-main`.`id` = 1681767 OR `props-main`.`id` = 1683107 OR `props-main`.`id` = 1651438 OR `props-main`.`id` = 1679511 OR `props-main`.`id` = 1674635 OR `props-main`.`id` = 1680357 OR `props-main`.`id` = 1638016 OR `props-main`.`id` = 1677294 OR `props-main`.`id` = 1678849 OR `props-main`.`id` = 1679769 OR `props-main`.`id` = 1683168 OR `props-main`.`id` = 1681360 OR `props-main`.`id` = 1683295 OR `props-main`.`id` = 1673634 OR `props-main`.`id` = 1651877 OR `props-main`.`id` = 1648636 OR `props-main`.`id` = 1680793 OR `props-main`.`id` = 1683973 OR `props-main`.`id` = 1681466 OR `props-main`.`id` = 1679272 OR `props-main`.`id` = 1672856 OR `props-main`.`id` = 1652560 OR `props-main`.`id` = 1680470 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1646806 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 1683175 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1678889 OR `props-main`.`id` = 1680668 OR `props-main`.`id` = 1680568 OR `props-main`.`id` = 1670908 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 1678670 OR `props-main`.`id` = 1682061 OR `props-main`.`id` = 1668584 OR `props-main`.`id` = 1684199 OR `props-main`.`id` = 1686215)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636892' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-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
Courtesy of Tamara Couto, London Properties, Ltd. - tcouto@londonproperties.com Last modified 1 week 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.
