Custom Home on 1 Acre... Built in 2008, 4 Bed/3 Bath. Lots of nice features with 3 car garage. Great location to store equipment and raise livestock. Home needs some minor repairs but has lots of potential. Property is not fenced. Located Across the street from Surf Ranch. Seller will Install New Well before close of escrow. Also For Sale separately are Nine 1 Acre Lots... with seller financing. There is a 1 Acres Lot North of Home with Barn that has a 2Bed/1Bath Unit For Sale $300K. Inquire for Details.
Property Type
Residential
Property Sub-Type
Single Family Residence
Year Built
2008
Year Built Source
Assessor
Days On London
53
Cumulative Days On London
53
County
Kings
New Construction
No
Stories
1
Directions to Property
Across the street from Surf Ranch
Construction Materials
Stucco
Roof
Flat Tile
Heating
Electric
Cooling
Central Air
Laundry Features
Inside, Laundry Room
Security Features
Carbon Monoxide Detector(s), Smoke Detector(s)
Interior Features
Built-in Features, Ceiling Fan(s), High Ceilings
Bathrooms Total (Integer)
3
Full Baths
3.0
Full Baths
3
Appliances
Exhaust Fan, Water Heater
Fireplace Y/N
Yes
Fireplace Features
Family Room
Common Walls
No Common Walls
Spa
No
Utilities
Electricity Connected
Water Source
Well
Sewer
Septic Tank
Parking Features
Attached
Garage
Yes
Attached Garage
Yes
# of Garage Spaces
3.0
APN
024 140 037 000
Lot Features
No Landscaping, Pasture
Lot Dimensions
1x1
Additional Parcels Y/N
No
HOA
No
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 616550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 681450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2810 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3310 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` = 1713028 OR `props-main`.`id` = 1694749 OR `props-main`.`id` = 1692086 OR `props-main`.`id` = 1715201 OR `props-main`.`id` = 1704140 OR `props-main`.`id` = 1697239 OR `props-main`.`id` = 1715349 OR `props-main`.`id` = 1715396 OR `props-main`.`id` = 1715137 OR `props-main`.`id` = 1671679 OR `props-main`.`id` = 1716404 OR `props-main`.`id` = 1705018 OR `props-main`.`id` = 1705011)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare239391' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-17' 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 Franklin Romine, The Equity Group
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.
