Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/metrolist/225131068/1237-W-Keyes-Rd/Modesto/https://www.londonproperties.com/images/props/metrolist/full/225131068.jpgLondon Properties Modesto Real Estate | 1237 W Keyes Rd
37.83 +/- Acre Ranch in Turlock Irrigation District. Property is currently open ground. Last crop planted was corn. Excellent sandy loam soils. Possibly develop into permanent crops like almonds. Flood irrigation by pipeline system through Turlock irrigation gates. Home was renovated in 2020. Including new flooring, paint (interior/exterior), vinyl dual-paned windows, new water heater, new gas fireplace insert, kitchen remodeled, bathroom remodeled. New composition roof installed in 2010. Detached 2 car garage features a separate room for wash basin and laundry hookups. Garage had a new roof installed and painted in 2020. Cyclone fenced back yard. Slab area at the property used to have a mobile home on its own septic system. 10' x 12' outbuilding (old milk house). Property could potentially be an excellent site for building a second home, county zoning may allow for two homes, prospects to contact Stanislaus County regarding ability to build, and/or regarding buyers intended use of the property.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country, Detached
Property Condition
Updated/Remodeled
Year Built
1940
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 0-5YR, Kitchen 0-5YR, Other-Rmks 0-5YR
Stories
1
Home Warranty
No
Directions to Property
From Modesto, Carpenter Road South to Keyes Road. Property on the corner of Keyes Road and Ustick Road. From Turlock, Keyes Road exit West to the Property.
Cross Street
Crowslanding
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Full Bath(s), Kitchen
Construction Materials
Brick Veneer, Stucco, Frame, Wood
Foundation
Raised
Roof
Composition
Heating
Fireplace Insert
Cooling
Ceiling Fan(s), Evaporative Cooler
Laundry Features
Sink, In Garage
Property Faces
South
Full Bathrooms
1
Bath Features
Tub w/Shower Over, Window
# of Fireplaces
1
Fireplace Features
Insert, Gas Piped
Flooring
Tile, Vinyl, Wood
Kitchen Features
Breakfast Area
Dining Room Features
Space in Kitchen, Formal Area
Living Room Features
Other
Patio And Porch Features
Front Porch
Pool
No
Spa
No
ADU/2nd Unit
No
Utilities
Electric, Propane Tank Leased
Electric
220 Volts in Kitchen,220 Volts in Laundry
Irrigation
Irrigation District
Water Source
Well
Sewer
Septic System
Parking Features
Detached
Garage Spaces
2.00
Lot Features
Auto Sprinkler F&R, Landscape Back, Landscape Front, Low Maintenance
APN
041 027 020 000
Fencing
Back Yard, Fenced
Horse Property
No
Road Responsibility
Public Maintained Road
Zoning Description
A-2-40
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
31.00
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1329724.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1469695.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1196 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1696 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` = 1689464 OR `props-main`.`id` = 1693286 OR `props-main`.`id` = 1688916 OR `props-main`.`id` = 1697351)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist225131068' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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 Lynn Garber, PMZ Commercial 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.
