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
$253
Price Per Acre
$2,371,097
Days On London
90
Cumulative Days On London
90
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) >= 310175 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 342825 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` = 1728731 OR `props-main`.`id` = 1728733 OR `props-main`.`id` = 1702192 OR `props-main`.`id` = 1721731 OR `props-main`.`id` = 1721710 OR `props-main`.`id` = 1719568 OR `props-main`.`id` = 1727934 OR `props-main`.`id` = 1708194 OR `props-main`.`id` = 1734095 OR `props-main`.`id` = 1717863 OR `props-main`.`id` = 1717862 OR `props-main`.`id` = 1717867 OR `props-main`.`id` = 1717879 OR `props-main`.`id` = 1717885 OR `props-main`.`id` = 1706685 OR `props-main`.`id` = 1726974 OR `props-main`.`id` = 1733210 OR `props-main`.`id` = 1731249 OR `props-main`.`id` = 1728758 OR `props-main`.`id` = 1716929 OR `props-main`.`id` = 1716910 OR `props-main`.`id` = 1720568 OR `props-main`.`id` = 1720570 OR `props-main`.`id` = 1728424 OR `props-main`.`id` = 1687940 OR `props-main`.`id` = 1727025 OR `props-main`.`id` = 1721026 OR `props-main`.`id` = 1724354 OR `props-main`.`id` = 1719994 OR `props-main`.`id` = 1719993 OR `props-main`.`id` = 1732951 OR `props-main`.`id` = 1733039 OR `props-main`.`id` = 1732875 OR `props-main`.`id` = 1728338 OR `props-main`.`id` = 1734153 OR `props-main`.`id` = 1725400 OR `props-main`.`id` = 1725451 OR `props-main`.`id` = 1731673 OR `props-main`.`id` = 1725454 OR `props-main`.`id` = 1701341 OR `props-main`.`id` = 1724616 OR `props-main`.`id` = 1726496 OR `props-main`.`id` = 1726509 OR `props-main`.`id` = 1726546 OR `props-main`.`id` = 1722858 OR `props-main`.`id` = 1727195 OR `props-main`.`id` = 1731820 OR `props-main`.`id` = 1728888 OR `props-main`.`id` = 1726614 OR `props-main`.`id` = 1731939 OR `props-main`.`id` = 1727185 OR `props-main`.`id` = 1723591 OR `props-main`.`id` = 1716730 OR `props-main`.`id` = 1722153 OR `props-main`.`id` = 1712807 OR `props-main`.`id` = 1723304 OR `props-main`.`id` = 1622949 OR `props-main`.`id` = 1729497 OR `props-main`.`id` = 1731905 OR `props-main`.`id` = 1724618 OR `props-main`.`id` = 1724829 OR `props-main`.`id` = 1724843 OR `props-main`.`id` = 1724844 OR `props-main`.`id` = 1724845 OR `props-main`.`id` = 1727768 OR `props-main`.`id` = 1728425 OR `props-main`.`id` = 1728492 OR `props-main`.`id` = 1728493 OR `props-main`.`id` = 1728494 OR `props-main`.`id` = 1728509 OR `props-main`.`id` = 1728510 OR `props-main`.`id` = 1727919 OR `props-main`.`id` = 1727946 OR `props-main`.`id` = 1728375 OR `props-main`.`id` = 1728610 OR `props-main`.`id` = 1713710 OR `props-main`.`id` = 1728603 OR `props-main`.`id` = 1727905 OR `props-main`.`id` = 1727906 OR `props-main`.`id` = 1731725 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1731402 OR `props-main`.`id` = 1724968 OR `props-main`.`id` = 1730450 OR `props-main`.`id` = 1735424 OR `props-main`.`id` = 1728673 OR `props-main`.`id` = 1731865)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645110' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-09' 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
$315,000
3
2
1,201
0.15
10845 Beverly Dr
Hanford, CA 93230
$313,000
4
2
1,438
0.14
10840 Beverly Dr
Hanford, CA 93230
Last modified 1 week ago Fresno MLS last checked for updates 20 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.
