Location, location, location. Come make this unique home your own. Located in a gated community, giving you the opportunity to relax and enjoy this beautiful oasis. House features a large interior with many upgrades including a fireplace in the main bedroom and relaxing exterior with pool and outdoor kitchen.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2015
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
No
Stories
2
Levels
Two
Home Warranty
No
Directions to Property
From McHenry Ave; go east on Briggsmore Ave (past Claus Rd) then right on Trails Way, past the gate and left on Trails Ct.
Cross Street
Trails Way
County
Stanislaus
Special Listing Conditions
Offer As Is, Trust
Lower Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Living Room, Primary Bedroom
Main Level
Bedroom(s), Dining Room, Family Room, Full Bath(s), Garage, Kitchen, Living Room, Primary Bedroom, Partial Bath(s), Street Entrance
Construction Materials
Stucco, Frame, Wood
Foundation
Slab
Roof
Tile
Heating
Propane, Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Sink, Inside Area, Inside Room
Other Structures
Gazebo
Interior Features
Cathedral Ceiling
Full Bathrooms
3
Half Bathrooms
1
Bath Features
Double Sinks, Tile, Tub w/Shower Over
Possible Bedrooms
6
# of Rooms
5
# of Fireplaces
2
Fireplace Features
Living Room, Primary Bedroom, Raised Hearth
Flooring
Carpet, Concrete, Tile
Appliances
Gas Cook Top, Hood Over Range, Dishwasher, Microwave, Double Oven
Kitchen Features
Pantry Closet, Granite Counter, Island, Stone Counter, Island w/Sink
Dining Room Features
Formal Area
Living Room Features
Other
Upper Level
Bedroom(s), Full Bath(s)
Exterior Features
Built-In Barbeque
Pool
Yes
Pool Features
Built-In, On Lot, Fenced
Spa
No
ADU/2nd Unit
No
Utilities
Public, Natural Gas Connected
Electric
220 Volts,220 Volts in Laundry
Irrigation
See Remarks
Water Source
Public
Sewer
See Remarks
Parking Features
Attached, Tandem Garage, Garage Door Opener
Garage Spaces
4.00
Lot Features
Auto Sprinkler F&R, Shape Irregular, Gated Community, Street Lights
APN
014 054 038 000
View Description
Water
Horse Property
No
Zoning Description
R-1
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
260
Association Fee Frequency
Monthly
Association Features
None
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Modesto City
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
28.03
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1305300 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1442700 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) >= 4216 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4716 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` = 1762806 OR `props-main`.`id` = 1762998 OR `props-main`.`id` = 1698929 OR `props-main`.`id` = 1773409 OR `props-main`.`id` = 1759479 OR `props-main`.`id` = 1727604 OR `props-main`.`id` = 1737367 OR `props-main`.`id` = 1728140 OR `props-main`.`id` = 1774210 OR `props-main`.`id` = 1764108 OR `props-main`.`id` = 1773226 OR `props-main`.`id` = 1773415 OR `props-main`.`id` = 1746761 OR `props-main`.`id` = 1736188 OR `props-main`.`id` = 1726824 OR `props-main`.`id` = 1768407 OR `props-main`.`id` = 1774188 OR `props-main`.`id` = 1771950 OR `props-main`.`id` = 1763176 OR `props-main`.`id` = 1751601 OR `props-main`.`id` = 1752511 OR `props-main`.`id` = 1774146 OR `props-main`.`id` = 1755639 OR `props-main`.`id` = 1764302 OR `props-main`.`id` = 1773767 OR `props-main`.`id` = 1763815 OR `props-main`.`id` = 1776377 OR `props-main`.`id` = 1763813 OR `props-main`.`id` = 1744005 OR `props-main`.`id` = 1726436 OR `props-main`.`id` = 1774347 OR `props-main`.`id` = 1774349 OR `props-main`.`id` = 1774350 OR `props-main`.`id` = 1774357 OR `props-main`.`id` = 1774378 OR `props-main`.`id` = 1774379 OR `props-main`.`id` = 1774394 OR `props-main`.`id` = 1774395 OR `props-main`.`id` = 1774404 OR `props-main`.`id` = 1774405 OR `props-main`.`id` = 1774406 OR `props-main`.`id` = 1774407 OR `props-main`.`id` = 1727300 OR `props-main`.`id` = 1774525 OR `props-main`.`id` = 1776765 OR `props-main`.`id` = 1774633 OR `props-main`.`id` = 1752442 OR `props-main`.`id` = 1773029 OR `props-main`.`id` = 1772863 OR `props-main`.`id` = 1771336 OR `props-main`.`id` = 1771338 OR `props-main`.`id` = 1774325 OR `props-main`.`id` = 1774327 OR `props-main`.`id` = 1774329 OR `props-main`.`id` = 1774390 OR `props-main`.`id` = 1774392 OR `props-main`.`id` = 1774393 OR `props-main`.`id` = 1768451 OR `props-main`.`id` = 1771364 OR `props-main`.`id` = 1764795 OR `props-main`.`id` = 1774328 OR `props-main`.`id` = 1767713 OR `props-main`.`id` = 1773352 OR `props-main`.`id` = 1725328 OR `props-main`.`id` = 1725327 OR `props-main`.`id` = 1725326 OR `props-main`.`id` = 1722553 OR `props-main`.`id` = 1725329 OR `props-main`.`id` = 1763972 OR `props-main`.`id` = 1763618 OR `props-main`.`id` = 1758286 OR `props-main`.`id` = 1770505 OR `props-main`.`id` = 1761573 OR `props-main`.`id` = 1759880 OR `props-main`.`id` = 1728945 OR `props-main`.`id` = 1743992 OR `props-main`.`id` = 1759983 OR `props-main`.`id` = 1733603 OR `props-main`.`id` = 1772872)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226017807' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-16' 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 Camila Carrillo, HomeSmart PV & Associates 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.
