Great investment opportunity!! Charming traditional single-story with updated kitchen granite countertops, newer cabinets, must see to appreciate! Conveniently located close to school.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1958
Location
City
Stories
1
Price Per Square Foot
$252
Price Per Acre
$2,839,397
Cumulative Days On Market
11
County
Kings
New Construction
No
HUD
No
Foreclosure
No
Short Sale
No
Directions
From South 11Th Ave, make a left on Hume ave property on your right side hand.
Heating Systems
Wall Heater
Cooling
Evaporative Cooler
Water Heater Types
Gas
Laundry
Room
Roof
Composition
Security Features
Smoke Detectors
Full Bathrooms
1
Floors
Tile Floors
Fireplace
In Family Room
Exterior
Wood Siding
Pool Private Y/N
No
Spa Y/N
No
Porch / Patio
Covered Patio
Utilities
All Public
Water Supply
Public
Sewer
Public Sewer
Solar Y/N
No
Garage Type
Garage Detached
Garage Capacity
2
Site Description
Corner Lot
Horse Property Y/N
No
APN Number
011 370 009 000
Zoning
R16
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
72873
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 304000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 336000 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) >= 1022 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1522 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` = 1626116 OR `props-main`.`id` = 1626120 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1692727 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1679817 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1636285 OR `props-main`.`id` = 1614339 OR `props-main`.`id` = 1613599 OR `props-main`.`id` = 1692046 OR `props-main`.`id` = 1692195 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1688781 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1659576 OR `props-main`.`id` = 1660339 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1687321 OR `props-main`.`id` = 1667648 OR `props-main`.`id` = 1687046 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1689477 OR `props-main`.`id` = 1689476 OR `props-main`.`id` = 1690924 OR `props-main`.`id` = 1690955 OR `props-main`.`id` = 1691285 OR `props-main`.`id` = 1689618 OR `props-main`.`id` = 1688708 OR `props-main`.`id` = 1686941 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1689293 OR `props-main`.`id` = 1689106 OR `props-main`.`id` = 1689110 OR `props-main`.`id` = 1673823 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1667593 OR `props-main`.`id` = 1692367 OR `props-main`.`id` = 1692359 OR `props-main`.`id` = 1692363 OR `props-main`.`id` = 1692364 OR `props-main`.`id` = 1692360 OR `props-main`.`id` = 1689272 OR `props-main`.`id` = 1627862 OR `props-main`.`id` = 1691963 OR `props-main`.`id` = 1691946 OR `props-main`.`id` = 1691959 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1662106 OR `props-main`.`id` = 1686895 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1688656 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1666685 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1666686 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1691606 OR `props-main`.`id` = 1669910 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1688313 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1686587 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1691788 OR `props-main`.`id` = 1692153 OR `props-main`.`id` = 1692170 OR `props-main`.`id` = 1691177 OR `props-main`.`id` = 1664322 OR `props-main`.`id` = 1687213 OR `props-main`.`id` = 1687245 OR `props-main`.`id` = 1687246 OR `props-main`.`id` = 1687255 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1688664 OR `props-main`.`id` = 1664766)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings233045' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-11-04' 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();
6
Similar Properties
$324,900
3
2
1,292
0.17
573 Manor Ave
Hanford, CA 93230
$319,999
4
2
1,397
0.14
1575 Bluejay Cir
Hanford, CA 93230
$319,900
4
2
1,365
0.17
1405 Arthur St
Hanford, CA 93230
$310,000
3
2
1,242
0.14
1765 Parkside Dr
Hanford, CA 93230
Courtesy of Reyna Medina, All Family Lending & Real Estate 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.
