Newer 2016 Affordable Starter Home: 3 Bedrooms, 2 Bathrooms, 2-Car Attached Garage in a Somewhat Secluded South-West, All-Newer-Home Neighborhood! Carpeting Will Be Cleaned by Ryan's Carpets After Seller Move-Out (cola spotting will come up). Inside Laundry Closet! Easy-to-Maintain Backyard with Succulents, Some Grass, Sprinklers, an Open Cement Patio & Shed!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2016
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$270
Price Per Acre
$2,544,098
Days On London
0
Cumulative Days On London
0
County
Kings
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Hanford-Armona Rd
Directions
Hwy 198, 12th Ave Exit, South to Hanford-Armona Rd, turn East/Left on H-A Rd, South/Right on Manor, follow the curve around to 1383 Manor
Unit Description
Ground Floor
Heating & Cooling
Central Heat & Cool
Laundry
Inside, In Closet
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
F/S Range/Oven, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry, Refrigerator
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Basement
None
Flooring
Carpet, Vinyl
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Patio Features
Uncovered, Concrete
Yard
Sprinklers Auto, Fenced, Mature Landscape
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
011 520 058 000
Zoning
SFR
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford West
School Type 2
Junior High School
School Name 2
Woodrow Wilson
School Type 3
Grade School
School Name 3
Martin Luther King
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 1140 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1640 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` = 1719951 OR `props-main`.`id` = 1702190 OR `props-main`.`id` = 1702702 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1714018 OR `props-main`.`id` = 1718986 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1709656 OR `props-main`.`id` = 1719547 OR `props-main`.`id` = 1719568 OR `props-main`.`id` = 1719569 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` = 1653176 OR `props-main`.`id` = 1719337 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1717067 OR `props-main`.`id` = 1717090 OR `props-main`.`id` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1720568 OR `props-main`.`id` = 1720570 OR `props-main`.`id` = 1717105 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1719333 OR `props-main`.`id` = 1715631 OR `props-main`.`id` = 1716144 OR `props-main`.`id` = 1710013 OR `props-main`.`id` = 1718327 OR `props-main`.`id` = 1718335 OR `props-main`.`id` = 1718330 OR `props-main`.`id` = 1718344 OR `props-main`.`id` = 1717116 OR `props-main`.`id` = 1705296 OR `props-main`.`id` = 1717957 OR `props-main`.`id` = 1718418 OR `props-main`.`id` = 1718383 OR `props-main`.`id` = 1719994 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1712806 OR `props-main`.`id` = 1719993 OR `props-main`.`id` = 1705459 OR `props-main`.`id` = 1709682 OR `props-main`.`id` = 1719588 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1709887 OR `props-main`.`id` = 1701340 OR `props-main`.`id` = 1714618 OR `props-main`.`id` = 1713905 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1716731 OR `props-main`.`id` = 1703694 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1714894 OR `props-main`.`id` = 1712814 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` = 1693541 OR `props-main`.`id` = 1712808 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1719589 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1720395 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1717395 OR `props-main`.`id` = 1717401 OR `props-main`.`id` = 1710025 OR `props-main`.`id` = 1709911)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644175' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-07' 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();
4
Similar Properties
$385,000
4
2
1,574
0.16
1853 S Kerckhoff Way
Hanford, CA 93230
$384,400
4
2
1,509
0.14
1050 15 BR Billingsley St
Hanford, CA 93230
$378,240
4
2
1,509
0.16
179 23 L Evergreen Ln
Hanford, CA 93230
$366,490
3
3
1,380
0.12
155 21 L Evergreen Ln
Hanford, CA 93230
Courtesy of Deanna Raeber, Deanna Raeber - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 18 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.
