Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/MC25269947/952-Upp-Ct/Hanford/https://www.londonproperties.com/images/props/crmls/full/MC25269947.jpgLondon Properties Hanford Real Estate | 952 Upp Ct
Listing Agent: Ashley Verna, Keller Williams Property Team
Welcome to 952 Upp Ct. A charming and well-kept single-story home tucked into a quiet Hanford cul-de-sac. This 3-bed, 2-bath property offers 1,300 sq ft of comfortable living space on a spacious 6,526 sq ft lot. Built in 1997, the home features a functional floorplan with a bright living area, open kitchen layout, brand-new stainless-steel appliances, and generously sized bedrooms. The backyard offers RV parking and plenty of space to create your own mini oasis.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1997
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Front
Price Per Square Foot
$277
Days On London
119
Cumulative Days On London
119
County Or Parish
Kings
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
right onto Ambassador Dr; left onto Zion Way; left onto Upp Ct
Room Type
Primary Bedroom, Laundry, Kitchen, Living Room, Primary Bathroom
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Room Kitchen Features
Tile Counters, Kitchen Island
Eating Area
Area
Appliances Y/N
Yes
Appliances
Microwave, Dishwasher
Room Bathroom Features
Bathtub, Shower
Interior Features
Ceiling Fan(s)
Flooring
Carpet
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage, Garage Faces Front, Driveway
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Corner Lot, Landscaped, Back Yard, Lawn
Lot Size Area
6526.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Common Interest
None
Parcel Number
008370047000
Additional Parcels Y/N
No
Community Features
Street Lights, Sidewalks, Suburban
Senior Community Y/N
No
Association Y/N
No
High School District
Hanford Joint Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
68
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) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1050 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1550 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` = 1622949 OR `props-main`.`id` = 1692171 OR `props-main`.`id` = 1719343 OR `props-main`.`id` = 1702263 OR `props-main`.`id` = 1711264 OR `props-main`.`id` = 1705552 OR `props-main`.`id` = 1718585 OR `props-main`.`id` = 1719548 OR `props-main`.`id` = 1719545 OR `props-main`.`id` = 1708500 OR `props-main`.`id` = 1709171 OR `props-main`.`id` = 1709168 OR `props-main`.`id` = 1720483 OR `props-main`.`id` = 1720485 OR `props-main`.`id` = 1713974 OR `props-main`.`id` = 1713982 OR `props-main`.`id` = 1713971 OR `props-main`.`id` = 1706879 OR `props-main`.`id` = 1710007 OR `props-main`.`id` = 1720395 OR `props-main`.`id` = 1697920 OR `props-main`.`id` = 1702783 OR `props-main`.`id` = 1688012 OR `props-main`.`id` = 1721486 OR `props-main`.`id` = 1721487 OR `props-main`.`id` = 1721414 OR `props-main`.`id` = 1721482 OR `props-main`.`id` = 1719590 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` = 1718070 OR `props-main`.`id` = 1720448 OR `props-main`.`id` = 1720460 OR `props-main`.`id` = 1720445 OR `props-main`.`id` = 1720447 OR `props-main`.`id` = 1712815 OR `props-main`.`id` = 1718897 OR `props-main`.`id` = 1710124 OR `props-main`.`id` = 1711130 OR `props-main`.`id` = 1711142 OR `props-main`.`id` = 1702833 OR `props-main`.`id` = 1702845 OR `props-main`.`id` = 1709188 OR `props-main`.`id` = 1709193 OR `props-main`.`id` = 1713472 OR `props-main`.`id` = 1721393 OR `props-main`.`id` = 1697272 OR `props-main`.`id` = 1719939 OR `props-main`.`id` = 1712817 OR `props-main`.`id` = 1681688 OR `props-main`.`id` = 1681689 OR `props-main`.`id` = 1694424 OR `props-main`.`id` = 1692202 OR `props-main`.`id` = 1694426 OR `props-main`.`id` = 1708431 OR `props-main`.`id` = 1708433 OR `props-main`.`id` = 1708489 OR `props-main`.`id` = 1722672 OR `props-main`.`id` = 1722665 OR `props-main`.`id` = 1712633 OR `props-main`.`id` = 1712651 OR `props-main`.`id` = 1717617 OR `props-main`.`id` = 1717980 OR `props-main`.`id` = 1718508 OR `props-main`.`id` = 1704293 OR `props-main`.`id` = 1708483 OR `props-main`.`id` = 1708010 OR `props-main`.`id` = 1715516 OR `props-main`.`id` = 1715515 OR `props-main`.`id` = 1715524 OR `props-main`.`id` = 1715526 OR `props-main`.`id` = 1713386 OR `props-main`.`id` = 1716323 OR `props-main`.`id` = 1721623 OR `props-main`.`id` = 1696935 OR `props-main`.`id` = 1696934 OR `props-main`.`id` = 1705468 OR `props-main`.`id` = 1722519 OR `props-main`.`id` = 1094176 OR `props-main`.`id` = 1719330 OR `props-main`.`id` = 1719327 OR `props-main`.`id` = 1719328 OR `props-main`.`id` = 1721515 OR `props-main`.`id` = 1704935 OR `props-main`.`id` = 1704975 OR `props-main`.`id` = 1695753 OR `props-main`.`id` = 1715663 OR `props-main`.`id` = 1719073 OR `props-main`.`id` = 1718727 OR `props-main`.`id` = 1718107 OR `props-main`.`id` = 1721655 OR `props-main`.`id` = 1720918 OR `props-main`.`id` = 1720927 OR `props-main`.`id` = 1719564 OR `props-main`.`id` = 1719641 OR `props-main`.`id` = 1718106 OR `props-main`.`id` = 1721351 OR `props-main`.`id` = 1721531 OR `props-main`.`id` = 1721359 OR `props-main`.`id` = 1720620 OR `props-main`.`id` = 1720675 OR `props-main`.`id` = 1715600 OR `props-main`.`id` = 1718120 OR `props-main`.`id` = 1722148 OR `props-main`.`id` = 1722151 OR `props-main`.`id` = 1696680 OR `props-main`.`id` = 1696498 OR `props-main`.`id` = 1696560 OR `props-main`.`id` = 1697839 OR `props-main`.`id` = 1722513 OR `props-main`.`id` = 1722512 OR `props-main`.`id` = 1698937 OR `props-main`.`id` = 1698938 OR `props-main`.`id` = 1720574 OR `props-main`.`id` = 1721750 OR `props-main`.`id` = 1708238 OR `props-main`.`id` = 1722391 OR `props-main`.`id` = 1722389 OR `props-main`.`id` = 1722405 OR `props-main`.`id` = 1722426 OR `props-main`.`id` = 1721165 OR `props-main`.`id` = 1721456 OR `props-main`.`id` = 1720718 OR `props-main`.`id` = 1718746 OR `props-main`.`id` = 1704240 OR `props-main`.`id` = 1709561 OR `props-main`.`id` = 1711293 OR `props-main`.`id` = 1711150 OR `props-main`.`id` = 1711290 OR `props-main`.`id` = 1721843 OR `props-main`.`id` = 1717632 OR `props-main`.`id` = 1722700 OR `props-main`.`id` = 1722689 OR `props-main`.`id` = 1712572 OR `props-main`.`id` = 1712568 OR `props-main`.`id` = 1712626 OR `props-main`.`id` = 1716333 OR `props-main`.`id` = 1712621 OR `props-main`.`id` = 1711095 OR `props-main`.`id` = 1711081 OR `props-main`.`id` = 1711093 OR `props-main`.`id` = 1718235 OR `props-main`.`id` = 1718994 OR `props-main`.`id` = 1707015 OR `props-main`.`id` = 1707022 OR `props-main`.`id` = 1707016 OR `props-main`.`id` = 1704221 OR `props-main`.`id` = 1706823 OR `props-main`.`id` = 1706833 OR `props-main`.`id` = 1680247 OR `props-main`.`id` = 1713158 OR `props-main`.`id` = 1719146 OR `props-main`.`id` = 1721034 OR `props-main`.`id` = 1718914 OR `props-main`.`id` = 1720318 OR `props-main`.`id` = 1720315 OR `props-main`.`id` = 1719529 OR `props-main`.`id` = 1719489 OR `props-main`.`id` = 1721002 OR `props-main`.`id` = 1719240 OR `props-main`.`id` = 1719483 OR `props-main`.`id` = 1702770 OR `props-main`.`id` = 1720378 OR `props-main`.`id` = 1720380 OR `props-main`.`id` = 1720391 OR `props-main`.`id` = 1720398 OR `props-main`.`id` = 1720490 OR `props-main`.`id` = 1705125)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25269947' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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();
10
Similar Properties
$375,000
3
2
1,550
0.15
440 W Pepper Dr
Hanford, CA 93230
$375,000
3
2
1,332
0.16
1963 W Merritt
Hanford, CA 93230
$365,000
3
2
1,494
0.14
1915 Valley Springs Ave
Hanford, CA 93230
$344,000
3
2
1,458
0.15
982 Cedarwood St
Hanford, CA 93230
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.
