Ranch style Mobile home with 2 bedrooms 1 bath, ready for new owner, large lot 1.50 acres
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1979
Year Built Source
Owner
Days On London
0
Cumulative Days On London
0
County
Tulare
New Construction
No
Stories
1
Current Use
Manufactured Home
Directions to Property
Lindsay
Construction Materials
Stucco
Foundation Details
Raised
Roof
Aluminum
Heating
Other, Electric, Natural Gas
Cooling
Other
Laundry Features
Inside
Direction Faces
South
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Appliances
6 Burner Stove,Electric Oven,Range
Fireplace Y/N
No
Flooring
Laminate
Exterior Features
Basketball Court
Spa
No
Spa Features
Bath
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Well
Sewer
Septic Tank
Parking Features
Drive Through, RV Access/Parking
Garage
No
Attached Garage
No
APN
141 150 045 000
Lot Features
Fencing
Lot Dimensions
irregular
Horse Property
Yes
Horse Amenities
Fenced
Additional Parcels Y/N
No
View
Orchard, Rural
Waterfront Y/N
No
Road Surface Type
Dirt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 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) >= 470 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 970 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` = 1720252 OR `props-main`.`id` = 1719942 OR `props-main`.`id` = 1703020 OR `props-main`.`id` = 1705109 OR `props-main`.`id` = 1720659 OR `props-main`.`id` = 1615630 OR `props-main`.`id` = 1716431 OR `props-main`.`id` = 1720763)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240902' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-08' 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 Maria Garcia, Platinum Realty - Porterville
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.
