NOT LISTED FOR SALE

500 Needle Pointe Dr Cheboygan, MI 49721

Estimated Value: $793,000 - $1,758,000

4 Beds
3 Baths
2,934 Sq Ft
$476/Sq Ft Est. Value

Last Sold November 08, 2023

Last sale price $2,489,000 $848 Per Sq Ft

Est. 44% decrease in value since last sale

Current estimated payment $9,921/month

292 Days on Market

Highlights

  • Docks
  • Maid or Guest Quarters
  • Vaulted Ceiling
  • Waterfront
  • Deck
  • Ranch Style House

About This Home

As of November 2023

A truly unique property on Mullett Lake with your very own island. This gorgeous 2,934 sq ft home is nestled at the end of Needle Point and showcases the beauty of Mullet Lake from almost every room in the house. From the front entryway, you are welcomed by an open floor plan, vaulted ceilings, immaculate tongue-and-groove detailing, a custom kitchen suited to fit any chef's dream, and a fireplace in the Master Suite for those cozy nights in. Built in 2014 with 4 bedrooms and 3 bathrooms, this home is the perfect peace and quiet for any outdoor enthusiasts, entertainers, or those who are simply looking to escape with its vast waterfront footage and acreage all around. Bonus 400 sq ft Guest House for family and friends who want to stay!

Last Agent to Sell the Property

Missy Koszegi

COLDWELL BANKER SCHMIDT CHEBOYGAN License #6506045140 Listed on: 10/23/2023

COLDWELL BANKER SCHMIDT CHEBOYGAN

Co-Listed By

Don Bastian

COLDWELL BANKER SCHMIDT CHEBOYGAN License #6501436356

Last Buyer's Agent

NON-MEMBER MLS

MLS NON-MEMBER

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $27,813

Lot Details

  • 3 Acre Lot
  • Waterfront
  • Inland Waterway
  • Landscaped

Home Design

  • Ranch Style House
  • Log Siding

Interior Spaces

  • 2,934 Sq Ft Home
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Blinds
  • Family Room
  • Living Room
  • Dining Room
  • Game Room
  • First Floor Utility Room
  • Crawl Space

Kitchen

  • Oven or Range
  • Dishwasher

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Maid or Guest Quarters
  • 3 Full Bathrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Home Security

  • Home Security System
  • Fire and Smoke Detector

Parking

  • 3 Car Attached Garage
  • Heated Garage
  • Garage Door Opener

Outdoor Features

  • Docks
  • Deck
  • Patio
  • Shed

Schools

  • Cheboygan Elementary School
  • Cheboygan High School

Utilities

  • Forced Air Heating System
  • Heating System Uses Natural Gas
  • Power Generator
  • Well
  • Septic Tank
  • Septic System
  • Cable TV Available

Community Details

  • No Home Owners Association
  • T36n, R1w Subdivision

Listing and Financial Details

  • Assessor Parcel Number 140-018-100-001-00/101-004-00/130-013-100-001-00
  • Tax Block Sec 18

Home Details

Home Type

Single Family

Est. Annual Taxes

$27,813

Lot Details

0

Listing Details

  • Directions: M-33 South, Right on Mann Road, Left of Needle Pointe Drive to end.
  • Garage Yn: Yes
  • Lot Size: 3.1 acres
  • Prop. Type: Residential
  • Bedroom 1 Level: 1st
  • Bedroom 2 Level: 1st
  • Dining Room Level: 1st
  • Kitchen Level: 1st
  • Living Room Level: 1st
  • PropertySubType: Residential Water
  • Road Frontage Type: Inland Waterway
  • ResoLaundryFeatures: Main Level
  • Lot Size Acres: 3.0
  • Road Surface Type: Gravel, Maintained
  • Water Body Name: Mullett Lake
  • NAV29_Unit_1_Appliances: Washer, Range/Oven, Refrigerator, Dryer, Dishwasher
  • ResoSecurityFeatures: Security System, Smoke Detector(s)
  • Co List Office Phone: 231-627-9959
  • MLS Status: Closed
  • Subdivision Name: T36N, R1W
  • Above Grade Finished Sq Ft: 2934.0
  • Architectural Style: Ranch
  • ResoBuildingAreaSource: Appraisal
  • Reso Fireplace Features: Gas
  • Contract Information:Short Sale: No
  • Property Information Waterfront: Yes
  • General Property Information Lot Size Dimensions: 3.1 acres
  • Property Information Total Bathrooms2: 3.0
  • Property Information:Style2: Ranch
  • Property Information Construction: Full Log
  • Water Well2: Yes
  • Sewer:Septic2: Yes
  • Appliances Equipmt Ceiling Fan: Yes
  • Appliances Equipmt Dishwasher2: Yes
  • Appliances Equipmt Garage Door Opener2: Yes
  • Appliances Equipmt RangeOven: Yes
  • HeatingAir Central Air2: Yes
  • HeatingAir Forced Air3: Yes
  • Laundry Main Level: Yes
  • HeatingAir Natural Gas4: Yes
  • General Property Information:Acres: 3.0
  • Appliances Equipmt Blinds: Yes
  • Appliances Equipmt Dryer2: Yes
  • Appliances Equipmt Washer2: Yes
  • Other Rooms Game Room: Yes
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Interior Amenities: Blinds, Ceiling Fan, Vaulted Ceiling(s), Walk-In Closet(s)
  • Bedroom 3 Level: 1st
  • Bedroom 4 Level: 1st
  • Utility Room Level: 1st
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Fireplace: Yes
  • Flooring: Hardwood, Tile
  • Interior Features Walk - In Closet: Yes
  • BasementFoundation:Crawl: Yes
  • Interior Features Vaulted Ceilings2: Yes
  • Interior Features:Gas Fireplace: Yes
  • Other Rooms:Family Room: Yes
  • Interior Features:Hardwood Floors: Yes
  • Interior Features Smoke Detector2: Yes
  • Interior Features Tile Floor: Yes
  • Interior Features Security System3: Yes

Exterior Features

  • Exterior Features: Automatic Generator, Cable TV, Deck, Dock, Guest Quarters/Apt, Landscaped, Patio/Porch, Shed
  • Waterfront: Yes
  • Foundation Details: Crawl
  • Exterior Features:Deck: Yes
  • Exterior Features PatioPorch: Yes
  • Exterior Features:Shed: Yes
  • Exterior Features:Landscaped: Yes
  • Exterior Features:Cable TV: Yes
  • Exterior Features Guest QuartersApt: Yes
  • Exterior Features:Dock: Yes
  • Exterior Features Automatic Generator: Yes

Garage/Parking

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

Utilities

  • Sewer: Septic Tank
  • Heating: Central Air, Forced Air, Natural Gas
  • HeatingYN: Yes

Association/Amenities

  • TaxesAndPossessionAssociationDues: No

Schools

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

Lot Info

  • Lot Size Sq Ft: 130680.0
  • ResoLotSizeUnits: Acres
  • Parcel Number: 140-018-100-001-00/101-004-00/130-013-100-001-00

Tax Info

  • Tax Block: Sec 18

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 23, 2023
Closed on
Nov 8, 2023
Sold by
Bastian Jeffrey L Trust
Bought by
Tls 2009 Investment Trust
Seller's Agent
Missy Koszegi
COLDWELL BANKER SCHMIDT CHEBOYGAN
Buyer's Agent
NON-MEMBER MLS
MLS NON-MEMBER
List Price
$3,800,000
Sold Price
$2,489,000
Premium/Discount to List
-$1,311,000
-34.5%
Current Estimated Value
$1,395,469

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,093,531
Avg. Annual Appreciation
-27.36%

Purchase Details

Closed on
Oct 31, 2009
Sold by
Bastian Jeffrey L
Bought by
Bastian, Jeffrey L, Trustee

Purchase Details

Closed on
Sep 13, 1991
Sold by
Bastian Frances D
Bought by
Bastian Frances and Jeffrey Bastian
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
Tls 2009 Investment Trust $2,489,000 --
Bastian Donald J -- --
Bastian, Jeffrey L, Trustee -- --
Bastian Frances -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bastian Jeffrey L Trust $75,000
Previous Owner Bastian Jeffrey L Trust $200,000
Previous Owner Jeffrey L Bastian Revocable Trust $115,000
Previous Owner Jeffrey L Bastian Revocable Trust $90,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/08/2023 11/08/23 Sold $2,489,000 -34.5% $848 / Sq Ft
10/23/2023 10/23/23 For Sale $3,800,000 +52.7% $1,295 / Sq Ft
10/21/2023 10/21/23 Off Market $2,489,000 -- --
10/21/2022 10/21/22 For Sale $3,800,000 -- $1,295 / Sq Ft
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 $27,813 $985,100 $0 $0
2024 $21,996 $677,600 $0 $0
2023 $5,303 $617,600 $0 $0
2022 $5,133 $545,300 $0 $0
2021 $7,034 $509,500 $509,500 $0
2020 $6,625 $505,800 $505,800 $0
2019 $6,444 $490,400 $490,400 $0
2018 $6,289 $510,600 $0 $0
2017 $5,918 $501,100 $0 $0
2016 $5,820 $565,600 $0 $0
2015 -- $437,000 $0 $0
2014 -- $336,600 $0 $0
2012 -- $39,200 $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: 201821666

Water Wonderland Board of REALTORS®

APN: 140-018-100-001-00