NOT LISTED FOR SALE

Estimated Value: $3,889,000 - $5,207,000

6 Beds
7 Baths
7,050 Sq Ft
$667/Sq Ft Est. Value

Last Sold August 23, 2023

Last sale price $4,300,000 $610 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $28,297/month

64 Days on Market

Highlights

  • Heated In Ground Pool
  • Sub-Zero Refrigerator
  • Colonial Architecture
  • Long Lots School Rated A+
  • Open Floorplan
  • Attic

About This Home

As of August 2023

Experience the height of luxury, built by SIR Signature Homes & Donald Fairbanks Architect. The design blends modern amenities w timeless architecture & Craftsman-inspired features that make one truly feel at home. Enjoy seamless indoor-outdoor living in a private backyard oasis complete with manicured lawn, oversized gunite saltwater pool w waterfall & spa, covered wood burning fireplace, outdoor kitchen with custom pergola & multiple patios, all embraced by lush landscaping. The expansive, open concept is equally suited to grand-scale entertaining & day-to-day relaxation, joining living & dining areas with the gourmet kitchen’s stunning Calacutta marble island & backsplash, & top-of-the-line SubZero, Wolf, & Marvel appliances. High-end finishes & craftsmanship are displayed throughout, from the gleaming wood floors, stunning chandeliers & pendant lighting, to the many built-ins plus impressive 10' millwork ceilings. The flexible layout includes a main-level dedicated office, two story paneled entry foyer with sweeping staircase, a second informal entrance w a large mudroom, plus two beautiful half baths. Upstairs, the primary suite is a 2 room private sanctuary w fireplace & sitting room, 2 generous walk-ins, & spa-quality bath w double sinks, water closet, soaking tub & steam shower. The walk-out lower level is complete with media room, pilates studio, gym, plus guest room w full bath, walk-in closet & storage. Many automated features +gas, city water, sewer.

Last Agent to Sell the Property

Sally Bohling

Coldwell Banker Realty License #RES.0791948 Listed on: 05/11/2023

Coldwell Banker Realty

Last Buyer's Agent

Amanda Thaw

The Riverside Realty Group License #RES.0797749

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $31,410

Year Built

  • Built in 2015

Lot Details

  • 1 Acre Lot
  • Stone Wall
  • Sprinkler System
  • Property is zoned AA

Home Design

  • Colonial Architecture
  • Concrete Foundation
  • Frame Construction
  • Wood Shingle Roof
  • Wood Siding
  • Shingle Siding

Interior Spaces

  • Open Floorplan
  • Entertainment System
  • Built In Speakers
  • 4 Fireplaces
  • Awning
  • French Doors
  • Mud Room
  • Sitting Room
  • Home Gym
  • Walkup Attic

Kitchen

  • Built-In Oven
  • Gas Range
  • Range Hood
  • Microwave
  • Sub-Zero Refrigerator
  • Dishwasher
  • Wine Cooler

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Laundry Room
  • Laundry on upper level
  • Dryer
  • Washer

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Interior Basement Entry
  • Basement Storage

Home Security

  • Home Security System
  • Smart Lights or Controls
  • Smart Thermostat

Parking

  • 3 Car Garage
  • Automatic Garage Door Opener
  • Private Driveway

Eco-Friendly Details

  • Energy-Efficient Lighting

Pool

  • Heated In Ground Pool
  • Spa
  • Gunite Pool
  • Saltwater Pool
  • Auto Pool Cleaner

Outdoor Features

  • Patio
  • Exterior Lighting
  • Outdoor Grill
  • Rain Gutters

Schools

  • Long Lots Elementary School
  • Bedford Middle School
  • Staples High School

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Humidifier
  • Humidity Control
  • Heating System Uses Natural Gas
  • Programmable Thermostat
  • Power Generator
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 415697

Home Details

Home Type

Single Family

Est. Annual Taxes

$31,410

Year Built

Built in 2015

Lot Details

0

Listing Details

  • Neighborhood: Long Lots
  • Property Type: Single Family For Sale
  • Style: Colonial
  • Sq Ft Est Heated Above Grade: 5141
  • Sq Ft Est Heated Below Grade: 1909
  • Total Sq Ft: 7050
  • Year Built: 2015
  • New Construction: No/Resale
  • Direct Waterfront: No
  • Home Warranty Offered: No
  • Public Record Gross Sq Ft: 11791
  • Directions: Roseville Rd to Salem Rd
  • Financing Used: Withheld
  • Living Area Sq Ft Per Public Record: 5141
  • Spec Assoc Asses: No
  • Street Type: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Room Count: 15
  • Total Bedrooms: 6
  • Total Bathrooms: 7
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Fireplaces: 4
  • Attic Description: Walk-up
  • Basement Description: Full With Walk-Out, Fully Finished, Heated, Cooled, Interior Access, Storage
  • Interior Amenities: Auto Garage Door Opener, Cable - Available, Humidifier, Open Floor Plan, Security System
  • Appliances: Gas Range, Wall Oven, Microwave, Range Hood, Refrigerator, Freezer, Subzero, Dishwasher, Washer, Dryer, Wine Chiller
  • Additional Rooms: Exercise Room, Gym, Laundry Room, Mud Room, Sitting Room
  • Laundry Room Info: Upper Level
  • Attic: Yes
  • Home Automation: Built In Audio, Entertainment System, Lighting, Security System, Thermostat(s)
  • Street Number Modifier: 4
  • Other SqFt Description: The house was measured with floor plan company. Floor one, the basement measured at 1909

Exterior Features

  • Exterior Features: Awnings, French Doors, Grill, Gutters, Hot Tub, Lighting, Patio, Stone Wall, Underground Sprinkler
  • Exterior Siding: Shingle, Wood
  • Foundation Type: Concrete
  • Roof Information: Wood Shingle
  • Waterfront Description: Water Community Beach Rights
  • Swimming Pool: Yes
  • Pool: In Ground Pool, Spa, Heated, Salt Water, Auto Cleaner, Gunite
  • Construction Description: Frame

Garage/Parking

  • Garages Number: 3
  • Driveway Type: Private, Asphalt
  • Garage And Parking: Attached Garage

Utilities

  • Cooling System: Central Air, Zoned
  • Heat Type: Hot Air, Zoned
  • Heat Fuel Type: Natural Gas
  • Fuel Tank Location: Non Applicable
  • Hot Water Description: Natural Gas
  • Water Source: Public Water Connected
  • Sewer: Public Sewer Connected

Schools

  • Elementary School: Long Lots
  • Middle School: Bedford
  • High School: Staples

Green Features

  • Energy Features: Generator, Humidistat, Programmable Thermostat

Lot Info

  • Acres: 1
  • Lot Description: Dry Level Lot Fence - Full Professionally Landscaped
  • Flood Zone: No
  • Zoning: AA
  • Parcel #: 415697

Tax Info

  • Tax Year: July 2023-June 2024
  • Property Tax: 31410
  • Total Assessed Value: 1711700
  • Mil Rate Total: 18.35

MLS Schools

  • Elementary School: Long Lots
  • Middle Jr High School: Bedford
  • High School: Staples

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 11, 2023
Closed on
Aug 22, 2023
Sold by
Douglas Drew and Douglas Joanna
Bought by
Heyer Joseph and Heyer Elizabeth
Seller's Agent
Sally Bohling
Coldwell Banker Realty
Buyer's Agent
Amanda Thaw
The Riverside Realty Group
List Price
$4,800,000
Sold Price
$4,300,000
Premium/Discount to List
-$500,000
-10.42%
Views
152
Current Estimated Value
$4,699,982

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$399,982
Avg. Annual Appreciation
4.57%
Original Mortgage
$3,000,000
Outstanding Balance
$2,924,032
Interest Rate
5.75%
Mortgage Type
Adjustable Rate Mortgage/ARM
Estimated Equity
$1,782,305

Purchase Details

Listed on
Jun 2, 2014
Closed on
Nov 18, 2014
Sold by
Sir 4 Salem Llc
Bought by
Douglas Drew and Douglas Joanna
Seller's Agent
Julie Haroun
Westport Residential, LLC.
Buyer's Agent
Jillian Klaff
Coldwell Banker Realty
List Price
$3,099,000
Sold Price
$3,125,000
Premium/Discount to List
$26,000
0.84%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.70%
Original Mortgage
$2,283,750
Interest Rate
3%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Nov 9, 2013
Closed on
Dec 6, 2013
Sold by
Grundei Michael and Grundei Jacqueline A
Bought by
Sir Salem Llc
Seller's Agent
Julie Haroun
Westport Residential, LLC.
Buyer's Agent
Julie Haroun
Westport Residential, LLC.
List Price
$1,149,000
Sold Price
$975,000
Premium/Discount to List
-$174,000
-15.14%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
245.25%

Purchase Details

Closed on
Jun 29, 1995
Sold by
Mullen Michael and Mullen Jill
Bought by
Grundei Michael and Grundei Jacqueline

Purchase Details

Closed on
Jun 1, 1992
Sold by
Knoebel Wanda J
Bought by
Sadrian F and Sadrian Durie
Source: Public Records

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
Heyer Joseph $4,300,000 None Available
Heyer Joseph $4,300,000 None Available
Heyer Joseph $4,300,000 None Available
Douglas Drew $3,125,000 --
Sir Salem Llc -- --
Grundei Michael $512,000 --
Douglas Drew $3,125,000 --
Sir Salem Llc -- --
Grundei Michael $512,000 --
Sadrian F $390,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Heyer Joseph $3,000,000
Closed Heyer Joseph $3,000,000
Previous Owner Douglas Joanna $1,752,270
Previous Owner Douglas Drew $2,283,750
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/23/2023 08/23/23 Sold $4,300,000 -6.4% $610 / Sq Ft
07/19/2023 07/19/23 Pending -- -- --
06/02/2023 06/02/23 Price Changed $4,595,000 -4.3% $652 / Sq Ft
05/15/2023 05/15/23 For Sale $4,800,000 +53.6% $681 / Sq Ft
11/14/2014 11/14/14 Sold $3,125,000 +0.8% $422 / Sq Ft
10/15/2014 10/15/14 Pending -- -- --
06/02/2014 06/02/14 For Sale $3,099,000 +217.8% $418 / Sq Ft
12/05/2013 12/05/13 Sold $975,000 -15.1% $286 / Sq Ft
11/09/2013 11/09/13 For Sale $1,149,000 -- $337 / Sq Ft
Source: SmartMLS

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 $32,856 $1,742,100 $428,400 $1,313,700
2024 $32,438 $1,742,100 $428,400 $1,313,700
2023 $31,410 $1,711,700 $428,400 $1,283,300
2022 $30,930 $1,711,700 $428,400 $1,283,300
2021 $30,930 $1,711,700 $428,400 $1,283,300
2020 $31,455 $1,882,400 $452,200 $1,430,200
2019 $31,737 $1,882,400 $452,200 $1,430,200
2018 $31,737 $1,882,400 $452,200 $1,430,200
2017 $31,737 $1,882,400 $452,200 $1,430,200
2016 $31,511 $1,869,000 $452,200 $1,416,800
2015 $30,444 $1,682,900 $373,700 $1,309,200
2014 $11,767 $655,900 $373,700 $282,200
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: SmartMLS

MLS Number: 170569084

SmartMLS

APN: WPOR-000010E-000000-000044