Listed by Laureen Koch of Edge Realty RI
Embrace the coastal lifestyle in this beautifully updated, meticulously maintained, 4-bedroom, 2-bath sanctuary where historic charm meets modern luxury. Graced with brilliant natural light from expansive windows, the home features stunning, rich hardwood floors that seamlessly connect its timeless original character with high-end contemporary finishes. At the heart of the home is a gourmet chef's kitchen, elegantly appointed with premium quartz countertops and sleek stainless steel appliances. Designed for ultimate versatility, the main level offers the convenience of single-level living, complete with a private primary suite and an additional bedroom. Upstairs, you will find two more generously sized bedrooms and a second full bath, offering plenty of space for family or guests. No detail has been overlooked in future-proofing this residence: mechanicals, the roof, and the security system are all recently updated. Peace of mind comes built-in with a waterproofed basement and chimney, alongside fresh interior and exterior paint. The property also features a heated two-car garage equipped with an EV charging station, a fully fenced private yard, and custom solar panels-offering a highly sought-after, eco-friendly shield against rising energy costs. This is coastal living at its finest.

Listing Tools

Property Details of 480 Church Avenue, Oakland Beach; Conimicut; Shawomet

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.