Don't miss this great investment opportunity! This property is to be sold AS IS . Cash is the best way to purchase it. Seller will not clean the property. Roof was inspected in March of 2024 and was found to be in excellent shape. Roof Inspection report is attached. The home is 1680 square feet on a large lot. Call for more details.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1971
Year Built Source
Public Records
Days On London
3
Cumulative Days On London
3
County
Tulare
Property Condition
Fixer
New Construction
No
Stories
1
Current Use
Residential
Directions to Property
From Hwy 190 and Plano go east on Hwy 190. Turn left on Martin and immediately right on Poplar. Go east on Poplar to Ruth St. North on Ruth St to Mountain View Ave. Go west on Mountain View to address on the south side of the street.
Construction Materials
Stucco
Foundation Details
Slab
Roof
Composition
Heating
Central, Forced Air, Natural Gas
Cooling
Central Air, Electric
Laundry Features
Electric Dryer Hookup, Inside, Laundry Room, Washer Hookup
Direction Faces
North
Other Structures
Shed(s)
Bathrooms Total (Integer)
2
Full Baths
1.75
Full Baths
1
Three Quarter Baths
1
Fireplace Y/N
Yes
Fireplace Features
Living Room
Flooring
Carpet, Concrete, Linoleum
Common Walls
No Common Walls
Private Pool
No
Spa
No
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Garage
No
# Uncovered Parking
2.0
APN
262 240 017 000
Lot Features
Back Yard, Front Yard
Lot Dimensions
85' X 120'
Horse Property
No
Additional Parcels Y/N
No
View
Neighborhood
Road Frontage Type
City Street
Road Surface Type
Paved
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 284050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 313950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1430 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1930 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` = 1733261 OR `props-main`.`id` = 1733253 OR `props-main`.`id` = 1723726 OR `props-main`.`id` = 1740713 OR `props-main`.`id` = 1719071 OR `props-main`.`id` = 1721500 OR `props-main`.`id` = 1722803 OR `props-main`.`id` = 1722806 OR `props-main`.`id` = 1722799 OR `props-main`.`id` = 1729029 OR `props-main`.`id` = 1722787 OR `props-main`.`id` = 1729064 OR `props-main`.`id` = 1744142 OR `props-main`.`id` = 1720108 OR `props-main`.`id` = 1719697 OR `props-main`.`id` = 1718806 OR `props-main`.`id` = 1676322 OR `props-main`.`id` = 1740517 OR `props-main`.`id` = 1719359 OR `props-main`.`id` = 1737633 OR `props-main`.`id` = 1345557 OR `props-main`.`id` = 1719865 OR `props-main`.`id` = 1740527 OR `props-main`.`id` = 1720138 OR `props-main`.`id` = 1719907 OR `props-main`.`id` = 1719908 OR `props-main`.`id` = 1720012 OR `props-main`.`id` = 1727490 OR `props-main`.`id` = 1720191 OR `props-main`.`id` = 1737657 OR `props-main`.`id` = 1723324 OR `props-main`.`id` = 1709556 OR `props-main`.`id` = 1719363 OR `props-main`.`id` = 1737634 OR `props-main`.`id` = 1736072 OR `props-main`.`id` = 1709741 OR `props-main`.`id` = 1717555 OR `props-main`.`id` = 1720052 OR `props-main`.`id` = 1719905 OR `props-main`.`id` = 1695654 OR `props-main`.`id` = 1719904 OR `props-main`.`id` = 1737643 OR `props-main`.`id` = 1735547 OR `props-main`.`id` = 1743951 OR `props-main`.`id` = 1720060 OR `props-main`.`id` = 1743097 OR `props-main`.`id` = 1737658 OR `props-main`.`id` = 1723373 OR `props-main`.`id` = 1673945 OR `props-main`.`id` = 1716722 OR `props-main`.`id` = 1712554 OR `props-main`.`id` = 1712666 OR `props-main`.`id` = 1723738 OR `props-main`.`id` = 1723743 OR `props-main`.`id` = 1738866 OR `props-main`.`id` = 1744081 OR `props-main`.`id` = 1744067 OR `props-main`.`id` = 1744068 OR `props-main`.`id` = 1720009 OR `props-main`.`id` = 1692369 OR `props-main`.`id` = 1723067 OR `props-main`.`id` = 1719985 OR `props-main`.`id` = 1732749 OR `props-main`.`id` = 1719132 OR `props-main`.`id` = 1726194 OR `props-main`.`id` = 1732061 OR `props-main`.`id` = 1720111 OR `props-main`.`id` = 1725247 OR `props-main`.`id` = 1725237 OR `props-main`.`id` = 1725244 OR `props-main`.`id` = 1725252)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare242582' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-30' 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 Matt Thompson, Century 21 Select Real Estate
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.
