It's in the top 10% of views. Tour it before it's gone!
Today:
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!
Spragueville, located between Greenville Center and the Scituate Reservoir watershed, is a residential and semi-rural Greenville neighborhood with wooded backroads and small-lot homesteads. The neighborhood’s character concentrates around the Greenville Avenue and Putnam Pike (Route 44) corridor, where local storefronts, coffee counters, and service shops set a steady daytime rhythm. Historic mill-era traces and mid-century houses mix with newer builds along curving streets and stone walls. The landscape reads as pond-and-forest Rhode Island, with trailheads and conservation parcels shaping weekend routines. Community touchstones include The Purple Cat Restaurant, The Village Bean, and the Smith-Appleby House Museum.
Provided by Walk Score and Local Logic
Market insights
87 Mann School Rd · $899,900
DAYS ON MARKET
1 days
The average home goes pending in 27 days.
SALE-TO-LIST
101.5%
Most homes are selling 2% above list price.
LIST PRICE
$899,900
Median sale price in this area is $487,141. (46% lower than this home)
PRICE DROP
0 price drops
15% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Dining
Interior features
Attic
Cable TV
Thermal windows
Zero clearance fireplace (1)
Bedrooms
Bedroom 2 on the first floor
Bedroom 3 on the first floor
Additional living suite on the first floor
Bathrooms
3 full bathrooms
Kitchen
Eat-in kitchen
Oven
Range
Microwave
Refrigerator
Dishwasher
Laundry & utility
Washer
Dryer
Gas water heater
Water heater
Flooring
Ceramic tile
Hardwood
Carpet
Heating & cooling
Forced air heating (gas)
Central air conditioning
Exterior features
Paved driveway
Fenced yard
In-ground pool
Corner lot
Home design
Single-story home (1 story)
Parking
Attached 2-car garage
Built-in parking
Total parking for 8 vehicles (2 covered)
Construction
Vinyl siding with drywall and plaster interior walls
Concrete perimeter foundation
Utilities
Public water (connected)
Public sewer (connected)
200+ amp electrical service with circuit breakers
HOA & community
Community access to golf, highway access, nearby hospital, public transportation, recreation area, restaurants and shopping
Electricity and solar
View estimated energy costs and solar savings for this home
Welcome to a true California ranch retreat in Smithfield, abutting the desirable Conners Farm subdivision. Sited on a commanding 2-acre corner lot, this single-level home offers an effortless blend of comfort, privacy, and possibility. The main residence features 3 bedrooms and 2 baths, including a spacious and private primary suite . Enjoy gracious living and dining spaces alongside a newly remodeled kitchen designed for both style and function. A large 2 car garage and a separately-entranced 1-bedroom ADU expands the property's flexibility, ideal for guests or extended family. Outdoors, a spectacular built-on pool with cabana, half bath, and generous lounging areas creates a resort-like atmosphere perfect for entertaining. This is a rare offering one of the few properties in the area providing this combination of acreage, layout, and amenities. Truly one of a kind.
RIS #1401500
Jan 13, 2026
Listing Removed
—
Dec 15, 2025
Listed
$899,999
$245/sq ft
RIS #1019692
Aug 28, 2012
Sold
$441,900
$120/sq ft
Jul 18, 2012
Listing Removed
—
Jun 15, 2012
Listed
$459,000
$125/sq ft
RIS #309933
Jul 24, 2003
Listing Removed
—
Jun 28, 2003
Listed
$479,900
$131/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$11,326 (+8.8%)
$210,900 + $703,200
$914,100
2024
$10,408 (+5.2%)
$165,800 + $555,000
$720,800
2023
$9,889 (+2.7%)
$165,800 + $555,000
$720,800
2022
$9,630 (+5.9%)
$165,800 + $555,000
$720,800
2021
$9,096 (+1.9%)
$128,500 + $402,500
$531,000
2020
$8,926
$128,500 + $402,500
$531,000
2019
$8,926 (+3.6%)
$128,500 + $402,500
$531,000
2018
$8,618 (+1.5%)
$128,500 + $362,300
$490,800
2017
$8,492 (+5.0%)
$121,300 + $362,300
$483,600
2016
$8,091 (−2.2%)
$121,300 + $362,300
$483,600
2015
$8,272 (+14.0%)
$115,300 + $355,500
$470,800
2012
$7,254
$132,400 + $320,400
$452,800
Public record
Beds
3
Baths
3
Stories
1
Lot width
—
Lot depth
—
Lot size
2.07 Acres
Year renovated
—
Finished Sq. Ft.
2,868
Unfinished Sq. Ft.
—
Total Sq. Ft.
2,868
Year built
1993
Style
Single Family Residential
County
Providence County
APN
185788
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jun 22, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
4/10 Heat Factor
7 days above 95° expected this year, 15 days in 30 years
6/10 Wind Factor
62% chance of strong winds in next 30 years
2/10 Air Factor
2 unhealthy days expected this year, 2 days in 30 years
Provided by First Street
Historical weather
Smithfield, RI • 02917
Average low and high temperatures (°F)
34
19
37
20
52
32
62
40
70
50
82
60
84
66
80
58
75
56
65
45
53
35
40
24
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
84/ 100
Very good sunlight
Sunscore
This home ranks in the top 12% for direct sun exposure in Smithfield. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.1 hrs
5.1 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 87 Mann School Rd
$917,380
$17K over list price of $900K
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $589K to $975K.