FANTASTIC FLOOR PLAN IN THIS BEAUTIFUL RANCH BEING BUILT IN STILLWATER PRESERVE. NINE FOOT CEILINGS , GOURMENT KITCHEN, MASTER W/JACUZZI. STILL TIME TO CUSTOMIZE. PHOTO IS OF SIMILAR HOUSE BEING BUILT, HOUSE WILL HAVE SIDE LOAD GARAGE.
- RI
- Smithfield
- 02917
- 27 TRISTAN Court
- MLS# 1112573
- Date Listed11/12/2015
- Bedrooms 4
- Bathrooms 2 Full baths, 1 Half baths
- Lot Size 1.01 acres (43,996 sq. ft)
- Subdivision STILLWATER PRESERVE
- Property Type Single Family
- County Providence
- Year Built 2015
- Water Well
- Square Feet 2,550 sq. ft
- Price Per Sq. Ft $254.86
Interior Features
- Appliances Dishwasher, Oven, Range, Refrigerator, Water Heater
- Flooring Hardwood
- Cooling Central Air
- Heating Forced Air, Propane
Exterior / Lot Features
- Roof -
- Lot Size Acres 1.01
- Lot Size SQFT 43,996.00
- Lot Features Cul- De- Sac, Wooded
Financial Considerations
- HOA Fee $150 Annually
- Tax Amount $8,000
- Terms Cash, Conventional, FHA, VA Loan
Nearby Schools
Source: School Digger
Public • PK - 5 • Serves this home
3.26 mi
Distance
Public • 6 - 8 • Serves this home
3.13 mi
Distance
Public • 9 - 12 • Serves this home
3.26 mi
Distance
Public • PK - 5 • Serves this home
3.26 mi
Distance
North Smithfield Elementary School
Public • PK - 4
4.14 mi
Distance
Public • PK - PK
4.74 mi
Distance
Public • PK - 5
5.04 mi
Distance
Public • PK - 5
5.04 mi
Distance
Public • PK - 5
5.43 mi
Distance
Public • PK - 5
6.35 mi
Distance
Public • PK - PK
7.58 mi
Distance
Public • PK - 5
7.58 mi
Distance
Public • PK - 12
8.17 mi
Distance
Public • 6 - 8 • Serves this home
3.13 mi
Distance
Vincent J. Gallagher Middle School
Public • 6 - 8
3.26 mi
Distance
North Smithfield Middle School
Public • 5 - 8
5.39 mi
Distance
Public • 6 - 8
5.74 mi
Distance
Public • 6 - 8
6.28 mi
Distance
Public • 6 - 8
8.74 mi
Distance
Public • 6 - 12
9.4 mi
Distance
Public • 9 - 12 • Serves this home
3.26 mi
Distance
Davies Career-tech High School
Public • 9 - 12
3.86 mi
Distance
Public • 9 - 12
5.79 mi
Distance
Public • 9 - 12
5.88 mi
Distance
Public • 9 - 12
5.95 mi
Distance
Public • 9 - 12
7.2 mi
Distance
Public • 9 - 12
7.92 mi
Distance
Public • 9 - 12
8.17 mi
Distance
Private • KG - 12
6.67 mi
Distance
Private • 01 - 12
6.83 mi
Distance
High Road School Of Providence
Private • 01 - 12
6.95 mi
Distance
Private • 06 - 12
7.92 mi
Distance
Private • PK - 12
9.4 mi
Distance
Sales & Tax History
Source: Public Records
| Street Address | Beds | Baths | Sold Date | List Price |
|---|---|---|---|---|
| 272 OLD COUNTY Road | 3 | 2 | Nov 20, 2025 | $264,900 |
| 23 WHIPPLE Road | 3 | 2 | Nov 20, 2025 | $279,900 |
| 295 OLD COUNTY Road | 3 | 2 | Nov 20, 2025 | $239,900 |
| 29 MEADOW VIEW Drive | 3 | 2 | Nov 20, 2025 | $299,900 |
| 200 FARNUM Pike | 4 | 2 | Nov 20, 2025 | $599,000 |
| 5 RIDGELAND Road | 3 | 3 | Nov 20, 2025 | $429,900 |
| 143 JENCKES HILL Road | 3 | 3 | Nov 20, 2025 | $335,000 |
| 3 CANDY Court | 3 | 2 | Nov 20, 2025 | $269,900 |
| 31 MANN SCHOOL Road | 3 | 2 | Nov 20, 2025 | $269,500 |
| 112 LOG Road | 3 | 3 | Nov 20, 2025 | $499,900 |
Population & Environment
Source: Sperling's Best Places
| Zip | City | County | National | |
|---|---|---|---|---|
| Population | 15,157 | 22,863 | 662,728 | 335,858,263 |
| Population Density | 729 | 870 | 1,618 | 95 |
| People per Household | 2.4 | 2.4 | 2.5 | 2.6 |
| Median Age | 37.8 | 42.8 | 39.5 | 39.1 |
| Median Income | $85,820 | $88,205 | $62,315 | $66,222 |
| Average Income | $37,958 | $41,042 | $32,816 | $35,475 |
| Cost of Living Index | 102 | 104 | 99 | 100 |
| Zip | City | County | National | |
|---|---|---|---|---|
| January Avg. High Temp | 20.3°F | 17.92°F | 20.3°F | 22.6°F |
| July Avg. High Temp | 82.6°F | 81.66°F | 82.6°F | 86.2°F |
| Annual Precipitation | 49.83" | 49.83" | 49.83" | 38" |
12/100
Car-Dependent
Walk Score ®
23/100
Bikable
Bike Score ®
Overview
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.Walkability averages in the surrounding area
The average walkability score in the surrounding area is Walk Score: 15/100, Transit Score: 0/100, Bike Score: 20/100.
Property Change History
Points of Interest near 27 TRISTAN Court, Smithfield, RI 02917
0.26 mi
Distance
0.38 mi
Distance
0.57 mi
Distance
0.6 mi
Distance
0.74 mi
Distance
Capron Pond, Smithfield, RI, USA
Natural • Recreation
0.56 mi
Distance
Georgiaville Pond, Smithfield, RI, USA
Natural • Recreation
0.59 mi
Distance
0.48 mi
Distance
0.52 mi
Distance
0.52 mi
Distance
0.53 mi
Distance
Capron Pond, Smithfield, RI, USA
Natural • Recreation
0.56 mi
Distance
Georgiaville Pond, Smithfield, RI, USA
Natural • Recreation
0.59 mi
Distance
0.49 mi
Distance
0.71 mi
Distance
0.38 mi
Distance
0.41 mi
Distance
0.55 mi
Distance
0.56 mi
Distance
0.58 mi
Distance
0.61 mi
Distance
0.66 mi
Distance
Nearby Properties
-
$599,999 Active3 bds • 3 ba • 2,200 sqft
4 Old County Village Rd B, Smithfield, RI 02917
MODEL UNIT FINISHED & READY FOR SALE SPECIAL PRICING IF UNDER CONTRACT BY 11-30-25 DEAL AND BE HOME FOR THE HOLIDAYS! Come experience modern luxury living in this beautiful & spacious 3 bedroom, 2.5-bath condo, w/ 2-car garage in Smithfield's newest...Listing by: -
$599,999 Active3 bds • 3 ba • 2,200 sqft
4 Old County Village Road B, Smithfield, RI 02917
MODEL UNIT FINISHED & READY FOR SALE! SPECIAL PRICING IF UNDER CONTRACT BY 11-30-25 TAKE ADVANTAGE OF THIS DEAL AND BE HOME FOR THE HOLIDAYS! Come experience modern luxury living in this beautiful and spacious 3 bedroom, 2.5-bathroom condo, along wit...Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
New$649,900 Active3 bds • 3 ba • 2,200 sqft
2 Old County Village Road A, Smithfield, RI 02917
NEW FLOOR PLAN FEARTURING MULTIGENERATIONAL VERSATILITY The ground floor will feature an in law suite option with separate entrance and full bath complete with walk in shower! Come experience modern luxury living in this beautiful and spacious 2/3 be...Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
New$649,900 Active3 bds • 3 ba • 2,200 sqft
2 Old County Village Rd A, Smithfield, RI 02917
NEW FLOOR PLAN FEARTURING MULTIGENERATIONAL VERSATILITY The ground floor will feature an in law suite option with separate entrance and full bath complete with walk in shower! Come experience modern luxury living in this beautiful &spacious 2/3 bedro...Listing by: -
$674,900 Active3 bds • 3 ba • 2,200 sqft
1 Old County Village Way E, Smithfield, RI 02917
Welcome home to this fully finished, beautifully upgraded 3-bedroom, 2.5-bathroom townhouse offering over 2,200 sq. ft. of living space. Designed with modern living in mind, this stunning property is part of a side-by-side duplex, blending privacy, s...Listing by: The Rachel Jones Team - SKD Real Estate -
$599,900 Active2 bds • 3 ba • 2,224 sqft
3 Desiree Court C, Smithfield, RI 02917
Welcome to this bright and inviting townhouse-style condo in the peaceful Apple Valley complex. This unit offers a warm, open layout featuring a spacious living room, a well-appointed kitchen, and sliding doors that lead to a private deck perfect for...Listing by: Jaclyn Arruda - JPAR Prime Real Estate -
New$699,000 Active3 bds • 2 ba • 2,298 sqft
13 Ivy Place, Lincoln, RI 02865
Welcome to this highly desired sprawling ranch set on a prime dead-end street in Lincoln. Perfectly located just minutes from all major highways, this home offers unmatched convenience while still providing privacy as it sits gracefully back from the...Listing by: Pacheco Homes Team - Century 21 Limitless -
$649,900 Active4 bds • 3 ba • 2,206 sqft
2 Fairview Drive, Smithfield, RI 02828
Welcome to Greenville! Set on a sunny corner lot with 3 garages, this well-kept ranch delivers an easygoing lifestyle in one of Smithfield's most convenient spots. With 2,200+ sf of finished space, you will be pleasantly surprised by it's size! Appre...Listing by: Brian McGloin - Williams & Stuart Real Estate -
$599,900 Active3 bds • 2 ba • 2,685 sqft
540 Greenville Road, North Smithfield, RI 02896
A huge farmers porch welcomes you into the double door front entry foyer of this circa 1750 post and beam colonial. All the old-world charm with an updated kitchen. Family room boasts exposed original beams, wide pine flooring and wood stove, large l...Listing by: Kristin Fontaine - Fontaine Real Estate, Inc. -
$579,900 Active Under Contract3 bds • 3 ba • 2,854 sqft
1 Pat Drive, Lincoln, RI 02865
Sitting in one of Lincoln's most sought-after neighborhoods, Lonsdale, this inviting property captures the best of small-town serenity and convenient living. A beautifully maintained raised ranch, the home sits at the end of a quiet street, offering...Listing by: Geddes Dupuis Team - Residential Properties Ltd. & RE/MAX 1st Choice -
New$699,000 Active4 bds • 4 ba • 2,488 sqft
252 Gentian Avenue, North Providence, RI 02908
Awesome duplex townhouse with nice garage and 2 bedrooms and 1.5 baths each side. Built in 1997, excellent tenants that pay every month on the 1st like clockwork and both currently month to month. One unit perfect for primary occupant with garage, up...Listing by: Jason Corsini - Northeast Realty Asssociates -
$629,900 Active Under Contract3 bds • 3 ba • 2,200 sqft
81 Gentian Avenue, Providence, RI 02908
Classic Tudor Charm Meets Modern Comfort in Elmhurst. Beautifully maintained and thoughtfully updated, this three-level Tudor style offers 3 bedrooms and 2.5 baths in one of Providence's most desirable neighborhoods Elmhurst. Step inside to find...Listing by: Doug Jeffrey - Broadway Real Estate Group & Tidal Consultation LLC -
$589,000 Active6 bds • 3 ba • 2,574 sqft
6 Cushing Street, Cumberland, RI 02864
Beautifully Updated 3-Family Home in a Desirable Location Perfect for Owner-Occupant or Investor! Don't miss this exceptional opportunity to own a well-maintained three-family property in a sought-after neighborhood. Ideal for owner-occupancy or...Listing by: Janelle Spence - Real Broker, LLC -
$639,900 Active2 bds • 3 ba • 2,270 sqft
1503 Hunting Hill Dr 1503, Cumberland, RI 02864
Unveiling a new phase of The Preserve at Hunting Hill! Luxurious townhomes situated 10 minutes to Providence, 45 minutes to Boston, and an hour to Mystic CT. Ideal alternative to a single family home with its sprawling 2,270 square feet of living spa...Listing by: -
$649,900 Active2 bds • 3 ba • 2,270 sqft
1504 Hunting Hill Dr 1504, Cumberland, RI 02864
Unveiling a new phase of The Preserve at Hunting Hill! Luxurious townhomes situated 10 minutes to Providence, 45 minutes to Boston, and an hour to Mystic CT. Ideal alternative to a single family home with its sprawling 2,270 square feet of living spa...Listing by: -
$649,900 Active2 bds • 3 ba • 2,270 sqft
1504 Hunting Hill Drive, Cumberland, RI 02864
Unveiling a new phase of The Preserve at Hunting Hill! Luxurious townhomes situated 10 minutes to Providence, 45 minutes to Boston, and an hour to Mystic CT. Ideal alternative to a single family home with its sprawling 2,270 square feet of living spa...Listing by: Cassidy St. Sauveur - Engel & Volkers Oceanside -
$649,900 Active Under Contract2 bds • 3 ba • 2,270 sqft
1501 Hunting Hill Drive, Cumberland, RI 02864
Unveiling a new phase of The Preserve at Hunting Hill! Luxurious townhomes situated 10 minutes to Providence, 45 minutes to Boston, and an hour to Mystic CT. Ideal alternative to a single family home with its sprawling 2,270 square feet of living spa...Listing by: Cassidy St. Sauveur - Engel & Volkers Oceanside & Compass -
$639,900 Active2 bds • 3 ba • 2,270 sqft
1503 Hunting Hill Drive, Cumberland, RI 02864
Unveiling a new phase of The Preserve at Hunting Hill! Luxurious townhomes situated 10 minutes to Providence, 45 minutes to Boston, and an hour to Mystic CT. Ideal alternative to a single family home with its sprawling 2,270 square feet of living spa...Listing by: Cassidy St. Sauveur - Engel & Volkers Oceanside -
$689,000 Active Under Contract9 bds • 3 ba • 2,878 sqft
41 Henrietta Street, Providence, RI 02904
3-unit property beautifully updated and ready for your new tenants to move right in. Featuring 3 bedrooms in each unit, refinished hardwood floors, new modern lighting and finishes, stainless appliances, granite countertops, new doors. The second and...Listing by: Sarah Stelluto - RE/MAX Properties & Coldwell Banker Realty -
$699,000 Active Under Contract3 bds • 3 ba • 2,522 sqft
33 Sandy Way, Cumberland, RI
Set on a quiet cul-de-sac just behind Cumberland High School, this home sits in one of the town's most desirable neighborhoods. The yards are generous, the streets are calm, and everything just feels like home. This house has curb appeal in spades...Listing by: David Nielson - Keller Williams Leading Edge & Real Broker, LLC
Similar Priced Comparison
-
$599,999 Active3 bds • 3 ba • 2200 sqft
4 Old County Village Rd B
- Home smaller by 350 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: -
$599,999 Active3 bds • 3 ba • 2200 sqft
4 Old County Village Road B
- Home smaller by 350 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
$629,900 Active3 bds • 3 ba • 2000 sqft
3 Old County Village Way E
- Home smaller by 550 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
$629,900 Active3 bds • 3 ba • 2000 sqft
3 Old County Village Way
- Home smaller by 550 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
$629,900 Active3 bds • 3 ba • 2000 sqft
3 Old County Village Way E
- Home smaller by 550 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
New$649,900 Active3 bds • 3 ba • 2200 sqft
2 Old County Village Road A
- Home smaller by 350 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: Barbara Jean Taylor - Coldwell Banker Realty -
New$649,900 Active3 bds • 3 ba • 2200 sqft
2 Old County Village Rd A
- Home smaller by 350 sqft
- Lot smaller by 43,996 sqft
- Newer by 10 years
Listing by: -
$674,900 Active3 bds • 3 ba • 2200 sqft
1 Old County Village Way E
- Home smaller by 350 sqft
- Lot smaller by 41,796 sqft
- Newer by 9 years
Listing by: The Rachel Jones Team - SKD Real Estate -
$599,900 Active2 bds • 3 ba • 2224 sqft
3 Desiree Court C
- Home smaller by 326 sqft
- Lot smaller by 43,996 sqft
- Newer by 5 years
Listing by: Jaclyn Arruda - JPAR Prime Real Estate -
$700,000 Active4 bds • 4 ba • 4260 sqft
16 Louise Ann Drive
- Home larger by 1,710 sqft
- Lot smaller by 15,682 sqft
- Older by 11 years
Listing by: Glenn Stavens - Aspen Realty Group, LLC -
$489,000 Active1 bds • 2 ba • 990 sqft
14 Mowry Drive
- Home smaller by 1,560 sqft
- Lot smaller by 36,155 sqft
- Older by 7 years
Listing by: Paul Ruhle - Archive Realty -
$569,000 Active3 bds • 3 ba • 1740 sqft
5 Meadow Court
- Home smaller by 810 sqft
- Lot smaller by 23,523 sqft
- Older by 9 years
Listing by: The RR&A Team - Coldwell Banker Realty -
$799,000 Active6 bds • 6 ba • 4523 sqft
56 Pleasant View Avenue
- Home larger by 1,973 sqft
- Lot smaller by 23,958 sqft
- Older by 29 years
Listing by: Nicole DeBenedictis - Homistic Real Estate, Inc. -
$499,000 Active3 bds • 2 ba • 1740 sqft
58 Alfred Avenue
- Home smaller by 810 sqft
- Lot smaller by 36,156 sqft
- Older by 11 years
Listing by: Michael Russo - RI Real Estate Services -
$569,900 Active Under Contract5 bds • 3 ba • 3464 sqft
2 Julia Drive
- Home larger by 914 sqft
- Lot smaller by 30,057 sqft
- Older by 48 years
Listing by: Barrows Team - Keller Williams Leading Edge & Keller Williams Leading Edge -
New$699,000 Active3 bds • 2 ba • 2298 sqft
13 Ivy Place
- Home smaller by 252 sqft
- Lot smaller by 1,743 sqft
- Older by 60 years
Listing by: Pacheco Homes Team - Century 21 Limitless -
$540,000 Active3 bds • 2 ba • 3354 sqft
3 Juniper Lane
- Home larger by 804 sqft
- Lot smaller by 30,928 sqft
- Older by 53 years
Listing by: Jack Mayo - Flagship Real Estate Advisors -
$629,900 Active4 bds • 2 ba • 3872 sqft
563 Putnam Pike
- Home larger by 1,322 sqft
- Lot smaller by 11,762 sqft
- Older by 115 years
Listing by: Scott Aceto - Smith and Oak Real Estate Co. -
$549,900 Active4 bds • 4 ba • 2462 sqft
52 Bicentennial Way
- Home smaller by 88 sqft
- Lot smaller by 35,981 sqft
- Older by 44 years
Listing by: Lydia Mayson - CENTURY 21 Gonsalves - Pastore -
$700,000 Activebds • 1 ba • 1916 sqft
1688 Old Louisquisset Pike
- Home smaller by 634 sqft
- Lot smaller by 4,356 sqft
- Older by 36 years
Listing by: Megan Hayden - HERE Realty
Nearby Locations
Communities
- Graniteville Homes For Sale
- Central Lincoln Homes For Sale
- Central Greenville Homes For Sale
- Geneva Homes For Sale
- Mount Pleasant Homes For Sale
- Elmhurst Homes For Sale
- Cumberland Hill Homes For Sale
- Globe Homes For Sale
- Wanskuck Homes For Sale
- Bernon District Homes For Sale
- Thornton Homes For Sale
- Monastery Heights Homes For Sale
- East Woonsocket Homes For Sale
- Valley Falls Homes For Sale
- East Side Homes For Sale
- South Side Homes For Sale
- Western Cranston Homes For Sale
- Pine Crest Homes For Sale
- Watchemocket Homes For Sale
- Edgewood Homes For Sale
Nearby Zips
- 02917 Homes For Sale
- 02865 Homes For Sale
- 02828 Homes For Sale
- 02919 Homes For Sale
- 02904 Homes For Sale
- 02908 Homes For Sale
- 02896 Homes For Sale
- 02909 Homes For Sale
- 02895 Homes For Sale
- 02864 Homes For Sale
- 02860 Homes For Sale
- 02907 Homes For Sale
- 02906 Homes For Sale
- 02920 Homes For Sale
- 02921 Homes For Sale
- 02910 Homes For Sale
- 01504 Homes For Sale
- 02861 Homes For Sale
- 02857 Homes For Sale
- 02905 Homes For Sale
Nearby Cities
- Smithfield, RI Homes for Sale
- Lincoln, RI Homes for Sale
- North Providence, RI Homes for Sale
- Johnston, RI Homes for Sale
- Cumberland Hill, RI Homes for Sale
- North Smithfield, RI Homes for Sale
- Woonsocket, RI Homes for Sale
- Cumberland, RI Homes for Sale
- Valley Falls, RI Homes for Sale
- Providence, RI Homes for Sale
- Pawtucket, RI Homes for Sale
- Cranston, RI Homes for Sale
- Blackstone, MA Homes for Sale
- Scituate, RI Homes for Sale
- Chestnut Hill Meeting House, MA Homes for Sale
- East Providence, RI Homes for Sale
- Hope, RI Homes for Sale
- Bellingham, MA Homes for Sale
- North Attleborough, MA Homes for Sale
- North Attleboro, MA Homes for Sale
Similar Searches
- Smithfield Land for Sale
- Smithfield New Homes for Sale
- Smithfield Single Story Homes for Sale
- Smithfield Homes with Pools for Sale
- Smithfield Cheap Homes for Sale
- Smithfield Luxury Homes for Sale
- Smithfield Condos for Sale
- Smithfield Town Homes for Sale
- Smithfield Commercial for Sale
- Smithfield Open Houses for Sale
- Smithfield Two Car Garage Homes for Sale
- Smithfield Large Lots for Sale
- National Listings
- National Home Values
- Properties in RI
- Home Values in RI
- Other properties in Providence, RI
- Other properties in 02917, RI
- Home Values in Smithfield, RI
Frequently Asked Questions for 27 TRISTAN Court
Source: Realty.com
27 TRISTAN Court, Smithfield, RI 02917 is a Single Family 2,550 sq. ft. home listed for sale. Realty.com has 1 photos available of this 4 bed, 3 bath house, listed at $649,900. View sales and tax history, use our mortgage calculator and more on Realty.com
Our records indicate that 27 TRISTAN Court was built in 2015.
The full address for this home is 27 TRISTAN Court, Smithfield, RI 02917.
27 TRISTAN Court has been listed on Realty.com since Thu November 12, 2015
Almost all errands require a car. It is possible to get on a bus. Minimal bike infrastructure.
The average walkability score in the surrounding area is Walk Score: 15/100, Transit Score: 0/100, Bike Score: 20/100.
There are 3 schools assigned to this home. Check out the schools near 27 TRISTAN Court. Anna M. Mccabe School (Grades: PK - 5), Lincoln Middle School (Grades: 6 - 8), Smithfield High School (Grades: 9 - 12)
Listing provided courtesy of:
Re/max Preferred
(tel: 401-353-2200)
Listing agent:
Richard Tessier
(tel: 401-353-6000)
(#6800)
This content last refreshed on 2025-12-03 22:38:37. Some properties which appear for sale on this web site may subsequently have sold or may no longer be available.
Export listing data of 27 TRISTAN Court, Smithfield, RI 02917 : MLS# 1112573