London Properties Hughson Real Estate

1501 Tristan Ct

Hughson, CA 95326

Copy Link Get Directions

Photo Gallery

$719,900

5 bd

4 ba

3,468 sq ft

0.18 acre

1501 Tristan Ct

Hughson, CA 95326

Get Directions

Listed On: 06/09/2026

Status: Active

Listing Number: 226073373 (Metrolist MLS)

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.436.4071 Email Agent

Property Description

Rare opportunity to purchase a spacious 5 bedroom, 4 bathroom home offering approximately 3,468 square feet of living space with potential RV access. This well-designed floor plan features a formal living room, separate family room, upstairs loft area, and a highly desirable full bedroom and bathroom downstairs. The second level includes 4 additional bedrooms and 3 full bathrooms, providing plenty of space for family, guests, or a home office setup. The home also offers a 3-car garage with a kitchen setup in the garage, generous living areas, and a functional layout ideal for both everyday living and entertaining. With its size, bedroom count, downstairs suite, potential RV access, and added garage kitchen, 1501 Tristan Court presents an excellent opportunity for buyers seeking space, flexibility, and long-term value.

Property Type

Residential

Property Subtype 1

Single Family Residence

Subtype Description

Detached

Year Built

2004

Year Built Source

Assessor Auto-Fill

Remodeled/Updated

Yes

Remodeled/Updated Desc

Other-Rmks 0-5YR

Stories

Home Warranty

Directions to Property

99 to E Hatch Rd to Seventh St to Chantilly Way to Tristan Ct.

Cross Street

Chantilly Way

County

Stanislaus

Special Listing Conditions

None

Main Level

Bedroom(s), Living Room, Dining Room, Full Bath(s), Garage, Kitchen

Construction Materials

Stucco, Wood

Foundation

Concrete, Slab

Roof

Tile

Heating

Central, Fireplace(s)

Cooling

Ceiling Fan(s), Central

Laundry Features

Cabinets, Sink, Inside Room

Full Bathrooms

Bath Features

Tile, Tub w/Shower Over

# of Fireplaces

Fireplace Features

Family Room, Gas Piped

Flooring

Carpet, Tile, Vinyl

Kitchen Features

Island, Kitchen/Family Combo

Dining Room Features

Dining/Family Combo, Space in Kitchen

Living Room Features

Great Room

Family Room Features

Great Room

Primary Bathroom Features

Shower Stall(s), Double Sinks, Soaking Tub, Tile

Upper Level

Bedroom(s), Loft, Full Bath(s)

Pool

Spa

ADU/2nd Unit

Utilities

Public

Electric

220 Volts,220 Volts in Laundry

Irrigation

None

Water Source

Public

Sewer

Public Sewer

Parking Features

Attached, Garage Facing Front

Garage Spaces

3.00

Lot Features

Manual Sprinkler F&R, Cul-De-Sac, Low Maintenance

APN

018 085 005 000

Horse Property

Zoning Description

SFR

List AOR

MetroList Services, Inc.

Association

Senior Community

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.04

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 683905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 755895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3218 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3718 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` = 1731269 OR `props-main`.`id` = 1695940 OR `props-main`.`id` = 1713545 OR `props-main`.`id` = 1725726 OR `props-main`.`id` = 1736742 OR `props-main`.`id` = 1721385 OR `props-main`.`id` = 1709990 OR `props-main`.`id` = 1737243 OR `props-main`.`id` = 1736997 OR `props-main`.`id` = 1727888 OR `props-main`.`id` = 1736202 OR `props-main`.`id` = 1725356 OR `props-main`.`id` = 1718009 OR `props-main`.`id` = 1725874 OR `props-main`.`id` = 1726463 OR `props-main`.`id` = 1721789 OR `props-main`.`id` = 1718196 OR `props-main`.`id` = 1728795 OR `props-main`.`id` = 1727631 OR `props-main`.`id` = 1735307 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 OR `props-main`.`id` = 1728119)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226073373' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-15' 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();

Courtesy of Sonny Uppal, Adroit Real Estate
IDX provided by Reliance Marketing

Metrolist
Terms of Use

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.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

1501 Tristan Ct

Hughson, CA 95326

Photo Gallery

$719,900

1501 Tristan Ct

Hughson, CA 95326

Schedule a Tour

Contact Info

Presented By:

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

1501 Tristan Ct

Hughson, CA 95326

Photo Gallery

$719,900

1501 Tristan Ct

Hughson, CA 95326

Schedule a Tour

Contact Info

Presented By:

Loading...

Saving...

Deleting...

Searching...