NOT LISTED FOR SALE

9387 Trails End Rd Petoskey, MI 49770

Estimated Value: $827,000 - $1,100,000

3 Beds
2 Baths
2,709 Sq Ft
$354/Sq Ft Est. Value

Last Sold June 03, 2019

Last sale price $489,900 $181 Per Sq Ft

Est. 96% increase in value since last sale

Current estimated payment $5,677/month

Highlights

  • 50 Feet of Waterfront
  • Guest House
  • Wood Burning Stove
  • Docks
  • Deck
  • Radiant Floor

About This Home

As of June 2019

Pickerel Lake Waterfront Home & Guest House: After many years of careful restoration and several additions this traditional lakefront cabin has been transformed into 2,700 sq. ft residence with charm and character throughout. Your family and guests will enter your home through the foyer and directly into the Great Room highlighted by pine cathedral ceilings with log trim, two very comfortable seating areas, one with an efficient wood-burning stove, plus ample space for a large dining table and chairs. The kitchen, totally updated in 2006, features granite counter tops, Kraftmade cabinets and flooring, stainless steel appliances, two sinks for lots of prep and cleanup space, and a large island that seats six for entertaining. The comfortable and cozy living room overlooks the lake and features a large natural field-stone fireplace that's been converted to gas. The main level also has a full bath and one bedroom. The second floor consists of a master bedroom with cathedral ceilings and water view, full bath, and laundry room. The 3rd floor bedroom overlooks the water and steps out to the "Eagles Nest" deck with a commanding view of the lake. The shoreline is protected by a new seawall and the lakeside deck actually overhangs the lake. And, the sale includes the dock with a large swimming platform leading you to the firm, sandy, lake bottom. The charming 588 sq ft Guest House consists of a living room, kitchen, bath, and bedroom. The oversize garage sits on the back lot and there is plenty of space behind the garage for boat storage. Natural gas will be available later this year and the current appliances are newer and easily convertible. Sale includes Home Warranty.

Last Agent to Sell the Property

Bill Takalo

Coldwell Banker Schmidt - Petoskey Listed on: 04/08/2019

Coldwell Banker Schmidt - Petoskey

Last Buyer's Agent

William Winslow

Coldwell Banker Schmidt- Harbor Springs

Coldwell Banker Schmidt- Harbor Springs

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,047

Lot Details

  • 0.4

Parking

  • 2 Car Detached Garage

Home Design

  • Wood Frame Construction
  • Asphalt Shingled Roof
  • Log Siding

Interior Spaces

  • 2,709 Sq Ft Home
  • Cathedral Ceiling
  • Wood Burning Stove
  • Gas Fireplace
  • Thermal Windows
  • Family Room
  • Living Room
  • Dining Room
  • Second Floor Utility Room
  • Radiant Floor
  • Water Views
  • Crawl Space

Kitchen

  • Range
  • Built-In Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Primary Bedroom Upstairs
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • Docks
  • Deck
  • Shed

Utilities

  • Cooling System Mounted In Outer Wall Opening
  • Heating System Uses Propane
  • Heating System Uses Wood
  • Hot Water Baseboard Heater
  • Well
  • Propane Water Heater
  • Community Sewer or Septic
  • Cable TV Available

Additional Features

  • 50 Feet of Waterfront
  • Guest House

Listing and Financial Details

  • Assessor Parcel Number 14-17-27-476-022

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,047

Lot Details

0

Listing Details

  • Class: RESIDENTIAL
  • Type: Residential
  • Lvt Date: 04/09/2019
  • Section: 27
  • Second Address Number: 9387
  • Directions: North on Ellsworth Rd from Pickerel Lake Rd to Trails End Rd, then left to to 9387 Trails end Rd.
  • Price per Sq Ft: 180.84
  • OFFICELIST_STATE: MI
  • Street Designation: Road
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Features: AC Wall Unit, Built In Microwave, Cable, Cathedral Ceilings, Deck, Dishwasher, Dock, Dryer, Garbage Disposal, Gas Fireplace, Range, Refrigerator, Washer, Wood Stove
  • Total Finished Sq Ft: 2709
  • Master Bedroom: Dimensions: 17' x 11', On Level: Upper
  • Bedroom 2: Dimensions: 11' x 11', On Level: Main
  • Bedroom 3: Dimensions: 3'rd Floor BDR, 329 Sq Ft, On Level: Upper
  • Bedroom 4: On Level: N/A
  • Total Rooms: 9
  • Basement: Crawl
  • Dining Room: Dimensions: Pt of Family Rm, On Level: Main
  • Kitchen: Dimensions: 17' x 16', On Level: Main
  • Family Room: Dimensions: 22' x 12' + 20' x 18', On Level: Main
  • Living Room: Dimensions: L shaped 24'x8' + 6'x10', On Level: Main
  • Above Grade Finished Sq Ft: 2709
  • Bathroom 1: Dimensions: 7' 6" x 6" 8", On Level: Main
  • Bathroom 2: Dimensions: !0' x 6', On Level: Upper
  • Number Of Bedrooms: 3
  • Full Bathrooms: 2
  • Rooms 1: Dimensions: 11' x 9', On Level: Upper
  • Rooms 2: On Level: N/A
  • Windows: Thermo

Exterior Features

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

Garage/Parking

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

Utilities

  • Heat Type: LP Gas, Electric, Wood, Hot Water Baseboard, In Floor Heating
  • Sewer: Community
  • Water: Well
  • Water Heater: Propane

Schools

  • School District: Petoskey
  • School District: Petoskey

Lot Info

  • Estimated Lot Dimensions: 50 x 218 & 50 x 138
  • Lot: Y
  • Zoning: Residential

Tax Info

  • Assessor Parcel Number: 14-17-27-476-022

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 8, 2019
Closed on
May 30, 2019
Sold by
Pierpont Eric and Pierpont Julie
Bought by
Johnson Leif and Johnson Caitlin
Seller's Agent
Bill Takalo
Coldwell Banker Schmidt - Petoskey
Buyer's Agent
William Winslow
Coldwell Banker Schmidt- Harbor Springs
List Price
$499,900
Sold Price
$489,900
Premium/Discount to List
-$10,000
-2%
Current Estimated Value
$960,066

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$470,166
Avg. Annual Appreciation
11.20%
Original Mortgage
$416,415
Outstanding Balance
$366,131
Interest Rate
4.1%
Mortgage Type
New Conventional
Estimated Equity
$593,935

Purchase Details

Listed on
Apr 8, 2019
Closed on
Apr 4, 2019
Sold by
Julie Eric and Julie Pierpont T
Bought by
Pierpont Eric and Pierpont Julie
Seller's Agent
Bill Takalo
Coldwell Banker Schmidt - Petoskey
Buyer's Agent
William Winslow
Coldwell Banker Schmidt- Harbor Springs
List Price
$499,900
Sold Price
$489,900
Premium/Discount to List
-$10,000
-2%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$416,415
Outstanding Balance
$366,131
Interest Rate
4.1%
Mortgage Type
New Conventional
Estimated Equity
$593,935

Purchase Details

Closed on
May 5, 2010
Sold by
Pierpont Eric S and Pierpont Julie E
Bought by
Pierpont Eric S and Pierpont Julie E

Purchase Details

Closed on
Jun 1, 1997
Bought by
Pierpont

Purchase Details

Closed on
Jun 1, 1983
Bought by
Russell
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
Johnson Leif -- Attorneys Title
Pierpont Eric -- Attorneys Title
Pierpont Eric S -- --
Pierpont $160,000 --
Russell $63,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Johnson Leif $416,415
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/03/2019 06/03/19 Sold $489,900 -2.0% $181 / Sq Ft
04/08/2019 04/08/19 For Sale $499,900 -- $185 / 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 $7,047 $364,400 $364,400 $0
2024 $7,047 $382,500 $382,500 $0
2023 $6,523 $247,100 $247,100 $0
2022 $6,523 $227,700 $227,700 $0
2021 $6,992 $245,300 $245,300 $0
2020 $11,168 $243,400 $243,400 $0
2019 -- $235,700 $235,700 $0
2018 -- $212,300 $212,300 $0
2017 -- $201,500 $201,500 $0
2016 -- $196,800 $196,800 $0
2015 -- $181,900 $0 $0
2014 -- $157,500 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Michigan MLS

MLS Number: 458080

Northern Michigan MLS

APN: 14-17-27-476-022