NOT LISTED FOR SALE

2300 24 Mile Rd Shelby Township, MI 48316

6 Beds
8.5 Baths
6,540 Sq Ft
5.5 Acres

Last Sold June 20, 2024

Last sale price $1,050,000 $161 Per Sq Ft

158 Days on Market

Highlights

  • In Ground Pool
  • Home fronts a pond
  • 5.5 Acre Lot
  • Malow Junior High School Rated A-
  • Built-In Refrigerator
  • Colonial Architecture

About This Home

As of June 2024

Welcome to this grand residence that unfolds across 6,540 sq ft, offering 6 bedrooms and 8.1 bathrooms in a seamless blend of luxury and spacious living. The grandeur begins as you are greeted by the elegance of marble flooring that spans the foyer and covers the breathtaking staircase that serves as a focal point of architectural splendor.
The kitchen, a culinary haven featuring a gas cooktop, double oven, warming drawers, and a Sub-Zero fridge, stands as a well-equipped space for culinary endeavors. Designed for entertaining, the expansive great room effortlessly blends comfort and sophistication with the inclusion of a welcoming wet bar, a stately fireplace, and a convenient walk-out balcony. The first-floor primary suite includes a private balcony, a spacious closet, and an opulent bathroom. Ascending to the upper level reveals a second family room and expansive bedrooms, each generously sized for ultimate comfort. The upstairs living room, complete with a fireplace, adds a touch of warmth and sophistication to the living space.
Venture into the basement to discover a second kitchen and a spacious entertainment room, complete with a full bar and a convenient walkout to a sprawling lot featuring a serene pond. Additionally, marvel at the unique feature of an indoor/outdoor pool seamlessly integrated into the basement space, offering an all-season aquatic experience. Along the back yard, is the Macomb Orchard Trail, providing a picturesque and convenient trail for outdoor enthusiasts.
Adding to the overall convenience and functionality is the attached 4 car garage. Welcome to a home where luxury and lifestyle converge seamlessly in the heart of Shelby Twp.

Last Agent to Sell the Property

Dan Gutfreund

Signature Sotheby's International Realty Bham License #6501367800 Listed on: 12/08/2023

Signature Sotheby's International Realty Bham

Co-Listed By

Janine Grillo

Crain Homes License #6506046833

Last Buyer's Agent

JoDee Leahy

License #6501450468

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1973

Lot Details

  • 5.5 Acre Lot
  • Lot Dimensions are 292x215x115x542x410x702
  • Home fronts a pond

Parking

  • 4 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Slate Roof

Interior Spaces

  • 6,540 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Dining Room with Fireplace
  • Finished Basement
  • Fireplace in Basement

Kitchen

  • Double Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 6 Bedrooms

Laundry

  • Dryer
  • Washer

Outdoor Features

  • In Ground Pool
  • Balcony
  • Patio
  • Porch

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 0718102010

Community Details

Recreation

  • Community Indoor Pool

Additional Features

  • No Home Owners Association
  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,929

Year Built

Built in 1973

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Year Built: 1973
  • State Equalized Value: 515800.0000
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Central Vacuum, Indoor Pool, Wet Bar
  • Fireplace: Yes
  • Fireplace Locations: Basement, Dining Room, Family Room, Great Room, Living Room
  • Room Count: 25
  • Total Bedrooms: 6
  • Total Bathrooms: 8.10
  • Full Bathrooms: 8
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished, Walk-Out Access
  • Kitchen Appliances: Built-In Electric Range, Built-In Refrigerator, Dishwasher, Disposal, Double Oven, Dryer, Electric Cooktop, Gas Cooktop, Microwave, Range Hood, Stainless Steel Appliance(s), Warming Drawer, Washer
  • Sq Ft Combined: 9909
  • Sq Ft Lower Floor: 3369
  • Total Sq Ft: 6540
  • Sq Ft Total Bsmt: 3869

Exterior Features

  • Roof Material: Slate
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exterior Features: Pool - Inground
  • Foundation Materials: Poured
  • Frontage Feet: 292
  • Porch Type: Balcony, Patio, Porch
  • Road Frontage Type: Paved
  • Waterfront Description: Pond

Garage/Parking

  • Garage Size: 4 Car
  • Garage Features: Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Septic Tank (Existing)
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Utica

Lot Info

  • Homestead: Yes
  • Lot Size Area: 5.50
  • Lot Dimensions: 292x215x115x542x410x702
  • Parcel Number: 0718102010

Tax Info

  • Tax Amount Summer: 5979.0000
  • Tax Amount Winter: 3950.0000
  • Total Tax: 9929.0000
  • Taxable Value: 330188.0000

MLS Schools

  • School District: Utica

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

Property History

Date Event Price Change Sq Ft Price
06/20/2024 06/20/24 Sold $1,050,000 -4.5% $161 / Sq Ft
05/14/2024 05/14/24 Pending -- -- --
12/08/2023 12/08/23 For Sale $1,100,000 -- $168 / Sq Ft
Source: Realcomp

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 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 20230100467

Realcomp

APN: 23-07-18-102-010