$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. 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
- 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, 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 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 21 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.