$799,900
About this home
Incredibly unique mixed-use property offering the perfect blend of residential comfort and commercial convenience, all on one lot! This fully updated property features a spacious 4 bedroom, 2 bathroom single family home alongside a commercial office space. Everything is new: electric, plumbing, septic system, parking lot, paint, flooring, kitchen, and bathrooms, truly move-in ready. Both spaces showcase modern finishes throughout. The commercial space is ADA compliant and includes a handicap ramp, making it ideal for a variety of business uses, and equipped with electric ductless heat and A/C. This space also has a full, walk-out basement to the parking lot. Prime location just minutes from all major interstates and within walking distance to Warwick Mall and local amenities. Whether you're looking for a live/work setup or an income-producing opportunity, this property is a rare find that checks all the boxes!
Property details
- MLS #
- 1397795
- Property type
- Multi Family
- Subdivision
- N/A
- Status
- Active
- Days on market
- 187
- On market date
- October 14, 2025
- Stories
- N/A
- Total bathrooms
- 2.5
- Garage spaces
- N/A
- Parking spaces
- 7
- Lot size
- 0.44 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
- 248
- Student:teacher ratio
- 15.5:1
- District
- Cranston
- Enrollment
- 720
- Student:teacher ratio
- 11.4:1
- District
- Warwick
- Enrollment
- 173
- Student:teacher ratio
- 11.5:1
- District
- Cranston
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 April 19, 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.