Welcome to 1704 Nutshell Court, a well-maintained 3-4 bedroom, 2-bath home located in Hughson's desirable Walnut Haven neighborhood. This single-story home offers 1,597 sq. ft. with an inviting floor plan, vaulted ceilings, fireplace, beautiful flooring, a finished garage air conditioned with a split duct system, and comfortable living spaces throughout. The kitchen features sleek counters, stainless steel appliances, and a functional dining area. Located on a quiet cul-de-sac near local schools and parks, this home offers a great combination of comfort, updates, and location.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2000
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
1
Home Warranty
No
Other Equipment
Water Cond Equipment Owned
Directions to Property
Tully to Walnut Haven to Nutshell
Cross Street
Walnut Haven
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Central
Laundry Features
Cabinets, Sink, Hookups Only, Inside Room
Window Features
Dual Pane Full
Full Bathrooms
2
Bath Features
Tub w/Shower Over
Possible Bedrooms
4
# of Fireplaces
1
Fireplace Features
Living Room, Gas Piped
Flooring
Carpet, Laminate, Vinyl
Appliances
Free Standing Gas Range, Dishwasher, Disposal, Microwave
Room Type
Primary Bathroom, Primary Bedroom, Office, Laundry, Living Room
Public, Sewer Connected, Electric, Natural Gas Connected
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Garage Facing Front
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Cul-De-Sac
APN
018 078 009 000
Driveway/Sidewalks
Sidewalk/Curb/Gutter
Fencing
Back Yard, Wood
Horse Property
No
Road Surface Type
Asphalt
Road Responsibility
Public Maintained Road
Zoning Description
Residential
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Hughson Union
Middle or Junior School District
Hughson Union
Senior High School District
Hughson Union
Census Tract
29.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 508250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 561750 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) >= 1347 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1847 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` = 1744440 OR `props-main`.`id` = 1742376 OR `props-main`.`id` = 1713545 OR `props-main`.`id` = 1725726 OR `props-main`.`id` = 1727888 OR `props-main`.`id` = 1745463 OR `props-main`.`id` = 1746687 OR `props-main`.`id` = 1736202 OR `props-main`.`id` = 1725356 OR `props-main`.`id` = 1718009 OR `props-main`.`id` = 1742236 OR `props-main`.`id` = 1725874 OR `props-main`.`id` = 1726463 OR `props-main`.`id` = 1721789 OR `props-main`.`id` = 1718196 OR `props-main`.`id` = 1727631 OR `props-main`.`id` = 1735307 OR `props-main`.`id` = 1738200 OR `props-main`.`id` = 1718007 OR `props-main`.`id` = 1712462 OR `props-main`.`id` = 1722646 OR `props-main`.`id` = 1737116 OR `props-main`.`id` = 1703146 OR `props-main`.`id` = 1714636 OR `props-main`.`id` = 1727727 OR `props-main`.`id` = 1728217)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226076556' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-08' 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 Robin Matthew, Reed Realty IDX provided by Reliance Marketing
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.
