For this great price you are not only getting a Beautiful 3 bedroom 2 bathroom house but you are also getting the following at no extra cost: * 2nd stove with cooking area in garage perfect for gatherings with family & friends * Washer & Dryer * Refrigerator * Table & chairs in back yard * Newly replaced roof in 2024 and much much more!!! Solar system to help lower your utilities Schedule your private showing NOW with your favorite agent
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1961
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$285
Price Per Acre
$1,977,401
Days On London
7
Cumulative Days On London
7
County
Kings
Leased Equipment
Solar Panels
REO / Bank Owned
No
Cross Street Address
12th & Hanford Armona Rd.
Directions
12th & Hanford Armona Rd. (see maps for more details)
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Shower
Flooring
Tile
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Battery
Garage Type
Attached
Garage Spaces
1
APN
012 480 085 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
Hamilton
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 299250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 330750 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) >= 855 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1355 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` = 1702190 OR `props-main`.`id` = 1702702 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1698649 OR `props-main`.`id` = 1711306 OR `props-main`.`id` = 1711315 OR `props-main`.`id` = 1709492 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1709656 OR `props-main`.`id` = 1708194 OR `props-main`.`id` = 1706685 OR `props-main`.`id` = 1701836 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1698513 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` = 1687046 OR `props-main`.`id` = 1695467 OR `props-main`.`id` = 1703994 OR `props-main`.`id` = 1711123 OR `props-main`.`id` = 1711139 OR `props-main`.`id` = 1711145 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1710013 OR `props-main`.`id` = 1705296 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1705459 OR `props-main`.`id` = 1703975 OR `props-main`.`id` = 1709682 OR `props-main`.`id` = 1709683 OR `props-main`.`id` = 1709236 OR `props-main`.`id` = 1709235 OR `props-main`.`id` = 1708363 OR `props-main`.`id` = 1709234 OR `props-main`.`id` = 1709525 OR `props-main`.`id` = 1709657 OR `props-main`.`id` = 1709505 OR `props-main`.`id` = 1709514 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1709887 OR `props-main`.`id` = 1701340 OR `props-main`.`id` = 1710889 OR `props-main`.`id` = 1698568 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1703694 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1699041 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1696094 OR `props-main`.`id` = 1696112 OR `props-main`.`id` = 1696509 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1709681 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1709675 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1694609 OR `props-main`.`id` = 1701306 OR `props-main`.`id` = 1704552 OR `props-main`.`id` = 1704553 OR `props-main`.`id` = 1701203 OR `props-main`.`id` = 1699028 OR `props-main`.`id` = 1702263 OR `props-main`.`id` = 1711264 OR `props-main`.`id` = 1705552 OR `props-main`.`id` = 1710055 OR `props-main`.`id` = 1703271 OR `props-main`.`id` = 1693452 OR `props-main`.`id` = 1696280 OR `props-main`.`id` = 1683661 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1710025 OR `props-main`.`id` = 1709911 OR `props-main`.`id` = 1704877 OR `props-main`.`id` = 1704879 OR `props-main`.`id` = 1668454 OR `props-main`.`id` = 1701856 OR `props-main`.`id` = 1701864 OR `props-main`.`id` = 1701850 OR `props-main`.`id` = 1701852 OR `props-main`.`id` = 1700018 OR `props-main`.`id` = 1702221 OR `props-main`.`id` = 1644759 OR `props-main`.`id` = 1657138 OR `props-main`.`id` = 1711336 OR `props-main`.`id` = 1710243 OR `props-main`.`id` = 1696886 OR `props-main`.`id` = 1691623)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643250' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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();
1
Similar Properties
$329,000
3
2
1,228
0.17
122 E 11th St
Hanford, CA 93230
Courtesy of Patricia Sanchez, Realty Essentials Group Inc - [email protected] Last modified 2 weeks ago Fresno MLS last checked for updates 29 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.
