Beautiful single story home with 3 bedroom 2 bathroom with Huge backyard. Open and Airy kitchen with bottom new kitchen cabinets, full slab granite counter top, new floor and with new appliances. New interior and exterior paint , new water heater. 2 solar system (one owned and one lease). Huge Backyard. Go and Sell!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1961
Location
City
Stories
1
Price Per Square Foot
$253
Price Per Acre
$2,371,097
Cumulative Days On London
76
County
Kings
Directions
From 12th ave, Turn right on woodland dr, then turn left on parkside dr, then turn right on cling cir.
Roof
Composition
Full Bathrooms
2
Pool Private Y/N
No
Spa Y/N
No
Solar Y/N
Yes
Solar Options
Solar Panels
Solar Ownership
Owned
Garage Type
Garage Attached
Garage Capacity
2
Site Description
Cul-de-Sac
Horse Property Y/N
No
APN Number
011 100 075 00
Zoning
R16
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 310175 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 342825 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) >= 1038 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1538 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` = 1694201 OR `props-main`.`id` = 1728731 OR `props-main`.`id` = 1728733 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1721731 OR `props-main`.`id` = 1721710 OR `props-main`.`id` = 1709656 OR `props-main`.`id` = 1719547 OR `props-main`.`id` = 1719568 OR `props-main`.`id` = 1727934 OR `props-main`.`id` = 1708194 OR `props-main`.`id` = 1717863 OR `props-main`.`id` = 1717862 OR `props-main`.`id` = 1717867 OR `props-main`.`id` = 1717879 OR `props-main`.`id` = 1717885 OR `props-main`.`id` = 1706685 OR `props-main`.`id` = 1726974 OR `props-main`.`id` = 1728758 OR `props-main`.`id` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1726360 OR `props-main`.`id` = 1720568 OR `props-main`.`id` = 1720570 OR `props-main`.`id` = 1728424 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1727025 OR `props-main`.`id` = 1715631 OR `props-main`.`id` = 1721026 OR `props-main`.`id` = 1710013 OR `props-main`.`id` = 1724354 OR `props-main`.`id` = 1729290 OR `props-main`.`id` = 1719994 OR `props-main`.`id` = 1719993 OR `props-main`.`id` = 1729190 OR `props-main`.`id` = 1729192 OR `props-main`.`id` = 1729193 OR `props-main`.`id` = 1729328 OR `props-main`.`id` = 1728338 OR `props-main`.`id` = 1725400 OR `props-main`.`id` = 1725451 OR `props-main`.`id` = 1725454 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1727010 OR `props-main`.`id` = 1724616 OR `props-main`.`id` = 1726496 OR `props-main`.`id` = 1726509 OR `props-main`.`id` = 1726546 OR `props-main`.`id` = 1725839 OR `props-main`.`id` = 1722858 OR `props-main`.`id` = 1727195 OR `props-main`.`id` = 1728888 OR `props-main`.`id` = 1726614 OR `props-main`.`id` = 1727185 OR `props-main`.`id` = 1723591 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1716731 OR `props-main`.`id` = 1722153 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1714894 OR `props-main`.`id` = 1726044 OR `props-main`.`id` = 1723304 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1724618 OR `props-main`.`id` = 1724829 OR `props-main`.`id` = 1724843 OR `props-main`.`id` = 1724844 OR `props-main`.`id` = 1724845 OR `props-main`.`id` = 1727768 OR `props-main`.`id` = 1728425 OR `props-main`.`id` = 1728492 OR `props-main`.`id` = 1728493 OR `props-main`.`id` = 1728494 OR `props-main`.`id` = 1728509 OR `props-main`.`id` = 1728510 OR `props-main`.`id` = 1727919 OR `props-main`.`id` = 1727946 OR `props-main`.`id` = 1728367 OR `props-main`.`id` = 1728375 OR `props-main`.`id` = 1728610 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1728603 OR `props-main`.`id` = 1727905 OR `props-main`.`id` = 1727906 OR `props-main`.`id` = 1727912 OR `props-main`.`id` = 1727914 OR `props-main`.`id` = 1727785 OR `props-main`.`id` = 1727797 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1724968 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1728673)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233973' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-28' 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();
3
Similar Properties
$326,500
3
2
1,288
0.14
1167 Cling Cir
Hanford, CA 93230
$320,000
3
2
1,182
0.18
1035 Michelle Ct
Hanford, CA 93230
$313,000
4
2
1,438
0.14
10840 Beverly Dr
Hanford, CA 93230
Courtesy of Tejinder Singh Khehra, RE/MAX Gold
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.
