Beautiful single story home with 3 bedroom 2 bathroom with Huge backyard. Open and Airy kitchen with bottom new kitchen cabinets, full slab granite counter top, new floor and with new appliances. New interior and exterior paint , new water heater. 2 solar system (one owned and one lease). Huge Backyard. Go and Sell!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1961
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$269
Price Per Acre
$2,519,971
Days On London
9
Cumulative Days On London
9
County
Kings
REO / Bank Owned
No
Cross Street Address
Parkside Dr
Directions
from 12th ave, west on Woodland, south on Parkside, North on Cling cir
Heating & Cooling
Central Heat & Cool
Laundry
In Garage
Roofing
Composition
Foundation
Concrete
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Solar
Yes
Solar Type
Owned
Parking Features
Potential RV Parking
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
APN
011 100 075 000
Zoning
R16
School District
Hanford Schools
School Type 1
High School
School Name 1
Sierra Pacific
School Type 2
Junior High School
School Name 2
Woodrow Wilson
School Type 3
Grade School
School Name 3
Roosevelt
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 329650 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 364350 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) >= 1038 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1538 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` = 1694201 OR `props-main`.`id` = 1702190 OR `props-main`.`id` = 1702702 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1717313 OR `props-main`.`id` = 1695834 OR `props-main`.`id` = 1709656 OR `props-main`.`id` = 1708194 OR `props-main`.`id` = 1706685 OR `props-main`.`id` = 1691468 OR `props-main`.`id` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1703994 OR `props-main`.`id` = 1704944 OR `props-main`.`id` = 1717105 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1710013 OR `props-main`.`id` = 1717104 OR `props-main`.`id` = 1717116 OR `props-main`.`id` = 1705296 OR `props-main`.`id` = 1715203 OR `props-main`.`id` = 1715202 OR `props-main`.`id` = 1705459 OR `props-main`.`id` = 1709682 OR `props-main`.`id` = 1702909 OR `props-main`.`id` = 1716139 OR `props-main`.`id` = 1713398 OR `props-main`.`id` = 1713391 OR `props-main`.`id` = 1713396 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1713884 OR `props-main`.`id` = 1703027 OR `props-main`.`id` = 1709887 OR `props-main`.`id` = 1702012 OR `props-main`.`id` = 1702016 OR `props-main`.`id` = 1702021 OR `props-main`.`id` = 1712336 OR `props-main`.`id` = 1712367 OR `props-main`.`id` = 1713905 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1716731 OR `props-main`.`id` = 1703694 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1714894 OR `props-main`.`id` = 1712814 OR `props-main`.`id` = 1677314 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1709675 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1704066 OR `props-main`.`id` = 1717395 OR `props-main`.`id` = 1717401 OR `props-main`.`id` = 1710025 OR `props-main`.`id` = 1709911 OR `props-main`.`id` = 1711371 OR `props-main`.`id` = 1704877 OR `props-main`.`id` = 1704879)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645110' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-20' 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();
2
Similar Properties
$350,000
3
2
1,344
0.11
10692 Daisy Way
Armona, CA 93202
$350,000
3
2
1,400
0.18
1921 S Kerckhoff Way
Hanford, CA 93230
Courtesy of Tejinder Khehra, RE/MAX Gold - [email protected] Last modified 2 hours ago Fresno MLS last checked for updates 22 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.
