Absolutely stunning single story country living! House is very open and the windows overlook a stunning pool and large lot that exudes peace! Full on guest quarters with full bath, kitchenette, etc. Also a massive gym between the guest house and the garage! All of this is behind a gate of a wonderful community for extra privacy!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
2005
Year Built Source
Assessor Agent-Fill
Remodeled/Updated
Unknown
Stories
1
Levels
One
Home Warranty
No
Directions to Property
Rodden to Amerine
Cross Street
Rodden
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen, Street Entrance
Construction Materials
Stucco
Foundation
Slab
Roof
Other
Heating
Propane, Central
Cooling
Ceiling Fan(s), Central
Laundry Features
Sink, Inside Area, Inside Room
Full Bathrooms
4
Half Bathrooms
1
Bath Features
Tub w/Shower Over
# of Fireplaces
1
Fireplace Features
Family Room, Gas Piped
Flooring
Carpet, Concrete, Tile, Wood
Appliances
Gas Cook Top, Built-In Refrigerator, Hood Over Range, Ice Maker, Dishwasher, Microwave
Room Type
Bonus Room, In Law Apartment
Kitchen Features
Granite Counter, Island
Dining Room Features
Formal Area
Living Room Features
Great Room
Exterior Features
Built-In Barbeque
Patio And Porch Features
Front Porch
Pool
Yes
Pool Features
Built-In, Fenced
Spa
No
ADU/2nd Unit
No
Utilities
Solar, Propane, Other
Electric
220 Volts
Irrigation
None
Water Source
Shared Well
Sewer
Septic System
Parking Features
Attached, Garage Door Opener, Garage Facing Side
Garage Spaces
6.00
Lot Features
Shape Irregular
APN
006 092 008 000
Horse Property
No
Zoning Description
RES
List AOR
MetroList Services, Inc.
Association
Yes
Association Mandatory
Yes
Association Fee
200
Association Fee Frequency
Monthly
Association Fee Includes
Water
Association Features
Other
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
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1329050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1468950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4450 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4950 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` = 1718178 OR `props-main`.`id` = 1704035 OR `props-main`.`id` = 1706878 OR `props-main`.`id` = 1714749 OR `props-main`.`id` = 1713455 OR `props-main`.`id` = 1716546 OR `props-main`.`id` = 1716409 OR `props-main`.`id` = 1718581 OR `props-main`.`id` = 1709819 OR `props-main`.`id` = 1715913 OR `props-main`.`id` = 1713062 OR `props-main`.`id` = 1714898 OR `props-main`.`id` = 1706914 OR `props-main`.`id` = 1709718 OR `props-main`.`id` = 1705210 OR `props-main`.`id` = 1695149 OR `props-main`.`id` = 1716662 OR `props-main`.`id` = 1711240 OR `props-main`.`id` = 1718256 OR `props-main`.`id` = 1702657 OR `props-main`.`id` = 1717107 OR `props-main`.`id` = 1717248 OR `props-main`.`id` = 1666524 OR `props-main`.`id` = 1694461 OR `props-main`.`id` = 1696705 OR `props-main`.`id` = 1719254 OR `props-main`.`id` = 1708122 OR `props-main`.`id` = 1716054 OR `props-main`.`id` = 1709963 OR `props-main`.`id` = 1719233)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226039506' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-01' 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 Brian Brazeal, RE/MAX Executive 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.
