Huge reduction!!! Charming 4 bedroom, 2 bath home offering 2,089 sq. ft. of comfortable living space on an expansive 34,848 sq. ft. lot. Country living with plenty of room to entertain, garden, or relax outdoors. The generous lot size and peaceful surroundings make this property ideal for families, hobbyist, and those seeking space and privacy. Schedule a tour today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1966
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$172
Price Per Acre
$450,000
Days On Market
378
Cumulative Days On Market
378
County
Kings
REO / Bank Owned
No
Cross Street Address
Houston Ave
Directions
198, take the 10th Ave exit and head south on 10th ave.
Heating & Cooling
Central Cooling
Laundry
Inside
Roofing
Composition
Foundation
Wood Subfloor
Primary Bedroom Level
Main
Exterior
Other
Pool
No
Pool
No
Gas & Electric
Propane, All Electric
Sewer / Water
Septic Tank, Private Well
Solar
No
APN
018 232 011
School District
Hanford Schools
School Type 1
High School
School Name 1
Hanford
School Type 2
Junior High School
School Name 2
Woodrow Wilson
School Type 3
Grade School
School Name 3
Lincoln
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 342000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 378000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1839 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2339 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` = 1686400 OR `props-main`.`id` = 1686402 OR `props-main`.`id` = 1686399 OR `props-main`.`id` = 1694206 OR `props-main`.`id` = 1626116 OR `props-main`.`id` = 1626120 OR `props-main`.`id` = 1626111 OR `props-main`.`id` = 1648248 OR `props-main`.`id` = 1643093 OR `props-main`.`id` = 1692727 OR `props-main`.`id` = 1665900 OR `props-main`.`id` = 1679817 OR `props-main`.`id` = 1694201 OR `props-main`.`id` = 1674594 OR `props-main`.`id` = 1693870 OR `props-main`.`id` = 1693668 OR `props-main`.`id` = 1693865 OR `props-main`.`id` = 1692046 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1685402 OR `props-main`.`id` = 1693846 OR `props-main`.`id` = 1653176 OR `props-main`.`id` = 1696872 OR `props-main`.`id` = 1696871 OR `props-main`.`id` = 1648085 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1668875 OR `props-main`.`id` = 1676228 OR `props-main`.`id` = 1689477 OR `props-main`.`id` = 1689476 OR `props-main`.`id` = 1694904 OR `props-main`.`id` = 1695124 OR `props-main`.`id` = 1695271 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno621478' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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
Courtesy of Susanna Alcoser, Realty One Group Action - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 15 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.
