$848,750
SOLD OCT 1, 2025

5010 Franklin Rd Bloomfield Hills, MI 48302

4 Beds
4.5 Baths
2,758 Sq Ft
0.91 Acres

Recently Sold

$308 Per Sq Ft

10% Above List Price

21 Days on Market

Highlights

  • Beach Access
  • Spa
  • Lake Privileges
  • Conant Elementary School Rated A
  • Built-In Refrigerator
  • Wolf Appliances

About This Home

As of October 2025

***Multiple Offers!!! All offers to be submitted by 5:00PM on Monday, September 1, 2025.***. Situated on an elevated 0.91 acre lot, surrounded by mature trees and woodland views, this custom, Mid Century Modern home combines warmth with form and function. The design provides open yet defined spaces utilizing natural materials. The kitchen features a concrete topped island, Wolf range, wall oven, warming drawer, Asko dishwasher, and a Sub Zero fridge. The heated bamboo flooring in the kitchen continues to a sitting area with fireplace adjacent to the kitchen. Tall, beamed ceiling, exposed aggregate flooring, fireplace, and dramatic use of brick define the Great Room. Multiple door walls open to patios and foster outdoor/indoor living. The spacious primary suite with framed views of trees and direct access to a secluded patio is complemented by an organized closet system and a double sink vanity. Two other bedrooms, both of which are large, and one with an en-suite bathroom, plus a full bath in main hall complete the south wing portion of the house. A powder room and laundry room are located on the north side of the main floor. The lower level provides direct access to the 2 car attached garage. A separate, enclosed area can serve as a 4th bedroom (egress window). This space is complete with kitchenette (fridge, sink, d/w & micro) and a full bathroom. Perfect for in-law/guest suite, studio... Additional features: Standing Seam Metal Roof, Clopay insulated glass garage doors, irrigation system, 48 kw Generator, French Drain system, newer electrical, Crestron system: Climate, Security & Audio. Bloomfield Hills public schools. Private beach access/lake privileges available through Lone Pine Association located on east shore of all-sports Walnut Lake.

Last Agent to Sell the Property

Robert Campbell

Max Broock, REALTORS®-Birmingham License #6501304530 Listed on: 08/29/2025

Max Broock, REALTORS®-Birmingham

Last Buyer's Agent

Christian Grothe

Max Broock, REALTORS®-Birmingham License #6501329715

Max Broock, REALTORS®-Birmingham

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1950 | Remodeled in 2012

Lot Details

  • 0.91 Acre Lot
  • Lot Dimensions are 235x219x175x175
  • Corner Lot
  • Wooded Lot

Home Design

  • Contemporary Architecture
  • Ranch Style House
  • Brick Exterior Construction
  • Block Foundation
  • Slab Foundation
  • Metal Roof

Interior Spaces

  • 2,758 Sq Ft Home
  • Gas Fireplace
  • ENERGY STAR Qualified Doors
  • Great Room with Fireplace
  • Dining Room with Fireplace
  • Finished Basement
  • Basement Window Egress
  • Security System Owned

Kitchen

  • Built-In Electric Oven
  • Gas Cooktop
  • Range Hood
  • Warming Drawer
  • Microwave
  • Built-In Refrigerator
  • ENERGY STAR Qualified Freezer
  • Dishwasher
  • Wolf Appliances
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms

Laundry

  • Laundry Room
  • Dryer
  • Washer

Parking

  • 2.5 Car Direct Access Garage
  • Garage Door Opener

Accessible Home Design

  • Accessible Bedroom
  • Accessible Kitchen
  • Accessible Hallway

Outdoor Features

  • Spa
  • Beach Access
  • Lake Privileges
  • Patio
  • Exterior Lighting
  • Porch

Location

  • Ground Level

Utilities

  • Forced Air Heating and Cooling System
  • Vented Exhaust Fan
  • Heat Pump System
  • Geothermal Heating and Cooling
  • Radiant Heating System
  • Programmable Thermostat
  • Whole House Permanent Generator
  • Electric Water Heater
  • High Speed Internet

Listing and Financial Details

  • Assessor Parcel Number 1919427004

Community Details

Overview

  • No Home Owners Association
  • Lone Pine Ridge Subdivision
  • Property is near a ravine

Amenities

  • Laundry Facilities

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Est. Annual Taxes

$10,377

Year Built

Built in 1950 | Remodeled in 2012

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Contemporary, Ranch
  • Architecture Level: 1 Story
  • Year Built: 1950
  • State Equalized Value: 294470.0000
  • Year Renovated: 2012
  • Accessibility Features: Accessible Bedroom, Accessible Hallway(s), Accessible Kitchen
  • Entry Location: Ground Level w/Steps
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1

Interior Features

  • Interior Amenities: Egress Window(s), ENERGY STAR® Qualified Door(s), High Spd Internet Avail, Programmable Thermostat, Security Alarm (owned), Fire Alarm
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Dining Room, Great Room
  • Total Bedrooms: 4
  • Total Bathrooms: 4.10
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: ENERGY STAR® qualified freezer, Vented Exhaust Fan, Built-In Electric Oven, Built-In Refrigerator, Dishwasher, Disposal, Dryer, Gas Cooktop, Microwave, Range Hood, Warming Drawer, Washer
  • Total Sq Ft: 2758

Exterior Features

  • Roof Material: Metal
  • Waterfront Name: WALNUT LAKE
  • Foundation Details: Slab, Basement
  • Construction Materials: Brick
  • Exterior Features: Spa/Hot-tub, Whole House Generator, Lighting
  • Foundation Materials: Block
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved, Pub. Sidewalk
  • Waterfront Description: Beach Access, Lake Privileges

Garage/Parking

  • Garage Size: 2.5 Car
  • Garage Features: Direct Access, Electricity, Door Opener, Attached
  • Garage: Yes

Utilities

  • Heating Fuel: Geo-Thermal
  • Cooling: Central Air, Heat Pump
  • Heating: Forced Air, Radiant
  • Sewer: Septic Tank (Existing)
  • Water Heater Fuel: Electric
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Lot Info

  • Homestead: Yes
  • Lot Features: Corner Lot, Hilly-Ravine, Wooded
  • Lot Size Area: 0.91
  • Lot Dimensions: 235X219X175X175
  • Parcel Number: 1919427004

Tax Info

  • Tax Amount Summer: 5228.0000
  • Tax Amount Winter: 5149.0000
  • Total Tax: 10377.0000
  • Taxable Value: 280860.0000

Multi Family

  • Waterfront Features: All Sports Lake

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 29, 2025
Closed on
Sep 15, 2025
Sold by
Hughes Christopher
Bought by
Macfarlane Kenneth and Macfarlane Lissette
Seller's Agent
Robert Campbell
Max Broock, REALTORS®-Birmingham
Buyer's Agent
Christian Grothe
Max Broock, REALTORS®-Birmingham
List Price
$775,000
Sold Price
$848,750
Premium/Discount to List
$73,750
9.52%
Views
29

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-67.49%

Purchase Details

Listed on
Nov 3, 2019
Closed on
Jan 17, 2020
Sold by
Kopek Brad
Bought by
Hughes Christopher
Seller's Agent
Angelo Buttazzoni
National Realty Centers, Inc
Buyer's Agent
Renee Orlewicz
Cedarwood Realty LLC, a Michigan LLC
List Price
$635,000
Sold Price
$600,000
Premium/Discount to List
-$35,000
-5.51%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.26%
Original Mortgage
$358,800
Interest Rate
3.73%
Mortgage Type
New Conventional

Purchase Details

Closed on
Apr 10, 2007
Sold by
Loret Lodovico and Bortoletto Margherita
Bought by
Kopek Brad

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$332,000
Interest Rate
6.18%
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 Type Sale Price Title Company
Warranty Deed $848,750 Capital Title
Warranty Deed $598,000 None Available
Warranty Deed $415,000 Nova Title Agency
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $358,800 New Conventional
Previous Owner $332,000 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/01/2025 10/01/25 Sold $848,750 +9.5% $308 / Sq Ft
09/19/2025 09/19/25 Pending -- -- --
08/29/2025 08/29/25 For Sale $775,000 +29.2% $281 / Sq Ft
01/17/2020 01/17/20 Sold $600,000 -5.5% $218 / Sq Ft View Prior Sale
12/08/2019 12/08/19 Pending -- -- --
11/03/2019 11/03/19 For Sale $635,000 -- $230 / 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 $5,228 $294,470 $0 $0
2023 $5,059 $278,950 $0 $0
2022 $9,507 $254,760 $0 $0
2021 $10,071 $263,140 $0 $0
2020 $3,230 $193,500 $0 $0
2019 $6,200 $188,620 $0 $0
2018 $5,780 $181,450 $0 $0
2017 $5,432 $176,000 $0 $0
2016 $5,443 $173,570 $0 $0
2015 -- $163,180 $0 $0
2014 -- $152,700 $0 $0
2011 -- $130,270 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Realcomp

MLS Number: 20251031850

Realcomp

APN: 19-19-427-004