Investor special alert! This is the opportunity you don't want to pass up. Located in the heart of Hanford, this property is brimming with potential and ready for the right buyer to bring it to life. Whether you're an experienced investor or just getting started, this is a fantastic chance to build equity in one of the Central Valley's most conveniently located cities. Close to schools, shopping, and major commuter routes -the value is here, you just need to unlock it. Act fast, deals like this don't last!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1971
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$121
Price Per Acre
$1,532,847
Days On London
0
Cumulative Days On London
70
County
Kings
REO / Bank Owned
No
Cross Street Address
10th & Houston Ave.
Directions
Use Gps
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Flooring
Laminate, Tile
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Are there garage spaces?
No
APN
011 480 003 000
Zoning
R16
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
John F. Kennedy
School Type 3
Grade School
School Name 3
Simas
Seller Will Consider
Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 199500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 220500 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) >= 1488 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1988 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` = 1748857 OR `props-main`.`id` = 1786528 OR `props-main`.`id` = 1721178 OR `props-main`.`id` = 1754548 OR `props-main`.`id` = 1748830 OR `props-main`.`id` = 1755438 OR `props-main`.`id` = 1721710 OR `props-main`.`id` = 1788237 OR `props-main`.`id` = 1788257 OR `props-main`.`id` = 1782333 OR `props-main`.`id` = 1785560 OR `props-main`.`id` = 1785590 OR `props-main`.`id` = 1785586 OR `props-main`.`id` = 1788668 OR `props-main`.`id` = 1791569 OR `props-main`.`id` = 1790369 OR `props-main`.`id` = 1790945 OR `props-main`.`id` = 1781675 OR `props-main`.`id` = 1748824 OR `props-main`.`id` = 1788036 OR `props-main`.`id` = 1719337 OR `props-main`.`id` = 1789454 OR `props-main`.`id` = 1788408 OR `props-main`.`id` = 1788737 OR `props-main`.`id` = 1788836 OR `props-main`.`id` = 1791290 OR `props-main`.`id` = 1773145 OR `props-main`.`id` = 1774026 OR `props-main`.`id` = 1744794 OR `props-main`.`id` = 1784965 OR `props-main`.`id` = 1769228 OR `props-main`.`id` = 1769343 OR `props-main`.`id` = 1786127 OR `props-main`.`id` = 1728424 OR `props-main`.`id` = 1771342 OR `props-main`.`id` = 1774250 OR `props-main`.`id` = 1785414 OR `props-main`.`id` = 1783424 OR `props-main`.`id` = 1778965 OR `props-main`.`id` = 1712806 OR `props-main`.`id` = 1782718 OR `props-main`.`id` = 1760042 OR `props-main`.`id` = 1758332 OR `props-main`.`id` = 1758345 OR `props-main`.`id` = 1753948 OR `props-main`.`id` = 1753953 OR `props-main`.`id` = 1759366 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1767787 OR `props-main`.`id` = 1789084 OR `props-main`.`id` = 1786102 OR `props-main`.`id` = 1786135 OR `props-main`.`id` = 1726614 OR `props-main`.`id` = 1790405 OR `props-main`.`id` = 1791444 OR `props-main`.`id` = 1731939 OR `props-main`.`id` = 1791393 OR `props-main`.`id` = 1791392 OR `props-main`.`id` = 1783070 OR `props-main`.`id` = 1789141 OR `props-main`.`id` = 1789150 OR `props-main`.`id` = 1789160 OR `props-main`.`id` = 1748863 OR `props-main`.`id` = 1783674 OR `props-main`.`id` = 1789166 OR `props-main`.`id` = 1789855 OR `props-main`.`id` = 1783637 OR `props-main`.`id` = 1783638 OR `props-main`.`id` = 1738561 OR `props-main`.`id` = 1748881 OR `props-main`.`id` = 1788124 OR `props-main`.`id` = 1788112 OR `props-main`.`id` = 1788131 OR `props-main`.`id` = 1788123 OR `props-main`.`id` = 1788111 OR `props-main`.`id` = 1788132 OR `props-main`.`id` = 1776879 OR `props-main`.`id` = 1780952 OR `props-main`.`id` = 1776837 OR `props-main`.`id` = 1789383 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1787306)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656772' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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
Last modified 2 hours ago Fresno MLS last checked for updates 5 minutes ago
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.
