Seller's Agent in 2025
Ellen Connelly
RE/MAX Real Estate Center
(508) 212-6948
1 in this area
167 Total Sales
262 Douglas Pike Smithfield, RI 02917
4
Beds
7
Baths
4,804
Sq Ft
2.03
Acres
Highlights
- In Ground Pool
- 2.03 Acre Lot
- Viking Appliances
- Raymond Laperche School Rated A
- Colonial Architecture
- Deck
About This Home
As of November 2025Custom-built in 2023, this stunning home is designed for modern luxury living and entertaining. It features 4 spacious bedrooms each with a private en-suite bath plus a dedicated office, coffered ceiling formal dining room, and a dream laundry room with built-in dog washing station. The gourmet kitchen is a chef's masterpiece, showcasing Viking and Thermador appliances, a massive island, walk-in pantry, and custom cabinetry.The open-concept living space centers around a striking floor-to-ceiling gas fireplace, flowing seamlessly into both indoor and outdoor entertaining areas. The finished basement offers a full working bar, lounge, and pool table ideal for hosting friends and family.The primary suite is a private retreat, featuring a spa-like bath with a soaking tub, oversized shower, and dual vanities. The custom walk-in closet is truly exceptional designed with high-end finishes, built-ins, and space for everything.Step outside to a resort-style backyard with a gorgeous pool, multi-color lighted fountains, a swim-up bar, and a fully equipped outdoor kitchen. Four mounted TVs, a pool room with its own bath, and ample seating complete the ultimate outdoor oasis. Situated on a private 2-acre lot surrounded by 24 acres of nature, this home offers unmatched privacy and tranquility.
Last Agent to Sell the Property
RE/MAX Real Estate Center License #RES.0040133 Listed on: 09/13/2025
Last Buyer's Agent
RE/MAX Real Estate Center License #RES.0040133 Listed on: 09/13/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $19,209
Year Built
- Built in 2023
Lot Details
- 2.03 Acre Lot
- Security Fence
- Sprinkler System
- Property is zoned RMED
Parking
- 3 Car Attached Garage
- Driveway
Home Design
- Colonial Architecture
- Contemporary Architecture
- Vinyl Siding
- Concrete Perimeter Foundation
Interior Spaces
- 3-Story Property
- Wet Bar
- Cathedral Ceiling
- Fireplace Features Masonry
- Family Room
- Home Office
- Home Gym
- Wood Flooring
- Laundry Room
- Attic
Kitchen
- Walk-In Pantry
- Oven
- Range
- Microwave
- Dishwasher
- Viking Appliances
Bedrooms and Bathrooms
- 4 Bedrooms
- Soaking Tub
- Bathtub with Shower
Finished Basement
- Basement Fills Entire Space Under The House
- Interior and Exterior Basement Entry
Pool
- In Ground Pool
- Saltwater Pool
Outdoor Features
- Deck
- Patio
- Outbuilding
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- 200+ Amp Service
- Private Water Source
- Water Heater
- Septic Tank
Listing and Financial Details
- Tax Block 03
- Assessor Parcel Number 262DOUGLASPIKESMTH
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Sep 13, 2025
Closed on
Nov 21, 2025
Sold by
262 Douglas Pike Llc
Bought by
Deoliveira Carlos H and Deoliveira Kamyla
Seller's Agent
Ellen Connelly
RE/MAX Real Estate Center
Buyer's Agent
Ellen Connelly
RE/MAX Real Estate Center
List Price
$1,600,000
Sold Price
$1,700,000
Premium/Discount to List
$100,000
6.25%
Views
52
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-37.52%
Original Mortgage
$1,360,000
Outstanding Balance
$1,360,000
Interest Rate
5.75%
Mortgage Type
New Conventional
Estimated Equity
$239,178
Purchase Details
Closed on
Apr 2, 2024
Sold by
Tanzi Adam V
Bought by
262 Douglas Pike Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$599,750
Interest Rate
6.9%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 3, 2022
Sold by
Tanzi Adam V
Bought by
262 Douglas Pike Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$601,000
Interest Rate
5.1%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 4, 2020
Sold by
Baca Realty Llc
Bought by
Tanzi Adam V
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $1,700,000 | -- | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | $185,000 | None Available | |
| Warranty Deed | $185,000 | None Available | |
| Warranty Deed | $185,000 | None Available |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,360,000 | New Conventional | |
| Previous Owner | $599,750 | New Conventional | |
| Previous Owner | $601,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 11/24/2025 11/24/25 | Sold | $1,700,000 | +6.3% | $354 / Sq Ft |
| 09/19/2025 09/19/25 | Pending | -- | -- | -- |
| 09/13/2025 09/13/25 | For Sale | $1,600,000 | -- | $333 / Sq Ft |
Source: State-Wide MLS
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $19,209 | $1,550,400 | $213,300 | $1,337,100 |
| 2024 | $18,791 | $1,301,300 | $170,700 | $1,130,600 |
| 2023 | $6,599 | $481,000 | $170,700 | $310,300 |
| 2022 | $2,281 | $170,700 | $170,700 | $0 |
| 2021 | $2,712 | $158,300 | $158,300 | $0 |
| 2020 | $227 | $13,500 | $13,500 | $0 |
| 2019 | $227 | $13,500 | $13,500 | $0 |
| 2018 | $155 | $8,800 | $8,800 | $0 |
| 2017 | $155 | $8,800 | $8,800 | $0 |
| 2016 | $147 | $8,800 | $8,800 | $0 |
| 2015 | $155 | $8,800 | $8,800 | $0 |
| 2012 | $162 | $10,100 | $10,100 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
Ellen Connelly
Map
Source: State-Wide MLS
MLS Number: 1392938
APN: 42/ / 061/A /
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Copyright © 2025 State-Wide MLS, Inc. All rights reserved.
Nearby Homes
- 23 Cambridge Cir
- 2 Varin Dr
- 24 Cambridge Cir
- 25 Linfield Cir
- 1 Stoneridge Rd Unit 1
- 6 Wadsworth Ave
- 15 Woodland Ave
- 5 Meadow Ct
- 2 Julia Dr
- 1 Victoria Dr
- 407 Pinewood Dr
- 61 Stillwater Rd
- 402 Pinewood Dr
- 15 Higgins St Unit 123
- 209 Waterman Ave
- 13 Ivy Place
- 18 Homestead Ave
- 3 Vineland Ave
- 154 Waterman Ave Unit 156
- 16 Louise Ann Dr