Listed by Friedman Group of Compass (401-864-0269)
Welcome to a rare opportunity in Riverside, where shimmering water views and versatile living spaces meet in this expansive 2-family duplex. Whether you're looking for a savvy investment or a place to call home while generating rental income, this property offers incredible potential in a serene setting. The first unit is ready for you to move right in. It's got a solid three-bedroom, two-bath layout, featuring a first-floor primary suite that feels like a true retreat with its own ensuite and dedicated laundry. It's bright, open, and easy to live in. On the other side, Unit 2 offers two bedrooms and a bathroom, plus a partially finished basement for extra storage or a hobby space. This side is a bit of a blank canvas-it needs some cosmetic updates, but the layout is great and the potential is obvious. It's the perfect spot to build some sweat equity or customize a rental unit exactly how you want it. The home features a brand-new roof and separate utilities for each unit. Outside, you get a private yard and off-street parking for four car. Whether you want to live in one side and let the other help pay the mortgage, or you're looking for a rock-solid addition to your portfolio, this place delivers. Come see the view for yourself and imagine what you can do with all this space.

Listing Tools

Property Details of 145 147 Oak Crest Drive, Riverside / Waddington

Property Details

Interior Features

Exterior Features

Community

Map Location

 IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed.  ©  2026 State-Wide Multiple Listing Service. All rights reserved.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Costello Realty. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

$

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.