NOT LISTED FOR SALE

3718 Newcastle Dr Rochester Hills, MI 48306

Estimated Value: $797,000 - $851,000

4 Beds
2 Baths
6,313 Sq Ft
$129/Sq Ft Est. Value

Last Sold August 23, 2017

Last sale price $570,000 $90 Per Sq Ft

Est. 43% increase in value since last sale

Current estimated payment $5,135/month

10 Days on Market

Highlights

  • Outdoor Pool
  • Colonial Architecture
  • Wood Flooring
  • Musson Elementary School Rated A
  • Cathedral Ceiling
  • Whirlpool Bathtub

About This Home

As of August 2017

Move right into this wonderful family home that's nestled on a very private professionally landscaped lot located in one of Rochester Hills most desirable neighborhoods "Hawthorn Hills!" With over 100K in updates this beautiful open floor plan offers a generous amount of natural light, very large rooms (one of the largest homes in the sub), gorgeous refinished 'Ebony' hardwood floors, exquisite entry to foyer, great room, formal DR/LR, updated bathrooms and kitchen (granite), freshly painted interior/exterior, new carpeting, Judges panel office, restoration hardware, and vanities. A few finishing touches needed to complete this unique basement floor plan which includes a home movie theater, bar, wine cellar, arcade, game room, and more. Over 5,000 square feet total! All appliances included plus the newer 80" Sony flat screen TV! Many updates throughout - please see the itemized list with disclosures. Immediate occupancy! Walking distance to Musson, VHMS, and Adams High School.

Last Agent to Sell the Property

Tina Pichette

RE/MAX First License #MISPE-6501268080 Listed on: 07/13/2017

RE/MAX First

Last Buyer's Agent

Emer Kenny

Real Living Kee Realty-Rochester License #RCO

Real Living Kee Realty-Rochester

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,163

Year Built

  • Built in 1990

Lot Details

  • 0.3 Acre Lot
  • Lot Dimensions are 100x138
  • Sprinkler System

HOA Fees

  • $13 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 2-Story Property
  • Wet Bar
  • Cathedral Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Window Treatments
  • Great Room with Fireplace
  • Home Security System
  • Finished Basement

Kitchen

  • Oven or Range
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms
  • Whirlpool Bathtub

Laundry

  • Dryer
  • Washer

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Outdoor Pool
  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Internet Available

Community Details

  • Hawthorne Hills Homeowners Associations HOA
  • Hawthorn Hills No 7 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 1506152017

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,163

Year Built

Built in 1990

Lot Details

0

HOA Fees

$13 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Total Tax Amount: 9163
  • Year Built: 1990
  • Mail City: Rochester Hills
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable/Internet Avail., Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Security System, Walk-In Closet, Wet Bar/Bar, Window Treatment(s)
  • Appliances: Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: Gas Fireplace, Grt Rm Fireplace
  • Basement: Yes
  • Basement: Finished
  • Bedrooms: 4
  • Bedroom 1: On Upper Floor, Dimensions: 20 x 15
  • Bedroom 1 Floor Covering: Wood
  • Bedroom 2: On Upper Floor, Dimensions: 16 x 14
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On Upper Floor, Dimensions: 15 x 12
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On Upper Floor, Dimensions: 13 x 14
  • Bedroom 4 Floor Covering: Carpet
  • Bathrooms Description: Whirlpool/Hot Tub
  • Full Bathrooms: 2
  • Total Bathrooms: 4
  • Bathroom 1: Dimensions: 9 x 9, On Level: Upper, Flooring: Ceramic
  • Bathroom 2: Dimensions: 8 x 7, On Level: Upper, Flooring: Ceramic
  • Breakfast Nook: On 1st Floor, Dimensions: 18 x 13
  • Breakfast Nook Floor Covering: Wood
  • Dining Room: On 1st Floor, Dimensions: 15 x 12
  • Dining Room Floor Covering: Wood
  • Great Room: On 1st Floor, Dimensions: 25 x 17
  • Great Room Floor Covering: Wood
  • Kitchen: On 1st Floor, Dimensions: 22 x 14
  • Kitchen Floor Covering: Wood
  • Laundry: On 1st Floor, Dimensions: 7 x 6
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On 1st Floor, Dimensions: 14 x 13
  • Library Den Floor Covering: Carpet
  • Living Room: On 1st Floor, Dimensions: 19 x 13
  • Living Room Floor Covering: Carpet
  • Below Grade Sq Ft: 2200
  • Finished Below Grade Sq Ft: 2200
  • Half Bathrooms: 2
  • Above Grade Finished Sq Ft: 4113
  • Total Finished Sq Ft: 6313

Exterior Features

  • Pool: Yes
  • Exterior: Brick
  • Exterior Features: Lawn Sprinkler, Patio
  • Foundation: Basement
  • Frontage: 100
  • Road: Paved Street, City/County

Garage/Parking

  • Garage: Gar Door Opener, Attached Garage
  • Garage Spaces: 3
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public Sanitary
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Condo/Co-op/Association

  • HOA Fees: 150
  • HOA Fee Frequency: Yearly
  • Association Contact: Hawthorne Hills Homeowners Associations
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 1506152017
  • Zoning: Residential
  • Lot Dimensions: 100X138
  • Acreage: 0.3
  • Geo Subdivision: MI

Tax Info

  • Total Tax: Amount: $9,163.00

MLS Schools

  • School District: Rochester Community School District

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Sep 23, 2019
Sold by
Maccallum Michael
Bought by
Maccallum Michael and Maccallum Katherine
Current Estimated Value
$816,809

Purchase Details

Listed on
Jul 13, 2017
Closed on
Aug 23, 2017
Sold by
Homburger Jay A and Homburger Lisa A
Bought by
Maccallum Michael
Seller's Agent
Tina Pichette
RE/MAX First
Buyer's Agent
Emer Kenny
Real Living Kee Realty-Rochester
List Price
$575,000
Sold Price
$570,000
Premium/Discount to List
-$5,000
-0.87%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.46%
Original Mortgage
$424,100
Outstanding Balance
$354,545
Interest Rate
4.03%
Mortgage Type
New Conventional
Estimated Equity
$462,264

Purchase Details

Listed on
Jan 3, 2014
Closed on
Apr 29, 2014
Sold by
Hannahan Leonard C and Hannahan Karen E
Bought by
Homburger Jay A and Homburger Lisa A
Seller's Agent
Ryan Gehris
USRealty.com, LLP
Buyer's Agent
Lila Casenave Pappal
Coldwell Banker Weir Manuel-Bir
List Price
$514,000
Sold Price
$499,000
Premium/Discount to List
-$15,000
-2.92%

Home Financials for this Owner

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

Purchase Details

Closed on
May 10, 2013
Sold by
Hannahan Leonard C and Hannahan Karen E
Bought by
Hannahan Leonard C and Hannahan Karen E

Purchase Details

Closed on
Oct 30, 2001
Sold by
Bosley Larry E
Bought by
Hannahan Leonard C

Purchase Details

Closed on
Apr 14, 2000
Sold by
Waggoner Patrice A
Bought by
Bosley Larry E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$449,650
Interest Rate
8.24%

Purchase Details

Closed on
Jan 19, 1996
Sold by
Patrice Ann Waggoner Tr
Bought by
Waggoner Patrice Ann

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$200,000
Interest Rate
7.24%
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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
Maccallum Michael -- None Available
Maccallum Michael $570,000 Greater Matomb Tftie Agency
Homburger Jay A $499,000 Homeowners Title Agency
Hannahan Leonard C -- None Available
Hannahan Leonard C $465,000 --
Bosley Larry E $529,900 --
Waggoner Patrice Ann -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Maccallum Michael $424,100
Previous Owner Bosley Larry E $449,650
Previous Owner Waggoner Patrice Ann $200,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/23/2017 08/23/17 Sold $570,000 -0.9% $90 / Sq Ft
07/23/2017 07/23/17 Pending -- -- --
07/13/2017 07/13/17 For Sale $575,000 +15.2% $91 / Sq Ft
04/29/2014 04/29/14 Sold $499,000 -2.9% $120 / Sq Ft View Prior Sale
02/27/2014 02/27/14 Pending -- -- --
01/03/2014 01/03/14 For Sale $514,000 -- $124 / Sq Ft
Source: Michigan Multiple Listing Service

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
2022 $4,677 $275,150 $0 $0
2018 $7,749 $241,430 $0 $0
2017 $7,747 $241,340 $0 $0
2015 -- $229,920 $0 $0
2014 -- $187,260 $0 $0
2011 -- $171,000 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Michigan Multiple Listing Service

MLS Number: 31325244

Michigan Multiple Listing Service

APN: 15-06-152-017