Welcome to this stunning 3,600 sq ft waterfront colonial in Shelby Township’s highly sought-after Diegel Farms community, located within award-winning Utica Community Schools.
This exceptional 5-bedroom, 4 full and 1 half bath home offers breathtaking pond views and beautifully designed living spaces throughout. The chef’s kitchen features granite countertops, a walk-in pantry, and a butler’s bar connecting the dining room and breakfast nook—perfect for everyday living and entertaining.
The finished walkout lower level is built for entertaining with a full bar, fireplace lounge, additional bedroom and bath, and private sauna. Step outside to enjoy the swimmable waterfront pond, ideal for fishing, paddle boating, canoeing, or relaxing along the shore.
With a 3-car garage, spacious living areas, and incredible waterfront setting, this home offers the perfect blend of comfort, luxury, and lifestyle.
Sold for $840,000
$840,000
54468 Flamingo Dr, Shelby Township, MI 48315
4beds
5,106sqft
Single Family Residence
Built in 2005
0.27 Acres Lot
$847,400 Zestimate®
$165/sqft
$5,094 Estimated rent
Home value
$847,400
$805,000 - $890,000
$5,094/mo
Zestimate® history
Owner options
List your home for rent
$5,094/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$5,094/mo
Rent Zestimate®
Refinance and save
$6,055/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$6,055/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked:
Listing updated:
Listed by:
Samantha Phillips 248-590-0800,
KW Domain
Bought with:
Aisar Auayd, 6501417187
Michigan Homes Realty Group
Source: Realcomp II,MLS#: 20261010854
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Bedroom
- Level: Second
- Area: 156
- Dimensions: 13 X 12
Bedroom
- Level: Second
- Area: 180
- Dimensions: 15 X 12
Bedroom
- Level: Second
- Area: 294
- Dimensions: 21 X 14
Bedroom
- Level: Basement
- Area: 156
- Dimensions: 13 X 12
Primary bathroom
- Level: Second
Other
- Level: Second
Other
- Level: Second
Other
- Level: Basement
Other
- Level: Entry
Other
- Level: Entry
- Area: 182
- Dimensions: 14 X 13
Great room
- Level: Entry
- Area: 391
- Dimensions: 23 X 17
Kitchen
- Level: Entry
- Area: 234
- Dimensions: 18 X 13
Library
- Level: Entry
- Area: 130
- Dimensions: 13 X 10
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Built In Refrigerator, Bar Fridge, Dishwasher, Disposal, Double Oven, Dryer, Free Standing Refrigerator, Gas Cooktop, Microwave, Stainless Steel Appliances, Trash Compactor, Washer, Wine Refrigerator
Features
- Basement: Finished,Walk Out Access
- Has fireplace: Yes
- Fireplace features: Basement, Epa Qualified Fireplace, Gas, Great Room
Interior area
- Total interior livable area: 5,106 sqft
- Finished area above ground: 3,606
- Finished area below ground: 1,500
Property
Parking
- Total spaces: 3
- Parking features: Three Car Garage, Attached, Direct Access, Electricityin Garage, Garage Faces Side, Side Entrance
- Garage spaces: 3
Features
- Levels: Three
- Stories: 3
- Entry location: GroundLevelwSteps
- Patio & porch: Deck, Patio
- Pool features: None
- On waterfront: Yes
- Waterfront features: Beach Front, Direct Water Frontage, Lake Front, No Motor Lake, Pond, Waterfront
- Body of water: Diegel Pond
Lot
- Size: 0.27 Acres
- Dimensions: 90 x 130
Details
- Parcel number: 0711229006
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Brick, Wood Siding
- Foundation: Basement, Poured, Sump Pump
- Roof: Asphalt
Condition
- New construction: No
- Year built: 2005
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
Community
- Subdivision: DIEGEL FARMS SUB 3
HOA
- Has HOA: Yes
- HOA fee: $545 annually
- HOA phone: 248-655-1500
Location
- Region: Shelby Township
Financial & listing details
- Price per square foot: $165/sqft
- Tax assessed value: $315,525
- Annual tax amount: $9,568
- Date on market: 3/13/2026
- Cumulative days on market: 5 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 4/27/2026 | Sold | $840,000+1.2%$165/sqft |
Source:  Realcomp II #20261010854 Report a problem | ||
| 3/16/2026 | Pending sale | $830,000$163/sqft |
Source: Realcomp II #20261010854 Report a problem | ||
| 3/13/2026 | Listed for sale | $830,000+45.6%$163/sqft |
Source: Realcomp II #20261010854 Report a problem | ||
| 4/26/2016 | Sold | $570,000-5%$112/sqft |
Source:  MiRealSource #31278777 Report a problem | ||
| 3/21/2016 | Pending sale | $599,900$117/sqft |
Source: CENTURY 21 Town & Country #31278777 Report a problem | ||
| 2/6/2016 | Listed for sale | $599,900+8.1%$117/sqft |
Source: Century 21 Town & Country-Utica #216009629 Report a problem | ||
| 7/31/2007 | Sold | $555,000$109/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $9,415 +5% | $376,900 +3.5% |
| 2024 | $8,964 +5.3% | $364,200 +9.5% |
| 2023 | $8,513 +2.8% | $332,700 +11.5% |
| 2022 | $8,281 +0.7% | $298,500 +3.5% |
| 2021 | $8,224 | $288,500 +3.7% |
| 2020 | $8,224 +8.5% | $278,100 -2.2% |
| 2019 | $7,581 +3.1% | $284,400 +11% |
| 2018 | $7,355 +34.9% | $256,200 +15.2% |
| 2017 | $5,451 | $222,300 |
| 2016 | $5,451 | $222,300 +9.2% |
| 2015 | $5,451 | $203,650 |
| 2012 | -- | -- |
| 2009 | -- | -- |
| 2001 | $404 -62.5% | $8,840 +3.2% |
| 2000 | $1,079 | $8,570 |
Find assessor info on the county website
Neighborhood: 48315
Nearby homes
- $861,6004 bd4 ba5.8k sqft54496 Flamingo Dr, Shelby Township, MI 48315Off Market
- $847,1005 bd5 ba3.8k sqft54412 Flamingo Dr, Shelby Township, MI 48315Off Market
- $624,8005 bd5 ba3.1k sqft54473 Flamingo Dr, Shelby Township, MI 48315Off Market
- $729,8004 bd3 ba3.7k sqft54524 Flamingo Dr, Shelby Township, MI 48315Off Market
- $788,8004 bd4 ba3.7k sqft54386 Flamingo Dr, Shelby Township, MI 48315Off Market
- $850,0004 bd5 ba5k sqft54381 Pelican Ln, Shelby Township, MI 48315Pending
- $560,0000.25 Acres54393 Pelican Ln, Shelby Township, MI 48315Off Market
- $557,1003 bd2 ba2.6k sqft54401 Flamingo Dr, Shelby Township, MI 48315Off Market
Nearby schools
GreatSchools rating
- 8/10Crissman Elementary SchoolGrades: PK-6Distance: 1.4 mi
- 7/10Malow Junior High SchoolGrades: 7-9Distance: 2.6 mi
- 9/10Eisenhower High SchoolGrades: 10-12Distance: 2.5 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$847,400
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$847,400
- Michigan
- Macomb County
- Shelby Township
- 48315
- 54468 Flamingo Dr
Nearby cities
Nearby zip codes
Other Shelby Township Topics
