Calling all investors: Take advantage of this completely renovated, high end turn-key rental property near Providence College Campus. Already rented for the 2025-2026 school year, there is nothing to do but collect rent! This charming dutch colonial was tastefully updated in 2020 inside and out. The first floor offers an open floor plan and a tremendous amount of natural light. The expansive kitchen is decked out with a gas stove, stainless hood, two stainless sinks and a large granite island for cooking and entertaining. One bedroom is tucked away with an ensuite bathroom. There is also a unique hidden half bath for guests. Custom moldings and built-ins throughout accent the charm of this 1930's home. The second floor offers 4 good sized bedrooms with each side of the hall sharing a high end Jack and Jill full bath. The basement offers a small finished area for entertainment/second living room/home office, plus storage and coin op laundry for additional income. This spectacular, thoughtfully designed home rents itself making it a tremendous one of a kind opportunity for any investor.
For sale
$699,000
457 Douglas Ave, Providence, RI 02908
5beds
2,154sqft
Est.:
Single Family Residence
Built in 1930
3,920.4 Square Feet Lot
$-- Zestimate®
$325/sqft
$-- HOA
What's special
Gas stoveHome officeHidden half bathOpen floor planGranite islandStainless hoodExpansive kitchen
- 60 days
- on Zillow |
- 375 |
- 15 |
Zillow last checked: 7 hours ago
Listing updated: June 17, 2025 at 09:33pm
Listed by:
Stacia Pietropaolo 401-286-5931,
RE/MAX Professionals
Source: StateWide MLS RI,MLS#: 1387084

Travel times
Tour with a buyer's agent
Tour with a buyer's agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
Bathroom
- Features: Bath w Shower Stall
Heating
- Natural Gas, Central Air, Forced Air
Cooling
- Central Air
Appliances
- Included: Gas Water Heater, Tankless Water Heater, Dishwasher, Dryer, Oven/Range, Refrigerator, Washer
Features
- Wall (Cermaic), Wall (Dry Wall), Wall (Plaster), Wall (Wood), Plumbing (Mixed)
- Flooring: Ceramic Tile, Hardwood, Laminate, Carpet
- Basement: Full,Interior and Exterior,Partially Finished,Laundry,Playroom,Storage Space,Utility
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 1,904
- Total interior livable area: 2,154 sqft
- Finished area above ground: 1,904
- Finished area below ground: 250
Video & virtual tour
Property
Parking
- Total spaces: 4
- Parking features: No Garage
Lot
- Size: 3,920.4 Square Feet
- Features: Sidewalks
Details
- Parcel number: PROVM70L327
- Zoning: R3
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Ceramic, Dry Wall, Plaster, Wood Wall(s), Brick, Vinyl Siding
- Foundation: Concrete Perimeter, Mixed
Condition
- New construction: No
- Year built: 1930
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Public Sewer
- Water: Municipal
- Utilities for property: Sewer Connected, Water Connected
Community & HOA
Community
- Features: Near Public Transport, Highway Access, Private School, Restaurants, Schools, Near Shopping
- Subdivision: Providence College / Oakland
HOA
- Has HOA: No
Location
- Region: Providence
Financial & listing details
- Price per square foot: $325/sqft
- Tax assessed value: $286,000
- Annual tax amount: $5,248
- Date on market: 6/7/2025
- Loading
- Loading