Courtesy of Teymour Farhang, Berkshire Hathaway HomeServices California Realty - [email protected]
This exceptional luxury-built home in one of Hanford's most sought-after locations offers the perfect blend of comfort, quality, and effortless entertaining. Designed with both everyday living and gathering in mind, the open-concept floor plan features a spacious great room, functional split-bedroom layout, formal and informal dining areas, and a dedicated office. Set on a large lot, the beautifully designed backyard is an entertainer's dream, complete with a sparkling pool and plenty of space for relaxing, dining, and enjoying time with family and friends. Owned solar adds energy efficiency, while the oversized three-car garage provides abundant parking and storage. With thoughtful upgrades, exceptional craftsmanship, and an ideal layout, this rare property is sure to impress even the most discerning buyer. Don't miss your opportunity to experience this remarkable homeschedule your private viewing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2010
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$279
Price Per Acre
$1,938,153
Days On London
0
Cumulative Days On London
0
County
Kings
REO / Bank Owned
No
Cross Street Address
Meadow View & Fargo
Directions
From 10th Ave, East on Fargo, North on Meadow View Road to the property
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Main
Flooring
Tile
# of Fireplaces
1
Fireplace Type
Gas Insert
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Patio Features
Covered
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
APN
014 400 027
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Kings River Hardwick
School Type 3
Grade School
School Name 3
Kings River Hardwick
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 845500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 934500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2944 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3444 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` = 1748864 OR `props-main`.`id` = 1765892 OR `props-main`.`id` = 1748875 OR `props-main`.`id` = 1754768 OR `props-main`.`id` = 1748007 OR `props-main`.`id` = 1723694 OR `props-main`.`id` = 1723733 OR `props-main`.`id` = 1723742 OR `props-main`.`id` = 1760863 OR `props-main`.`id` = 1758993 OR `props-main`.`id` = 1765898 OR `props-main`.`id` = 1724840 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` = 1754478 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` = 1759340 OR `props-main`.`id` = 1738701 OR `props-main`.`id` = 1739049 OR `props-main`.`id` = 1764280 OR `props-main`.`id` = 1750955 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` = 1762466 OR `props-main`.`id` = 1762479 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` = 1762326 OR `props-main`.`id` = 1761024 OR `props-main`.`id` = 1761822 OR `props-main`.`id` = 1757572 OR `props-main`.`id` = 1746210 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` = 1758413 OR `props-main`.`id` = 1736349 OR `props-main`.`id` = 1762503 OR `props-main`.`id` = 1748547 OR `props-main`.`id` = 1753362 OR `props-main`.`id` = 1744424 OR `props-main`.`id` = 1744396 OR `props-main`.`id` = 1744402 OR `props-main`.`id` = 1745341 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` = 1739595 OR `props-main`.`id` = 1741083 OR `props-main`.`id` = 1764281 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1759433 OR `props-main`.`id` = 1754206 OR `props-main`.`id` = 1754468 OR `props-main`.`id` = 1754342 OR `props-main`.`id` = 1754405 OR `props-main`.`id` = 1766416 OR `props-main`.`id` = 1766438 OR `props-main`.`id` = 1766432 OR `props-main`.`id` = 1765402 OR `props-main`.`id` = 1765581 OR `props-main`.`id` = 1751368 OR `props-main`.`id` = 1738280 OR `props-main`.`id` = 1738619 OR `props-main`.`id` = 1738689 OR `props-main`.`id` = 1740019 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`) != 'fresno654216' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-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();
0
Last modified 3 hours ago Fresno MLS last checked for updates 44 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.
