Great find ! All Inclusive Mobile Home Park at Villa Capri with (No Age Restrictions !!).Freeway Proximity & Conveniently Located Close to River Park !! This Inviting Double Wide Mobile Home sits on Space 33 which is all the way towards the Back of the Mobile Park and offers Added Privacy ! It Features: 2Bd/2Bth, 1440sqft of Functional Floor Plan.Convenient Auto Lift Elevator right next to the wooden steps. Inviting sitting area on Covered Porch. Dual Pane Windows with lots of Light. Wet Bar. Dishwasher. Inside Laundry Washer & Dryer will be included at no additional value or warranty from Seller. AC Unit. Storage Shed on Back yard. (If Buyers are interested some of the furniture pieces & personal items are available for sale upon request). Some of the Mobile Home Park Amenities are: Club House, Fenced Community Refreshing Pool !! Please contact the office Manager Genevieve to find out the requirements to qualify for Park Approval M-Fr 9am to 5pm at: .Per office manager the current space Rent is $544.99 plus $117.73 for water, sewer & garbage.
Property Type
Residential
Property Subtype 1
Mobile Home
Property Subtype 2
Single Family Residence
Year Built
1976
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$94
Days On London
245
Cumulative Days On London
245
County
Fresno
Special Features
Built In Cabinets, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
N/Blackstone/Herndon
Directions
N/Blackstone W/Herndon (Frontage Road) Look for Villa Capri Mobile Home Park Space 33 is all the way towards the Back.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 128250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 141750 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) >= 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` = 1683979 OR `props-main`.`id` = 1716143 OR `props-main`.`id` = 1708234 OR `props-main`.`id` = 1713180 OR `props-main`.`id` = 1657930 OR `props-main`.`id` = 1715596 OR `props-main`.`id` = 1712714 OR `props-main`.`id` = 1706829 OR `props-main`.`id` = 1713346 OR `props-main`.`id` = 1713349 OR `props-main`.`id` = 1706827 OR `props-main`.`id` = 1706826 OR `props-main`.`id` = 1712581 OR `props-main`.`id` = 1707127 OR `props-main`.`id` = 1712786 OR `props-main`.`id` = 1703751 OR `props-main`.`id` = 1713259 OR `props-main`.`id` = 1713270 OR `props-main`.`id` = 1704705 OR `props-main`.`id` = 265423 OR `props-main`.`id` = 1702890 OR `props-main`.`id` = 1695738 OR `props-main`.`id` = 1716513 OR `props-main`.`id` = 1715979 OR `props-main`.`id` = 1713964 OR `props-main`.`id` = 138928 OR `props-main`.`id` = 1707122 OR `props-main`.`id` = 1704257 OR `props-main`.`id` = 1704053 OR `props-main`.`id` = 1704646 OR `props-main`.`id` = 1694435 OR `props-main`.`id` = 1701818 OR `props-main`.`id` = 1716349 OR `props-main`.`id` = 1706745 OR `props-main`.`id` = 1710166 OR `props-main`.`id` = 1710177 OR `props-main`.`id` = 1713631 OR `props-main`.`id` = 1713654 OR `props-main`.`id` = 241543 OR `props-main`.`id` = 1713853 OR `props-main`.`id` = 1709934 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1710010 OR `props-main`.`id` = 1687193 OR `props-main`.`id` = 1701661 OR `props-main`.`id` = 1709913 OR `props-main`.`id` = 1706099 OR `props-main`.`id` = 1714995 OR `props-main`.`id` = 1711498 OR `props-main`.`id` = 1715640 OR `props-main`.`id` = 1707182 OR `props-main`.`id` = 1714972 OR `props-main`.`id` = 1714992 OR `props-main`.`id` = 1710076 OR `props-main`.`id` = 1700029 OR `props-main`.`id` = 1697378 OR `props-main`.`id` = 217382 OR `props-main`.`id` = 1707971 OR `props-main`.`id` = 1715869 OR `props-main`.`id` = 305398 OR `props-main`.`id` = 1709498 OR `props-main`.`id` = 1689729 OR `props-main`.`id` = 1702378 OR `props-main`.`id` = 1696769 OR `props-main`.`id` = 1704511 OR `props-main`.`id` = 233922 OR `props-main`.`id` = 1711241 OR `props-main`.`id` = 1709946 OR `props-main`.`id` = 1704748 OR `props-main`.`id` = 1713804 OR `props-main`.`id` = 222632 OR `props-main`.`id` = 1713839 OR `props-main`.`id` = 1715977 OR `props-main`.`id` = 330848 OR `props-main`.`id` = 1698752 OR `props-main`.`id` = 1716368 OR `props-main`.`id` = 244266 OR `props-main`.`id` = 1702968 OR `props-main`.`id` = 1703769 OR `props-main`.`id` = 1715764 OR `props-main`.`id` = 1701542 OR `props-main`.`id` = 1705055 OR `props-main`.`id` = 1703344 OR `props-main`.`id` = 1688322 OR `props-main`.`id` = 1713334 OR `props-main`.`id` = 1706790 OR `props-main`.`id` = 1702438 OR `props-main`.`id` = 1704188 OR `props-main`.`id` = 1715514 OR `props-main`.`id` = 1716012 OR `props-main`.`id` = 325803 OR `props-main`.`id` = 1716413 OR `props-main`.`id` = 1706872 OR `props-main`.`id` = 1701234 OR `props-main`.`id` = 1688764 OR `props-main`.`id` = 1693642 OR `props-main`.`id` = 1715960 OR `props-main`.`id` = 1694874 OR `props-main`.`id` = 1701233 OR `props-main`.`id` = 1702541 OR `props-main`.`id` = 1697236 OR `props-main`.`id` = 1690962 OR `props-main`.`id` = 1702063 OR `props-main`.`id` = 1712682 OR `props-main`.`id` = 1709629 OR `props-main`.`id` = 1709942 OR `props-main`.`id` = 1716107 OR `props-main`.`id` = 1716453 OR `props-main`.`id` = 1704902 OR `props-main`.`id` = 1716084 OR `props-main`.`id` = 1715475 OR `props-main`.`id` = 1705061 OR `props-main`.`id` = 896872 OR `props-main`.`id` = 1704227 OR `props-main`.`id` = 1693947 OR `props-main`.`id` = 1713973 OR `props-main`.`id` = 1716497 OR `props-main`.`id` = 1671794 OR `props-main`.`id` = 1715781 OR `props-main`.`id` = 186738 OR `props-main`.`id` = 1690778 OR `props-main`.`id` = 1707020 OR `props-main`.`id` = 1707036 OR `props-main`.`id` = 1708090 OR `props-main`.`id` = 248378 OR `props-main`.`id` = 1709947 OR `props-main`.`id` = 1713604 OR `props-main`.`id` = 1713523 OR `props-main`.`id` = 1713837 OR `props-main`.`id` = 1696890 OR `props-main`.`id` = 1688804 OR `props-main`.`id` = 1705441 OR `props-main`.`id` = 1709252 OR `props-main`.`id` = 1713832 OR `props-main`.`id` = 1706855 OR `props-main`.`id` = 1679646 OR `props-main`.`id` = 1702495 OR `props-main`.`id` = 1696173 OR `props-main`.`id` = 1711188 OR `props-main`.`id` = 1716126 OR `props-main`.`id` = 1707183 OR `props-main`.`id` = 1703440 OR `props-main`.`id` = 1703833 OR `props-main`.`id` = 1689221 OR `props-main`.`id` = 1709427 OR `props-main`.`id` = 1712934 OR `props-main`.`id` = 1713696 OR `props-main`.`id` = 1713816 OR `props-main`.`id` = 1706079 OR `props-main`.`id` = 1684568 OR `props-main`.`id` = 1713222 OR `props-main`.`id` = 1713107 OR `props-main`.`id` = 1665746 OR `props-main`.`id` = 1709423 OR `props-main`.`id` = 1698125 OR `props-main`.`id` = 1716165 OR `props-main`.`id` = 1716114 OR `props-main`.`id` = 1712378)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno633774' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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
Courtesy of Diana Monroy, Real Broker - [email protected] Last modified 3 months ago Fresno MLS last checked for updates 36 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.
