NOT LISTED FOR SALE

417 Tremont St Rehoboth, MA 02769

Estimated Value: $1,193,000 - $1,201,000

7 Beds
5 Baths
4,689 Sq Ft
$256/Sq Ft Est. Value

Last Sold October 28, 2021

Last sale price $975,000 $208 Per Sq Ft

Est. 23% increase in value since last sale

Current estimated payment $6,686/month

Highlights

  • Open Floorplan
  • Cathedral Ceiling
  • Solid Surface Countertops
  • Custom Closet System
  • Wood Flooring
  • Beamed Ceilings

About This Home

As of October 2021

At the end of a tree lined drive a private 2.7 acre oasis awaits. This extraordinary estate is unlike any property you have seen. Approximately 4,700 square feet of idyllic living space provides the ultimate in flexibility. The main 4-bedroom home and the equally exceptional three-bedroom handicapped accessible in-law are joined by the central foyer. Each wing of the home was designed thoughtfully- the floor plan is open with exceptional details throughout. The meticulously maintained grounds offer equal flexibility. Enjoy views from the screened porch or various patios of the incredible 40’ pool, mature perennial gardens, the peony field or take a relaxing stroll through the labyrinth meditation garden. Detached studio at the street offers a place to dance, learn, work or create art. Eco-friendly geothermal heat fuels the utilities making this smart home efficient. Generator, 3-car garage, central air and vac. Country living with close to proximity to Boston/Providence. See 3D V-Tour!

Last Listed By

Jennifer Mello

The Mello Group, Inc. Listed on: 09/18/2021

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $142

Year Built

  • 1994

Lot Details

  • 2.61

Parking

  • 3

Interior Spaces

  • Open Floorplan
  • Beamed Ceilings
  • Cathedral Ceiling
  • Skylights
  • Recessed Lighting
  • Decorative Lighting
  • Bay Window
  • French Doors
  • Exterior Basement Entry

Kitchen

  • Stove
  • Stainless Steel Appliances
  • Kitchen Island
  • Solid Surface Countertops

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • Primary bedroom located on second floor
  • Custom Closet System
  • Walk-In Closet
  • Double Vanity
  • Soaking Tub
  • Separate Shower
  • Linen Closet In Bathroom

Utilities

  • 3 Cooling Zones
  • 3 Heating Zones

Home Details

Home Type

Single Family

Est. Annual Taxes

$142

Year Built

1994

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • SUB AGENCY OFFERED: No
  • Compensation Based On: Net Sale Price
  • Architectural Style: Colonial, Contemporary, Craftsman, Other (See Remarks)
  • Carport Y N: No
  • Directions: Rt. 118 to Tremont Street
  • Garage Yn: Yes
  • Property Attached Yn: No
  • Road Frontage Type: Public
  • Road Surface Type: Paved
  • Subdivision Name: Tremont Street
  • Year Built Details: Actual
  • Special Features: None
  • Year Built: 1994

Interior Features

  • Appliances: Range,Dishwasher,Refrigerator, Stainless Steel Appliance(s), Geothermal/GSHP Hot Water, Plumbed For Ice Maker, Utility Connections for Gas Range, Utility Connections for Electric Oven, Utility Connections for Gas Dryer
  • Has Basement: Full, Partially Finished, Interior Entry, Concrete
  • Fireplace Features: Living Room
  • Room Bedroom2 Level: Second
  • Room Bedroom2 Features: Skylight, Closet, Flooring - Hardwood, Flooring - Wood
  • Room Bedroom2 Area: 135.972222
  • Room Bedroom3 Features: Closet, Flooring - Hardwood, French Doors
  • Room Bedroom3 Area: 130.291666
  • Room Bedroom3 Level: Second
  • Room Bedroom4 Area: 184.722222
  • Room Bedroom4 Level: Second
  • Room Bedroom4 Features: Closet, Flooring - Hardwood, Flooring - Wood, French Doors
  • Room Bedroom5 Level: Second
  • Room Bedroom5 Features: Cathedral Ceiling(s), Beamed Ceilings, Vaulted Ceiling(s), Closet, Closet/Cabinets - Custom Built, Flooring - Hardwood, Flooring - Wood
  • Room Bedroom5 Area: 180
  • Total Bathrooms: 5
  • Room Master Bedroom Features: Walk-In Closet(s), Closet, Flooring - Hardwood, Flooring - Wood
  • Room Master Bedroom Level: Second
  • Room Master Bedroom Area: 446.881944
  • Master Bathroom Features: Yes
  • Bathroom 1 Area: 48
  • Bathroom 1 Features: Bathroom - Full, Bathroom - With Shower Stall, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
  • Bathroom 1 Level: Main
  • Bathroom 2 Level: Main
  • Bathroom 2 Area: 72
  • Bathroom 2 Features: Bathroom - Full, Bathroom - Tiled With Shower Stall, Closet - Linen, Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid
  • Bathroom 3 Features: Bathroom - Full, Bathroom - Double Vanity/Sink, Cathedral Ceiling(s), Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Jacuzzi / Whirlpool Soaking Tub, Double Vanity
  • Bathroom 3 Level: Second
  • Bathroom 3 Area: 108
  • Room Dining Room Features: Flooring - Hardwood, Flooring - Wood, Open Floorplan, Lighting - Pendant
  • Room Dining Room Level: Main
  • Room Dining Room Area: 278.298611
  • Room Family Room Level: Main
  • Room Family Room Features: Flooring - Hardwood, Flooring - Wood, Open Floorplan
  • Room Family Room Area: 242
  • Room Kitchen Level: Main
  • Room Kitchen Features: Flooring - Stone/Ceramic Tile, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Cabinets - Upgraded, Exterior Access, Open Floorplan, Recessed Lighting, Stainless Steel Appliances, Gas Stove, Peninsula
  • Room Kitchen Area: 159.201388
  • Room Living Room Level: Main
  • Room Living Room Area: 478.666666
  • Room Living Room Features: Cathedral Ceiling(s), Flooring - Hardwood, Flooring - Wood, Window(s) - Bay/Bow/Box, Open Floorplan
  • MAIN LO: AC1556
  • LIST PRICE PER Sq Ft: 204.52
  • PRICE PER Sq Ft: 207.93
  • MAIN SO: AC1556
  • Accessibility Features: Handicap Accessible
  • Full Bathrooms: 5
  • Total Bedrooms: 7
  • Door Features: French Doors
  • Fireplace: Yes
  • Fireplaces: 1
  • Flooring: Wood, Tile, Carpet, Flooring - Wall to Wall Carpet, Flooring - Hardwood, Flooring - Stone/Ceramic Tile
  • Interior Amenities: Closet, Ceiling - Cathedral, Ceiling Fan(s), Ceiling - Vaulted, Countertops - Stone/Granite/Solid, Countertops - Upgraded, Kitchen Island, Open Floor Plan, Recessed Lighting, Lighting - Pendant, Bedroom, Kitchen, Foyer, Inlaw Apt.
  • Main Level Bathrooms: 2
  • Private Spa: Yes
  • Window Features: Insulated Windows, Screens

Exterior Features

  • Roof: Shingle
  • Exterior Features: Rain Gutters, Professional Landscaping, Garden
  • Foundation Details: Concrete Perimeter
  • Construction Type: Frame
  • Disclosures: Geothermal Heat, Hot Water, Electricity And Central Air For The Entire Property. 400 Amp Circuit Breakers. Septic Has An Oversized Leach Field To Accommodate The In-Law.
  • Fencing: Fenced/Enclosed, Fenced
  • Home Warranty: No
  • Lot Features: Farm, Level, Other
  • Patio And Porch Features: Screened, Deck, Patio, Covered
  • Pool Features: In Ground
  • Pool Private: Yes
  • Waterfront: No

Garage/Parking

  • Parking Features: Attached, Garage Door Opener, Storage, Garage Faces Side, Insulated, Off Street, Stone/Gravel
  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Garage Spaces: 3
  • Total Parking Spaces: 10

Utilities

  • Cooling: Central Air, Geothermal
  • Heating: Geothermal
  • HEAT ZONES: 3
  • COOLING ZONES: 3
  • Cooling Y N: Yes
  • Electric: Generator, Circuit Breakers, 200+ Amp Service, Generator Connection
  • Heating Yn: Yes
  • Laundry Features: In Basement, Washer Hookup
  • Security: Security System
  • Sewer: Private Sewer
  • Utilities: for Gas Range, for Electric Oven, for Gas Dryer, Washer Hookup, Icemaker Connection, Generator Connection
  • Water Source: Private

Condo/Co-op/Association

  • Association: No
  • Community Features: Public Transportation, Shopping, Pool, Tennis Court(s), Stable(s), Golf, Medical Facility, Conservation Area, Highway Access, House of Worship, Private School, Public School, T-Station, Other
  • Senior Community: No

Schools

  • Elementary School: Palmer River
  • High School: Dr High
  • Middle Or Junior School: Dl Beckwith

Lot Info

  • LOT SIZE: 113579
  • PAGE: 0056
  • Farm Land Area Units: Square Feet
  • Lot Size Sq Ft: 113691.599999
  • Zoning: R

Tax Info

  • Tax Annual Amount: 9685.06
  • Tax Book Number: 24137
  • Tax Year: 2021

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 18, 2021
Closed on
Oct 28, 2021
Sold by
Diamond Todd
Bought by
Cadorette Gerard R
Seller's Agent
Jennifer Mello
The Mello Group, Inc.
Buyer's Agent
Jennifer Mello
The Mello Group, Inc.
List Price
$959,000
Sold Price
$975,000
Premium/Discount to List
$16,000
1.67%
Total Days on Market
0
Current Estimated Value
$1,198,135

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$223,135
Avg. Annual Appreciation
6.05%
Original Mortgage
$780,000
Outstanding Balance
$720,484
Interest Rate
2.8%
Mortgage Type
Purchase Money Mortgage
Estimated Equity
$477,651

Purchase Details

Closed on
May 3, 2021
Sold by
Ngo Diana and Diamond Todd J
Bought by
Diamond Todd

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$600,000
Interest Rate
3.1%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan

Purchase Details

Listed on
May 30, 2017
Closed on
Nov 21, 2017
Sold by
Szydlowski Stephen C and Lantry Jacklynn M
Bought by
Diamond Todd J and Ngo Diana
Seller's Agent
Ellen Kasle
Residential Properties Ltd.
Buyer's Agent
Jennifer Mello
The Mello Group, Inc.
List Price
$749,000
Sold Price
$745,088
Premium/Discount to List
-$3,912
-0.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
6.58%
Original Mortgage
$596,070
Interest Rate
3.85%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 24, 2016
Sold by
Szydlowski Stephen C and Lantrhy Jacklynn M
Bought by
Sinclair Jeffrey C and Sinclair Catherine R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
3.42%
Mortgage Type
New Conventional

Purchase Details

Closed on
Nov 29, 2010
Sold by
Lantry Jacklynn M
Bought by
Szydlowski Stephen C and Lantry Jacklynn M

Purchase Details

Closed on
Jan 9, 2007
Sold by
Lantry Jacklynn M
Bought by
Szydlowski Stephen C and Lantry-Szydlowsk Jacklynn

Purchase Details

Closed on
Aug 23, 2004
Sold by
Szydlowski Stephen C
Bought by
Lantry Jacklynn M

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Cadorette Gerard R $975,000 None Available
Diamond Todd -- None Available
Diamond Todd -- None Available
Diamond Todd J $745,088 --
Sinclair Jeffrey C -- --
Szydlowski Stephen C -- --
Lantry Jacklynn M -- --
Szydlowski Stephen C -- --
Lantry Jacklynn M -- --
Sinclair Jeffrey C -- --
Lantry Jacklynn M -- --
Szydlowski Stephen C -- --
Lantry Jacklynn M -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Cadorette Gerard R $780,000
Closed Cadorette Gerard R $780,000
Previous Owner Diamond Todd $600,000
Previous Owner Diamond Todd J $596,070
Previous Owner Sinclair Jeffrey C $100,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/28/2021 10/28/21 Sold $975,000 +1.7% $208 / Sq Ft
09/19/2021 09/19/21 Pending -- -- --
09/18/2021 09/18/21 For Sale $959,000 +28.7% $205 / Sq Ft
11/21/2017 11/21/17 Sold $745,088 -0.5% $159 / Sq Ft
10/22/2017 10/22/17 Pending -- -- --
05/30/2017 05/30/17 For Sale $749,000 -- $159 / Sq Ft
Source: MLS Property Information Network (MLS PIN)

Tax History Compared to Growth

Source: Public Records

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 $142 $1,276,000 $180,800 $1,095,200
2024 $14,058 $1,237,500 $163,500 $1,074,000
2023 $9,369 $1,183,200 $160,300 $1,022,900
2022 $9,369 $739,500 $160,300 $579,200
2021 $9,685 $731,500 $145,200 $586,300
2020 $8,759 $667,600 $129,100 $538,500
2018 $8,094 $676,200 $138,600 $537,600
2017 $8,665 $689,900 $147,000 $542,900
2016 $8,290 $682,300 $139,400 $542,900
2015 $7,744 $629,100 $140,600 $488,500
2014 $7,369 $592,400 $134,100 $458,300
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MLS Property Information Network (MLS PIN)

MLS Number: 72897109

MLS Property Information Network (MLS PIN)

APN: REHO-000068-000000-000073