NOT LISTED FOR SALE

5874 Coastal Cliffs Ct Petoskey, MI 49770

Estimated Value: $1,017,000 - $3,840,176

4 Beds
6 Baths
4,354 Sq Ft
$575/Sq Ft Est. Value

Last Sold October 21, 2022

Last sale price $3,755,000 $862 Per Sq Ft

Est. 33% decrease in value since last sale

Current estimated payment $17,607/month

Highlights

  • Water Views
  • Deck
  • Wood Flooring
  • Spa
  • Cathedral Ceiling
  • Main Floor Primary Bedroom

About This Home

As of October 2022

Enjoy the luxury of Bay Harbor in this spectacular custom home! Overlooking the 9th hole on the Quarry golf course with breathtaking views of Lake Michigan, you will not be disappointed in all this modern home has to offer. Travel down the exposed aggregate driveway and you’ll notice the little brass lights shining up onto the impeccable landscaping. Glance to your right and you’ll see and hear the small brook that rolls through the property. As you approach this magnificent house you are greeted by the unmatched beauty of Lake Michigan which can be seen through the glass front doors. Entering through the foyer you are greeted by an open floor plan, gleaming hardwood floors, and a gas fireplace in the living room. The kitchen boasts top of the line Sub Zero appliances and a custom white Viking range, and the home is complete with Lutron automation for lighting and shades. The perfectly manicured backyard hosts plenty of space for entertaining and relaxing with an expanded patio, hot tub, outside sitting area, and second gas fireplace. Enjoy panoramic views from your backyard patio with automatic sunsetter awning. The home is protected by a whole house generator. Enjoy the most incredible sunsets northern Michigan has to offer. Truly a must see! Photos just don't do this amazing home and view justice! Furniture is negotiable.

Last Agent to Sell the Property

Patrick Leavy

Kidd & Leavy Real Estate Co. LLC Listed on: 10/05/2022

Last Buyer's Agent

Wally Kidd

Kidd & Leavy Real Estate Co. LLC

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $36,470

Year Built

  • Built in 2018

Lot Details

  • Creek or Stream

HOA Fees

  • $1,294 Monthly HOA Fees

Home Design

  • Wood Frame Construction
  • Asphalt Shingled Roof

Interior Spaces

  • 4,354 Sq Ft Home
  • Cathedral Ceiling
  • Gas Fireplace
  • Family Room
  • Living Room
  • Dining Room
  • First Floor Utility Room
  • Wood Flooring
  • Water Views
  • Home Security System

Kitchen

  • Range
  • Built-In Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Attached Garage
  • Driveway

Outdoor Features

  • Spa
  • Deck

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Cable TV Available

Community Details

  • Bay Harbor Bh Association

Listing and Financial Details

  • Assessor Parcel Number 52-18-08-210-101

Home Details

Home Type

Single Family

Est. Annual Taxes

$36,470

Year Built

Built in 2018

Lot Details

0

HOA Fees

$1,294 per month

Listing Details

  • Class: RESIDENTIAL
  • Type: Residential
  • Estimated Year Built: 2018
  • Lvt Date: 10/05/2022
  • Measurement Source: Owner
  • Section: 8
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2018

Interior Features

  • Features: Built In Microwave, Cable, Cathedral Ceilings, Central Air, Deck, Dishwasher, Dryer, Garbage Disposal, Gas Fireplace, Hot Tub, Paved Drive, Range, Refrigerator, Washer, Wood Floors, Security System, Stream/Creek, Paved Road
  • Total Finished Sq Ft: 4354
  • Master Bedroom: Dimensions: 15'10"x14', On Level: Main
  • Bedroom 2: Dimensions: 16'11"x22'4", On Level: Upper
  • Bedroom 3: Dimensions: 12'x18'7", On Level: Upper
  • Bedroom 4: Dimensions: 12'x19'7", On Level: Upper
  • Total Rooms: 18
  • Dining Room: Dimensions: 17'2"x11'10", On Level: Main
  • Kitchen: Dimensions: 19'5"x15'10", On Level: Main
  • Family Room: Dimensions: 15'11"x12'8", On Level: Main
  • Living Room: Dimensions: 20'6"x20'9", On Level: Main
  • Above Grade Finished Sq Ft: 4354
  • Bathroom 1: On Level: Main
  • Bathroom 2: On Level: Upper
  • Number Of Bedrooms: 4
  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Rooms 1: Dimensions: Rec Room 12'x10', On Level: Upper
  • Rooms 2: Dimensions: Bedroom 21'2"x18'4", On Level: Upper

Exterior Features

  • Construction: Wood Frame/Site Built
  • Lake: Michigan
  • Roof: Asphalt Shingle
  • Waterfront Water Access: Neither
  • Water View: Y

Garage/Parking

  • Garage Carport: Garage-Attached
  • Gar Car Capacity: Two and Half

Utilities

  • Heat Type: Natural Gas, Forced Air
  • Sewer: City
  • Water: City

Condo/Co-op/Association

  • Association: Bay Harbor BH
  • Association: Yes
  • Fees: 3,883

Schools

  • School District: Petoskey

Lot Info

  • Zoning: Residential

Tax Info

  • Assessor Parcel Number: 52-18-08-210-101

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 5, 2022
Closed on
Oct 21, 2022
Sold by
Ctc-Tsc Michigan Holdings Llc
Bought by
Teglia Dean J and Teglia Karin G
Seller's Agent
Patrick Leavy
Kidd & Leavy Real Estate Co. LLC
Buyer's Agent
Wally Kidd
Kidd & Leavy Real Estate Co. LLC
List Price
$3,795,000
Sold Price
$3,755,000
Premium/Discount to List
-$40,000
-1.05%
Current Estimated Value
$2,503,725

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,251,275
Avg. Annual Appreciation
-12.25%
Original Mortgage
$2,816,250
Outstanding Balance
$2,706,509
Interest Rate
5.3%
Mortgage Type
New Conventional
Estimated Equity
-$149,519

Purchase Details

Listed on
Feb 11, 2021
Closed on
May 18, 2021
Sold by
Tl 5874 Llc
Bought by
Ctc-Tsc Michigan Holdings Llc
Seller's Agent
Stephanie Jones
Kidd & Leavy Real Estate Co. LLC
Buyer's Agent
Patrick Leavy
Kidd & Leavy Real Estate Co. LLC
List Price
$3,200,000
Sold Price
$2,600,000
Premium/Discount to List
-$600,000
-18.75%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
29.54%
Original Mortgage
$2,000,000
Interest Rate
2.9%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 12, 2017
Sold by
Peninsula Drive Properties Llc
Bought by
Tl 5874 Llc

Purchase Details

Closed on
Oct 27, 2011
Sold by
Babcock Dan J and Babcock Kathy J
Bought by
Peninsula Drive Properties Llc

Purchase Details

Closed on
Sep 23, 1998
Bought by
Babcock Dan J and Babcock Kathy J

Purchase Details

Closed on
Oct 1, 1995
Sold by
Golf Sites
Bought by
Eller New95
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
Teglia Dean J -- --
Ctc-Tsc Michigan Holdings Llc -- --
Tl 5874 Llc -- Crossroads Title
Peninsula Drive Properties Llc -- --
Babcock Dan J -- --
Eller New95 -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Ctc-Tsc Michigan Holdings Llc $2,000,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/21/2022 10/21/22 Sold $3,755,000 -1.1% $862 / Sq Ft
10/05/2022 10/05/22 For Sale $3,795,000 +46.0% $872 / Sq Ft
05/20/2021 05/20/21 Sold $2,600,000 -10.3% $578 / Sq Ft
03/17/2021 03/17/21 Price Changed $2,900,000 -9.4% $644 / Sq Ft
02/11/2021 02/11/21 For Sale $3,200,000 -- $711 / Sq Ft
Source: Northern Michigan MLS

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 $36,470 $941,900 $941,900 $0
2024 $36,470 $863,500 $863,500 $0
2023 $32,070 $659,400 $659,400 $0
2022 $32,070 $606,500 $606,500 $0
2021 $12,762 $240,500 $240,500 $0
2020 $12,974 $240,500 $240,500 $0
2019 -- $240,500 $240,500 $0
2018 -- $240,500 $240,500 $0
2017 -- $240,500 $240,500 $0
2016 -- $240,500 $240,500 $0
2015 -- $240,500 $0 $0
2014 -- $240,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Patrick Leavy

    Seller's Agent in 2022

    Patrick Leavy

    Kidd & Leavy Real Estate Co. LLC

    (231) 881-6639

    183 in this area

    383 Total Sales

    Patrick Leavy
    Section Image
  • Wally Kidd

    Buyer's Agent in 2022

    Wally Kidd

    Kidd & Leavy Real Estate Co. LLC

    (231) 838-2700

    49 in this area

    173 Total Sales

    Wally Kidd
    Section Image
  • Stephanie Jones

    Seller's Agent in 2021

    Stephanie Jones

    Kidd & Leavy Real Estate Co. LLC

    (231) 844-4410

    84 in this area

    149 Total Sales

    Stephanie Jones
    Section Image
See All Agents

Map

Source: Northern Michigan MLS

MLS Number: 469703

Northern Michigan MLS

APN: 52-18-08-210-101

Michigan Emmet County Petoskey 49770

5874 Coastal Cliffs Ct, Petoskey, MI

This home is located at 5874 Coastal Cliffs Ct, Petoskey, MI 49770 since 05 October 2022 and is currently estimated at $2,503,725, approximately $575 per square foot. This property was built in 2018. 5874 Coastal Cliffs Ct is a home located in Emmet County with nearby schools including Petoskey High School.

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.

Northern Michigan MLS 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.

Nearby Homes