Recently Viewed Properties
See This Home
Save This Listing
Close

View All Photos

$719,900 Just Listed

  • For Sale
  • Active
  • Single Family
  • 5 Beds
  • 4 Full Baths
  • 3,468 Sq. Ft.
  • 3 Car Garage
  • Updated 12 hours ago
See This Home
Save This Home
See This Home
Save This Home
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.

Full Property Details for 1501 Tristan Ct

General

  • Price: $719,900
  • Status: Active
  • Type: Single Family
  • Source: METROLIST_Cali
  • MLS ID: 226073373
  • Updated: 6/9/2026
  • Added to Site: Today

Interior

  • Fireplace: Yes
  • Number of Fireplaces: 1
  • Fireplace(s): Family Room, Gas Piped
  • Flooring: Carpet, Tile, Vinyl

Rooms

Bathrooms

  • Total Bathrooms: 4
  • Full Bathrooms: 4
  • Bathroom Features: Shower Stall(s), Double Sinks, Soaking Tub, Tile
  • Primary Bathroom: Shower Stall(s), Double Sinks, Soaking Tub, Tile

Bedrooms

  • Total Bedrooms: 5

Other Rooms

  • Kitchen: Island, Kitchen/Family Combo
  • Dining Room: Dining/Family Combo, Space in Kitchen
  • Laundry: Cabinets, Sink, Inside Room

Parking

  • Garage: Yes
  • Garage Spaces: 3
  • Parking: Attached, Garage Facing Front

Location

  • County: Stanislaus
  • Cross Streets: Chantilly Way
  • Driving Directions: 99 to E Hatch Rd to Seventh St to Chantilly Way to Tristan Ct.

School Information

  • School District: Stanislaus
  • Elem School District: Hughson Union
  • Midd School District: Hughson Union
  • High School District: Hughson Union

Heating & Cooling

  • Cooling Type: Ceiling Fan(s), Central
  • Heating Type: Central, Fireplace(s)
  • Heating Fuel: Central, Fireplace(s)

Utilities

  • Sewer: Public Sewer
  • Water: Public
  • Utility Description: Public

Structural Information

  • Construction: Stucco, Wood
  • Basement: Yes
  • Foundation: Concrete, Slab
  • Roof: Tile
  • Stories/Levels: 2
  • Square Feet: 3,468
  • Sq. Ft. Source: Assessor Agent-Fill
  • Year Built: 2004

Lot Features

  • Lot Size (Acres): 0.182
  • Lot Size (Sq. Ft.): 7,928
  • Irrigation System: None
  • Zoning: SFR
  • Lot Description: Manual Sprinkler F&R, Cul-De-Sac, Low Maintenance

Disclosures and Reports

  • Special Conditions: None
  • APN: 018-085-005-000

Listed by Adroit Real Estate

Quickly Find Out More

* Indicates a required field

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Send Message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

We Value Your Privacy

Listing agent

— 1501 Tristan Ct —

  • Adroit Real Estate

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Schools serving 1501 Tristan Ct

School District:Hughson Unified School District
NameGradesDistance
Fox Road Elementary School
7600 Fox Road, Hughson, CA 95326
4-50.6 mi
Hughson Elementary School
7201 East Whitmore Avenue, Hughson, CA 95326
PK-31 mi
Emilie J. Ross Middle School
7448 Fox Road, Hughson, CA 95326
6-80.5 mi
Hughson High School
7419 East Whitmore Avenue, Hughson, CA 95326
9-120.9 mi
Disclaimer: School attendance boundaries provided by ATTOM Data Solutions and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 1501 Tristan Ct Get Price Alerts and Save Property

Date
Details
Price
Change
Source
6/09/2026
Listed
$719,900
128.54%
MLS
3/19/2014
Sold
$315,000
—
Public Record
Get Price Alerts and Save Property
Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Tax History for 1501 Tristan Ct

Year
Property Taxes
Change
Tax Assessment
Change
2025
$5,469
6%
$471,947
2%
2024
$5,139
2%
$462,694
2%
2023
$5,022
2%
$453,622
2%
2022
$4,945
2%
$444,728
2%
2021
$4,853
1%
$436,009
1%
2020
$4,783
1%
$431,539
2%
2019
$4,736
3%
$423,079
2%
2018
$4,601
-1%
$414,785
2%
2017
$4,638
6%
$406,653
2%
2016
$4,379
2%
$398,680
2%
2015
$4,306
39%
$392,692
41%
2013
$3,105
—
$279,000
—
View All
Disclaimer: Historical tax information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

Estimate the Cost for 1501 Tristan Ct

$
Down Payment
%
$
%

$
$

*These costs are estimates, and the interest rates assume exceptional credit standing.

Be ready to buy your new home!

with our affiliated lender
NMLS#: 1598647

Get Pre-Approved

Listed by Adroit Real Estate

Similar Properties near 1501 Tristan Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

3909 Ruffed Grouse Ln, Modesto, CA 95355 - Photo 1 Just Listed
$695,000

3909 Ruffed Grouse Ln  Modesto, CA 95355

  • Single Family
  • Active
  • Updated 4 days ago
  • 5
    Beds
  • 4
    Total Baths
  • 3,154
    Sq. Ft.
Listed by RE/MAX Executive
3440 Jake Wy, Denair, CA 95316 - Photo 1
$744,900

3440 Jake Wy  Denair, CA 95316

  • Single Family
  • Active
  • 5
    Beds
  • 3
    Total Baths
  • 2,411
    Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
2117 Vincent Ave, Hughson, CA 95326 - Photo 1
$695,700

2117 Vincent Ave  Hughson, CA 95326

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 2,326
    Sq. Ft.
Listed by PMZ Real Estate
3613 Southern Oak Dr, Ceres, CA 95307 - Photo 1
$719,999

3613 Southern Oak Dr  Ceres, CA 95307

  • Single Family
  • Active
  • 4
    Beds
  • 3
    Total Baths
  • 3,182
    Sq. Ft.
Listed by Lifestyle Realty

Just Listed near 1501 Tristan Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

30 A St, Empire, CA 95319 - Photo 1 Just Listed
$419,900

30 A St  Empire, CA 95319

  • Single Family
  • Active
  • Updated 2 hours ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,530
    Sq. Ft.
Listed by Sandra Oliveira, Broker
3719 Blaker Rd, Ceres, CA 95307 - Photo 1 Just Listed
$520,000

3719 Blaker Rd  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,408
    Sq. Ft.
Listed by Barrios Realty Consultants
5136 Blaker Rd, Ceres, CA 95307 - Photo 1 Just Listed
$849,000
Open House

5136 Blaker Rd  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 4 hours ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,702
    Sq. Ft.
Listed by Professional Realty Associates
2125 Pine St, Ceres, CA 95307 - Photo 1 Just Listed
$425,000

2125 Pine St  Ceres, CA 95307

  • Residential Lots
  • Active
  • Updated 6 days ago
  • 0.78
    Acres
Listed by PMZ Real Estate

Price Reduced near 1501 Tristan Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

4806 Ariel St, Keyes, CA 95328 - Photo 1 Price Reduced
-$14,000 (-2.65%)
$515,000

4806 Ariel St  Keyes, CA 95328

  • Single Family
  • Active
  • Updated 22 hours ago
  • 4
    Beds
  • 2
    Total Baths
  • 1,835
    Sq. Ft.
Listed by GNN Real Estate
2213 7th St, Ceres, CA 95307 - Photo 1 Price Reduced
-$20,000 (-5%)
$380,000

2213 7th St  Ceres, CA 95307

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,226
    Sq. Ft.
Listed by Action Real Estate
3324 Dillion Way, Denair, CA 95316 - Photo 1 Price Reduced
-$1,000 (-0.14%)
$724,900

3324 Dillion Way  Denair, CA 95316

  • Single Family
  • Active
  • Updated 5 days ago
  • 3
    Beds
  • 2
    Total Baths
  • 1,506
    Sq. Ft.
Listing provided by LGI Realty - California, Inc., Jeanine M Roach
430 Becky Way, Waterford, CA 95386 - Photo 1 Price Reduced
-$31,000 (-6.87%)
$420,000

430 Becky Way  Waterford, CA 95386

  • Single Family
  • Active
  • Updated 5 days ago
  • 4
    Beds
  • 3
    Total Baths
  • 1,200
    Sq. Ft.
Listed by GNN Real Estate

Recent Sales near 1501 Tristan Ct

This is a carousel with tiles that activate property listing cards. Use the previous and next buttons to navigate.

1619 7th St, Hughson, CA 95326 - Photo 1 Sold
$615,000

1619 7th St  Hughson, CA 95326

  • Single Family
  • Closed
  • 6
    Beds
  • 3
    Total Baths
  • 2,750
    Sq. Ft.
Listed by Real Broker
Sold by HomeSmart PV & Associates
7009 Finale Ln, Hughson, CA 95326 - Photo 1 Sold
$649,000

7009 Finale Ln  Hughson, CA 95326

  • Single Family
  • Closed
  • 5
    Beds
  • 3
    Total Baths
  • 2,743
    Sq. Ft.
Listed by Keller Williams Property Team Turlock
Sold by HomeSmart PV and Associates
1710 Adeline Court, Hughson, CA 95326 - Photo 1 Sold
$660,000

1710 Adeline Court  Hughson, CA 95326

  • Single Family
  • Closed
  • Updated 12 days ago
  • 5
    Beds
  • 3
    Total Baths
  • 2,415
    Sq. Ft.
Listed by PMZ Real Estate
Sold by RE/MAX Executive
7634 Path Dr, Hughson, CA 95326 - Photo 1 Sold
$645,000

7634 Path Dr  Hughson, CA 95326

  • Single Family
  • Closed
  • 4
    Beds
  • 2
    Total Baths
  • 2,720
    Sq. Ft.
Listed by Wedgewood Homes Realty
Sold by Valley Heritage Realty

1501 Tristan Court, Hughson, CA 95326 (MLS# 226073373) is a Single Family property with 5 bedrooms and 4 full bathrooms. 1501 Tristan Court is currently listed for $719,900 and was received on June 09, 2026. Want to learn more about 1501 Tristan Court? Do you have questions about finding other Single Family real estate for sale in Hughson? You can browse all Hughson real estate or contact a Coldwell Banker agent to request more information.

Tour this property