NOT LISTED FOR SALE

9633 Trails End Rd Petoskey, MI 49770

Estimated Value: $1,283,000 - $2,015,173

7 Beds
5.5 Baths
6,000 Sq Ft
$260/Sq Ft Est. Value

Last Sold March 16, 2021

Last sale price $1,350,000 $225 Per Sq Ft

Est. 15% increase in value since last sale

Current estimated payment $10,708/month

Highlights

  • 219 Feet of Waterfront
  • Spa
  • Cathedral Ceiling
  • Docks
  • Deck
  • Wood Flooring

About This Home

As of March 2021

At a time when high quality lake home options are seemingly impossible to come by, this extraordinary offering has come available for purchase. This stunning shabby chic estate includes 7 bedrooms, 5 full & 1 half bathrooms and tasteful finishes throughout every inch of the roughly 6000 feet of finished living space. Two master suites, 3 fireplaces, a custom kitchen and butler pantry, and expansive waterside decking are just a few of the seemingly limitless features this property affords. If that weren't enough, this offering also includes 219' of hard packed sandy Pickerel Lake frontage. Located just a short drive from downtown Petoskey, this listing is an extremely hard to find combination of impressive finishes, size, privacy, and lakefront quality all at a highly attractive price point. Additional land across the street included which may present opportunity for storage, gardening or other creative uses! Do not delay in checking out this one-of-a-kind property.

Last Agent to Sell the Property

Kyle Lieberman

Kidd & Leavy Real Estate Co. LLC Listed on: 08/31/2020

Last Buyer's Agent

Kyle Lieberman

Kidd & Leavy Real Estate Co. LLC Listed on: 08/31/2020

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $29,309

Lot Details

  • 219 Feet of Waterfront
  • Property is zoned RR

Home Design

  • Wood Frame Construction
  • Asphalt Shingled Roof

Interior Spaces

  • 6,000 Sq Ft Home
  • Cathedral Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Fireplace
  • Family Room
  • Living Room
  • Dining Room
  • First Floor Utility Room
  • Wood Flooring
  • Water Views

Kitchen

  • Range
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Primary Bedroom on Main

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Attached Garage
  • Driveway

Outdoor Features

  • Spa
  • Docks
  • Deck

Utilities

  • Forced Air Heating System
  • Heating System Uses Propane
  • Well
  • Septic System

Community Details

  • Snowmobile Trail

Listing and Financial Details

  • Assessor Parcel Number 3 Tax IDs - Agent Remarks

Home Details

Home Type

Single Family

Est. Annual Taxes

$29,309

Lot Details

0

Listing Details

  • Class: RESIDENTIAL
  • Type: Residential
  • Lvt Date: 09/01/2020
  • Measurement Source: Owner
  • Section: 27
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Features: Cathedral Ceilings, Ceiling Fans, Deck, Dishwasher, Dock, Dryer, Garbage Disposal, Gas Fireplace, Hot Tub, Paved Drive, Range, Refrigerator, Washer, Wood Fireplace, Wood Floors, Near Snowmobile Trails
  • Total Finished Sq Ft: 6000
  • Master Bedroom: On Level: Main
  • Bedroom 2: On Level: Main
  • Bedroom 3: On Level: Upper
  • Bedroom 4: On Level: Upper
  • Total Rooms: 14
  • Dining Room: On Level: Main
  • Kitchen: On Level: Main
  • Family Room: On Level: Main
  • Living Room: On Level: Main
  • Above Grade Finished Sq Ft: 6000
  • Bathroom 1: On Level: Main
  • Bathroom 2: On Level: Main
  • Number Of Bedrooms: 7
  • Full Bathrooms: 5
  • Half Bathrooms: 1
  • Rooms 1: On Level: Upper
  • Rooms 2: On Level: Upper

Exterior Features

  • Construction: Wood Frame/Site Built
  • Lake: Pickerel/Em
  • Roof: Asphalt Shingle
  • Waterfront Frontage: 219
  • Waterfront Water Access: Water Front
  • Water View: Y
  • Wf Wa Ownership Type: Deeded and Private Ownership

Garage/Parking

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

Utilities

  • Heat Type: Forced Air, LP Gas
  • Sewer: Septic
  • Water: Well

Schools

  • School District: Petoskey

Lot Info

  • Zoning: RR

Tax Info

  • Assessor Parcel Number: 3 Tax IDs - Agent Remarks

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 31, 2020
Closed on
Mar 15, 2021
Sold by
Hammons Mark C
Bought by
Hart John and Hart Kelly
Seller's Agent
Kyle Lieberman
Kidd & Leavy Real Estate Co. LLC
Buyer's Agent
Kyle Lieberman
Kidd & Leavy Real Estate Co. LLC
List Price
$1,499,000
Sold Price
$1,350,000
Premium/Discount to List
-$149,000
-9.94%
Current Estimated Value
$1,559,058

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$209,058
Avg. Annual Appreciation
3.21%

Purchase Details

Closed on
Nov 9, 2001
Bought by
Langlois Cynthia L and Balogh Eugene

Purchase Details

Closed on
Mar 5, 2001
Bought by
Old Kent Bank

Purchase Details

Closed on
Nov 4, 1997
Sold by
Hoggard Joan A
Bought by
Hoggard Keith A
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
Hart John -- --
Langlois Cynthia L $275,000 --
Old Kent Bank -- --
Hoggard Keith A -- --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/16/2021 03/16/21 Sold $1,350,000 -9.9% $225 / Sq Ft
03/16/2021 03/16/21 For Sale $1,499,000 +11.0% $250 / Sq Ft
03/16/2021 03/16/21 Off Market $1,350,000 -- --
08/31/2020 08/31/20 For Sale $1,499,000 +284.4% $250 / Sq Ft
06/19/2012 06/19/12 Sold $390,000 -22.0% $72 / Sq Ft
06/01/2012 06/01/12 Pending -- -- --
03/19/2012 03/19/12 For Sale $499,900 -- $92 / 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 $29,309 $872,700 $872,700 $0
2024 $29,309 $816,800 $816,800 $0
2023 $26,855 $636,700 $636,700 $0
2022 $26,855 $588,900 $588,900 $0
2021 $16,629 $686,500 $686,500 $0
2020 $16,162 $662,500 $662,500 $0
2019 -- $628,300 $628,300 $0
2018 -- $438,800 $438,800 $0
2017 -- $411,300 $411,300 $0
2016 -- $400,600 $400,600 $0
2015 -- $370,400 $0 $0
2014 -- $320,100 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Northern Michigan MLS

MLS Number: 463109

Northern Michigan MLS

APN: 14-17-27-477-002