NOT LISTED FOR SALE

5540 Franklin Rd Bloomfield Hills, MI 48301

Estimated Value: $819,000 - $1,110,000

3 Beds
2.5 Baths
3,435 Sq Ft
$279/Sq Ft Est. Value

Last Sold May 15, 2023

Last sale price $875,000 $255 Per Sq Ft

Est. 9% increase in value since last sale

Current estimated payment $6,052/month

8 Days on Market

Highlights

  • Built-In Refrigerator
  • Deck
  • Furnished
  • Conant Elementary School Rated A
  • Ranch Style House
  • No HOA

About This Home

As of May 2023

Sophisticated Custom Built Ranch Home situated on a .89 acre lot in a sought-after area, this 3BR/4BA, ~3,500sqft contemporary stuns with impeccable landscaping, a circular driveway, Brazilian cherry wood flooring, an open floor plan, abundant natural light, and a spacious living room with triple-tray ceilings and a fireplace. Inspired by urban design, the gourmet kitchen dazzles with custom lacquered cabinetry, premium Dacor appliances, enormous pantry, breakfast bar, and granite counters. Boasting a perimeter of mature trees and greenery, the private backyard impresses with a custom paver patio and room for customization. Cheerful and relaxing, the light and bright primary bedroom includes ample closet space and a large en suite. Other features: 3-car garage, whole home generator, tankless water heater, partially finished basement w/potential for 4th bedroom and plumbed for the 4th bathroom, near shopping and Bloomfield Hills Schools, and much more! Call for a tour! I.D.R.B.N.G

Last Agent to Sell the Property

Renee Lossia Acho

KW Domain License #6501305857 Listed on: 04/06/2023

KW Domain

Co-Listed By

Tushar Vakhariya

KW Domain License #6501279268

KW Domain

Last Buyer's Agent

Tushar Vakhariya

KW Domain License #RCO-6501279268

KW Domain

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2002

Lot Details

  • 0.89 Acre Lot
  • Lot Dimensions are 147x264

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 3,435 Sq Ft Home
  • Central Vacuum
  • Furnished
  • Furnished or left unfurnished upon request
  • Gas Fireplace
  • Living Room with Fireplace
  • Partially Finished Basement
  • Basement Window Egress
  • Security System Owned
  • Washer

Kitchen

  • Double Convection Oven
  • Electric Cooktop
  • Down Draft Cooktop
  • Microwave
  • Built-In Refrigerator
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 3 Bedrooms

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Porch

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Whole House Permanent Generator
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Laundry Facilities

Listing and Financial Details

  • Assessor Parcel Number 1930228006

Home Details

Home Type

Single Family

Est. Annual Taxes

$13,260

Year Built

Built in 2002

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Ranch
  • Architecture Level: 1 Story
  • Year Built: 2002
  • State Equalized Value: 431280.0000
  • Entry Location: Ground Level w/Steps
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Humidifier, Furnished - Yes, Furnished - Negotiable, Central Vacuum, High Spd Internet Avail, Security Alarm (owned), Cable Available, Egress Window(s)
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Living Room
  • Room Count: 10
  • Total Bedrooms: 3
  • Total Bathrooms: 2.10
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Daylight, Partially Finished
  • Kitchen Appliances: Built-In Refrigerator, Convection Oven, Dishwasher, Disposal, Double Oven, Down Draft, Electric Cooktop, Microwave, Washer
  • Sq Ft Combined: 3935
  • Sq Ft Lower Floor: 500
  • Total Sq Ft: 3435
  • Sq Ft Total Bsmt: 3435

Exterior Features

  • Roof Material: Asphalt
  • Foundation Details: Basement
  • Construction Materials: Brick
  • Exterior Features: Whole House Generator, Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 147
  • Porch Type: Deck, Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 3 Car
  • Garage Features: Side Entrance, Electricity, Door Opener, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • Lot Size Area: 0.89
  • Lot Dimensions: 147x264
  • Parcel Number: 1930228006

Tax Info

  • Tax Amount Summer: 6782.0000
  • Tax Amount Winter: 6478.0000
  • Total Tax: 13260.0000
  • Taxable Value: 355320.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 6, 2023
Closed on
May 15, 2023
Sold by
Ruth A Cooley Trust
Bought by
Yousif Patrick and Akrawe Silvy
Seller's Agent
Renee Lossia Acho
KW Domain
Buyer's Agent
Tushar Vakhariya
KW Domain
List Price
$899,000
Sold Price
$875,000
Premium/Discount to List
-$24,000
-2.67%
Views
100
Current Estimated Value
$957,808

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$82,808
Avg. Annual Appreciation
4.36%
Original Mortgage
$850,000
Outstanding Balance
$825,958
Interest Rate
5.13%
Mortgage Type
New Conventional
Estimated Equity
$131,850

Purchase Details

Closed on
Feb 2, 2004
Sold by
Cooley Gordon W and Cooley Ruth A
Bought by
Cooley Ruth A and Ruth A Cooley Trust

Purchase Details

Closed on
Sep 24, 2001
Sold by
Al-Najjar Mufid B
Bought by
Cooley Gordon W
Source: Public Records

Similar Homes in Bloomfield Hills, MI

  • 1575 Lakewood Rd, Bloomfield Hills, MI 48302

    $999,000

    • 3 Beds
    • 4 Baths
    • 4,358 Sq Ft
    • 1575 Lakewood Rd
    • Bloomfield Hills, MI

    Nestled on 2.54 acres of picturesque hilltop land, this exquisite ranch offers breathtaking views of both Mirror Lake and Chalmers Lake. The home has been thoughtfully updated with modern touches, including fresh paint, and gleaming hardwood floors. Featuring three spacious bedrooms, two full bathrooms, and one powder room, the layout is both functional and luxurious. A brand new office provides

    Jameela Kallabat @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 5259 Echo Rd, Bloomfield Hills, MI 48302

    $799,000

    • 5 Beds
    • 3.5 Baths
    • 3,626 Sq Ft
    • 5259 Echo Rd
    • Bloomfield Hills, MI

    Welcome to this exquisitely maintained 5-bedroom, 3.5-bath home in the highly sought-after Dells of Bloomfield neighborhood—a true masterpiece of comfort and sophistication. The heart of the home is the extraordinary first-floor primary suite, a serene and stylish retreat crafted by renowned local architect Arik Green. The walk-in closet is a standout, thoughtfully designed with built-in shelving

    Kathryn Paulon KW Domain

    Section Image
  • 5341 Forest Way, Bloomfield Hills, MI 48302

    $849,900

    • 4 Beds
    • 2.5 Baths
    • 2,716 Sq Ft
    • 5341 Forest Way
    • Bloomfield Hills, MI

    ****OPEN HOUSE SUN 6/8 11am-2pm**** Welcome home to this custom renovated brick colonial, featuring 4 bedrooms and 2.5 baths, built in 1974 remodeled in 2025, situated on an expansive .66 acre lot overlooking the lake offers modern luxury and classic charm. As you step in you are greeted with an open- concept floor plan, shimmering hardwood flooring and custom architectural details throughout.

    Sammy Sakla KW Professionals

    Section Image
  • 4779 Walnut Lake Rd, Bloomfield Hills, MI 48301

    $795,000

    • 2 Beds
    • 2 Baths
    • 1,641 Sq Ft
    • 4779 Walnut Lake Rd
    • Bloomfield Hills, MI

    Elegant and charming! A modern day open floor plan w/ beaming natural light. Floor to ceiling windows serve scenic pond views w/ sprouting fountains and meticulous landscape designs. Home Gourmet Neff kitchen w/3" thick granite countertops & premium stainless steel appliances including: Wolf oven, Sub Zero refrigerator, Thermador six-burner gas range & Miele integrated dishwasher. Custom

    Stetson Jarbo @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 5100 Kings Gate Way, Bloomfield Hills, MI 48302

    $949,000

    • 5 Beds
    • 4.5 Baths
    • 5,300 Sq Ft
    • 5100 Kings Gate Way
    • Bloomfield Hills, MI

    Stately home in a desirable Bloomfield Hills neighborhood! With over 5,300 square feet of gracious living space, this spacious residence is ideal for large or extended families seeking comfort, style, and flexibility. Enjoy five generous bedrooms and 4.1 bathrooms, including a 40-foot, two-story great room with a loft and a nearby wet bar—perfect for gathering and entertaining. The newly

    Lian Kollin The Agency Hall & Hunter

    Section Image
  • 4383 Pine Tree Trail, Bloomfield Hills, MI 48302

    $750,000

    • 3 Beds
    • 3 Baths
    • 1,800 Sq Ft
    • 4383 Pine Tree Trail
    • Bloomfield Hills, MI

    YOU'LL NEVER WANT TO LEAVE YOUR OWN PRIVATE, LUSH GREEN RESORT!Tucked away at the end of a peaceful lane on 1.13 secluded acres, this 4-bedroom, 3-bathroom home offers the perfect balance of spaciousness and manageability. Surrounded by mature trees and evergreens, the entire property feels like a hidden sanctuary—offering total privacy and tranquility.The thoughtfully designed floor plan is

    Matthew Martinec @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 7100 Wing Lake Rd, Bloomfield Hills, MI 48301

    $799,000

    • 4 Beds
    • 2.5 Baths
    • 3,069 Sq Ft
    • 7100 Wing Lake Rd
    • Bloomfield Hills, MI

    Spacious, well-maintained, and updated 1800s farmhouse in Oakland County. This 4-bedroom, 2.5-bath home offers 3,069 square feet of living space on a private 1.10-acre lot in a prime Bloomfield Hills neighborhood. Features include a functional layout, mature landscaping, and a two-stall attached garage. The secondary bath boasts a shower with a large soaking tub! Located in the Bloomfield Hills

    Casion (SCOTT) Hunt Weichert REALTORS Plat (Main)

    Section Image
  • 6895 Cedarbrook Dr, Bloomfield Hills, MI 48301

    $749,000

    • 4 Beds
    • 3 Baths
    • 1,700 Sq Ft
    • 6895 Cedarbrook Dr
    • Bloomfield Hills, MI

    This sought-after 1960 Mid-Century Modern residence is an iconic Donald Scholz designed home, featured as the 1958 "House of the Year" in House Beautiful magazine. The recent renovation perfectly balances timeless architectural integrity and thoughtful modern updates tailored for today's lifestyle.From the moment you step inside, the sunken living room, vaulted ceilings, exposed

    Sal Impastato The Agency Hall & Hunter

    Section Image
  • 4573 Ranch Ln, Bloomfield Hills, MI 48302

    $869,000

    • 4 Beds
    • 4.5 Baths
    • 3,599 Sq Ft
    • 4573 Ranch Ln
    • Bloomfield Hills, MI

    Welcome to this move-in-ready colonial, ideally situated on a desirable corner lot in a great neighborhood. Just minutes from top-rated Bloomfield Hills schools, premier shopping, and favorite dining spots, this home is sure to please. Step inside to discover a bright and spacious interior featuring a flexible floor plan and an open layout. With updated finishes, this welcoming home is perfect

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image

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
Yousif Patrick $875,000 None Listed On Document
Cooley Ruth A -- --
Cooley Gordon W $250,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Yousif Patrick $850,000
Previous Owner Cooley Gordon $300,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/15/2023 05/15/23 Sold $875,000 -2.7% $255 / Sq Ft
04/14/2023 04/14/23 Pending -- -- --
04/06/2023 04/06/23 For Sale $899,000 -- $262 / 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
2024 $8,841 $475,000 $0 $0
2023 $7,056 $512,190 $0 $0
2022 $13,260 $431,280 $0 $0
2021 $13,165 $461,880 $0 $0
2020 $6,454 $483,010 $0 $0
2019 $12,387 $456,330 $0 $0
2018 $12,444 $441,370 $0 $0
2017 $12,355 $422,930 $0 $0
2016 $12,378 $404,280 $0 $0
2015 -- $371,930 $0 $0
2014 -- $366,780 $0 $0
2011 -- $289,940 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20230023078

Realcomp

APN: 19-30-228-006