54245 Queensborough, Shelby, MI 48315

Local realty services provided by:CENTURY 21 Realty North
54245 Queensborough,Shelby Twp, MI 48315
$1,349,900
  • 5 Beds
  • 5 Baths
  • 4,980 sq. ft.
  • Single family
  • Active
Listed by: kevin kostka
Office: epique inc.
MLS#:50209172
Source:MI_REALSOURCE

Price summary

  • Price:$1,349,900
  • Price per sq. ft.:$159.92
  • Monthly HOA dues:$50

About this home

Welcome to an extraordinary luxury estate nestled in one of the most exclusive enclaves of Shelby Township; Lake in The Woods. Offering nearly 5,000 square feet of impeccably maintained above-grade living space, plus an additional 3,000 square feet of beautifully finished walkout lower level living, this exceptional residence delivers the perfect blend of elegance, comfort, and functionality. Designed with both everyday living and entertaining in mind, the home features a dramatic two-story great room filled with natural light, creating a stunning focal point and an incredible sense of openness throughout the main living area. The spacious kitchen is complemented by a dedicated dining area large enough to comfortably accommodate even the largest of families, making it the perfect setting for gatherings and entertaining alike. A convenient first-floor laundry room further enhances the home’s thoughtful and functional layout. Two spacious first-floor primary suites each offer privacy...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2009
  • Listing ID #:50209172
  • Added:5 day(s) ago
  • Updated:June 02, 2026 at 10:14 AM

Rooms and interior

  • Bedrooms:5
  • Total bathrooms:5
  • Full bathrooms:4
  • Half bathrooms:1
  • Flooring:Ceramic Floors, Hardwood Floors
  • Dining Description:On Entry Level
  • Kitchen Description:Bar-Refrigerator, Dishwasher, Disposal, On Entry Level, Range/Oven, Refrigerator
  • Bedroom Description:Bedroom 1 on Entry Level, Bedroom 2 on Entry Level, Bedroom 3 on Second Level, Bedroom 4 on Second Level, Bedroom 5 in Basement
  • Basement Description:Finished, Poured, Walk Out
  • Living area:4,980 sq. ft.

Heating and cooling

  • Cooling:Central A/C
  • Heating:Forced Air, Natural Gas

Structure and exterior

  • Year built:2009
  • Building area:4,980 sq. ft.
  • Lot area:0.65 Acres
  • Architectural Style:Split Level
  • Construction Materials:Brick, Stone
  • Exterior Features:Patio, Porch
  • Foundation Description:Basement, Poured
  • Levels:1 1/2 Story

Utilities

  • Water:Public Water
  • Sewer:Public Sanitary

Finances and disclosures

  • Price:$1,349,900
  • Price per sq. ft.:$159.92
  • Tax amount:$17,538

Features and amenities

  • Appliances:Dishwasher, Disposal, Dryer, Humidifier, Range/Oven, Refrigerator, Washer
  • Laundry features:Dryer, Washer
  • Amenities:9 ft + Ceilings, Bay Window, Cable/Internet Available, Cathedral/Vaulted Ceiling, Dogs Allowed, Interior Balcony, Security System, Walk-In Closet, Window Treatment(s)

Parking

  • Parking description:3 or More Spaces, Attached Garage, Electric in Garage, Garage, Garage Door Opener
  • Garage spaces:3