Looking for a home in the country, but close to town? Then this one is it! Nice 3 bdrm, 2 ba home with over 3 acres of land!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2005
Year Built Source
Public Records
Days On London
59
Cumulative Days On London
59
County
Tulare
New Construction
No
Stories
1
Current Use
Agricultural, Dairy, Farm
Directions to Property
Start on Ave 416 East, South on Rd 130, East on Ave 414
Construction Materials
Stucco
Foundation Details
Concrete Perimeter
Roof
Composition
Heating
Central
Cooling
Central Air
Security Features
Carbon Monoxide Detector(s)
Interior Features
Ceiling Fan(s)
Bathrooms Total (Integer)
2
Full Baths
2.0
Full Baths
2
Appliances
Gas Oven, Gas Range, Gas Water Heater
Fireplace Y/N
No
Private Pool
No
Spa
No
Utilities
Natural Gas Connected
Electric
Circuit Breakers
Water Source
Well
Sewer
Septic Tank
Garage
Yes
# of Garage Spaces
2.0
APN
025 220 014 000
Lot Features
Ranch
Lot Dimensions
Irregular
Additional Parcels Y/N
No
View
Mountain(s)
Road Surface Type
Dirt
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 565250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 624750 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) >= 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` = 1716969 OR `props-main`.`id` = 1732307 OR `props-main`.`id` = 1734249 OR `props-main`.`id` = 1724925 OR `props-main`.`id` = 1722461 OR `props-main`.`id` = 1722520 OR `props-main`.`id` = 1721679 OR `props-main`.`id` = 1721681 OR `props-main`.`id` = 1709593 OR `props-main`.`id` = 1688964 OR `props-main`.`id` = 1733445)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare241137' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-14' 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 Angie Barajas, Newton & Sons 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.
