1508 Tristan Court

    Hughson, CA 95326
    • $477,900
    • STATUS: Active
    • ON SITE: 128 days
    • MLS #: 18031969
    UPDATED: 39 min ago
    $477,900
    • 5
      BEDS
    • 0.17
      ACRES
    • 4
      BATHS
    • 0
      1/2 BATHS
    • 3,468
      SQFT
    • $138
      $/SQFT
    Neighborhood:
    Type:
    Single-Family Home
    Built:
    2004
    County:
    Area:

    School Information

    Elementary School:
    Middle School:
    High School:
    School District:

    Description

    Entertainers Delight! Great Court Location. Safe for children! Possible RV Parking. Updated throughout, Granite Counters, Large granite island, Premium Tile Flooring, Custom built entertainment center, 5 bedrooms, 4 full baths, new carpet upstairs, rec/loft/game area, Master retreat. Downstairs bedroom and full bath in the hall. Bring on the summer, backyard features a custom built Gazebo with built in BBQ Bar and don't forget the pool for those hot summer days!! Opportunity is Knocking!

    Monthly Payment Calculator



    © 2018 MetroList® MLS. All rights reserved. All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data last updated 2018-09-21T23:39:47.843. MetroList® MLS Terms of Use. IDX provided by BoomTown.
    www.thedelrealgroup.com/homes/83644285

    1508 Tristan Court Hughson, CA 95326

    • Price: $477,900
    • Status: Active
    • Updated: 39 min ago
    • MLS #: 18031969
    5
    Beds
    4
    Baths
    0
    ½ Baths
    0.17
    Acres
    3,468
    SQFT
    $138
    $/SQFT
    2004
    Built
    Neighborhood:
    Hughson
    County:
    Stanislaus
    Area:
    Hughson
    Elementary School:
    Hughson Union
    Middle School:
    Hughson Union
    High School:
    Hughson Union
    School District:
    Stanislaus
    Property Description
    Entertainers Delight! Great Court Location. Safe for children! Possible RV Parking. Updated throughout, Granite Counters, Large granite island, Premium Tile Flooring, Custom built entertainment center, 5 bedrooms, 4 full baths, new carpet upstairs, rec/loft/game area, Master retreat. Downstairs bedroom and full bath in the hall. Bring on the summer, backyard features a custom built Gazebo with built in BBQ Bar and don't forget the pool for those hot summer days!! Opportunity is Knocking!
    Exterior Features

    Approx Elevation 0 Construction Wood Exterior Siding VinylStucco Foundation Concrete Slab Garage 3 Car AttachedGarage Door Opener Horse Property No House Faces North Improvements Sidewalk/Curb/Gutter Landscape Sprinkler Auto F&R Miscellaneous Features Bbq Built-InPatio Covered Other Structures GazeboTool Shed Pool Yes Pool Location On Lot Pool Type Built-InGunite Construction Road Description PavedPublic Maintained Roof Tile Site Description LevelShape Regular Site Location Cul-De-Sac Stories 2 Style Contemporary

    Interior Features

    Air CentralMultizone Dining Dining/Living ComboSpace in Kitchen Downstairs Bedroom Yes Downstairs Full Bath Yes Equipment Cable Tv AvailableGas Water Heater Fireplace Family RoomGas Piped Fireplaces 1 Floor Coverings CarpetTile Heat CentralMultizone Kitchen Counter GraniteIslandKitchen/Family Combo Kitchen Appliances Cook Top GasDishwasherDisposalMicrowave B/IOven Gas B/I Laundry 220 Volt Hook-UpCabinetsGas Hook-UpInside Room Master Bedroom Sitting Area Other Baths Double SinksTileTub W/Shower Over Possible Bedrooms 7.00 Rooms Downstairs BedroomGame RoomGreat Room ConceptLiving RoomLoft Sq Ft Second Res 0

    Property Features

    Auction No CCRs Yes Energy Features Ceiling Fan(S)Dual Pane Full HOA No Hoa Dues 0 HUD No Master Bath Closet Walk-InDouble SinksShower Stall(S)TileTub Remodeled Or Updated Yes Remodeled Or Updated Description Bath 6-10YrKitchen 11-15Yr Sewer Sewer ConnectedSewer in Street Square Footage Source Assessor/Agt-Fill Subtype Description Detached Utilities 220 VoltsAll Public Water Public District Zoning R1

    Listing provided courtesy of Real Estate Ebroker Inc.. Listing information © 2018 MetroList Services, Inc.


    © 2018 MetroList® MLS. All rights reserved. All measurements and all calculations of area are approximate. Information provided by Seller/Other sources, not verified by Broker. All interested persons should independently verify accuracy of information. Provided properties may or may not be listed by the office/agent presenting the information. Data last updated 2018-09-21T23:39:47.843. MetroList® MLS Terms of Use. IDX provided by BoomTown.
     
    The Del Real Group
    1600 N. Carpenter Rd
    Modesto CA, 95351