99 South Hatch Rd East, turn right on Mitchell Rd, and right on Rosewood to the property.
Cross Street
Mitchell
County
Stanislaus
Special Listing Conditions
Offer As Is
Main Level
Bedroom(s), Living Room, Dining Room, Primary Bedroom
Architectural Style
Ranch
Construction Materials
Stucco, Wood
Foundation
Slab
Roof
Composition
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
In Garage
Full Bathrooms
2
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Living Room
Flooring
Carpet
Appliances
Free Standing Gas Range, Free Standing Refrigerator, Dishwasher, Disposal
Kitchen Features
Ceramic Counter, Tile Counter
Dining Room Features
Dining/Living Combo
Living Room Features
Great Room
Pool
Yes
Pool Features
Gunite Construction
Spa
No
ADU/2nd Unit
No
Utilities
Sewer Connected, Electric, Natural Gas Connected
Electric
220 Volts in Laundry
Irrigation
None
Water Source
Public
Sewer
Public Sewer
Parking Features
Attached
Garage Spaces
2.00
Lot Features
Corner, Curb(s)/Gutter(s)
APN
040 078 020 000
Topography
Level
Driveway/Sidewalks
Paved Driveway
Fencing
Wood
Horse Property
No
Land Lease
No
Zoning Description
R1
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Ceres Unified
Middle or Junior School District
Ceres Unified
Senior High School District
Ceres Unified
Census Tract
26.05
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 332500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 367500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1285 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1785 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` = 1711739 OR `props-main`.`id` = 1712174 OR `props-main`.`id` = 1704913 OR `props-main`.`id` = 1688578 OR `props-main`.`id` = 1712636 OR `props-main`.`id` = 1711831 OR `props-main`.`id` = 1712098 OR `props-main`.`id` = 1668573 OR `props-main`.`id` = 1711598 OR `props-main`.`id` = 1662513 OR `props-main`.`id` = 1712819 OR `props-main`.`id` = 1709991 OR `props-main`.`id` = 1674469 OR `props-main`.`id` = 1713082 OR `props-main`.`id` = 1703583 OR `props-main`.`id` = 1711376 OR `props-main`.`id` = 1702216 OR `props-main`.`id` = 1706037 OR `props-main`.`id` = 1713498 OR `props-main`.`id` = 1712170 OR `props-main`.`id` = 1708278 OR `props-main`.`id` = 1712169 OR `props-main`.`id` = 1711491 OR `props-main`.`id` = 1709948 OR `props-main`.`id` = 1703456 OR `props-main`.`id` = 1712141 OR `props-main`.`id` = 1712345 OR `props-main`.`id` = 1712140 OR `props-main`.`id` = 1712142 OR `props-main`.`id` = 1702785 OR `props-main`.`id` = 1691126 OR `props-main`.`id` = 1712830 OR `props-main`.`id` = 1646283 OR `props-main`.`id` = 1711689 OR `props-main`.`id` = 1712168 OR `props-main`.`id` = 1713136 OR `props-main`.`id` = 1708168 OR `props-main`.`id` = 1713055 OR `props-main`.`id` = 1711332 OR `props-main`.`id` = 1700083 OR `props-main`.`id` = 1712062)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226026188' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-05' 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 Howard Hayes, Sun Valley Real Estate 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.
