NOT LISTED FOR SALE

5490 Mackenzie Dr Kewadin, MI 49648

Estimated Value: $1,930,000 - $2,150,453

5 Beds
4.5 Baths
5,879 Sq Ft
$347/Sq Ft Est. Value

Sale Details

Date Sold: March 3, 2025

Last sale price $1,950,000 $332 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $11,352 / mo

42 Days on Market

Highlights

  • Private Waterfront
  • Deeded Waterfront Access Rights
  • Bay View
  • Elk Rapids High School Rated 9+
  • Private Dock
  • Deck

About This Home

As of March 2025

A Dream Location on Grand Traverse Bay: 100 Feet of Pristine Waterfront Nestled on a private, quiet road, this breathtaking waterfront home offers the perfect blend of luxury, serenity, and Up North charm. With 100 feet of pristine Grand Traverse Bay frontage, this property provides the ultimate retreat for those seeking a peaceful sanctuary while remaining close to the charm and amenities of downtown Elk Rapids. Designed for both relaxation and entertaining, this spacious home features five or six bedrooms, including a large master suite with generous walk-in closet on the main floor. The finished bonus space above the garage provides additional flexibility, whether you need a home office, entertainment room, or private guest area. With expansive high ceilings and an abundance of windows throughout, the home is bathed in natural light and offers stunning views of the bay from nearly every room. Step outside and you'll find multiple outdoor seating areas, each offering exceptional views of the sparkling water and picturesque sunsets—perfect for entertaining guests or unwinding in tranquility. The beautifully landscaped and wooded lot ensures privacy, while the gentle sounds of the water create a serene atmosphere. Getting out on the water for fun has never been easier, with direct access to the bay right at your doorstep. With ample room for both social gatherings and peaceful retreats, this home offers the best of both worlds. Enjoy the ease of being just a 4 mile drive from downtown Elk Rapids, and close to Charlevoix and Traverse City, where you’ll find shopping, dining, and entertainment options for every taste. This isn’t just a home—it’s a lifestyle. Embrace the peace and beauty of Grand Traverse Bay, where every day feels like a getaway. Don’t miss your opportunity to own this unparalleled retreat. Whole house generator for peace of mind!

Last Agent to Sell the Property

Sandy Ehlers

Coldwell Banker Schmidt-Elk Ra Listed on: 01/16/2025

Coldwell Banker Schmidt-Elk Ra

Last Buyer's Agent

Christina Ingersoll

REMAX Bayshore - Union St TC

REMAX Bayshore - Union St TC

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2002

Lot Details

  • 30,492 Sq Ft Lot
  • Lot Dimensions are 100 x 294 x 100 x 294
  • Private Waterfront
  • 100 Feet of Waterfront
  • Landscaped
  • Sloped Lot
  • Wooded Lot
  • The community has rules related to zoning restrictions

Home Design

  • Frame Construction
  • Asphalt Roof
  • Cement Board or Planked

Interior Spaces

  • 5,879 Sq Ft Home
  • 2-Story Property
  • Bookcases
  • Vaulted Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Gas Fireplace
  • Mud Room
  • Entrance Foyer
  • Den
  • Home Gym
  • Bay Views

Kitchen

  • Oven or Range
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Walk-In Closet
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Basement

  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Basement Windows

Parking

  • 2 Car Attached Garage
  • Brick Driveway

Outdoor Features

  • Deeded Waterfront Access Rights
  • Property is near a lake
  • Private Dock
  • Deck
  • Patio

Location

  • Property is near a Great Lake

Utilities

  • Forced Air Heating and Cooling System
  • Baseboard Heating
  • Well
  • Cable TV Available

Community Details

  • White Sands Community

Home Details

Home Type

Single Family

Year Built

Built in 2002

Lot Details

0.7 Acres

Listing Details

  • Class: Single Family
  • Type: Residential
  • Style: 2 Story
  • Estimated Year Built: 2002
  • Construction: Frame
  • Private Shared: Private
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2
  • Year Built: 2002

Interior Features

  • Appliances Equipment: Refrigerator, Oven/Range, Disposal, Dishwasher, Washer, Dryer, Ceiling Fan
  • Interior Amenities: Jetted Tub, Built-In Bookcase, Foyer Entrance, Walk-In Closet(s), Solid Surface Counters, Island Kitchen, Mud Room, Den/Study, Exercise Room, Vaulted Ceilings
  • Bedrooms: 5
  • Bedroom 1: Dimensions: 14x15, On Level: Main Floor, Flooring: Carpet
  • Bedroom 2: Dimensions: 9x15, On Level: Main Floor, Flooring: Carpet
  • Bedroom 3: Dimensions: 14x15, On Level: Upper Floor, Flooring: Carpet
  • Bedroom 4: Dimensions: 9x19, On Level: Upper Floor, Flooring: Carpet
  • Total Bathrooms: 4.5
  • Primary Bathroom: Private
  • Number of Lower Level Bathrooms: 1
  • Number of Main Level Bathrooms: 3
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Main Floor Primary: Yes
  • Dining Room: Dimensions: 18xCombo, On Level: Main Floor, Flooring: Tile
  • Family Room: Dimensions: 18x20, On Level: Lower Floor
  • Kitchen: Dimensions: Combox22, On Level: Main Floor, Flooring: Tile
  • Living Room: Dimensions: 20x24, On Level: Main Floor, Flooring: Wood
  • Range: R 9W
  • Total Finished Sf Apx: 5879

Exterior Features

  • Body Of Water: Grand Traverse Bay
  • Exterior Features: Bay View, Deck, Patio, Landscaped
  • Exterior Finish: Cement Board
  • Foundation: Walkout, Daylight Windows, Full Finished
  • Number Of Acres: 0.7
  • Road: Public Maintained, Blacktop
  • Roof: Asphalt
  • Water Features: Priv Frontage (Wtr Side), Private Dock, Gradual Slope to Water, Great Lake, Public Lake
  • Waterfront Frontage: 100

Garage/Parking

  • Driveway: Brick
  • Garage Capacity: 2
  • Primary Garage: Attached

Utilities

  • Fireplaces And Stoves: Fireplace(s), Gas, Wood
  • Heating Cooling Types: Forced Air, Hot Water, Baseboard
  • Laundry: On Level: Main Floor
  • Sewer: Private Septic
  • Tv Service Internet Avail: Cable TV, Cable Internet
  • Water: Private Well

Association/Amenities

  • Development Name: White Sands

Lot Info

  • Deeded Waterfront: Yes
  • Land Features: Wooded, Sloping
  • Lot Dimensions: 100 x 294 x 100 x 294
  • Mineral Rights: Unknown
  • Parcel Description: Subdivision
  • Zoning Use Restrictions: Residential

Rental Info

  • Rent Spree Y N: No

MLS Schools

  • School District: Elk Rapids Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 16, 2025
Closed on
Mar 3, 2025
Sold by
Laney Of Halliday Trust
Bought by
Stabenow Deborah A No 1
Seller's Agent
Sandy Ehlers
Coldwell Banker Schmidt-Elk Ra
Buyer's Agent
Christina Ingersoll
REMAX Bayshore - Union St TC
List Price
$1,950,000
Sold Price
$1,950,000
Views
59
Current Estimated Value
$2,039,818

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$89,818
Avg. Annual Appreciation
4.07%
Original Mortgage
$1,150,000
Outstanding Balance
$1,139,548
Interest Rate
6.6%
Mortgage Type
New Conventional
Estimated Equity
$900,270

Purchase Details

Closed on
Aug 19, 2015
Sold by
Halliday Gail and Laney Thomas C
Bought by
The Laney/Halliday Trust

Purchase Details

Closed on
Sep 15, 2010
Bought by
Halliday Gail
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Buyer Sale Price Title Company
Stabenow Deborah A No 1 $1,900,000 Attorneys Title Agcy Llc
The Laney/Halliday Trust -- None Available
Halliday Gail $615,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Stabenow Deborah A No 1 $1,150,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/03/2025 03/03/25 Sold $1,950,000 0.0% $332 / Sq Ft
02/27/2025 02/27/25 Pending -- -- --
01/16/2025 01/16/25 For Sale $1,950,000 -- $332 / Sq Ft
Source: Northern Great Lakes REALTORS® MLS

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,340 $894,900 $0 $0
2024 $71 $863,700 $0 $0
2023 $6,814 $721,700 $0 $0
2022 $8,710 $579,200 $0 $0
2021 $8,352 $510,300 $0 $0
2020 $7,897 $465,600 $0 $0
2019 $8,243 $430,900 $0 $0
2018 $8,268 $413,500 $0 $0
2017 $8,129 $408,800 $0 $0
2016 $5,672 $382,300 $0 $0
2015 -- $375,900 $0 $0
2014 -- $353,900 $0 $0
2013 -- $339,800 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Northern Great Lakes REALTORS® MLS

MLS Number: 1930168

Northern Great Lakes REALTORS® MLS

APN: 05-12-795-004-00

Your Personal Tour Guide

Ask me questions while you tour the home.