NOT LISTED FOR SALE

3678 Squaw Beach Rd Big Bay, MI 49808

Estimated Value: $1,040,000 - $1,422,899

7 Beds
4 Baths
3,950 Sq Ft
$312/Sq Ft Est. Value

Last Sold January 18, 2022

Last sale price $974,000 $247 Per Sq Ft

Est. 26% increase in value since last sale

Current estimated payment $6,664/month

137 Days on Market

Highlights

  • Waterfront
  • Wood Flooring
  • Main Floor Bedroom
  • Deck
  • Pole Barn
  • 2 Car Detached Garage

About This Home

As of January 2022

Lake Superior. The words bring to mind a multitude of images of the greatest of the Great Lakes with its crystal clear waters and pristine scenery. The spectacular sunrises and sunsets, the froth of crashing waves or the peace and tranquility of a quiet, secluded beach with warm, golden sand to sink your toes in can all be yours at this amazing compound situated on 235' of sandy Lake Superior shoreline. Upon your approach you'll immediately be wowed by the expansive green lawn dotted with many mature trees, planned landscaping and seating areas designed to take in the fabulous views in all directions over the bay. There's a jungle gym for kids, a horseshoe pit, picnic area, swing and large deck area all designed for creating great memories. Upon entering this extraordinary residence from the inviting front porch you'll immediately feel right at home and welcomed by the warm wood floors throughout, the wall of windows and french doors overlooking the lake, the beautiful vaulted and beamed ceiling and and a cozy, "settle right in" atmosphere. You'll find the functional kitchen a great gathering place with its eye catching 8' black marble bar and proximity to the massive stone fireplace. There's a striking matching "bar" area designed for those who love to entertain, offering a wine fridge, wine rack, wood plank style tile flooring, full size fridge and lots of storage for your wine glasses and party plates! The main floor offers two spacious and charming bedrooms which share a large bathroom complete with spa tub, heated floor and walk-in shower. There's also an additional guest bedroom tucked away with its own bath on this floor. Be prepared to be impressed with the amazing master suite which encompasses the entire upper floor on the east side of the home. This amazing suite is 27x15 with tons of natural light, well designed lighting, and walk-in closet with pull out drawers. The 10x 15 master bath is gorgeous with a fully tiled walk in shower, beautiful cabinetry with granite counters, heated floor, and a spacious walk in closet with full size washer and dryer. On the opposite side of the the upper level you'll find a large bedroom currently serving as an office that includes a cozy 12x10 enclosed sunroom with great views of the lake. Venturing outside, you'll find the fully insulated, heated two car garage with an awesome bunkhouse. This great space offers two huge bunk rooms which sleep up to 8. Tucked between the two rooms is a luxurious bathroom with white tiled floor and tiled walk-in shower, vanity with double sinks and granite counter, heated floor and lots of natural light. This floor has its own heat and air conditioning and there's eight individual cubbies, one for each guest! The garage below is insulated and heated as well. Additionally, there's a 22x26 garage for storage and 36x30 pole barn with power and 10' door for all your water toys. For those looking to work remotely there's high speed fiber optic internet.

Last Agent to Sell the Property

TAMMY BEWARD

COLDWELL BANKER SCHMIDT REALTORS License #UPAR-6501324372 Listed on: 06/18/2021

COLDWELL BANKER SCHMIDT REALTORS

Last Buyer's Agent

Brooke Berube

RE/MAX 1ST REALTY License #UPAR-6501394727

RE/MAX 1ST REALTY

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $77

Year Built

  • Built in 2002

Lot Details

  • 1.4 Acre Lot
  • Lot Dimensions are 235x200
  • Waterfront

Home Design

  • Slab Foundation
  • Vinyl Siding

Interior Spaces

  • 3,950 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Fireplace
  • Window Treatments
  • Wood Flooring

Kitchen

  • Microwave
  • Dishwasher
  • Trash Compactor
  • Disposal

Bedrooms and Bathrooms

  • 7 Bedrooms
  • Main Floor Bedroom
  • Walk-In Closet
  • Bathroom on Main Level
  • 4 Full Bathrooms

Parking

  • 2 Car Detached Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Pole Barn
  • Shed

Location

  • Property is near a Great Lake

Utilities

  • Cooling System Mounted To A Wall/Window
  • Forced Air Heating System
  • Heating System Uses Propane
  • Tankless Water Heater
  • Septic Tank

Listing and Financial Details

  • Assessor Parcel Number 52-11-530-042-00

Home Details

Home Type

Single Family

Est. Annual Taxes

$77

Year Built

Built in 2002

Lot Details

0

Listing Details

  • Originating MLS: Upper Peninsula Assoc of Realtors
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Structure Style: 2 Story
  • Year Built: 2002
  • Mail City: Big Bay
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Hardwood Floors, Walk-In Closet, Window Treatment(s)
  • Appliances: Dishwasher, Disposal, Microwave, Trash Compactor
  • Fireplace: Yes
  • Bedrooms: 7
  • Bedroom 1: On 2nd Floor, Dimensions: 27 x 15
  • Bedroom 2: On Main Floor, Dimensions: 22 x 11
  • Bedroom 3: On Main Floor, Dimensions: 22 x 11
  • Bedroom 4: On Main Floor, Dimensions: 11 x 10
  • Bedroom 5: On Main Floor, Dimensions: 19 x 13
  • Full Bathrooms: 4
  • Total Bathrooms: 4
  • Bathroom 1: On Level: Main
  • Bathroom 2: On Level: Main
  • Bathroom 3: On Level: Second
  • Bathroom 4: On Level: Second
  • Room Types: First Floor Bedroom, First Flr Full Bathroom, Primary Bdrm Suite
  • Kitchen: On 1st Floor, Dimensions: 23 x 21
  • Living Room: On 1st Floor, Dimensions: 25 x 16
  • Above Grade Finished Sq Ft: 3950
  • Total Finished Sq Ft: 3950

Exterior Features

  • Exterior: Vinyl Siding
  • Exterior Features: Deck
  • Foundation: Slab
  • Frontage: 235
  • Lake Name: Lake Superior
  • Road: Private Road, Year Round
  • Water Features: Lake Frontage, Great Lake
  • Waterfront: Yes
  • Out Buildings: Pole Barn, Shed
  • Frontage Type: Water

Garage/Parking

  • Garage: Detached Garage, Gar Door Opener
  • Garage Spaces: 2
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: LP/Propane Gas
  • Sewer: Septic
  • Water: Private Well
  • Water Heater: Tankless Hot Water
  • Cooling: Ceiling Fan(s), Wall/Window A/C

Lot Info

  • Assessor Parcel Number: 52-11-530-042-00
  • Lot Dimensions: 235x200
  • Acreage: 1.4

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 18, 2021
Closed on
Jan 13, 2022
Sold by
Odonnell Revocable Trust and Odonnell Michael F
Bought by
Tackett Stacie Lynn
Seller's Agent
TAMMY BEWARD
COLDWELL BANKER SCHMIDT REALTORS
Buyer's Agent
Brooke Berube
RE/MAX 1ST REALTY
List Price
$999,990
Sold Price
$974,000
Premium/Discount to List
-$25,990
-2.6%
Current Estimated Value
$1,231,450

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$257,450
Avg. Annual Appreciation
6.23%
Original Mortgage
$730,500
Outstanding Balance
$675,993
Interest Rate
3.11%
Mortgage Type
New Conventional
Estimated Equity
$538,574

Purchase Details

Closed on
Aug 20, 2002
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
Tackett Stacie Lynn $974,000 None Listed On Document
-- $255,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tackett Stacie Lynn $730,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/18/2022 01/18/22 Sold $974,000 -2.6% $247 / Sq Ft
11/02/2021 11/02/21 Pending -- -- --
06/18/2021 06/18/21 For Sale $999,990 -- $253 / Sq Ft
Source: Upper Peninsula Association 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 $77 $543,300 $0 $0
2024 $77 $522,300 $0 $0
2023 $4,862 $486,200 $0 $0
2022 $14,453 $303,100 $0 $0
2021 $11,981 $298,300 $0 $0
2020 $11,885 $303,100 $0 $0
2019 $11,568 $294,700 $0 $0
2018 $11,306 $292,050 $0 $0
2017 $10,800 $287,450 $0 $0
2016 $6,191 $157,000 $0 $0
2015 -- $157,000 $0 $0
2014 -- $150,600 $0 $0
2012 -- $164,950 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Upper Peninsula Association of REALTORS®

MLS Number: 10044896

Upper Peninsula Association of REALTORS®

APN: 52-11-530-042-00