$399,899
PENDING

54158 Blue Cloud Dr Shelby Township, MI 48315

Estimated payment $2,704/month

Total Views 2,958
4 Beds
2.5 Baths
3,941 Sq Ft
$101 Price per Sq Ft

Highlights

  • Beach Front
  • Access To Lake
  • Recreation Room
  • Crissman Elementary School Rated A-
  • Colonial Architecture
  • Home Office

About This Home

ALERT! Best priced waterfront home in Shelby!! Located on the Township's largest lake, 3 illuminated fountains; its a water view like no other (day and night). Updates & amenities: 2024 roof, 2022 high efficiency furnace, 2022 central air ... walkout finished basement onto 22' pie-shaped cement patio, ground level cement patio is tiered to lake level patio (solid cement stairway), lake fed sprinkler system, deep yard/gorgeous beachfront. Massive cement driveway/walkways/front porch in stellar condition. Needs some updates yet so well-constructed with mid-century flair ready to be incorporated into today's styling. Rare quarried full stone natural fireplace, big bayed window & two dining options overlooking lake, large open foyer features open-riser floating staircase (think Brady Bunch!), expansive grand kitchen makes cooking/entertaining a delight, super-sized primary bedroom ensuite complete walk-in closet/private shower-toilet separated vanity-sink making mornings easier (shag carpet baby!). Finished walkout basement has two entertainment areas, one complete with dry bar ... setup for parties of 50+ to enjoy the serene shore of Lake Arrowhead yet creating the perfect backdrop to unwind and relax! Expect activity ... Seize this rare (price) opportunity to customize your backyard, waterfront paradise! Lot size/land listed is owned to center of lake. Occupancy could be sooner/negotiable. Some specialty lighting may be excluded/negotiable. Seller may favor offers allowing seller to leave any personal property not sold prior to key exchange.

Listing Agent

Al Block

RE/MAX First License #MISPE-6506044979 Listed on: 07/06/2025

RE/MAX First

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1975

Lot Details

  • 0.53 Acre Lot
  • Lot Dimensions are 105 x 311 x 128 x 211
  • Beach Front
  • Lake Front
  • Irregular Lot
  • Lot Has A Rolling Slope
  • Sprinkler System

HOA Fees

  • $58 Monthly HOA Fees

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Family Room with Fireplace
  • Living Room
  • Formal Dining Room
  • Home Office
  • Recreation Room

Kitchen

  • Breakfast Area or Nook
  • Eat-In Kitchen
  • Oven or Range

Flooring

  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Laundry

  • Laundry Room
  • Dryer
  • Washer

Finished Basement

  • Walk-Out Basement
  • Sump Pump

Parking

  • 2.5 Car Attached Garage
  • Side Facing Garage
  • Garage Door Opener

Outdoor Features

  • Access To Lake
  • Patio
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas
  • Gas Water Heater
  • Septic Tank
  • Internet Available

Community Details

  • Association fees include hoa
  • John Livingstone (La East)/Thomas Beck (Pres Laha) HOA
  • Lake Arrowhead # 02 Subdivision

Listing and Financial Details

  • Assessor Parcel Number 23-07-11-177-011

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,177

Year Built

Built in 1975

Lot Details

0

HOA Fees

$58 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type: 1 to 4 Units
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Total Tax Amount: 6177
  • Year Built: 1975
  • Mail City: Utica
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable/Internet Avail., Ceramic Floors, Sump Pump, Walk-In Closet
  • Appliances: Dryer, Range/Oven, Refrigerator, Washer
  • Fireplace: Yes
  • Fireplaces: FamRoom Fireplace, Natural Fireplace
  • Basement: Yes
  • Basement: Finished, Walk Out, Poured
  • Bedrooms: 4
  • Bedroom 1: On 2nd Floor, Dimensions: 19 x 15
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On 2nd Floor, Dimensions: 14 x 10
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On 2nd Floor, Dimensions: 13 x 13
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On 2nd Floor, Dimensions: 13 x 10
  • Bedroom 4 Floor Covering: Carpet
  • Full Bathrooms: 2
  • Total Bathrooms: 3
  • Bathroom 1: On Level: Second, Flooring: Ceramic
  • Bathroom 2: On Level: Second, Flooring: Ceramic
  • Room Types: Den/Study/Lib, Family Room, First Floor Laundry, Living Room, Recreation Room, Utility/Laundry Room, Primary Bedroom, Primary Bathroom, Home Office, First Flr Lavatory, Primary Bdrm Suite, Second Flr Full Bathroom, Breakfast Nook/Room, Eat-In Kitchen, Formal Dining Room
  • Dining Room: On Entry Level, Dimensions: 13 x 10
  • Dining Room Floor Covering: Carpet
  • Family Room: On Entry Level, Dimensions: 21 x 14
  • Family Room Floor Covering: Carpet
  • Kitchen: On Entry Level, Dimensions: 27 x 12
  • Kitchen Floor Covering: Ceramic
  • Laundry: On Entry Level, Dimensions: 10 x 6
  • Laundry Room Floor Covering: Ceramic
  • Library Den: On Entry Level, Dimensions: 10 x 9
  • Library Den Floor Covering: Carpet
  • Living Room: On Entry Level, Dimensions: 16 x 14
  • Living Room Floor Covering: Carpet
  • Other Room 2: Dimensions: 41x26, On Level: Basement, Flooring: Carpet
  • Below Grade Sq Ft: 1502
  • Finished Below Grade Sq Ft: 1200
  • Above Grade Finished Sq Ft: 2741
  • Total Finished Sq Ft: 3941
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Brick
  • Exterior Features: Lawn Sprinkler, Patio, Porch, Sidewalks
  • Foundation: Basement
  • Frontage: 105
  • Lake Name: ARROWHEAD LAKE
  • Road: Paved Street, Private Road, Private w/association
  • Water Features: Lake Frontage, Lake/River Access, Water View, Waterfront, Beach Front, No Gas Motors, No Wake Lake, Interior Lake
  • Waterfront: Yes
  • Frontage Type: Water

Garage/Parking

  • Garage: Attached Garage, Electric in Garage, Gar Door Opener, Side Loading Garage
  • Garage Spaces: 2.5
  • Parking: Garage
  • Garage: Yes

Utilities

  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Sewer: Septic
  • Water: Public Water
  • Water Heater: Gas
  • Cooling: Ceiling Fan(s), Central A/C

Condo/Co-op/Association

  • HOA Fee Includes: Hoa
  • HOA Fees: 700
  • HOA Fee Frequency: Yearly
  • Association Contact: JOHN LIVINGSTONE (LA EAST)/THOMAS BECK (PRES LAHA)
  • Association Phone: 586-323-5090
  • Pets: Yes
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 23-07-11-177-011
  • Zoning: Residential
  • Lot Description: Deep Lot - 150+ Ft., Large Lot - 65+ Ft.
  • Lot Dimensions: 105 X 311 X 128 X 211
  • Acreage: 0.53
  • Geo Subdivision: MI
  • Site/Lot Features: Subdivision, Irregular, Platted, Rolling/Hilly, Sidewalks

Rental Info

  • Pets Allowed: Yes
  • Pet Restriction: Call For Pet Restrictions

Tax Info

  • Summer Tax: Year: 2025, Amount: $4,264.00
  • Winter Tax: Year: 2024, Amount: $1,913.00
  • Total Tax: Amount: $6,177.00
  • SEV Year: 2025

MLS Schools

  • School District: Utica Community Schools

Map

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

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 $4,687 $219,700 $0 $0
2024 $2,774 $210,600 $0 $0
2023 $2,628 $195,700 $0 $0
2022 $4,238 $178,000 $0 $0
2021 $4,123 $167,100 $0 $0
2020 $2,419 $160,500 $0 $0
2019 $3,774 $157,600 $0 $0
2018 $3,700 $148,800 $0 $0
2017 $3,661 $141,100 $42,500 $98,600
2016 $3,635 $141,100 $0 $0
2015 $3,583 $133,100 $0 $0
2012 -- $0 $0 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/04/2025 08/04/25 Pending -- -- --
07/08/2025 07/08/25 For Sale $399,899 -- $101 / Sq Ft
Source: Michigan Multiple Listing Service

Mortgage History

Date Status Loan Amount Loan Type
Closed $158,570 Unknown
Closed $220,000 Credit Line Revolving
Closed $80,000 Unknown
Source: Public Records

Source: Michigan Multiple Listing Service

MLS Number: 50180758

Michigan Multiple Listing Service

APN: 23-07-11-177-011