NOT LISTED FOR SALE

5340 Kellen Ln Bloomfield Hills, MI 48302

Estimated Value: $730,000 - $844,000

4 Beds
3 Baths
2,922 Sq Ft
$271/Sq Ft Est. Value

Last Sold July 02, 2012

Last sale price $455,000 $156 Per Sq Ft

Est. 74% increase in value since last sale

Current estimated payment $4,771/month

49 Days on Market

Highlights

  • Deck
  • Jetted Tub in Primary Bathroom
  • Porch
  • Conant Elementary School Rated A
  • 3 Car Direct Access Garage
  • Patio

About This Home

As of July 2012

*Don't be fooled by the price...not a short sale or foreclosure* Must see feature filled home on premium cul de sac location has been made over since 2000. Spectacular kitchen with cherry cabinets and granite island features floor to ceiling fireplace. Custom trim with arched and crown mouldings and solid cherry 6 panel doors. Finished basement rec room & beautifully landscaped backyard with patio and deck. All measurements and data approximate.

Last Agent to Sell the Property

David Kaplan

Real Estate One-WB/FH License #6501305682 Listed on: 05/09/2012

Real Estate One-WB/FH

Last Buyer's Agent

Patricia Moran

The Agency Hall & Hunter License #6501248321

The Agency Hall & Hunter

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 1961 | Remodeled in 2001

Lot Details

  • 0.48 Acre Lot
  • Lot Dimensions are 133 x152 x119x152

HOA Fees

  • $3 Monthly HOA Fees

Home Design

  • Split Level Home
  • Quad-Level Property
  • Brick Exterior Construction
  • Stone Siding

Interior Spaces

  • 2,922 Sq Ft Home
  • Central Vacuum
  • Sound System
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • Finished Basement
  • Sump Pump
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms
  • Jetted Tub in Primary Bathroom

Parking

  • 3 Car Direct Access Garage
  • Garage Door Opener

Outdoor Features

  • Deck
  • Patio
  • Exterior Lighting
  • Porch

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Heating System Uses Natural Gas
  • Natural Gas Water Heater
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1920451031
  • $5,000 Seller Concession

Community Details

Overview

  • The Dells Of Bloomfield Subdivision

Amenities

  • Community Barbecue Grill

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,010

Year Built

Built in 1961 | Remodeled in 2001

Lot Details

0

HOA Fees

$3 per month

Listing Details

  • Property Type: Residential
  • Architecture Style: Split Level
  • Architecture Level: Quad-Level
  • Year Built: 1961
  • Year Renovated: 2001
  • Foundation Features: Sump Pump
  • Pets Allowed: Yes
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 4

Interior Features

  • Interior Amenities: Cable Available, Central Vacuum, Humidifier, Jetted Tub, Security Alarm (owned), Sound System
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Family Room
  • Room Count: 12
  • Total Bedrooms: 4
  • Total Bathrooms: 3.00
  • Full Bathrooms: 3
  • Basement: Yes
  • Basement Type: Finished
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range/Stove
  • Sq Ft Combined: 2922
  • Total Sq Ft: 2922

Exterior Features

  • Foundation Details: Basement
  • Construction Materials: Brick, Stone
  • Exterior Features: Lighting, BBQ Grill
  • Frontage Feet: 133
  • Porch Type: Deck, Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

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

Utilities

  • Heating Fuel: Natural Gas
  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Forced Air
  • Sewer: Public Sewer (Sewer-Sanitary)
  • Water Heater Fuel: Natural Gas
  • Water Source: Public (Municipal)
  • Laundry Facilities: No

Condo/Co-op/Association

  • Association Fee Frequency: Annually
  • Association Fee: 35
  • Association Fee: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • Homestead: Yes
  • List Price per Acre: 956250.0000
  • Lot Size Area: 0.48
  • Lot Dimensions: 133 X152 X119X152
  • Parcel Number: 1920451031

Tax Info

  • Tax Amount Summer: 3097.0000
  • Tax Amount Winter: 2913.0000
  • Total Tax: 6010.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 9, 2012
Closed on
Jun 29, 2012
Sold by
Lewis Daniel C and Lewis Michelle
Bought by
Vandenplas Bart and Vandenplas Meghan
Seller's Agent
David Kaplan
Real Estate One-WB/FH
Buyer's Agent
Patricia Moran
The Agency Hall & Hunter
List Price
$459,000
Sold Price
$455,000
Premium/Discount to List
-$4,000
-0.87%
Current Estimated Value
$792,076

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$337,076
Avg. Annual Appreciation
4.07%
Original Mortgage
$390,000
Interest Rate
3.77%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 3, 2007
Sold by
Basler Frank and Basler Cindy
Bought by
Lewis Daniel C and Lewis Michelle

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$7,000
Interest Rate
6.44%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jan 21, 1999
Sold by
Ruth L Stephens Tr
Bought by
Basler Frank
Source: Public Records

Similar Homes in Bloomfield Hills, MI

  • 5799 Blandford Ct, Bloomfield Hills, MI 48302

    $645,000

    • 3 Beds
    • 2.5 Baths
    • 2,027 Sq Ft
    • 5799 Blandford Ct
    • Bloomfield Hills, MI

    Welcome to this beautifully remodeled ranch!This home features a gourmet kitchen with granite countertops, aesthetically pleasing cabinetry, and a large center island that comfortably seats six. Stainless steel appliances, recessed lighting, and interior cabinet lighting truly make this gem shine.Enjoy hardwood floors throughout, a cedar closet, and large French patio doors flanked by

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 830 Jonathan Ln, Bloomfield Hills, MI 48302

    $700,000

    • 3 Beds
    • 4 Baths
    • 2,440 Sq Ft
    • 830 Jonathan Ln
    • Bloomfield Hills, MI

    Bloomfield Hills Sprawling Ranch with Room to Roam!Tucked away on a quiet, dead-end street and surrounded by mature trees and lush landscaping, this sought-after Bloomfield Hills ranch offers privacy and serenity on nearly 3/4 of an acre. The circular driveway welcomes guests while adding convenience and ample parking.Inside, a generous floor plan features a spacious first-floor primary suite,

    Linda Wells RE/MAX Classic

    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
  • 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
  • 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
  • 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
  • 4265 Pine Tree Trail, Bloomfield Hills, MI 48302

    $629,000

    • 4 Beds
    • 2.5 Baths
    • 2,794 Sq Ft
    • 4265 Pine Tree Trail
    • Bloomfield Hills, MI

    Hardwood floors in all of the large sized bedrooms make this home with Bloomfield Hills Schools perfect for adding your own touches. Set on .74 acres this well-built home is ready for you to call it home. Located on a corner lot you will find endless possibilities. The eat in kitchen has a Sub Zero refrigerator, double wall oven and cooktop. The patio and florida room double your entertainment

    Lisa Blake Shain Park, REALTORS

    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
Vandenplas Bart $455,000 Metropolitan
Lewis Daniel C $530,000 Capital Title Ins Agency
Basler Frank $250,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Vandenplas Bart $360,000
Closed Vandenplas Bart $390,000
Previous Owner Lewis Daniel C $414,900
Previous Owner Lewis Daniel C $417,000
Previous Owner Lewis Michelle $7,000
Previous Owner Lewis Michelle $417,000
Previous Owner Basler Frank $275,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/02/2012 07/02/12 Sold $455,000 -0.9% $156 / Sq Ft
06/27/2012 06/27/12 Pending -- -- --
05/09/2012 05/09/12 For Sale $459,000 -- $157 / 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 $4,477 $369,950 $0 $0
2023 $4,332 $339,900 $0 $0
2022 $8,142 $333,230 $0 $0
2021 $8,084 $333,980 $0 $0
2020 $3,963 $298,130 $0 $0
2019 $7,606 $277,400 $0 $0
2018 $7,641 $262,240 $0 $0
2017 $7,586 $253,030 $0 $0
2016 $7,601 $244,150 $0 $0
2015 -- $242,170 $0 $0
2014 -- $231,890 $0 $0
2011 -- $149,660 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Realcomp

MLS Number: 212047322

Realcomp

APN: 19-20-451-031