Please provide the following information and Ashley Lovrencevic will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/agent/15077/ashley-lovrencevic/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,465,931
Days On London
1
Cumulative Days On London
1
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) >= 361000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 399000 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` = 1699087 OR `props-main`.`id` = 1699041 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1694609 OR `props-main`.`id` = 1700122 OR `props-main`.`id` = 1703974 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` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1706020 OR `props-main`.`id` = 1704877 OR `props-main`.`id` = 1706022 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` = 1702833 OR `props-main`.`id` = 1702845 OR `props-main`.`id` = 1704191 OR `props-main`.`id` = 1704189 OR `props-main`.`id` = 1703230 OR `props-main`.`id` = 1696880 OR `props-main`.`id` = 1696886 OR `props-main`.`id` = 1705653 OR `props-main`.`id` = 1703213 OR `props-main`.`id` = 1691623 OR `props-main`.`id` = 1686713 OR `props-main`.`id` = 1698146 OR `props-main`.`id` = 1696879 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` = 1690454 OR `props-main`.`id` = 1690442 OR `props-main`.`id` = 1690460 OR `props-main`.`id` = 1690462 OR `props-main`.`id` = 1702510 OR `props-main`.`id` = 1705922 OR `props-main`.`id` = 1705925 OR `props-main`.`id` = 1692537 OR `props-main`.`id` = 1683522 OR `props-main`.`id` = 1683663 OR `props-main`.`id` = 1696261 OR `props-main`.`id` = 1696262 OR `props-main`.`id` = 1692193 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` = 1704962 OR `props-main`.`id` = 1697745 OR `props-main`.`id` = 1690996 OR `props-main`.`id` = 1701967 OR `props-main`.`id` = 1701903 OR `props-main`.`id` = 1698937 OR `props-main`.`id` = 1698923 OR `props-main`.`id` = 1698938 OR `props-main`.`id` = 1704328 OR `props-main`.`id` = 1690789 OR `props-main`.`id` = 1691019 OR `props-main`.`id` = 1703724 OR `props-main`.`id` = 1688765 OR `props-main`.`id` = 1690308 OR `props-main`.`id` = 1705114 OR `props-main`.`id` = 1696740 OR `props-main`.`id` = 1704343 OR `props-main`.`id` = 1701651 OR `props-main`.`id` = 1684996 OR `props-main`.`id` = 1701638 OR `props-main`.`id` = 1697125 OR `props-main`.`id` = 1702836 OR `props-main`.`id` = 1704881 OR `props-main`.`id` = 1695590 OR `props-main`.`id` = 1695614 OR `props-main`.`id` = 1695996 OR `props-main`.`id` = 1705592 OR `props-main`.`id` = 1705580 OR `props-main`.`id` = 1705449 OR `props-main`.`id` = 1705466 OR `props-main`.`id` = 1701126)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno636320' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-06' 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();
3
Similar Properties
$386,000
3
2
1,541
0.16
926 Northstar Dr
Hanford, CA 93230
$379,900
3
2
1,513
0.12
906 Don Medico Dr
Hanford, CA 93230
$379,900
3
2
1,280
0.13
2307 Zion Way
Hanford, CA 93230
Courtesy of Deanna Raeber, Deanna Raeber - [email protected] Last modified 1 day ago Fresno MLS last checked for updates 51 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.
