3 bedroom, 1 bath on a Huge Lot, Make this property into a cozy home, It has a welcoming feeling when you walk in, The huge lot is big enough to build a pool, shop. Call today for a personal showing!
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
1969
Year Built Source
Public Records
Days On London
1
Cumulative Days On London
1
County
Tulare
New Construction
No
Stories
1
Directions to Property
Go South on Hwy 99, Take the Pixley Exit, Turn Right on Davis, Turn Left on S. Market St, Turn Right on Compton. Property will be on the Left Side
Construction Materials
Wood Siding
Foundation Details
Slab
Roof
Composition
Heating
Wall Furnace
Cooling
Evaporative Cooling
Laundry Features
Inside, Laundry Room
Direction Faces
North
Bathrooms Total (Integer)
1
Full Baths
1.0
Full Baths
1
Appliances
None
Fireplace Y/N
No
Flooring
Carpet, Linoleum
Common Walls
No Common Walls
Spa
No
Utilities
Electricity Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Features
Concrete
Garage
No
Attached Garage
No
APN
298 060 006 000
Lot Features
Back Yard, Fencing
Lot Dimensions
94x191
Additional Parcels Y/N
No
View
Orchard, Neighborhood
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 189905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 209895 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) >= 813 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1313 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` = 1715324 OR `props-main`.`id` = 1701583 OR `props-main`.`id` = 1714582 OR `props-main`.`id` = 1704746 OR `props-main`.`id` = 1715354 OR `props-main`.`id` = 1717557 OR `props-main`.`id` = 1717262 OR `props-main`.`id` = 1696014 OR `props-main`.`id` = 1715207 OR `props-main`.`id` = 1709579)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare240512' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-21' 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 Cynthia Ravenscroft, Melson Realty, Inc.
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.
