NOT LISTED FOR SALE

19583 Pine Cone Dr Macomb, MI 48042

Estimated Value: $447,000 - $500,000

3 Beds
2 Baths
3,086 Sq Ft
$152/Sq Ft Est. Value

Last Sold August 25, 2015

Last sale price $273,900 $89 Per Sq Ft

Est. 71% increase in value since last sale

Current estimated payment $2,931/month

65 Days on Market

Highlights

  • Recreation Room
  • Ranch Style House
  • Great Room with Fireplace
  • Sequoyah Elementary School Rated A-
  • Cathedral Ceiling
  • Den

About This Home

As of August 2015

Spectacular full brick ranch in northern Macomb Township. Large foyer opens to fabulous great room with vaulted ceilings and gas fireplace. Warm and inviting kitchen with large dining area, perfect for family gatherings, with door wall to wonderful views. Magnificent master bedroom with walk-in closets, complete with built-in shelving units and master bath. Two more spacious bedrooms, another full bath and first floor laundry complete the main floor. Absolutely dazzling, professionally finished basement has a full wet bar with island and refrigerator, separate game room, office, storage area and tool shop. The basement is flawless; could be an in-law suite, a family room or perfect for a college student. Private backyard features an enormous paver patio and large private and fenced yard. Architectural shingles new in 2014. Make this model-like home yours!

Last Agent to Sell the Property

Lawrence Campbell

Century 21 Campbell Realty License #MISPE-6502103862 Listed on: 05/06/2015

Century 21 Campbell Realty

Last Buyer's Agent

Susan Vogel

RE/MAX First License #MISPE-6501370780

RE/MAX First

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2001

Lot Details

  • 8,712 Sq Ft Lot
  • Lot Dimensions are 70x126
  • Fenced Yard

HOA Fees

  • $8 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • Wet Bar
  • Cathedral Ceiling
  • Great Room with Fireplace
  • Family Room
  • Den
  • Recreation Room
  • Finished Basement
  • Basement Window Egress

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Walk-In Closet
  • 2 Full Bathrooms

Outdoor Features

  • Patio

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 0816331005

Home Details

Home Type

Single Family

Est. Annual Taxes

$2,957

Year Built

Built in 2001

Lot Details

0

HOA Fees

$8 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL CONDO
  • Type Of Property: Residential
  • Architecture Style: Ranch
  • Structure Style: 1 Story
  • Total Tax Amount: 2957
  • Total Tax Year: 2014
  • Year Built: 2001
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Cathedral/Vaulted Ceiling, Walk-In Closet, Wet Bar/Bar
  • Fireplace: Yes
  • Fireplaces: Grt Rm Fireplace
  • Basement: Yes
  • Basement: Egress/Daylight Windows, Finished, Poured
  • Bedrooms: 3
  • Bedroom 1: On Entry Level, Dimensions: 16 x 14
  • Bedroom 2: On Entry Level, Dimensions: 13 x 12
  • Bedroom 3: On Entry Level, Dimensions: 14 x 11
  • Bathrooms Description: Basement Full Bath, First Flr Lavatory, First Flr Full Bathroom
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Room Types: Den/Study/Lib, Family Room, First Floor Laundry, First Floor Mstr Bedroom, Great Room, Recreation Room
  • Family Room: On Lower Floor, Dimensions: 20 x 16
  • Great Room: On Entry Level, Dimensions: 21 x 18
  • Kitchen: On Entry Level, Dimensions: 23 x 14
  • Kitchen Features: Eat-In Kitchen
  • Laundry: On Entry Level, Dimensions: 9 x 6
  • Library Den: On Lower Floor, Dimensions: 12 x 11
  • Other Room1: Dimensions: 10x12, On Level: Lower
  • Below Grade Sq Ft: 1786
  • Finished Below Grade Sq Ft: 1300
  • Half Bathrooms: 1
  • Above Grade Finished Sq Ft: 1786
  • Total Finished Sq Ft: 3086

Exterior Features

  • Exterior: Brick
  • Exterior Features: Fenced Yard, Patio
  • Foundation: Basement
  • Frontage: 70

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 2
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Public At Street
  • Water: Public Water at Street
  • Cooling: Central A/C

Condo/Co-op/Association

  • HOA Fees: 100
  • HOA Fee Frequency: Yearly
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 0816331005
  • Zoning: Residential
  • Lot Dimensions: 70X126
  • Acreage: 0.2
  • Geo Subdivision: MI

Tax Info

  • Summer Tax: Year: 2014, Amount: $2,250.00
  • Winter Tax: Year: 2014, Amount: $707.00
  • Total Tax: Year: 2014, Amount: $2,957.00

MLS Schools

  • School District: Chippewa Valley Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 6, 2015
Closed on
Aug 25, 2015
Sold by
Lemerise Alicia M and Settlemoir Ryan K
Bought by
Staten Duane C and Staten Lynn M
Seller's Agent
Lawrence Campbell
Century 21 Campbell Realty
Buyer's Agent
Susan Vogel
RE/MAX First
List Price
$279,900
Sold Price
$273,900
Premium/Discount to List
-$6,000
-2.14%
Current Estimated Value
$469,103

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$195,203
Avg. Annual Appreciation
5.47%

Purchase Details

Closed on
Oct 26, 2005
Sold by
Pellerito Natale and Pellerito Maddalena
Bought by
Settlemoir Ryan K and Settlemoir Alicia M

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$208,000
Interest Rate
5.75%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Jun 7, 2001
Sold by
Nova Homes Inc
Bought by
Pellerito Natale
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
Staten Duane C $273,900 Seaver Title Agency
Settlemoir Ryan K $260,000 --
Pellerito Natale $191,600 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Settlemoir Ryan K $208,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/25/2015 08/25/15 Sold $273,900 -2.1% $89 / Sq Ft
07/10/2015 07/10/15 Pending -- -- --
05/06/2015 05/06/15 For Sale $279,900 -- $91 / 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
2025 $5,235 $187,500 $0 $0
2024 $3,776 $183,500 $0 $0
2023 $3,582 $169,800 $0 $0
2022 $5,291 $151,700 $0 $0
2021 $5,095 $143,100 $0 $0
2020 $3,286 $139,200 $0 $0
2019 $4,682 $131,000 $0 $0
2018 $4,461 $127,000 $0 $0
2017 $4,426 $121,190 $32,500 $88,690
2016 $3,728 $121,190 $0 $0
2015 $2,958 $109,960 $0 $0
2014 $2,958 $95,580 $21,500 $74,080
2011 $624 $93,100 $18,500 $74,600
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Michigan Multiple Listing Service

MLS Number: 31241484

Michigan Multiple Listing Service

APN: 20-08-16-331-005