$899,900
About this home
The Real Deal! This oversized executive ranch offers an exceptional and versatile layout on a large corner lot. The main level features a perfect ADU setup, ideal for extended family, guests, an in-law arrangement, or flexible living space. Enjoy your own backyard retreat with an in-ground pool, plus a finished lower level featuring a wet bar or potential third kitchen—offering even more possibilities for entertaining or multi-generational living. Clean, neat, and well cared for, this property presents a fantastic opportunity for buyers looking for space, flexibility, and a home that can adapt to their needs. A truly unique offering with tremendous potential!
Highlights
Property details
- MLS #
- 1422846
- Property type
- Single Family Residence
- Subdivision
- Corner Of Connors Farm
- Status
- Active
- Days on market
- 2
- On market date
- September 9, 2026
- Stories
- N/A
- Total bathrooms
- 3
- Garage spaces
- 2
- Parking spaces
- 8
- Lot size
- 2.07 acres
Location
Get directions →Nearby schools
Within 10 miles · public school directory data (NCES)
- Enrollment
- 533
- Student:teacher ratio
- 17.8:1
- District
- Smithfield
- Enrollment
- 538
- Student:teacher ratio
- 13.1:1
- District
- Smithfield
- Enrollment
- 791
- Student:teacher ratio
- 13.4:1
- District
- Smithfield
Walkability
Blended score for Smithfield's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Market position
How this listing compares to current activity in Smithfield, 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 14 days ago.
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.