NOT LISTED FOR SALE

5340 Kellen Ln Bloomfield Hills, MI 48302

Estimated Value: $735,000 - $789,000

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

Last Sold July 02, 2012

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

Est. 68% increase in value since last sale

Current estimated payment $4,614/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 Listed By

David Kaplan

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

Real Estate One-WB/FH

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%
Total Days on Market
49
Current Estimated Value
$764,353

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$309,353
Avg. Annual Appreciation
4.11%
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

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

Similar Homes in Bloomfield Hills, MI

  • 5799 Blandford Ct, Bloomfield Hills, MI 48302

    $650,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 additional

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 815 Great Oaks Dr, Bloomfield Hills, MI 48304

    $674,900

    • 4 Beds
    • 2.5 Baths
    • 2,719 Sq Ft
    • 815 Great Oaks Dr
    • Bloomfield Hills, MI

    Welcome to this beautifully maintained 4-bedroom, 2.5-bath Colonial, featuring a thoughtful mix of updates and classic charm. Step inside to find hardwood flooring throughout the living room, dining room, library, and hallway (2015), with hardwood also under the carpet in the family room and all bedrooms—perfect for future customization. The partially finished basement (2019) offers great

    Anthony Djon Anthony Djon Luxury Real Estate

    Section Image
  • 1322 Lake Crescent Dr, Bloomfield Hills, MI 48302

    $649,000

    • 4 Beds
    • 2.5 Baths
    • 2,451 Sq Ft
    • 1322 Lake Crescent Dr
    • Bloomfield Hills, MI

    Located in the heart of Bloomfield Hills, this meticulously maintained 4-bedroom, 2.1-bathroom brick ranch offers 2,451 square feet of single-level living on a lush and private .51-acre corner lot. This residence combines timeless architecture with comfortable everyday functionality. The main living areas feature rich wood flooring and fresh paint throughout. A spacious formal great room opens

    Dan Gutfreund Signature Sotheby's International Realty Bham

    Section Image
  • 1615 Bracken Rd, Bloomfield Hills, MI 48302

    $670,000

    • 4 Beds
    • 3 Baths
    • 2,890 Sq Ft
    • 1615 Bracken Rd
    • Bloomfield Hills, MI

    Welcome home to your spacious and beautifully updated ranch. The generous foyer opens to a stunning home of warmth and comfort. Sun filled open floor plan with spacious rooms and hardwood flooring. The family room, dining room and living room, with their own cozy fireplace make this home great for family time, entertaining or relaxing. Beautiful chef inspired kitchen has premium maple

    Marilyn Lentz Oakland Hills Real Estate Corp

    Section Image
  • 4747 Keithdale Ln, Bloomfield Hills, MI 48302

    $898,500

    • 4 Beds
    • 4.5 Baths
    • 3,932 Sq Ft
    • 4747 Keithdale Ln
    • Bloomfield Hills, MI

    Prime Bloomfield Twp location with Bloomfield Hills Schools! Nestled in a stunning park-like setting, this exceptional quad-level home welcomes you with a circular drive. Inside, the spacious living room features a cozy fireplace, hardwood floors, and abundant natural light, while the elegant dining room boasts marble floors and a built-in lighted display case. The large kitchen is a chef’s

    Alyse Robertelli Max Broock, REALTORS®-Bloomfield Hills

    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
  • 4511 Lakeview Ct, Bloomfield Hills, MI 48301

    $775,000

    • 5 Beds
    • 4 Baths
    • 2,618 Sq Ft
    • 4511 Lakeview Ct
    • Bloomfield Hills, MI

    #WelcomeHOM to 4511 Lakeview! Bring your vision to this 5-bed, 4-bath colonial situated amongst multi-million dollar homes on a beautiful, private cul-de-sac. Set on a level .78 acre lot, with Wing Lake privileges and Bloomfield Hills schools. The home has tasteful upgrades throughout such as a bricked patio, two gas fireplaces and a master suite & bath with spa tub and heated flooring. Below,

    Dade DiMaggio House Of May

    Section Image
  • 4268 Covered Bridge Rd, Bloomfield Hills, MI 48302

    $650,000

    • 4 Beds
    • 3.5 Baths
    • 2,602 Sq Ft
    • 4268 Covered Bridge Rd
    • Bloomfield Hills, MI

    Charming Brick Center Entrance Colonial in the Highly Sought-After Bennington GreenSubdivision! This spacious 4-bedroom, 3.5-bath home features numerous updates, including thestunning gourmet kitchen that boasts granite countertops, stainless steel appliances, and amplespace for cooking and gathering. This lovely Center Entrance Colonial offers a spacious FormalLiving and Dining Room with

    Jack Apap @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 4678 Brightmore Rd, Bloomfield Hills, MI 48302

    $880,000

    • 5 Beds
    • 4 Baths
    • 3,151 Sq Ft
    • 4678 Brightmore Rd
    • Bloomfield Hills, MI

    This stunning 5-bedroom, 4-bathroom home offers over 3,100 square feet of living space, plus an additional 860 square feet in the beautifully finished basement. Nestled on a desirable corner lot, the property boasts lush landscaping and exceptional curb appeal. With four levels of spacious living, this home features multiple gathering areas, including a family room with a gas fireplace, wet bar,

    Kathy Coon BHHS Michigan RE Great Lakes RH

    Section Image

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