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/226010082/1184-River-Ave/Oakdale/https://www.londonproperties.com/images/props/metrolist/full/226010082.jpgLondon Properties Oakdale Real Estate | 1184 River Ave
1184 River Ave offers a comfortable and well-designed living space in Oakdale. This 4-bedroom, 2.5-bathroom home includes approximately 2,519 square feet on a 7,568 square foot lot, with a layout that supports both everyday living and gatherings. Natural light moves easily through the home with dual-pane windows throughout, creating a bright and open feel across the main living areas. A second family room provides flexibility and may also serve as a formal dining space depending on your needs. The primary bedroom includes a remodeled en-suite bathroom with a separate tub and shower, along with generous counter space and storage. The backyard features a pool and a covered deck that offers space for outdoor dining, relaxing, or spending time with guests. The home presents a balanced combination of functionality and comfort in an established Oakdale setting.
Property Type
Residential
Property Subtype 1
Single Family Residence
Subtype Description
Detached
Year Built
2002
Year Built Source
Assessor Auto-Fill
Remodeled/Updated
Yes
Remodeled/Updated Desc
Bath 6-10YR, Kitchen 6-10YR
Stories
2
Pets Allowed
Yes
Home Warranty
No
Directions to Property
Boyd Dr to River Ave
Cross Street
BoydDr
County
Stanislaus
Special Listing Conditions
None
Main Level
Bedroom(s), Living Room, Dining Room, Family Room, Primary Bedroom, Full Bath(s), Garage, Kitchen
Construction Materials
Stucco
Foundation
Concrete
Roof
Cement
Heating
Propane, Central, Fireplace Insert, Fireplace(s), Gas, MultiZone, Natural Gas
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 612750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 677250 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) >= 2269 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2769 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` = 1695075 OR `props-main`.`id` = 1699993 OR `props-main`.`id` = 1698083 OR `props-main`.`id` = 1704222 OR `props-main`.`id` = 1708434 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` = 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` = 1701342 OR `props-main`.`id` = 1692290 OR `props-main`.`id` = 1711975 OR `props-main`.`id` = 1711870 OR `props-main`.`id` = 1712294 OR `props-main`.`id` = 1712466 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` = 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` = 1697653 OR `props-main`.`id` = 1708045 OR `props-main`.`id` = 1704035 OR `props-main`.`id` = 1706878 OR `props-main`.`id` = 1707039 OR `props-main`.`id` = 1704763 OR `props-main`.`id` = 1711621 OR `props-main`.`id` = 1711980 OR `props-main`.`id` = 1709718 OR `props-main`.`id` = 1695149 OR `props-main`.`id` = 1684503 OR `props-main`.`id` = 1666524)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'metrolist226010082' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-04' 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 Mario Barajas, PMZ 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.
