Welcome to your dream home, a spacious and impeccably well-cared-for sanctuary nestled in a quiet, established neighborhood. This stunning residence immediately impresses with its airy cathedral ceilings and expansive layout, featuring a highly desirable downstairs primary suite for ease and privacy. The home's versatility shines through a professionally converted loft, now a bright and functional space perfect for a 6th bedroom or a dedicated home office. Outside, you'll find a private oasis on a generous lot situated in a peaceful court, complete with a sparkling swimming pool and a durable tile roof. Its prime location offers the ultimate convenience, being within walking distance to Crossroads Elementary School and just minutes away from Costco, Home Depot, and premier shopping malls.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2003
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
Turn left or right onto Coloma from Prospectors Pkwy
Cross Street
Prospectors Pkwy
County
Stanislaus
Special Listing Conditions
Other
Main Level
Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Architectural Style
Contemporary
Construction Materials
Brick, Stucco, Frame, Wood
Foundation
Slab
Roof
Tile
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central, Window Unit(s)
Laundry Features
Sink, Hookups Only, Inside Area, Inside Room
Window Features
Dual Pane Full
Interior Features
Cathedral Ceiling
Full Bathrooms
3
Bath Features
Closet, Double Sinks, Tub w/Shower Over
Possible Bedrooms
6
# of Fireplaces
1
Fireplace Features
Family Room, Gas Log
Flooring
Carpet, Tile, Wood
Appliances
Free Standing Gas Range, Dishwasher, Microwave
Kitchen Features
Island, Tile Counter
Dining Room Features
Dining Bar, Space in Kitchen
Living Room Features
Cathedral/Vaulted
Upper Level
Bedroom(s), Full Bath(s)
Patio And Porch Features
Front Porch, Covered Patio
Pool
Yes
Pool Features
Built-In, On Lot, Fenced, Solar Heat
Spa
No
ADU/2nd Unit
No
Utilities
Public, Sewer In & Connected
Electric
220 Volts in Laundry
Irrigation
Public District
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached, Garage Door Opener, Garage Facing Front
Garage Spaces
3.00
Lot Features
Cul-De-Sac, Shape Regular
APN
075 064 033 000
Horse Property
No
Road Surface Type
Paved
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
Sylvan Union
Middle or Junior School District
Modesto City
Senior High School District
Modesto City
Census Tract
4.06
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 598405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 661395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2775 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3275 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` = 1700668 OR `props-main`.`id` = 1669972 OR `props-main`.`id` = 1697741 OR `props-main`.`id` = 1677502 OR `props-main`.`id` = 1693393 OR `props-main`.`id` = 1694288 OR `props-main`.`id` = 1694287 OR `props-main`.`id` = 1655893 OR `props-main`.`id` = 1695535 OR `props-main`.`id` = 1701773 OR `props-main`.`id` = 1674150 OR `props-main`.`id` = 1655863 OR `props-main`.`id` = 1701961 OR `props-main`.`id` = 1655903 OR `props-main`.`id` = 1700556 OR `props-main`.`id` = 1694239 OR `props-main`.`id` = 1689305 OR `props-main`.`id` = 1699850 OR `props-main`.`id` = 1699862 OR `props-main`.`id` = 1700744 OR `props-main`.`id` = 1697954 OR `props-main`.`id` = 1698940 OR `props-main`.`id` = 1690546 OR `props-main`.`id` = 1691597 OR `props-main`.`id` = 1697367 OR `props-main`.`id` = 1700412 OR `props-main`.`id` = 1700966 OR `props-main`.`id` = 1690480 OR `props-main`.`id` = 1683669 OR `props-main`.`id` = 1697966 OR `props-main`.`id` = 1697973 OR `props-main`.`id` = 1683710 OR `props-main`.`id` = 1683720 OR `props-main`.`id` = 1684830 OR `props-main`.`id` = 1695643 OR `props-main`.`id` = 1695721 OR `props-main`.`id` = 1700990 OR `props-main`.`id` = 1693755)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226002462' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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 Tian Diaz-Ordaz, 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.
