This 3 bedroom 2.5 bathroom residential property offers comfortable country living with almost 3 acres of land is a must see. A custom home with elegant features such as high ceilings, inviting floor plan will captivate you as soon as you walk in.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country, Detached
Year Built
2002
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Unknown
Stories
2
Home Warranty
No
Directions to Property
0ff of highway 120/108
Cross Street
Orange Blossom Rd
County
Stanislaus
Special Listing Conditions
Offer As Is
Main Level
Living Room, Kitchen
Construction Materials
Stucco
Foundation
Slab
Roof
Shingle
Heating
Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Inside Area
Interior Features
Cathedral Ceiling
Full Bathrooms
2
Half Bathrooms
1
Bath Features
Shower Stall(s)
Flooring
Carpet, Tile
Appliances
Dishwasher, Microwave
Kitchen Features
Quartz Counter
Dining Room Features
Other
Living Room Features
View
Exterior Features
Balcony
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Public
Electric
220 Volts
Irrigation
Other
Water Source
Well
Sewer
Septic System
Parking Features
Detached
Garage Spaces
4.00
Lot Features
Private
APN
010 023 053 000
Horse Property
Yes
Horse Property Features
Pasture
Zoning Description
RUR HMST
List AOR
MetroList Services, Inc.
Association
No
Senior Community
No
School District (County)
Stanislaus
Elementary School District
Oakdale Joint
Middle or Junior School District
Oakdale Joint
Senior High School District
Oakdale Joint
Census Tract
1.02
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1045000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1155000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2211 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2711 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` = 1712276 OR `props-main`.`id` = 1700863 OR `props-main`.`id` = 1714037 OR `props-main`.`id` = 1704682 OR `props-main`.`id` = 1708072 OR `props-main`.`id` = 1687484 OR `props-main`.`id` = 1704809 OR `props-main`.`id` = 1694461 OR `props-main`.`id` = 1696705 OR `props-main`.`id` = 1708122 OR `props-main`.`id` = 1711858)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226027255' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-07' 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 Gabriel Albor, Atlantic Realty 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.
