NOT LISTED FOR SALE

54624 Franklin Dr Shelby Township, MI 48316

Estimated Value: $495,000 - $543,000

5 Beds
3.5 Baths
4,250 Sq Ft
$123/Sq Ft Est. Value

Last Sold January 17, 2024

Last sale price $477,500 $112 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $3,361/month

10 Days on Market

Highlights

  • Waterfront
  • 0.74 Acre Lot
  • Deck
  • Malow Junior High School Rated A-
  • Colonial Architecture
  • Wood Flooring

About This Home

As of January 2024

Enjoy the lake in the Summer for swimming and other water activities or Winter for skating fun. Ride your bike or walk to Stoney Creek trails and let the adventures begin! Welcome to this stunning colonial on the picturesque Gemini Lake. Updated home offers a perfect blend of modern comfort and craftsman elegance. Enter the front door, you are greeted by a grand foyer leading you into a spacious living area bathed in natural light, highlighting the beautiful hardwood floors and charming formal dining room overlooking the lake, creating a warm and inviting atmosphere. Updated kitchen, features granite countertops, stainless appliances and ample storage space. Adjacent nook area offers breathtaking views of the lake, making every meal a delightful experience. Cozy up in the family room in front of the beautiful fireplace with builtins, hardwood floors and plenty of natural light. Enjoy the composite deck off the family room for gatherings or just relaxing amidst the lake view. Retreat to the upper level where you will find the luxurious, spacious, master suite, complete with a walk-in closet and ensuite bathroom, and don’t miss the sitting room or 5th bedroom providing a peaceful sanctuary to unwind after a long day. Three additional spacious bedrooms, one with its own walk in closet and second ensuite. 2 additional bedrooms and a full bath complete the upstairs. Finished w/o basement w/endless possibilities, featuring home theater, game area. Step outside to the expansive patio, enjoy breathtaking sunsets over the tranquil lake. Septic replaced in 2023, GFA 2022 A/C 2023. Pella windows. City Water.

Last Agent to Sell the Property

Karina Ball

Century 21 Professionals License #MISPE-6506046669 Listed on: 12/05/2023

Century 21 Professionals

Last Buyer's Agent

Mohammad Karim

Real Estate Advantage License #RCO-6501371514

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1971

Lot Details

  • 0.74 Acre Lot
  • Lot Dimensions are 130x250x281.78
  • Waterfront
  • Sprinkler System

HOA Fees

  • $21 Monthly HOA Fees

Parking

  • 2 Car Attached Garage

Home Design

  • Colonial Architecture
  • Brick Exterior Construction

Interior Spaces

  • 2-Story Property
  • Ceiling Fan
  • Family Room with Fireplace
  • Finished Basement
  • Walk-Out Basement

Flooring

  • Wood
  • Carpet
  • Laminate
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms

Outdoor Features

  • Balcony
  • Deck
  • Patio
  • Porch

Utilities

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

Community Details

  • Paulette HOA
  • Twilight Subdivision No 5

Listing and Financial Details

  • Assessor Parcel Number 0708226014

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,381

Year Built

Built in 1971

Lot Details

0

HOA Fees

$21 per month

Listing Details

  • Originating MLS: MiRealSource
  • Class: RESIDENTIAL
  • Type Of Property: Single Family
  • Architecture Style: Colonial
  • Structure Style: 2 Story
  • Total Tax Amount: 5381
  • Year Built: 1971
  • Mail City: Shelby Twp
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Fireplace: Yes
  • Fireplaces: FamRoom Fireplace
  • Basement: Yes
  • Basement: Finished, Walk Out
  • Bedrooms: 5
  • Bedroom 1: On Upper Floor, Dimensions: 24 x 12
  • Bedroom 1 Floor Covering: Carpet
  • Bedroom 2: On Upper Floor, Dimensions: 15 x 13
  • Bedroom 2 Floor Covering: Carpet
  • Bedroom 3: On Upper Floor, Dimensions: 14 x 10
  • Bedroom 3 Floor Covering: Carpet
  • Bedroom 4: On Upper Floor, Dimensions: 11 x 10
  • Bedroom 4 Floor Covering: Carpet
  • Bedroom 5: On Upper Floor, Dimensions: 14 x 10
  • Bedroom 5 Floor Covering: Carpet
  • Full Bathrooms: 3
  • Total Bathrooms: 4
  • Bathroom 1: Dimensions: 9 x 5, On Level: Upper, Flooring: Ceramic
  • Bathroom 2: Dimensions: 7 x 7, On Level: Upper, Flooring: Ceramic
  • Bathroom 3: Dimensions: 7 x 6, On Level: Upper, Flooring: Ceramic
  • Breakfast Nook: On Entry Level, Dimensions: 12 x 12
  • Breakfast Nook Floor Covering: Ceramic
  • Dining Room: On Entry Level, Dimensions: 12 x 10
  • Dining Room Floor Covering: Wood
  • Family Room: On Entry Level, Dimensions: 19 x 13
  • Family Room Floor Covering: Wood
  • Kitchen: On Entry Level, Dimensions: 11 x 8
  • Kitchen Floor Covering: Ceramic
  • Laundry: On Entry Level, Dimensions: 17 x 10
  • Laundry Room Floor Covering: Laminate
  • Living Room: On Entry Level, Dimensions: 29 x 12
  • Living Room Floor Covering: Wood
  • Sitting Room: On Entry Level, Dimensions: 17 x 11
  • Sitting Room Floor Covering: Wood
  • Below Grade Sq Ft: 1245
  • Finished Below Grade Sq Ft: 1000
  • Above Grade Finished Sq Ft: 3250
  • Total Finished Sq Ft: 4250
  • Half Bathrooms: 1

Exterior Features

  • Exterior: Brick
  • Exterior Features: Exterior Balcony, Deck, Lawn Sprinkler, Patio, Porch
  • Foundation: Basement
  • Frontage: 130
  • Lake Name: Gemini Lake
  • Water Features: Lake Frontage
  • Waterfront: Yes
  • Frontage Type: Road

Garage/Parking

  • Garage: Attached Garage
  • Garage Spaces: 2
  • 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 Fees: 250
  • HOA Fee Frequency: Yearly
  • Association Contact: Paulette
  • Association Phone: 586-871-5182
  • Association Fee: Yes

Lot Info

  • Assessor Parcel Number: 0708226014
  • Zoning: Residential
  • Lot Dimensions: 130X250X281.78
  • Acreage: 0.74
  • Geo Subdivision: MI

Rental Info

  • Pets Allowed: Yes
  • Pet Restriction: No Restrictions

Tax Info

  • Summer Tax: Year: 2023, Amount: $3,240.00
  • Winter Tax: Year: 2022, Amount: $2,141.00
  • Taxable Value: 178920
  • Total Tax: Amount: $5,381.00
  • SEV Year: 2023

MLS Schools

  • School District: Utica Community Schools

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Dec 5, 2023
Closed on
Jan 16, 2024
Sold by
Mcnutt James and Mcnutt Melanie
Bought by
Hussain Holdings Llc
Seller's Agent
Karina Ball
Century 21 Professionals
Buyer's Agent
Mohammad Karim
Real Estate Advantage
List Price
$480,000
Sold Price
$477,500
Premium/Discount to List
-$2,500
-0.52%
Views
11
Current Estimated Value
$523,998

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$46,498
Avg. Annual Appreciation
4.53%

Purchase Details

Closed on
Nov 20, 2020
Sold by
Mcnutt James
Bought by
Mcnutt James and Mcnutt Melanie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$316,725
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Nov 16, 2016
Closed on
Jan 9, 2017
Sold by
Green Jon and Green Jennifer
Bought by
Mcnutt James
Seller's Agent
Rob Scalici
RE/MAX First
Buyer's Agent
Karina Ball
Century 21 Professionals
List Price
$349,900
Sold Price
$345,000
Premium/Discount to List
-$4,900
-1.4%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.70%
Original Mortgage
$327,750
Interest Rate
4.08%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 18, 2006
Sold by
Ryan William C and Ryan Patricia A
Bought by
Green Jon and Green Jennifer

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$110,000
Interest Rate
6.27%
Mortgage Type
Purchase Money Mortgage
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
Hussain Holdings Llc $477,500 Alliance Title
Mcnutt James -- None Available
Mcnutt James $345,000 Title One Inc
Green Jon $337,000 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Mcnutt James $316,725
Previous Owner Mcnutt James $327,750
Previous Owner Green Jennifer $91,947
Previous Owner Green Jon $94,706
Previous Owner Green Jon $110,000
Previous Owner Ryan William C $244,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/17/2024 01/17/24 Sold $477,500 -0.5% $112 / Sq Ft
12/15/2023 12/15/23 Pending -- -- --
12/05/2023 12/05/23 For Sale $480,000 +39.1% $113 / Sq Ft
01/09/2017 01/09/17 Sold $345,000 -1.4% $81 / Sq Ft
11/20/2016 11/20/16 Pending -- -- --
11/16/2016 11/16/16 For Sale $349,900 -- $82 / Sq Ft
Source: Michigan Multiple Listing Service

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 $5,894 $218,800 $0 $0
2024 $3,421 $212,400 $0 $0
2023 $3,240 $193,500 $0 $0
2022 $5,226 $170,400 $0 $0
2021 $5,420 $175,900 $0 $0
2020 $3,187 $176,400 $0 $0
2019 $4,973 $173,400 $0 $0
2018 $4,338 $166,600 $0 $0
2017 $3,582 $149,750 $34,900 $114,850
2016 $3,556 $149,750 $0 $0
2015 $3,505 $136,250 $0 $0
2013 $1,968 $122,400 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Michigan Multiple Listing Service

MLS Number: 50129175

Michigan Multiple Listing Service

APN: 23-07-08-226-014