Charming country home with cosmetic updates needed. Sitting on a 1/2 acre lot just outside outside of town close to shopping and Riverway Sports Park. This home is very spacious and features 3 bedrooms 1 bath, with a large family room and a separate living room. There is a detached bonus room, work area with a sink and toilet. A covered patio, as well as a large storage shed. Large lot with room to spare, private setting. This home offers plenty of potential - bring your vision and make it your own. Detached bonus room is not part of square footage
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1950
Year Built Source
Public Records
Days On London
7
Cumulative Days On London
7
County
Tulare
New Construction
No
Stories
1
Directions to Property
From Houston Ave go North on CA-63 / N Dinuba Blvd. Turn West on Ave. 322
Roof
Composition
Heating
Wall Furnace
Cooling
Evaporative Cooling
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Fireplace Y/N
No
Private Pool
No
Spa
No
Utilities
Natural Gas Connected, Satellite TV
Water Source
Well
Sewer
Septic Tank
Garage
No
APN
078 090 005 000
Lot Dimensions
Irregular
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 285000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 315000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1550 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` = 1782860 OR `props-main`.`id` = 1727186 OR `props-main`.`id` = 1756265 OR `props-main`.`id` = 1761800 OR `props-main`.`id` = 1766482 OR `props-main`.`id` = 1754542 OR `props-main`.`id` = 1775396 OR `props-main`.`id` = 1764839 OR `props-main`.`id` = 1779919 OR `props-main`.`id` = 1789101 OR `props-main`.`id` = 1787459 OR `props-main`.`id` = 1726349 OR `props-main`.`id` = 1786051 OR `props-main`.`id` = 1782149 OR `props-main`.`id` = 1772999 OR `props-main`.`id` = 1792097 OR `props-main`.`id` = 1788039 OR `props-main`.`id` = 1743825 OR `props-main`.`id` = 1761292 OR `props-main`.`id` = 1778008 OR `props-main`.`id` = 1766467 OR `props-main`.`id` = 1792641 OR `props-main`.`id` = 1751917 OR `props-main`.`id` = 1781345 OR `props-main`.`id` = 1732910 OR `props-main`.`id` = 1770797 OR `props-main`.`id` = 1781350 OR `props-main`.`id` = 1755707 OR `props-main`.`id` = 1781910 OR `props-main`.`id` = 1773732 OR `props-main`.`id` = 1783368 OR `props-main`.`id` = 1657899 OR `props-main`.`id` = 1760351 OR `props-main`.`id` = 1738141 OR `props-main`.`id` = 1780562 OR `props-main`.`id` = 1774247 OR `props-main`.`id` = 1775082 OR `props-main`.`id` = 1733288 OR `props-main`.`id` = 1733339 OR `props-main`.`id` = 1734059 OR `props-main`.`id` = 1776171 OR `props-main`.`id` = 1776170 OR `props-main`.`id` = 1776181 OR `props-main`.`id` = 1776168 OR `props-main`.`id` = 1785081 OR `props-main`.`id` = 1755083 OR `props-main`.`id` = 1745302 OR `props-main`.`id` = 1701240 OR `props-main`.`id` = 1725591 OR `props-main`.`id` = 1786304 OR `props-main`.`id` = 1739805 OR `props-main`.`id` = 1737251 OR `props-main`.`id` = 1780883 OR `props-main`.`id` = 1787180 OR `props-main`.`id` = 1787586 OR `props-main`.`id` = 1744135 OR `props-main`.`id` = 1776116 OR `props-main`.`id` = 1792146 OR `props-main`.`id` = 1776120 OR `props-main`.`id` = 1776121 OR `props-main`.`id` = 1744722 OR `props-main`.`id` = 1744755 OR `props-main`.`id` = 1722942 OR `props-main`.`id` = 1722930 OR `props-main`.`id` = 1776127 OR `props-main`.`id` = 1776126 OR `props-main`.`id` = 1729259 OR `props-main`.`id` = 1729261 OR `props-main`.`id` = 1729274 OR `props-main`.`id` = 1768528 OR `props-main`.`id` = 1776131 OR `props-main`.`id` = 1776125 OR `props-main`.`id` = 1776130 OR `props-main`.`id` = 1729281 OR `props-main`.`id` = 1776124 OR `props-main`.`id` = 1779991 OR `props-main`.`id` = 1770362 OR `props-main`.`id` = 1770363 OR `props-main`.`id` = 1776132 OR `props-main`.`id` = 1776128 OR `props-main`.`id` = 1770364 OR `props-main`.`id` = 1770366 OR `props-main`.`id` = 1770368 OR `props-main`.`id` = 1770367 OR `props-main`.`id` = 1739091 OR `props-main`.`id` = 1754480 OR `props-main`.`id` = 1768040 OR `props-main`.`id` = 1770112 OR `props-main`.`id` = 1793086 OR `props-main`.`id` = 1785021 OR `props-main`.`id` = 1792618 OR `props-main`.`id` = 1764496 OR `props-main`.`id` = 1724830 OR `props-main`.`id` = 1782857 OR `props-main`.`id` = 1782858 OR `props-main`.`id` = 1782859 OR `props-main`.`id` = 1761694 OR `props-main`.`id` = 1726700 OR `props-main`.`id` = 1750014 OR `props-main`.`id` = 1751448 OR `props-main`.`id` = 1792617 OR `props-main`.`id` = 1750012)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare244616' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-19' 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 Robert Cortez, 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.
