NOT LISTED FOR SALE

5114 Hiawatha Dr Cheboygan, MI 49721

Estimated Value: $747,000 - $971,000

3 Beds
2.5 Baths
3,400 Sq Ft
$251/Sq Ft Est. Value

Last Sold May 12, 2017

Last sale price $460,000 $135 Per Sq Ft

Est. 86% increase in value since last sale

Current estimated payment $5,234/month

24 Days on Market

Highlights

  • Waterfront
  • Vaulted Ceiling
  • Hydromassage or Jetted Bathtub
  • Maid or Guest Quarters
  • Ranch Style House
  • Mud Room

About This Home

As of May 2017

Turnkey quality constructed brick home for sale sitting on the shores of beautiful Long Lake. This newer home sits on a nice landscaped lot with 150ft of frontage. We have a soaring cathedral ceiling in the living room with a stone fireplace, gorgeous views, custom oak cabinetry in the kitchen w/island & dining area, oak trim throughout, recessed lighting, full finished walk-out basement w/wet bar, paver patios, outdoor deck overlooking the water, stone retaining wall, guest cottage with workroom and so much more including a one year home warranty. Call today for more information.

Last Agent to Sell the Property

Roger Kopernik

Exit Realty Premier License #6502378183 Listed on: 02/27/2017

Exit Realty Premier

Last Buyer's Agent

Team Martinchek

Berkshire Hathaway HomeServices-Cheboygan License #6506043613

Berkshire Hathaway HomeServices-Cheboygan

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,208

Year Built

  • Built in 2002

Lot Details

  • 0.69 Acre Lot
  • Lot Dimensions are 150 x 199
  • Waterfront

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Frame Construction

Interior Spaces

  • 3,400 Sq Ft Home
  • Vaulted Ceiling
  • Ceiling Fan
  • Self Contained Fireplace Unit Or Insert
  • Gas Fireplace
  • Blinds
  • Rods
  • Mud Room
  • Living Room
  • Dining Room
  • Home Office
  • Game Room
  • Workshop
  • First Floor Utility Room
  • Laundry on main level
  • Tile Flooring
  • Finished Basement

Kitchen

  • Oven or Range
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Maid or Guest Quarters
  • Hydromassage or Jetted Bathtub

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Separate Outdoor Workshop

Schools

  • Cheboygan Area Elementary School
  • Cheboygan Area High School

Utilities

  • Heating System Uses Natural Gas
  • Baseboard Heating
  • Well
  • Septic Tank
  • Septic System

Community Details

  • T36n,R1w Subdivision

Listing and Financial Details

  • Assessor Parcel Number 140-002-300-023-00
  • Tax Block 2

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,208

Year Built

Built in 2002

Lot Details

0

Listing Details

  • Directions: Take S River Rd to Long Lake Rd. Follow to Hiawatha. Take to end, make left. Look for 5th home on right
  • Garage Yn: Yes
  • Lot Size: 150 x 199
  • Prop. Type: Residential
  • Bedroom 1 Level: 1st
  • Bedroom 2 Level: 1st
  • Dining Room Level: 1st
  • Kitchen Level: 1st
  • Living Room Level: 1st
  • Year Built: 2002
  • PropertySubType: Residential Water
  • Road Frontage Type: All-Sport
  • ResoLaundryFeatures: Main Level
  • Lot Size Acres: 0.69
  • Road Surface Type: Paved, Maintained
  • Water Body Name: Long Lake
  • NAV29_Unit_1_Appliances: Range/Oven, Refrigerator, Dishwasher
  • Co List Office Phone: 231-597-8000
  • MLS Status: Closed
  • Subdivision Name: T36N,R1W
  • Above Grade Finished Sq Ft: 2000.0
  • Architectural Style: Ranch
  • ResoBuildingAreaSource: Floor Plans
  • Reso Fireplace Features: Insert, Gas
  • Contract Information:Short Sale: No
  • Property Information Waterfront: Yes
  • General Property Information Lot Size Dimensions: 150 x 199
  • Property Information Total Bathrooms2: 3.0
  • Property Information:Style2: Ranch
  • Property Information Construction: Frame
  • Water Well2: Yes
  • Sewer:Septic2: Yes
  • Foundation Basement2: Yes
  • Appliances Equipmt Ceiling Fan: Yes
  • Appliances Equipmt Dishwasher2: Yes
  • Appliances Equipmt Garage Door Opener2: Yes
  • Appliances Equipmt RangeOven: Yes
  • Laundry Main Level: Yes
  • HeatingAir Natural Gas4: Yes
  • General Property Information:Acres: 0.69
  • Other Rooms Workshop2: Yes
  • Appliances Equipmt Blinds: Yes
  • Appliances Equipmt Curtain Rods: Yes
  • HeatingAir Baseboard2: Yes
  • Basement Specifics Full-Finished: Yes
  • Other Rooms Game Room: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Has Basement: Finished, None
  • BasementSpecificsBasementSize: 2000 sqft
  • BasementSpecificsPercentage: 85.0
  • Interior Amenities: Blinds, Ceiling Fan, Curtain Rods, Jet Tub, Vaulted Ceiling(s)
  • Bedroom 3 Level: 1st
  • Utility Room Level: 1st
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Fireplace: Yes
  • Flooring: Tile
  • Interior Features Jet Tub2: Yes
  • Other Rooms:Office2: Yes
  • Interior Features Vaulted Ceilings2: Yes
  • Other Rooms:Mud Room: Yes
  • Interior Features Fireplace W Insert: Yes
  • Interior Features:Gas Fireplace: Yes
  • Interior Features Tile Floor: Yes
  • Other Rooms:DenStudy: Yes

Exterior Features

  • Exterior Features: Guest Quarters/Apt, Workshop
  • Waterfront: Yes
  • Construction Type: Brick
  • Foundation Details: Basement
  • Exterior Brick2: Yes
  • Exterior Features Workshop: Yes
  • Exterior Features Guest QuartersApt: Yes

Garage/Parking

  • Attached Garage: No
  • Parking Features: Garage Door Opener
  • Property Information:Garage Stall2: 3
  • Property Information:Garage Type2: Attached/UN

Utilities

  • Sewer: Septic Tank
  • Heating: Baseboard, Natural Gas
  • HeatingYN: Yes

Schools

  • Schools Elementary School: Cheboygan Area
  • Schools High School: Cheboygan Area
  • Elementary School: Cheboygan Area
  • Junior High Dist: Cheboygan Area
  • High School: Cheboygan Area

Lot Info

  • Lot Size Sq Ft: 30056.4
  • ResoLotSizeUnits: Acres
  • Parcel Number: 140-002-300-023-00
  • ResoLotSizeUnits: Acres

Tax Info

  • Tax Block: 2

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 11, 2023
Sold by
Ehlers Jeffrey
Bought by
Ehlers Jeffrey Paul And Judith Elaine Tr
Current Estimated Value
$854,042

Purchase Details

Listed on
Feb 27, 2017
Closed on
May 12, 2017
Sold by
Maurice D Urell And Debra L Ureel Living
Bought by
Ehlers Jeffrey P and Ehlers Judith E
Seller's Agent
Roger Kopernik
Exit Realty Premier
Buyer's Agent
Team Martinchek
Berkshire Hathaway HomeServices-Cheboygan
Sold Price
$460,000

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 23, 2005
Sold by
Ureel Maurice
Bought by
Ureel, Maurice & Debra Trustees

Purchase Details

Closed on
Jan 2, 1999
Sold by
Aown Richard
Bought by
Ureel Maurice D
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
Ehlers Jeffrey Paul And Judith Elaine Tr -- --
Ehlers Jeffrey P $460,000 None Available
Ureel, Maurice & Debra Trustees -- --
Ureel Maurice D $82,500 --
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/12/2017 05/12/17 Sold $460,000 -- $135 / Sq Ft
03/23/2017 03/23/17 Pending -- -- --
Source: Water Wonderland Board of REALTORS®

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 $6,208 $437,500 $0 $0
2024 $3,760 $376,000 $0 $0
2023 $3,602 $281,200 $0 $0
2022 $3,491 $240,000 $0 $0
2021 $5,634 $237,800 $237,800 $0
2020 $5,400 $228,000 $228,000 $0
2019 $5,631 $240,000 $240,000 $0
2018 $5,788 $239,100 $0 $0
2017 $3,244 $180,100 $0 $0
2016 $3,194 $183,500 $0 $0
2015 -- $183,100 $0 $0
2014 -- $132,600 $0 $0
2012 -- $154,300 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Water Wonderland Board of REALTORS®

MLS Number: 306494

Water Wonderland Board of REALTORS®

APN: 140-002-300-023-00