D
Seller's Agent in 2025
Douglas Mittelsteadt
Anchor Real Estate Group, LLC
154 Julian Rd Warwick, RI 02889
Hoxie NeighborhoodEstimated Value: $595,574 - $716,000
3
Beds
2.5
Baths
1,876
Sq Ft
$345/Sq Ft
Est. Value
Highlights
- Marina
- Media Room
- Deck
- Golf Course Community
- Colonial Architecture
- Cathedral Ceiling
About This Home
As of June 2025This pristine, well maintained, upgraded and spacious Craftsman Colonial built in 2014 is ready for you to call Home! 3 Bedrooms and 2.5 Baths with additional finished living space in the Basement will provide you with all of the indoor space you need. Interior Upgrades include blower fan w/ remote added to Gas Fireplace; Basement Finished (2021) adding 360 sq ft of living space; Electrical adding separate 60/80 Amp subpanel and whole house generator plug (2021); Gas Water Heater - A.O. Smith commercial grade 50 gallon (2023); Speed Queen commercial grade Washer/Dryer (2024 - $4,400 value). Outside, the home is situated on a 1/4 acre lot, located at the end of a cul-de-sac. 8 home street just recently developed in 2014. Exterior Upgrades include Deck renovation with Trex brand composite decking, white PVC trim boards and white Vinyl railings (2019); UNILOCK brand patio pavers off deck - 17 ft X 17 ft (2020); Anderson ventilating storm door on Front Entry door (2021); Sprinkler/Irrigation watering system with app-based WiFi control and Deduct Meter (2021); Leaf Filter brand gutter protection/gutter guards (2021); Front Porch decking and trim boards completely stripped and refinished (2024). This home spares no details. Granite Kitchen and Baths; GE Profile appliances; Bamboo hardwoods; Luxury Vinyl Plank flooring and Cedar Closet in Basement; Oversized (576 sq ft) 2 Car Garage can easily fit two cars and accommodate all storage needs. Nothing to do but move in. Welcome Home!
Last Agent to Sell the Property
Douglas Mittelsteadt
Anchor Real Estate Group, LLC License #REC.0018305 Listed on: 04/09/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $6,109
Year Built
- Built in 2014
Lot Details
- 10,019 Sq Ft Lot
- Cul-De-Sac
- Sprinkler System
HOA Fees
- $21 Monthly HOA Fees
Parking
- 2 Car Attached Garage
- Garage Door Opener
- Driveway
Home Design
- Colonial Architecture
- Vinyl Siding
- Concrete Perimeter Foundation
Interior Spaces
- 2-Story Property
- Cathedral Ceiling
- Gas Fireplace
- Thermal Windows
- Family Room
- Media Room
- Game Room
- Storage Room
- Utility Room
- Attic
Kitchen
- Oven
- Range
- Microwave
- Dishwasher
Flooring
- Wood
- Carpet
- Ceramic Tile
- Vinyl
Bedrooms and Bathrooms
- 3 Bedrooms
- Cedar Closet
- Bathtub with Shower
Laundry
- Dryer
- Washer
Partially Finished Basement
- Basement Fills Entire Space Under The House
- Interior Basement Entry
Home Security
- Security System Owned
- Storm Doors
Outdoor Features
- Deck
- Patio
- Porch
Location
- Property near a hospital
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Gas
- Underground Utilities
- 100 Amp Service
- Power Generator
- Gas Water Heater
- Cable TV Available
Listing and Financial Details
- Tax Lot 716
- Assessor Parcel Number 154JULIANRDWARW
Community Details
Overview
- Hidden Oaks Subdivision
Amenities
- Shops
- Restaurant
- Public Transportation
Recreation
- Marina
- Golf Course Community
- Tennis Courts
- Recreation Facilities
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 9, 2025
Closed on
Jun 6, 2025
Sold by
Mittelsteadt Lt and Mittelsteadt
Bought by
Guynn Peter and Guynn Caroline
Seller's Agent
Douglas Mittelsteadt
Anchor Real Estate Group, LLC
Buyer's Agent
Steve Brunero
BHHS Commonwealth Real Estate
List Price
$589,000
Sold Price
$617,500
Premium/Discount to List
$28,500
4.84%
Views
119
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$29,144
Avg. Annual Appreciation
4.87%
Original Mortgage
$494,000
Outstanding Balance
$491,874
Interest Rate
6.81%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$154,770
Purchase Details
Closed on
May 11, 2023
Sold by
Mittelsteadt Kimberly D and Mittelsteadt Douglas M
Bought by
Mittelsteadt Lt and Mittelsteadt
Purchase Details
Closed on
Nov 28, 2018
Sold by
Brown Kimbrly D
Bought by
Mittelsteadt Kimberly D and Mittelsteadt Douglas M
Purchase Details
Listed on
Jan 20, 2017
Closed on
Mar 20, 2017
Sold by
Romero Robert R and Romero Gloria J
Bought by
Brown Kimberly D
Seller's Agent
Michelle Richard
RISE REC
Buyer's Agent
Douglas Mittelsteadt
List Price
$329,900
Sold Price
$318,000
Premium/Discount to List
-$11,900
-3.61%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.03%
Original Mortgage
$302,100
Interest Rate
4.19%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jan 10, 2014
Closed on
Jul 14, 2014
Sold by
Sturbridge Home Builde
Bought by
Romero Robert R and Romero Gloria J
Seller's Agent
The Stone Alliance Team
Coldwell Banker Realty
Buyer's Agent
Barbara Dacey
Residential Properties Ltd.
List Price
$299,900
Sold Price
$302,025
Premium/Discount to List
$2,125
0.71%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.94%
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
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Guynn Peter | $617,500 | None Available | |
| Guynn Peter | $617,500 | None Available | |
| Mittelsteadt Lt | -- | None Available | |
| Mittelsteadt Lt | -- | None Available | |
| Mittelsteadt Kimberly D | -- | -- | |
| Mittelsteadt Kimberly D | -- | -- | |
| Brown Kimberly D | $318,000 | -- | |
| Brown Kimberly D | $318,000 | -- | |
| Romero Robert R | $299,900 | -- | |
| Romero Robert R | $299,900 | -- |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | Guynn Peter | $494,000 | |
| Closed | Guynn Peter | $494,000 | |
| Previous Owner | Brown Kimberly D | $302,100 |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/06/2025 06/06/25 | Sold | $617,500 | +4.8% | $329 / Sq Ft | |
| 05/09/2025 05/09/25 | Pending | -- | -- | -- | |
| 04/09/2025 04/09/25 | For Sale | $589,000 | +85.2% | $314 / Sq Ft | |
| 03/20/2017 03/20/17 | Sold | $318,000 | -3.6% | $210 / Sq Ft | View Prior Sale |
| 02/18/2017 02/18/17 | Pending | -- | -- | -- | |
| 01/20/2017 01/20/17 | For Sale | $329,900 | +9.2% | $218 / Sq Ft | |
| 07/14/2014 07/14/14 | Sold | $302,025 | +0.7% | $199 / Sq Ft | View Prior Sale |
| 06/14/2014 06/14/14 | Pending | -- | -- | -- | |
| 01/10/2014 01/10/14 | For Sale | $299,900 | -- | $197 / Sq Ft |
Source: State-Wide MLS
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 | $6,233 | $490,800 | $109,300 | $381,500 |
| 2024 | $6,109 | $422,200 | $95,000 | $327,200 |
| 2023 | $5,991 | $422,200 | $95,000 | $327,200 |
| 2022 | $6,089 | $325,100 | $68,200 | $256,900 |
| 2021 | $5,980 | $319,300 | $68,200 | $251,100 |
| 2020 | $5,980 | $319,300 | $68,200 | $251,100 |
| 2019 | $5,980 | $319,300 | $68,200 | $251,100 |
| 2018 | $5,266 | $260,200 | $68,200 | $192,000 |
| 2017 | $5,266 | $260,200 | $68,200 | $192,000 |
| 2016 | $5,266 | $260,200 | $68,200 | $192,000 |
| 2015 | $5,341 | $257,400 | $61,200 | $196,200 |
| 2014 | $5,163 | $257,400 | $61,200 | $196,200 |
Source: Public Records
Agents Affiliated with this Home
-
-
Steve Brunero
Buyer's Agent in 2025
Steve Brunero
BHHS Commonwealth Real Estate
(401) 595-5445
1 in this area
12 Total Sales
-
M
Seller's Agent in 2017
Michelle Richard
RISE REC
-
The Stone Alliance Team
T
Seller's Agent in 2014
The Stone Alliance Team
Coldwell Banker Realty
(401) 623-1419
3 in this area
93 Total Sales
-
Barbara Dacey
Buyer's Agent in 2014
Barbara Dacey
Residential Properties Ltd.
(401) 553-6322
1 in this area
129 Total Sales
Map
Source: State-Wide MLS
MLS Number: 1382087
APN: WARW-000340-000716-000000
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 © 2026 State-Wide MLS, Inc. All rights reserved.
Nearby Homes
- 207 Stillwater Dr
- 25 Walker Rd
- 45 Haven St
- 110 Marigold Dr
- 91 Hilton Rd
- 859 Church Ave
- 47 Amsterdam Ave
- 700 Sandy Ln Unit 3
- 700 Sandy Ln Unit 5
- 700 Sandy Ln Unit 19
- 700 Sandy Ln Unit 20
- 700 Sandy Ln Unit 2
- 591 Sandy Ln
- 32 Stillwater Dr
- 178 Hilton Rd
- 157 Betsey Williams Dr
- 112 Old Warwick Ave
- 128 Fern St
- 121 Fern St
- 15 Community Rd
Your Personal Tour Guide
Ask me questions while you tour the home.