Great investment opportunity!! Charming traditional single-story with updated kitchen granite countertops, newer cabinets, must see to appreciate! Conveniently located close to school.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1958
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$252
Price Per Acre
$2,839,397
Days On Market
64
Cumulative Days On Market
64
County
Kings
REO / Bank Owned
No
Cross Street Address
11th Ave
Directions
From South 11Th Ave, make a left on Hume ave property on your right side hand.
Heating & Cooling
Evaporative Cool
Laundry
Inside, Utility Room, Gas Hook Up
Roofing
Composition
Foundation
Concrete
Dining Room Features
Living Room/Area, Family Room/Area
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
# of Fireplaces
1
Fireplace Type
Wood Insert
Exterior
Wood
Pool
No
Pool
No
Spa
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
No
Garage Type
Detached
Garage Spaces
2
Site Amenities
Corner
APN
011 370 009 000
Zoning
R16
School District
Hanford Schools
School Type 1
Grade School
School Name 1
Martin Luther King
School Type 2
Junior High School
School Name 2
John F. Kennedy
School Type 3
High School
School Name 3
Hanford West
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 304000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 336000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1022 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1522 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` = 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` = 1698649 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` = 1698513 OR `props-main`.`id` = 1687039 OR `props-main`.`id` = 1687037 OR `props-main`.`id` = 1691467 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1687321 OR `props-main`.`id` = 1687046 OR `props-main`.`id` = 1695467 OR `props-main`.`id` = 1696113 OR `props-main`.`id` = 1695957 OR `props-main`.`id` = 1695977 OR `props-main`.`id` = 1694359 OR `props-main`.`id` = 1694904 OR `props-main`.`id` = 1695124 OR `props-main`.`id` = 1695271 OR `props-main`.`id` = 1694643 OR `props-main`.`id` = 1692213 OR `props-main`.`id` = 1540885 OR `props-main`.`id` = 1593798 OR `props-main`.`id` = 1692212 OR `props-main`.`id` = 1695172 OR `props-main`.`id` = 1692366 OR `props-main`.`id` = 1692368 OR `props-main`.`id` = 1692412 OR `props-main`.`id` = 1698568 OR `props-main`.`id` = 1571373 OR `props-main`.`id` = 1571371 OR `props-main`.`id` = 1681814 OR `props-main`.`id` = 1686730 OR `props-main`.`id` = 1686276 OR `props-main`.`id` = 1677774 OR `props-main`.`id` = 1699087 OR `props-main`.`id` = 1696438 OR `props-main`.`id` = 1699041 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1691606 OR `props-main`.`id` = 1695517 OR `props-main`.`id` = 1696094 OR `props-main`.`id` = 1696112 OR `props-main`.`id` = 1696509 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1681909 OR `props-main`.`id` = 1693541 OR `props-main`.`id` = 1685459 OR `props-main`.`id` = 1685460 OR `props-main`.`id` = 1696855 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1694609 OR `props-main`.`id` = 1692170 OR `props-main`.`id` = 1691177 OR `props-main`.`id` = 1699028 OR `props-main`.`id` = 1683661)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno639084' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-26' 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 Bernadette Bray, All Family Lending and Real Estate Inc - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 21 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.
