Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/636320/2141-W-Hampton-Dr/Hanford/https://www.londonproperties.com/images/props/fresno/full/636320.jpgLondon Properties Hanford Real Estate | 2141 W Hampton Dr
This North West Hanford Home in Pioneer School District is Calling Out To You!! A Short Walking Distance to School! If You Are Looking For Move-In Ready, a Secluded Corner Lot, Tons of Extra Cement Surrounding Home, at an Affordable Price, This is IT!! Newer Luxury Vinyl Tile Flooring & Cam Lighting! 3 Bedrooms, 2 Full Bathrooms, Spacious Kitchen-Living-Dining Open Concept! Fully-Fenced Backyard Has 2 Patio Gazebo Areas for Respite from the Summer Sun & Winter Rains! Complete with Keyless Entry for Your Family & Leased Solar Including a Tesla Charging Station For Economical Utility Bills! Arrange Your Viewing Today! This Comfortable, Affordable Home Will Not Last Long!!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$265
Price Per Acre
$2,459,442
Days On London
14
Cumulative Days On London
14
County
Kings
Leased Equipment
Solar Panels
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
Vintage
Directions
W Grangeville Blvd, N @Vintage, W @Hampton to the Corner
Unit Description
Ground Floor
Style
Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 360050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 397950 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) >= 1182 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1682 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` = 1681814 OR `props-main`.`id` = 1703694 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1699041 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1709675 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1694609 OR `props-main`.`id` = 1704552 OR `props-main`.`id` = 1704553 OR `props-main`.`id` = 1699028 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` = 1710124 OR `props-main`.`id` = 1711130 OR `props-main`.`id` = 1711142 OR `props-main`.`id` = 1702833 OR `props-main`.`id` = 1702845 OR `props-main`.`id` = 1704191 OR `props-main`.`id` = 1704189 OR `props-main`.`id` = 1711336 OR `props-main`.`id` = 1709188 OR `props-main`.`id` = 1709193 OR `props-main`.`id` = 1710243 OR `props-main`.`id` = 1696886 OR `props-main`.`id` = 1691623 OR `props-main`.`id` = 1709476 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1694424 OR `props-main`.`id` = 1698153 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1697869 OR `props-main`.`id` = 1690462 OR `props-main`.`id` = 1705922 OR `props-main`.`id` = 1705925 OR `props-main`.`id` = 1692537 OR `props-main`.`id` = 1708431 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1708433 OR `props-main`.`id` = 1696261 OR `props-main`.`id` = 1696262 OR `props-main`.`id` = 1692193 OR `props-main`.`id` = 1707094 OR `props-main`.`id` = 1687097 OR `props-main`.`id` = 1696935 OR `props-main`.`id` = 1696934 OR `props-main`.`id` = 1704664 OR `props-main`.`id` = 1704677 OR `props-main`.`id` = 1705468 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1700061 OR `props-main`.`id` = 1700065 OR `props-main`.`id` = 1700093 OR `props-main`.`id` = 1700051 OR `props-main`.`id` = 1695753 OR `props-main`.`id` = 1697745 OR `props-main`.`id` = 1709803 OR `props-main`.`id` = 1709806 OR `props-main`.`id` = 1690996 OR `props-main`.`id` = 1698937 OR `props-main`.`id` = 1698938 OR `props-main`.`id` = 1708238 OR `props-main`.`id` = 1704328 OR `props-main`.`id` = 1690789 OR `props-main`.`id` = 1691019 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1709561 OR `props-main`.`id` = 1690308 OR `props-main`.`id` = 1705114 OR `props-main`.`id` = 1696740 OR `props-main`.`id` = 1704343 OR `props-main`.`id` = 1709226 OR `props-main`.`id` = 1709213 OR `props-main`.`id` = 1709219 OR `props-main`.`id` = 1701651 OR `props-main`.`id` = 1701638 OR `props-main`.`id` = 1711095 OR `props-main`.`id` = 1711081 OR `props-main`.`id` = 1711093 OR `props-main`.`id` = 1711265 OR `props-main`.`id` = 1706823 OR `props-main`.`id` = 1706833 OR `props-main`.`id` = 1704881 OR `props-main`.`id` = 1706731 OR `props-main`.`id` = 1701126)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636320' 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();
2
Similar Properties
$379,000
3
2
1,513
0.12
906 Don Medico Dr
Hanford, CA 93230
$375,000
3
2
1,325
0.14
921 Don Medico Dr
Hanford, CA 93230
Courtesy of Deanna Raeber, Deanna Raeber - [email protected] Last modified 6 days 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.
