London Properties, Ltd.559.436.4071Email Agentinfo@londonproperties.com
Property Description
Listing Agent: Nai Saechao, Homesmart PV & Assoc., Merced
MUST SEE IN HUGHSON!!! This beautiful single-story home has 4 bedrooms, 2 bathrooms, at approximately 2,056 Sqft the home features a separate living room, family room, office, den with a closet. (can be a bedroom) formal dining area, spacious kitchen with quartz countertop and large kitchen island, primary suite with walk in closet, and outdoor access. Large 3 car garage with lots of storages. Full landscape with a patio area in the back for entertainment. Please let me know if you have any questions.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2002
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
2
Entry Level
1
Price Per Square Foot
$285
Days On London
20
Cumulative Days On London
20
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
E Hatch rd. Make a right to Tully rd. House will be on the left. Right by the park.
Room Type
All Bedrooms Down
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Main Level Bedrooms
1
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
1
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
0-1 Unit/Acre
Lot Size Area
7008.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Park/Greenbelt
Common Interest
None
Parcel Number
018080004000
Additional Parcels Y/N
No
Community Features
Park
Senior Community Y/N
No
Association Y/N
No
High School District
Stanislaus Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
140
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 555749.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 614248.95 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) >= 1806 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2306 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` = 1762813 OR `props-main`.`id` = 1753324 OR `props-main`.`id` = 1749896 OR `props-main`.`id` = 1749922 OR `props-main`.`id` = 1763502 OR `props-main`.`id` = 1760946 OR `props-main`.`id` = 1745463 OR `props-main`.`id` = 1736202 OR `props-main`.`id` = 1758434 OR `props-main`.`id` = 1718009 OR `props-main`.`id` = 1727631 OR `props-main`.`id` = 1735307 OR `props-main`.`id` = 1738200 OR `props-main`.`id` = 1718007 OR `props-main`.`id` = 1757494 OR `props-main`.`id` = 1712462 OR `props-main`.`id` = 1766725 OR `props-main`.`id` = 1750641 OR `props-main`.`id` = 1737116 OR `props-main`.`id` = 1703146 OR `props-main`.`id` = 1750487 OR `props-main`.`id` = 1764879 OR `props-main`.`id` = 1727727 OR `props-main`.`id` = 1728217 OR `props-main`.`id` = 1753885)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26174797' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-31' 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();
4
Similar Properties
$575,000
4
3
1,985
0.11
1808 Apiary Way
Hughson, CA 95326
$565,000
4
3
2,050
0.18
2143 Locust Ct
Hughson, CA 95326
$559,990
4
2
2,143
0.11
1624 Apiary Way
Hughson, CA 95326
$556,990
4
2
2,202
0.11
6113 Honey Haven Ln
Hughson, CA 95326
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.
