NOT LISTED FOR SALE

5215 Clarendon Crest St Bloomfield Hills, MI 48302

Estimated Value: $2,440,761 - $3,448,000

5 Beds
7 Baths
8,000 Sq Ft
$379/Sq Ft Est. Value

Last Sold June 06, 2019

Last sale price $2,350,000 $294 Per Sq Ft

Est. 29% increase in value since last sale

Current estimated payment $17,982/month

32 Days on Market

Highlights

  • In Ground Pool
  • Fireplace in Primary Bedroom
  • Tudor Architecture
  • Conant Elementary School Rated A
  • Wooded Lot
  • Jetted Tub in Primary Bathroom

About This Home

As of June 2019

LUXURIOUS CUSTOM BUILT HOME DESIGNED BY ALEXANDER V. BOGAERTS FEATURING OVER 8,000 SQFT OF LIVING SPACE. SITUATED ON OVER 1.4 ACRES OF MANICURED GROUNDS ON PRESTIGIOUS CLARENDON CREST, THIS HOME FEATURES A GRAND FOYER W/DOUBLE STAIRCASE, 5 BEDROOM SUITES, 7 BATHS, 1ST FLOOR IN-LAW OR GUEST SUITE, FAMILY ROOM OFF GOURMET KITCHEN W/OVERSIZED CENTER ISLAND, 2 STORY GREAT ROOM WITH LIMESTONE FIREPLACE, 2 BUTLER'S PANTRIES, MUD ROOM, 6 CAR GARAGE, & MUCH MORE! EXTERIOR FEATURES INCLUDE CUSTOM LANDSCAPING, FOUNTAINS & IN-GROUND FENCED IN POOL W/BLUE STONE PATIO. BLOOMFIELD HILLS SCHOOLS. I.D.R.B.N.G. NOTE NON-HOMSTEAD TAXES. ALL MEASUREMENTS & DIMENSIONS APPROXIMATE.

Last Listed By

Tushar Vakhariya

KW Domain License #6501279268 Listed on: 03/21/2019

KW Domain

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2010

Lot Details

  • 1.4 Acre Lot
  • Lot Dimensions are 469x273x258
  • Fenced
  • Corner Lot
  • Irregular Lot
  • Wooded Lot

Home Design

  • Tudor Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof

Interior Spaces

  • 8,000 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Ceiling Fan
  • Gas Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Security System Owned

Kitchen

  • Microwave
  • Dishwasher
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Jetted Tub in Primary Bathroom

Unfinished Basement

  • Walk-Out Basement
  • Walk-Up Access
  • Sump Pump

Parking

  • 6 Car Direct Access Garage
  • Garage Door Opener

Pool

  • In Ground Pool
  • Spa

Outdoor Features

  • 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 1919428007

Community Details

Overview

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

Amenities

  • Community Barbecue Grill

Home Details

Home Type

Single Family

Est. Annual Taxes

$49,989

Year Built

Built in 2010

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Tudor
  • Architecture Level: 2 Story
  • Assessment: 3990.86
  • Year Built: 2010
  • Foundation Features: Sump Pump
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Cable Available, Humidifier, Jetted Tub, Security Alarm (owned), Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Great Room, Living Room, Primary Bedroom
  • Room Count: 20
  • Total Bedrooms: 5
  • Total Bathrooms: 5.20
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Unfinished, Walkout Access, Walk-Up Access
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Range/Stove
  • Sq Ft Combined: 8000
  • Total Sq Ft: 8000
  • Sq Ft Total Bsmt: 3861

Exterior Features

  • Roof Material: Asphalt
  • Pool: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Wood
  • Exclusions: Yes
  • Exterior Features: BBQ Grill, Fenced, Lighting, Pool - Inground, Spa/Hot-tub
  • Foundation Materials: Poured
  • Frontage Feet: 469
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved

Garage/Parking

  • Garage Size: 6 or More
  • Garage Features: Attached, Direct Access, 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: No

Schools

  • School District: Bloomfield Hills

Lot Info

  • List Price per Acre: 1785000.0000
  • Lot Features: Corner Lot, Hilly-Ravine, Irregular, Wooded
  • Lot Size Area: 1.40
  • Lot Dimensions: 469X273X258
  • Parcel Number: 1919428007

Tax Info

  • Tax Amount Summer: 23237.0000
  • Tax Amount Winter: 26752.0000
  • Total Tax: 49989.0000

MLS Schools

  • School District: Bloomfield Hills

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 21, 2019
Closed on
Jun 5, 2019
Sold by
Kinra Diwakar
Bought by
Ayar Vincent and Ayar Amanda
Seller's Agent
Tushar Vakhariya
KW Domain
Buyer's Agent
Fanar Ayar
ICON Realty Experts, LLC
List Price
$2,499,000
Sold Price
$2,350,000
Premium/Discount to List
-$149,000
-5.96%
Total Days on Market
32
Current Estimated Value
$3,034,440

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$684,440
Avg. Annual Appreciation
4.92%
Original Mortgage
$1,645,000
Interest Rate
4.12%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Aug 4, 2006
Sold by
Washington Mutual Bank Fa
Bought by
Dlj Mortgage Capital Inc

Purchase Details

Closed on
Jan 24, 2006
Sold by
Moses Ken and Moses Carolyn E
Bought by
Washington Mutual Bank and Washington Mutual Bank Fa

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 the area

  • 5190 Clarendon Crest St, Bloomfield Hills, MI 48302

    $3,750,000

    • 6 Beds
    • 6 Baths
    • 8,572 Sq Ft
    • 5190 Clarendon Crest St
    • Bloomfield Hills, MI

    Welcome to this stunning, completely redone European-inspired estate, meticulously renovated, where timeless design meets modern luxury. Nestled on a wooded lot with serene Rouge River views, this gated property offers privacy, sophistication, and impeccable craftsmanship. The property’s unique 7-car garage is thoughtfully designed with 3 bays on one side and 4 on the other, perfect for car

    Tushar Vakhariya KW Domain

    Section Image
  • 4456 W Maple Rd, Bloomfield Township, MI 48301

    $2,390,000

    • 4 Beds
    • 6 Baths
    • 5,700 Sq Ft
    • 4456 W Maple Rd
    • Bloomfield Township, MI

    Featured is the Palisade, a 2-story home with 4 bedrooms, 4+ bathrooms, and more than 5,700 square feet of living space. The first floor showcases a grand foyer, great room that opens to the kitchen and dining room, a library, gathering room, and walk-in pantry and optional prep kitchen. The second floor features three secondary suites, each with a full bath and walk-in closet. Homeowners are

    Jonathan Rivera KW Professionals Brighton

    Section Image
  • 5626 Shadow Ln, Bloomfield Hills, MI 48302

    $2,499,000

    • 5 Beds
    • 7 Baths
    • 8,893 Sq Ft
    • 5626 Shadow Ln
    • Bloomfield Hills, MI

    Discover this breathtaking nearly 8,900-square-foot estate offering a perfect blend of elegance and comfort. With 5 spacious bedrooms, 5 full bathrooms, and 2 half bathrooms, this home is designed to meet all of your needs for both grand entertaining and quiet relaxation.The two-story living room and expansive three-story entry create an impressive first impression. The home also features a

    Jane Lowell Max Broock, REALTORS®-Birmingham

    Section Image
  • 975 Sunningdale Dr, Bloomfield Hills, MI 48302

    $3,285,000

    • 6 Beds
    • 6.5 Baths
    • 13,033 Sq Ft
    • 975 Sunningdale Dr
    • Bloomfield Hills, MI

    Breathtaking and profound builder's personal estate with unmatched characteristics and timeless elegance, rich in hand-crafted detail and inspiration at every turn! Carefully built and thoughtfully designed by artisans from around the world, this home is truly stunning and equipped with countless remarkable features including custom woodwork and plaster detail tastefully tied together across all

    Nick Petrucci @properties Christie's Int'l R.E. Birmingham

    Section Image
  • 6925 Meadowlake Rd, Bloomfield Hills, MI 48301

    $3,379,000

    • 6 Beds
    • 8 Baths
    • 5,503 Sq Ft
    • 6925 Meadowlake Rd
    • Bloomfield Hills, MI

    This stunning, newer construction lakefront home exemplifies luxury living at its finest. Meticulously designed with every detail in mind, the residence offers the perfect blend of elegance and functionality. Upon entry, soaring ceilings and floor-to-ceiling windows provide breathtaking views of the lake. The gourmet kitchen is a true showstopper, featuring extensive use of stone surfaces and

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image
  • 1350 Orchard Ridge Rd, Bloomfield Hills, MI 48304

    $2,499,000

    • 5 Beds
    • 8 Baths
    • 6,398 Sq Ft
    • 1350 Orchard Ridge Rd
    • Bloomfield Hills, MI

    Seize the rare opportunity, now with a $500K REDUCTION, to own an estate-sized property in the heart of Bloomfield Hills, surrounded by multi-million dollar homes. Set on nearly 3 acres of pristine land, this remarkable estate offers unparalleled privacy and exclusivity, with its own tennis court and ample space to design a custom pool. Located in one of Bloomfield Hills’ most sought-after

    Tushar Vakhariya KW Domain

    Section Image
  • 2748 Turtle Lake Dr, Bloomfield Hills, MI 48302

    $2,298,000

    • 5 Beds
    • 7 Baths
    • 4,983 Sq Ft
    • 2748 Turtle Lake Dr
    • Bloomfield Hills, MI

    Experience true luxury in this meticulously remodeled 5-bedroom, 5.2 bath, 4,983 sq.ft. colonial located in an exclusive gated community. The home’s all-limestone exterior and newly painted interior/exterior create a timeless, elegant look. Inside, discover a state-of-the-art kitchen outfitted with Bertazzoni appliances, stunning Calacatta Berlin granite countertops, and custom Ridge cabinetry

    Mark Zawaideh EXP Z Real Estate

    Section Image
  • 2937 Turtle Pond Ct Unit 40, Bloomfield Hills, MI 48302

    $2,390,000

    • 4 Beds
    • 6 Baths
    • 5,285 Sq Ft
    • 2937 Turtle Pond Ct
    • Unit 40
    • Bloomfield Hills, MI

    This stunning French Country estate, nestled within the prestigious, gated Turtle Lake community, offers an exceptional blend of luxury and comfort. The home showcases a custom granite facade, a newer cedar shake roof, copper gutters, and a beautifully laid brick-paver driveway. Impeccably maintained, this home is ready for you to move in and enjoy. Enjoy breathtaking views of Turtle Pond,

    Katherine Broock Max Broock, REALTORS®-Birmingham

    Section Image
  • 2779 Turtle Lake Dr, Bloomfield Hills, MI 48302

    $3,699,900

    • 4 Beds
    • 7 Baths
    • 4,568 Sq Ft
    • 2779 Turtle Lake Dr
    • Bloomfield Hills, MI

    Stunning 5BR/4.3BA residence in the exclusive gated community of Turtle Lake, offering over 7,300 SF of luxurious living space (4,568 SF above grade + 2,800 SF finished lower level). This listing also includes the adjacent lot at 2785 Turtle Lake Dr, adding an additional 0.97 acres providing both privacy and opportunity for future expansion or development. The main level features a spacious great

    Marisa Thomas DOBI Real Estate

    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
Ayar Vincent $2,350,000 None Available
Dlj Mortgage Capital Inc -- None Available
Washington Mutual Bank $662,432 None Available
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ayar Vince $1,537,000
Closed Ayar Vincent $619,300
Closed Ayar Vincent $300,000
Closed Ayar Vincent $1,645,000
Previous Owner Kinra Diwakar $995,000
Previous Owner Kinra Diwakar $240,000
Previous Owner Kinra Diwakar $1,450,000
Previous Owner Kinra Diwakar $128,000
Previous Owner Kinra Diwakar $417,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/06/2019 06/06/19 Sold $2,350,000 -6.0% $294 / Sq Ft
04/22/2019 04/22/19 Pending -- -- --
03/21/2019 03/21/19 For Sale $2,499,000 0.0% $312 / Sq Ft
03/15/2017 03/15/17 Rented $12,000 -20.0% --
02/03/2017 02/03/17 Under Contract -- -- --
10/18/2016 10/18/16 For Rent $15,000 +50.8% --
02/13/2013 02/13/13 Rented $9,950 0.0% --
02/11/2013 02/11/13 Under Contract -- -- --
12/19/2012 12/19/12 For Rent $9,950 -- --
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 $22,541 $1,433,910 $0 $0
2023 $21,814 $1,275,930 $0 $0
2022 $40,993 $1,098,450 $0 $0
2021 $42,436 $1,108,770 $0 $0
2020 $21,588 $1,134,790 $0 $0
2019 $41,402 $1,129,620 $0 $0
2018 $49,990 $1,115,340 $0 $0
2017 $45,499 $1,082,520 $0 $0
2016 $45,353 $1,107,710 $0 $0
2015 -- $1,088,330 $0 $0
2014 -- $990,900 $0 $0
2011 -- $658,130 $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: 219023169

Realcomp

APN: 19-19-428-007