$5,400,000
SOLD OCT 25, 2024

2575 Hiller Rd West Bloomfield, MI 48324

5 Beds
7 Baths
10,000 Sq Ft
2.5 Acres

Recently Sold

$540 Per Sq Ft

10% Below List Price

37 Days on Market

Highlights

  • 100 Feet of Waterfront
  • Built-In Freezer
  • Colonial Architecture
  • New Construction
  • 2.5 Acre Lot
  • Jetted Tub in Primary Bathroom

About This Home

As of October 2024

Brand new construction estate located on approximately 2.5 acres on all-sports Cass Lake. This luxurious home offers over 10,000 sqft of living space, not including the walk-out lower level. The first-floor primary suite features large walk-in closets and a euro style bath. The chef’s kitchen is equipped with high-end cabinetry and state-of-the-art appliances, along with an additional prep kitchen. The bright, open floor plan boasts floor-to-ceiling windows, and all bedrooms come with private baths and large custom closets. The property includes a 5-car attached garage, a professionally landscaped yard, and is prepped for a gate. There’s ample space for a pool and sport court. An incredible opportunity to move right in and avoid the hassle of building! Designed by DBE Design Build Engineer and Edward Born Engineer, with exterior elevation by Paul Butalia. This estate exemplifies architectural excellence. Featuring full low voltage system including alarm, music, cameras, and a whole-house intercom system. The property boasts a heated 5-car garage, the exterior includes brick paver and exposed concrete walkways, a master suite with a balcony, custom walk-in closets, heated bathroom flooring and towel bars, and porcelain walls and floors. Enjoy the concrete deck patio with aluminum railings and ample guest parking. Inside, there are two custom kitchens: a master kitchen and a butler kitchen, supported by 4 furnaces and 4 AC units, and generator-ready capabilities. The home features a walk-out basement and a shingled and metal architectural roof. With 99 feet of lake frontage, the property includes a lake irrigation system pump and both power and fresh water lines at the lake. This estate offers unparalleled luxury and convenience on a private lot, making it the perfect home for both entertaining and tranquil lakefront living. Don’t miss the chance to own this exceptional property!

Last Agent to Sell the Property

Tushar Vakhariya

KW Domain License #6501279268 Listed on: 08/03/2024

KW Domain

Co-Listed By

Amy Jindo

Max Broock Realtors License #6501369091

Last Buyer's Agent

Joseph Sesi

EXP Realty Main License #6506048975

EXP Realty Main

Home Details

Home Type

  • Single Family

Est. Annual Taxes

Year Built

  • Built in 2023 | New Construction

Lot Details

  • 2.5 Acre Lot
  • Lot Dimensions are 239x634x98x660
  • 100 Feet of Waterfront
  • Lake Front
  • Fenced
  • Sprinkler System

Home Design

  • Colonial Architecture
  • Brick Exterior Construction
  • Poured Concrete
  • Asphalt Roof
  • Metal Roof
  • Stone Siding
  • Stucco
  • Cedar

Interior Spaces

  • 10,000 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Furnished or left unfurnished upon request
  • Sound System
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace

Kitchen

  • Double Self-Cleaning Convection Oven
  • Gas Cooktop
  • Range Hood
  • Recirculated Exhaust Fan
  • Microwave
  • Built-In Freezer
  • Ice Maker
  • Dishwasher
  • Stainless Steel Appliances
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Dual Flush Toilets
  • Jetted Tub in Primary Bathroom

Laundry

  • Dryer
  • Washer

Unfinished Basement

  • Walk-Out Basement
  • Natural lighting in basement

Home Security

  • Security System Owned
  • Carbon Monoxide Detectors

Parking

  • 5 Car Direct Access Garage
  • Heated Garage

Outdoor Features

  • Balcony
  • Covered Patio or Porch
  • Exterior Lighting

Location

  • Ground Level Unit

Utilities

  • Forced Air Heating and Cooling System
  • Humidifier
  • Vented Exhaust Fan
  • Heating System Uses Natural Gas
  • Net Metering or Smart Meter
  • 100 Amp Service
  • Tankless Water Heater
  • Natural Gas Water Heater
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 1809176006

Community Details

Recreation

  • Water Sports

Additional Features

  • No Home Owners Association
  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$70,099

Year Built

Built in 2023 | New Construction

Lot Details

0

Listing Details

  • Property Type: Residential
  • Architecture Style: Colonial
  • Architecture Level: 2 Story
  • Assessment: 492.00
  • Year Built: 2023
  • State Equalized Value: 1304120.0000
  • Foundation Features: Sealed Foundation
  • Entry Location: Ground Level
  • Special Features: NewHome
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Interior Amenities: Smoke Alarm, 100 Amp Service, Cable Available, Carbon Monoxide Alarm(s), Circuit Breakers, Dual-Flush Toilet(s), High Spd Internet Avail, Humidifier, Jetted Tub, Furnished - Negotiable, Security Alarm (owned), Sound System, Utility Smart Meter, Wet Bar
  • Fireplace: Yes
  • Fireplace Fuel: Gas
  • Fireplace Locations: Living Room
  • Room Count: 21
  • Total Bedrooms: 5
  • Total Bathrooms: 5.20
  • Full Bathrooms: 5
  • Half Bathrooms: 2
  • Basement: Yes
  • Basement Type: Daylight, Unfinished, Walkout Access
  • Kitchen Appliances: Vented Exhaust Fan, Built-In Freezer, Convection Oven, Dishwasher, Disposal, Double Oven, Dryer, Exhaust Fan, Free-Standing Refrigerator, Gas Cooktop, Ice Maker, Microwave, Range Hood, Self Cleaning Oven, Stainless Steel Appliance(s), Washer
  • Sq Ft Combined: 13411
  • Sq Ft Lower Floor: 3411
  • Total Sq Ft: 10000
  • Sq Ft Total Bsmt: 3411

Exterior Features

  • Roof Material: Asphalt, Metal
  • Waterfront Name: Cass Lake
  • Waterfront: Yes
  • Foundation Details: Basement
  • Construction Materials: Brick, Cedar, Stone, Stucco
  • Construction Features: New Construction
  • Exterior Features: Lighting
  • Foundation Materials: Poured
  • Frontage Feet: 165
  • Porch Type: Balcony, Patio, Patio - Covered
  • Road Frontage Type: Paved
  • Water Frontage Feet: 100.00
  • Waterfront Description: Direct Water Frontage, Lake Front, Water Front
  • Fencing: Fence Allowed

Garage/Parking

  • Garage Size: 5 Car
  • Garage Features: Side Entrance, Direct Access, Electricity, Heated, Attached
  • 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, Tankless
  • Water Source: Public (Municipal)
  • Laundry Facilities: Yes

Condo/Co-op/Association

  • Association Fee: No

Schools

  • School District: West Bloomfield

Lot Info

  • Lot Features: Sprinkler(s)
  • Lot Size Area: 2.50
  • Lot Dimensions: 239x634x98x660
  • Parcel Number: 1809176006

Tax Info

  • Tax Amount Summer: 52563.0000
  • Tax Amount Winter: 17536.0000
  • Total Tax: 70099.0000
  • Taxable Value: 1304120.0000

Multi Family

  • Waterfront Features: All Sports Lake, DIRFRT

MLS Schools

  • School District: West Bloomfield

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 3, 2024
Closed on
Oct 25, 2024
Sold by
Wh Construction Investments Llc
Bought by
Attisha Zeana and Attisha Saad
Seller's Agent
Tushar Vakhariya
KW Domain
Buyer's Agent
Joseph Sesi
EXP Realty Main
List Price
$5,999,900
Sold Price
$5,400,000
Premium/Discount to List
-$599,900
-10%
Views
81
Current Estimated Value
$4,065,336

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$1,334,664
Avg. Annual Appreciation
-26.80%
Original Mortgage
$3,000,000
Outstanding Balance
$2,969,909
Interest Rate
6.08%
Mortgage Type
New Conventional
Estimated Equity
$1,095,427

Purchase Details

Closed on
Feb 16, 2024
Sold by
Hannawa Wael W
Bought by
Wh Construction Investments Llc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,408,000
Interest Rate
6.66%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jul 24, 2023
Sold by
Wh Construction Investments Llc
Bought by
Hannawa Wad W

Purchase Details

Closed on
Jul 13, 2022
Sold by
Hannawa Wael W
Bought by
Wh Construction Investments Llc

Purchase Details

Listed on
May 16, 2019
Closed on
Aug 16, 2019
Sold by
Samona Sue B
Bought by
Hannawa Waei W
Seller's Agent
Tushar Vakhariya
KW Domain
Buyer's Agent
Tushar Vakhariya
KW Domain
List Price
$1,175,000
Sold Price
$1,125,000
Premium/Discount to List
-$50,000
-4.26%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
23.40%
Original Mortgage
$843,750
Interest Rate
3.7%
Mortgage Type
New Conventional

Purchase Details

Listed on
Aug 17, 2018
Closed on
Sep 13, 2018
Sold by
Jpmorgan Chase Bank Na
Bought by
Samona Sue B and Sbs Property Trust
Seller's Agent
Jason Megie
Preferred Realty Pros
Buyer's Agent
Jason Megie
Preferred Realty Pros
List Price
$999,900
Sold Price
$1,000,000
Premium/Discount to List
$100
0.01%

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 10, 2013
Sold by
Talmer Bank & Trust
Bought by
Jp Morgan Chase Bank N A

Purchase Details

Closed on
May 1, 2012
Sold by
Kays Zair and Zair Patrice
Bought by
Jpmorgan Chase Bank National Association

Purchase Details

Closed on
Mar 30, 2010
Sold by
Kays Zair and Zair Patrice
Bought by
Peoples State Bank

Purchase Details

Closed on
Oct 27, 1999
Sold by
Gloria M Robb Tr
Bought by
Kays Zair

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
7.81%

Purchase Details

Closed on
Sep 14, 1998
Sold by
Robb Jerome J
Bought by
Gloria M Robb Tr
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 -- Legacy Title
Warranty Deed -- Legacy Title
Quit Claim Deed -- None Listed On Document
Quit Claim Deed -- Premier Title
Quit Claim Deed -- None Listed On Document
Warranty Deed -- Legacy Title Agency
Deed $1,000,000 Bay National Title Company
Quit Claim Deed -- None Available
Sheriffs Deed $944,395 None Available
Sheriffs Deed $264,824 None Available
Deed $1,091,250 --
Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Previous Owner $2,408,000 New Conventional
Previous Owner $843,750 New Conventional
Previous Owner $1,000,000 No Value Available
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
10/25/2024 10/25/24 Sold $5,400,000 -10.0% $540 / Sq Ft
09/09/2024 09/09/24 Pending -- -- --
08/03/2024 08/03/24 For Sale $5,999,900 +433.3% $600 / Sq Ft
08/16/2019 08/16/19 Sold $1,125,000 -4.3% $217 / Sq Ft
07/01/2019 07/01/19 Pending -- -- --
05/16/2019 05/16/19 For Sale $1,175,000 +17.5% $227 / Sq Ft
09/26/2018 09/26/18 Sold $1,000,000 0.0% $193 / Sq Ft
08/23/2018 08/23/18 Pending -- -- --
08/17/2018 08/17/18 For Sale $999,900 -- $193 / 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 $67,905 $1,745,680 $0 $0
2022 $52,563 $1,131,460 $338,660 $792,800
2021 $26,672 $492,520 $0 $0
2020 $24,893 $629,310 $338,660 $290,650
2018 $31,536 $676,250 $309,280 $366,970
2015 -- $720,080 $0 $0
2014 -- $642,370 $0 $0
2011 -- $543,320 $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: 20240055777

Realcomp

APN: 18-09-176-006