Listed by Lorraine Bandoni of CrossRoads Real Estate Group (401-219-0682)
Step inside this uniquely beautiful EAST SIDE residence located on a generous, landscaped lot located at the top of the FREEMAN PLAT historic district. The original Granite stone structure was designed by architect Cliffton A. Hall in the 1860's as part of the grand Smith-Nichols Estate. Additional rooms were thoughtfully added during the 1900's. Classic architectural details blend seamlessly with elevated, modern living. From the grand foyer, gleaming hardwood floors, custom millwork, sun filled sitting rooms, modern chefs' kitchen with a breakfast room, beautiful formal dining room, and the handsome library, this home has everything you have been looking for and more. Retreat to the second-floor primary suite, a private sanctuary designed for the ultimate serenity! This suite features a recently renovated spa-inspired en-suite bath complete with a soaking tub, steam shower, and bidet, a walk-in closet, a study, and a sun filled sitting room and a private balcony. There are 6 to 8 bedrooms in this home along with 3 full bathrooms and 2 lavettes. The home also offers plenty of closet space, a second-floor laundry room, a walk-out basement, a large attached two car garage, and so much more! Located near Brown, RISD, The Miriam Hospital, private schools (a short walk to Moses Brown), scenic parks, downtown shopping, fine dining, trains, and highway access, this exceptional property is not just a home but a lifestyle.

Listing Tools

Property Details of 45 Hazard Avenue, Upper Freeman Plat

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.