2401 Ashwood Court delivers turnkey ease on a standout corner lot. Framed by mature trees and lush greenery, this refreshed retreat pairs cozy, character-rich updates with total peace of mind - starting with a brand-new roof overhead. Sunlit living spaces flow effortlessly for quiet evenings or weekend barbecues, all set in one of Hanford's most established, peaceful neighborhoods. Move right in and make it yours. Schedule your private showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1990
Location
City
Property Condition
Updated/Remodeled
Stories
1
Price Per Square Foot
$236
Price Per Acre
$2,180,649
Cumulative Days On London
20
County
Kings
Directions
From the corner of Fargo & 10th Ave, head east on Fargo Ave, turn south on Neil Way, turn east on Burlwood Ave, turn north on Ashwood Ct. The house is on the corner.
Heating Systems
Central
Cooling
Central
Roof
Shingle
Full Bathrooms
2
Appliances Included
Built In Microwave, Dishwasher, Gas Range/Oven
Interior Features
Jet Tub
Floors
Carpet, Laminate Floors, Tile Floors
Fireplace
Masonry, In Living Room
Pool Private Y/N
No
Spa Y/N
No
Utilities
All Public
Water Supply
Public
Sewer
Public Sewer
Solar Y/N
No
Garage Type
Garage Attached
Garage Capacity
2
Site Description
Corner Lot
Horse Property Y/N
No
APN Number
014 620 006 000
Zoning
R16
Association
Kings County Multiple Listing Service
Currently Rented
No
Lease Type
Net
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 370405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 409395 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) >= 1399 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1899 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` = 1712816 OR `props-main`.`id` = 1712810 OR `props-main`.`id` = 1745018 OR `props-main`.`id` = 1754410 OR `props-main`.`id` = 1760094 OR `props-main`.`id` = 1760174 OR `props-main`.`id` = 1765517 OR `props-main`.`id` = 1762794 OR `props-main`.`id` = 1767322 OR `props-main`.`id` = 1748864 OR `props-main`.`id` = 1724094 OR `props-main`.`id` = 1724097 OR `props-main`.`id` = 1765892 OR `props-main`.`id` = 1748875 OR `props-main`.`id` = 1767640 OR `props-main`.`id` = 1754768 OR `props-main`.`id` = 1748007 OR `props-main`.`id` = 1746804 OR `props-main`.`id` = 1746848 OR `props-main`.`id` = 1758455 OR `props-main`.`id` = 1757153 OR `props-main`.`id` = 1723041 OR `props-main`.`id` = 1767222 OR `props-main`.`id` = 1767249 OR `props-main`.`id` = 1769394 OR `props-main`.`id` = 1768990 OR `props-main`.`id` = 1770358 OR `props-main`.`id` = 1723694 OR `props-main`.`id` = 1723733 OR `props-main`.`id` = 1723742 OR `props-main`.`id` = 1768472 OR `props-main`.`id` = 1758993 OR `props-main`.`id` = 1767326 OR `props-main`.`id` = 1765898 OR `props-main`.`id` = 1724840 OR `props-main`.`id` = 1769145 OR `props-main`.`id` = 1770361 OR `props-main`.`id` = 1768012 OR `props-main`.`id` = 1768031 OR `props-main`.`id` = 1769138 OR `props-main`.`id` = 1745984 OR `props-main`.`id` = 1707238 OR `props-main`.`id` = 1764712 OR `props-main`.`id` = 1710124 OR `props-main`.`id` = 1711130 OR `props-main`.`id` = 1711142 OR `props-main`.`id` = 1770184 OR `props-main`.`id` = 1768939 OR `props-main`.`id` = 1744713 OR `props-main`.`id` = 1754478 OR `props-main`.`id` = 1752523 OR `props-main`.`id` = 1754982 OR `props-main`.`id` = 1748877 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1760958 OR `props-main`.`id` = 1763138 OR `props-main`.`id` = 1728296 OR `props-main`.`id` = 1741243 OR `props-main`.`id` = 1747274 OR `props-main`.`id` = 1752880 OR `props-main`.`id` = 1754259 OR `props-main`.`id` = 1747289 OR `props-main`.`id` = 1728299 OR `props-main`.`id` = 1738701 OR `props-main`.`id` = 1739049 OR `props-main`.`id` = 1764280 OR `props-main`.`id` = 1766942 OR `props-main`.`id` = 1739177 OR `props-main`.`id` = 1753162 OR `props-main`.`id` = 1729113 OR `props-main`.`id` = 1741567 OR `props-main`.`id` = 1741557 OR `props-main`.`id` = 1768940 OR `props-main`.`id` = 1762466 OR `props-main`.`id` = 1762479 OR `props-main`.`id` = 1736662 OR `props-main`.`id` = 1731115 OR `props-main`.`id` = 1752334 OR `props-main`.`id` = 1752887 OR `props-main`.`id` = 1716323 OR `props-main`.`id` = 1724791 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1765255 OR `props-main`.`id` = 1763669 OR `props-main`.`id` = 1751842 OR `props-main`.`id` = 1767298 OR `props-main`.`id` = 1762326 OR `props-main`.`id` = 1761024 OR `props-main`.`id` = 1761822 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1746210 OR `props-main`.`id` = 1742125 OR `props-main`.`id` = 1761739 OR `props-main`.`id` = 1761738 OR `props-main`.`id` = 1761740 OR `props-main`.`id` = 1758347 OR `props-main`.`id` = 1758773 OR `props-main`.`id` = 1760501 OR `props-main`.`id` = 1756192 OR `props-main`.`id` = 1750915 OR `props-main`.`id` = 1752088 OR `props-main`.`id` = 1736349 OR `props-main`.`id` = 1762503 OR `props-main`.`id` = 1748547 OR `props-main`.`id` = 1753362 OR `props-main`.`id` = 1737824 OR `props-main`.`id` = 1762533 OR `props-main`.`id` = 1762549 OR `props-main`.`id` = 1761465 OR `props-main`.`id` = 1762209 OR `props-main`.`id` = 1731799 OR `props-main`.`id` = 1745699 OR `props-main`.`id` = 1764296 OR `props-main`.`id` = 1737059 OR `props-main`.`id` = 1739571 OR `props-main`.`id` = 1764281 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1770579 OR `props-main`.`id` = 1768565 OR `props-main`.`id` = 1766677 OR `props-main`.`id` = 1765402 OR `props-main`.`id` = 1765581 OR `props-main`.`id` = 1751368 OR `props-main`.`id` = 1758343 OR `props-main`.`id` = 1758344 OR `props-main`.`id` = 1765475 OR `props-main`.`id` = 1765481 OR `props-main`.`id` = 1750282 OR `props-main`.`id` = 1758364 OR `props-main`.`id` = 1765998 OR `props-main`.`id` = 1752581 OR `props-main`.`id` = 1757023)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'kings234782' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-01' 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();
11
Similar Properties
$408,000
3
2
1,400
0.17
1074 Raymond Rd
Hanford, CA 93230
$386,990
3
3
1,590
0.11
1724 34 L S Harris St
Hanford, CA 93230
$385,000
3
2
1,795
0.21
144 W Cortner St
Hanford, CA 93230
$375,000
3
2
1,726
0.37
842 E Florinda St
Hanford, CA 93230
Courtesy of Michael Burke, Bloom Group, Inc.
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.
