Listing Agent: Jessie Espinosa, Century 21 Select Real Estate, Turlock
This almond ranch offers a private country setting on a dead-end road with great views along Dry Creek. The home of approx 2500sf has been recently remodeled to an open floor plan, a new kitchen featuring; a beautiful butcher's block countertop on the giant island, white cabinets with bronze finishes, granite counters accented by the subway tile backsplash and the pristine white farm sink. Additionally, the kitchen showcases KitchenAid stainless steel appliances from the built-in side-by-side frig, an under the counter wine/beverage frig and microwave along with the built-in oven and gas cook top. The floors throughout the home have been tastefully upgraded as well with the waterproof vinyl flooring. The home is a four-bedroom, three full bath with a large primary bedroom and a junior suite on the other end of the home that could serve as an in-law quarters. The orchard offers a steady income stream to help supplement the mortgage while the deprecation on the improvements offers the tax shelter (please consult with your CPA). The orchard consists of Butte/Padre planted in 06/07 at 21'x15'. M.I.D. supplies the surface water via a dedicated side gate/pipeline, boosted by a diesel pump through the spin clean out to the micro-sprinklers. Buyer to independently verify info.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1960
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
Road
Price Per Square Foot
$562
Days On Market
2
Cumulative Days On Market
2
County Or Parish
Stanislaus
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
132/Yosemite to Hopper Road, North on Hopper road over canal to Creekside lane, East on Creekside lane
Room Type
Family Room, Kitchen, Living Room
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
In Garage
Main Level Bedrooms
3
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
3
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
Private
Pool Private Y/N
Yes
Water Source
Well
Sewer
Private Sewer
Parking Total
3.00
Attached Garage Y/N
Yes
Garage Spaces
3.00
Lot Features
Agricultural - Tree/Orchard
Lot Size Area
1588198.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Creek/Stream, Orchard
Common Interest
None
Parcel Number
009016018000
Additional Parcels Y/N
No
Community Features
Rural
Senior Community Y/N
No
Association Y/N
No
High School District
Modesto City
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Census Tract
28.02
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) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2239 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2739 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` = 1700531 OR `props-main`.`id` = 1700591 OR `props-main`.`id` = 1640695 OR `props-main`.`id` = 1701595)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26003060' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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
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.
