Seller's Agent in 2012
John Goodman
Century 21 Curran & Oberski
(248) 532-0608
86 in this area
530 Total Sales
47725 Bellagio Dr Unit 42 Northville, MI 48167
Estimated Value: $2,581,115 - $2,846,000
5
Beds
8
Baths
6,956
Sq Ft
$390/Sq Ft
Est. Value
Highlights
- Tennis Courts
- 1 Acre Lot
- Fireplace in Primary Bedroom
- Moraine Elementary School Rated A+
- Colonial Architecture
- Deck
About This Home
As of August 2012Spectacular Bellagio mansion! 2 story foyer w/circular staircase, limestone, marble, granite & hardwood t/o! 4 f/p's, rear staircase, gourmet kitchen, 10'ceiling on 1st floor,sound system t/o,custom decor t/o,4 car garage w/bonus rm. over garage. Fabulous walkout w/2 f/p's,family rm., 2 baths,home theater, 5th bdrm., wine cellar, office, workout rm. All bedroom's are suites, stone exterior, tennis ct., concrete deck, stone patio's,all M/D approx.
Home Details
Home Type
- Single Family
Est. Annual Taxes
Year Built
- Built in 2004
Lot Details
- 1 Acre Lot
- Gated Home
- Wooded Lot
HOA Fees
- $192 Monthly HOA Fees
Home Design
- Colonial Architecture
- Stone Siding
Interior Spaces
- 6,956 Sq Ft Home
- 1.5-Story Property
- Wet Bar
- Central Vacuum
- Bar Fridge
- Gas Fireplace
- Family Room with Fireplace
- Great Room with Fireplace
- Living Room with Fireplace
- Security System Owned
Kitchen
- Microwave
- Dishwasher
- Trash Compactor
- Disposal
Bedrooms and Bathrooms
- 5 Bedrooms
- Fireplace in Primary Bedroom
- Jetted Tub in Primary Bathroom
Finished Basement
- Walk-Out Basement
- Sump Pump
- Fireplace in Basement
Parking
- 4 Car Attached Garage
- Garage Door Opener
Eco-Friendly Details
- Air Purifier
Outdoor Features
- Tennis Courts
- Deck
- Patio
- Exterior Lighting
- Breezeway
- Porch
Utilities
- Forced Air Heating and Cooling System
- Humidifier
- Heating System Uses Natural Gas
- Natural Gas Water Heater
- Cable TV Available
Community Details
- Bellagio Condo Subdivision
Listing and Financial Details
- Assessor Parcel Number 2232278021
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Dec 21, 2012
Sold by
Sandhu Jatinder Bir and Sandhu Roop
Bought by
Sandhu Jatinder Bir and Sandhu Roop
Total Days on Market
24
Current Estimated Value
Purchase Details
Listed on
Jun 18, 2012
Closed on
Aug 30, 2012
Sold by
Lidstrom Nicklas and Lidstrom Annika
Bought by
Sandhu Jatinder Bir and Sandhu Roop
Seller's Agent
John Goodman
Century 21 Curran & Oberski
Buyer's Agent
Jennifer Sgroi
3DX Real Estate LLC
List Price
$2,900,000
Sold Price
$2,250,000
Premium/Discount to List
-$650,000
-22.41%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.45%
Purchase Details
Closed on
Sep 26, 2005
Sold by
Lidstrom Nicklas
Bought by
Lidstrom Nicklas and Lidstrom Annika
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,000,000
Interest Rate
5.87%
Mortgage Type
Stand Alone Refi Refinance Of Original Loan
Purchase Details
Closed on
Jan 31, 2005
Sold by
Casa Bellagio Llc
Bought by
K A S L Properties 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,000,000
Interest Rate
5.67%
Mortgage Type
Unknown
Purchase Details
Closed on
Aug 31, 2004
Sold by
Cerretani James M and Cerretani Robin
Bought by
Casa Bellagio Llc
Purchase Details
Closed on
Jan 16, 2004
Sold by
Novi Investment Co Ii Llc
Bought by
Cerretani James M and Cerretani Robin
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
Average Home Value in this Area
Purchase History
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| Sandhu Jatinder Bir | -- | None Available | |
| Sandhu Jatinder Bir | $2,250,000 | None Available | |
| Lidstrom Nicklas | -- | Greco | |
| Lidstrom Nicklas | -- | Greco | |
| K A S L Properties Llc | -- | -- | |
| Casa Bellagio Llc | -- | -- | |
| Cerretani James M | $280,000 | First Michigan Title Inc |
Source: Public Records
Mortgage History
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | Lidstrom Nicklas | $2,000,000 | |
| Previous Owner | K A S L Properties Llc | $2,000,000 |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 08/30/2012 08/30/12 | Sold | $2,250,000 | -22.4% | $323 / Sq Ft |
| 07/12/2012 07/12/12 | Pending | -- | -- | -- |
| 06/18/2012 06/18/12 | For Sale | $2,900,000 | -- | $417 / Sq Ft |
Source: Realcomp
Tax History Compared to Growth
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 |
|---|---|---|---|---|
| 2023 | $34,672 | $1,136,820 | $0 | $0 |
| 2022 | $35,654 | $1,034,470 | $0 | $0 |
| 2020 | $30,823 | $1,071,150 | $161,000 | $910,150 |
| 2015 | -- | $940,200 | $0 | $0 |
| 2014 | -- | $933,700 | $0 | $0 |
| 2011 | -- | $762,350 | $0 | $0 |
Source: Public Records
Agents Affiliated with this Home
-
John Goodman
-
Jennifer Sgroi
J
Buyer's Agent in 2012
Jennifer Sgroi
3DX Real Estate LLC
(888) 304-1447
5 Total Sales
Map
Similar Homes in the area
-
$2,900,000
- 7 Beds
- 8 Baths
- 6,582 Sq Ft
- 47490 Bellagio Dr
- Unit 2
- Northville, MI
This custom estate home, totally renovated in 2024, is nestled in the prestigious, gated Bellagio community. Set on a beautifully landscaped lot with a circular driveway, this exquisite residence spans over 6,500 sq ft of above grade living space and includes a 4-car attached garage with custom mirrored doors. The home boasts new windows, new hardwood flooring, custom light fixtures, automatic
Bill Gardner @properties Christie's Int'l RE Northville
-
$3,399,000
- 7 Beds
- 9 Baths
- 11,434 Sq Ft
- 590 Dubuar St
- Northville, MI
Discover an extraordinary opportunity to own Michigan’s most prestigious estate, Castello Montebello—a grand Classic European-style residence spanning over 15,000 square feet of unparalleled luxury. Perched on 2.3 meticulously maintained, gated acres at the highest elevation in Wayne County, this architectural gem offers both privacy and convenience, just a short walk from Historic Downtown
Dylan Tent Signature Sotheby's International Realty Nvl
Source: Realcomp
MLS Number: 212062335
APN: 22-32-278-021
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
IDX provided courtesy of Realcomp II Ltd. via Ten-X and MLS
Copyright 2025 Realcomp II Ltd. Shareholders
IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393
Nearby Homes
- 47490 Bellagio Dr Unit 2
- 21859 Barclay Dr
- 48000 8 Mile Rd
- 47900 W 9 Mile Rd
- 46821 Elmsmere Dr
- 48002 Eight Mile W
- 20665 Woodbend Dr
- 900 Andover Dr
- 23261 Argyle St
- 23102 Argyle St
- 45831 Sheffield Dr
- 49351 Villa Ct
- 822 Springfield Dr
- 22098 Worcester Dr
- 21044 Palomino Dr
- 49825 9 Mile Rd
- 1048 Bristol Ct
- 49588 Villa Dr
- 20900 Taft Rd
- 21082 Boulder Cir Unit 303