$379,900
About this home
Estate Sale! Welcome to 149 Columbia Avenue, a charming three-bedroom bungalow nestled in a quiet section of Warwick's Lakewood/Gaspee neighborhood. Offering approximately 1,296 square feet of interior living space plus an unfinished basement, this home combines classic character with several important recent improvements. The first floor features a welcoming three-season porch entry, kitchen, formal dining room, comfortable living room, two bedrooms, and a full bath. The second floor offers a private third bedroom and added versatility. Recent major improvements include a newer roof, oil tank, windows, exterior doors, front porch, and sump pump, providing peace of mind for the next owner. Outside, enjoy a smaller, manageable yard and a detached one-car garage, perfect for those seeking low maintenance without sacrificing convenience. Ideally located close to shopping, dining, schools, recreation, and everyday amenities, with the potential for a pleasant walk to nearby Pawtuxet Village.
Property details
- MLS #
- 1420895
- Property type
- Single Family Residence
- Subdivision
- Gaspee/Lakewood
- Status
- Active
- Days on market
- 16
- On market date
- August 20, 2026
- Stories
- N/A
- Total bathrooms
- 1
- Garage spaces
- 1
- Parking spaces
- 4
- Lot size
- 0.1 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card (e.g. NC Dept. of Public Instruction, SC Report Card).
- Enrollment
- 288
- Student:teacher ratio
- 15.2:1
- District
- Warwick
- Enrollment
- 680
- Student:teacher ratio
- 11.9:1
- District
- Cranston
- Enrollment
- 1,176
- Student:teacher ratio
- 10.9:1
- District
- Warwick
Walkability
Blended score for Warwick's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Warwick, from live MLS data.
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Rhode Island Association of REALTORS via Trestle/CoreLogic. Last updated September 6, 2026.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.