Listing Agent: Mezdan Mota, The Dana Real Estate & Investments Inc.
Location! Location! Location! Nestled in the desirable gated Cottages at River Oaks community, this stunning 3-bedroom, 2.5-bath home in Paso Robles wine country has it all. Recently updated with new flooring, fresh paint, and vaulted ceilings, it also includes brand new kitchen appliances plus a new washer and dryer. Enjoy resort-style amenities such as a sparkling pool, relaxing hot tub, and clubhouse. Conveniently located just minutes from downtown, top restaurants, spa, and boutique shops
Property Sub Type
Single Family Residence
Year Built
2005
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Price Per Square Foot
$477
Days On Market
14
County Or Parish
San Luis Obispo
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Heating Y/N
Yes
Directions
North of Hwy 46 and East of Hwy 101
Architectural Style
Contemporary
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Roof
Composition
Security Features
Gated Community
Construction Materials
Stucco, Wood Siding
Direction Faces
East
Foundation Details
Slab
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Bathrooms Half
1
Appliances Y/N
Yes
Appliances
Dishwasher, Disposal, Microwave
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Living Room
Pool Features
Community
Pool Private Y/N
No
Spa Y/N
Yes
Spa Features
Community
Patio Y/N
Yes
Patio And Porch Features
Covered
Sewer
Other
Parking Y/N
Yes
Parking Total
2.00
Parking Features
Garage - Two Door
Garage Spaces
1.00
Lot Size Area
3162.0000
Lot Size Units
Square Feet
View Y/N
No
View
None
Parcel Number
025803005
Additional Parcels Y/N
No
Zoning
R1
Association Amenities
Pool
Senior Community Y/N
No
Association Y/N
Yes
Association Fee
330.00
Association Fee Frequency
Monthly
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 670950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1089 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1589 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` = 1697826 OR `props-main`.`id` = 1692579 OR `props-main`.`id` = 1697726 OR `props-main`.`id` = 1690873 OR `props-main`.`id` = 1623058 OR `props-main`.`id` = 1697404 OR `props-main`.`id` = 1686838 OR `props-main`.`id` = 1679353 OR `props-main`.`id` = 1694900 OR `props-main`.`id` = 1696614 OR `props-main`.`id` = 1697759 OR `props-main`.`id` = 1697677 OR `props-main`.`id` = 1679488 OR `props-main`.`id` = 1650747 OR `props-main`.`id` = 1628031 OR `props-main`.`id` = 1696128 OR `props-main`.`id` = 1693604 OR `props-main`.`id` = 1640741 OR `props-main`.`id` = 1695865 OR `props-main`.`id` = 1683273 OR `props-main`.`id` = 1649719 OR `props-main`.`id` = 1693862 OR `props-main`.`id` = 1695995 OR `props-main`.`id` = 1677220 OR `props-main`.`id` = 1697727 OR `props-main`.`id` = 1623065 OR `props-main`.`id` = 1658232 OR `props-main`.`id` = 1680713 OR `props-main`.`id` = 1696416 OR `props-main`.`id` = 1655096 OR `props-main`.`id` = 1695416 OR `props-main`.`id` = 1692459 OR `props-main`.`id` = 1697306 OR `props-main`.`id` = 1689183 OR `props-main`.`id` = 1696208 OR `props-main`.`id` = 1692468 OR `props-main`.`id` = 1623078 OR `props-main`.`id` = 1623077 OR `props-main`.`id` = 1623248 OR `props-main`.`id` = 1441090 OR `props-main`.`id` = 1623256 OR `props-main`.`id` = 1623254 OR `props-main`.`id` = 1674417 OR `props-main`.`id` = 1691926 OR `props-main`.`id` = 1684784 OR `props-main`.`id` = 1688676 OR `props-main`.`id` = 1689003 OR `props-main`.`id` = 1697308 OR `props-main`.`id` = 1689037 OR `props-main`.`id` = 1657316 OR `props-main`.`id` = 1649812 OR `props-main`.`id` = 1679725 OR `props-main`.`id` = 1696746 OR `props-main`.`id` = 1696730 OR `props-main`.`id` = 1696744 OR `props-main`.`id` = 1696745 OR `props-main`.`id` = 1697725 OR `props-main`.`id` = 1655027)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmls25625125' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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.
