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/226026975/1500-Walnut-St/Oakdale/https://www.londonproperties.com/images/props/metrolist/full/226026975.jpgLondon Properties Oakdale Real Estate | 1500 Walnut St
Welcome home to peaceful country living! Nestled near beautiful almond orchards, this property offers a large corner lot with plenty of space to enjoy the outdoors. The home features updated bathrooms, durable laminate flooring, and a kitchen featuring a stainless steel farmhouse sink. Step outside to find covered RV parking, perfect for storing your toys, trailers, or extra vehicles. Located in a quiet neighborhood, this home combines comfort and convenience with energy-saving solar and a newer roof that's only 3 years old. Enjoy the tranquility of orchard views while still being close to town amenities- this property is ready for you t move in and make it your own!
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Ranchette/Country
Year Built
1969
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Other-Rmks 0-5YR
Stories
1
Home Warranty
No
Directions to Property
Head East on West F Street toward Ash Ave. Turn left on N Oak Ave. Proceed straight down N Oak Ave. and turn left on Walnut Street.
Cross Street
N Oak St
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Frame
Foundation
Raised
Roof
Composition
Heating
Central, Fireplace(s)
Cooling
Ceiling Fan(s), Central
Laundry Features
Electric, In Garage
Other Structures
Shed(s)
Full Bathrooms
2
Bath Features
Granite, Tile, Tub, Window
# of Fireplaces
1
Fireplace Features
Brick
Flooring
Carpet, Laminate, Tile, Wood
Appliances
Built-In Electric Oven, Free Standing Refrigerator, Dishwasher, Disposal, Microwave, Double Oven, Electric Cook Top, ENERGY STAR Qualified Appliances
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 475000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 525000 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) >= 1280 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1780 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` = 1699993 OR `props-main`.`id` = 1698083 OR `props-main`.`id` = 1704222 OR `props-main`.`id` = 1703284 OR `props-main`.`id` = 1708080 OR `props-main`.`id` = 1705319 OR `props-main`.`id` = 1709832 OR `props-main`.`id` = 1709822 OR `props-main`.`id` = 1709821 OR `props-main`.`id` = 1712130 OR `props-main`.`id` = 1675227 OR `props-main`.`id` = 1705040 OR `props-main`.`id` = 1713450 OR `props-main`.`id` = 1713706 OR `props-main`.`id` = 1711373 OR `props-main`.`id` = 1711539 OR `props-main`.`id` = 1712251 OR `props-main`.`id` = 1705171 OR `props-main`.`id` = 1693585 OR `props-main`.`id` = 1692290 OR `props-main`.`id` = 1711975 OR `props-main`.`id` = 1711870 OR `props-main`.`id` = 1712294 OR `props-main`.`id` = 1712995 OR `props-main`.`id` = 1697557 OR `props-main`.`id` = 1712997 OR `props-main`.`id` = 1712208 OR `props-main`.`id` = 1712225 OR `props-main`.`id` = 1703692 OR `props-main`.`id` = 1706754 OR `props-main`.`id` = 1713542 OR `props-main`.`id` = 1658344 OR `props-main`.`id` = 1660514 OR `props-main`.`id` = 1658341 OR `props-main`.`id` = 1660513 OR `props-main`.`id` = 1694685 OR `props-main`.`id` = 1712255 OR `props-main`.`id` = 1713771 OR `props-main`.`id` = 1697653 OR `props-main`.`id` = 1713484 OR `props-main`.`id` = 1704035 OR `props-main`.`id` = 1706878 OR `props-main`.`id` = 1713207 OR `props-main`.`id` = 1707039 OR `props-main`.`id` = 1713455 OR `props-main`.`id` = 1704763 OR `props-main`.`id` = 1711621 OR `props-main`.`id` = 1711980 OR `props-main`.`id` = 1713313 OR `props-main`.`id` = 1709718 OR `props-main`.`id` = 1695149 OR `props-main`.`id` = 1684503 OR `props-main`.`id` = 1666524)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226026975' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-06' 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 Allison Motz, EXIT Realty Consultants 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.
