Eco Friendly
Address
54150 Queensborough Drive, Shelby Charter Township, MI
Price
$ 1,100,000
Property Attributes
- ID#20261030783
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityShelby Charter Township
- AreaShelby Twp
- NeighborhoodLAKE IN THE WOODS SUB
- Zip48315
- StyleColonial
- Year Built2000
- Taxes$ 9164
- Price$ 1,100,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage6410
- Lot Size0.56 Acres
Data Source:
RealComp
Property Description
Welcome to this exceptional luxury estate nestled within the prestigious Lake in the Woods community of Shelby Township. Situated on a premium corner lot, this impressive brick colonial offers over 6,400 square feet of finished living space, including a beautifully finished walk-out lower level designed for both entertaining and everyday enjoyment. A grand two-story foyer welcomes you into a thoughtfully designed floor plan featuring 4 spacious bedrooms, 4.1 baths, a private library, formal dining room, and an expansive great room highlighted by a natural fireplace and soaring ceilings. The gourmet kitchen is appointed with premium appliances, including a built-in refrigerator, gas cooktop, double ovens, and a convenient butler's pantry. The luxurious primary suite serves as a private retreat, complete with a spa-inspired bath and generous closet space. The finished walk-out lower level provides exceptional additional living space with a fireplace, wet bar, and versatile recreation areas perfect for entertaining guests. Step outside to enjoy multiple patios, covered outdoor living spaces, professional landscaping, and a full sprinkler system. Residents enjoy annual HOA services include snow removal for added convenience. Meticulously maintained by its original owners, this home showcases true pride of ownership throughout. Recent improvements include updated ENERGY STAR forced air and central air systems (2023/2024), exterior repainting completed in 2025, and a Macomb County septic inspection passed in May 2026, providing peace of mind for the next owner. Completing the package is a side-entry 3-car garage and an ideal location within the award-winning Utica Community Schools district, just minutes from shopping, dining, and major commuter routes. This extraordinary residence offers the perfect blend of timeless elegance, modern efficiency, and luxury living.
| Price History | |
|---|---|
| 6/5/2026 | Listed $1,165,000 |
| 8/6/2026 | 1$1,164,999 |
| 8/14/2026 | 6$1,100,000 |
General Features
| Sewer | SepticTank |
|---|---|
| Heating | ENERGYSTARQualifiedFurnaceEquipment, ForcedAir, NaturalGas |
| Cooling | CeilingFans, CentralAir, ENERGYSTARQualifiedACEquipment |
| Utilities | CableAvailable, UndergroundUtilities |
| Possession | ClosePlus3To5Days |
| Roof | Asphalt |
| Appliances | BuiltInRefrigerator, BarFridge, Dishwasher, DoubleOven, Dryer, EnergyStarQualifiedDishwasher, GasCooktop, RangeHood, Washer |
| HOA Fee | 650.0 |
| Garage Spaces | 3.0 |
| Association Fee Includes | SnowRemoval |
| Patio/Porch Features | Covered, Patio, Terrace |
| Architectural Style | Colonial |
| Pool Features | None |
| Security Features | SecuritySystemOwned |
| Construction Materials | Brick |
| Pets Allowed | Yes |
| Year Built | 2000 |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| Accessibility | AccessibleHallways, CommonArea |
| Assoc Fee Paid Per | Annually |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | No |
| Subdivision Name | LAKE IN THE WOODS SUB |
| Garage Y/N | Yes |
| Total Rooms | 13 |
| Full Baths | 4 |
| Status | Active |
| Directions | Jewell Rd between 24 and 25 mile on the West side of the road. Enter the neighboorhood on Scarborough Dr, immediately take a left onto Tiverton Ln. Property is on the corner as you turn onto Queensbo |
| City | ShelbyCharterTownship_Macomb |
| Body of Water | Jewell Lake |
| Disclosures | TaxesHomesteadExempt |
| Entry Location | GroundLevelwSteps |
| Senior Community Y/N | No |
| High School District | Utica |
| MLS Area | Area03071ShelbyTwp |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 9164.16 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Standard Status | Active |
| Occupancy Type | Owner |
| Tax Assessed Value | 310272 |
| Expected Active Date | 2026-06-08 |
| MobileHomeRemainsYN | No |
| PostalCity | ShelbyTwp_Macomb |
| Legal Description | L 59 V LAKE IN THE WOODS SUB LOT 59 LIBER 6616 PAGES 737-767 |
Interior Features
| Interior Amenities | EntranceFoyer, HighSpeedInternet, WetBar |
|---|---|
| Basement | Finished, Full, WalkOutAccess |
| Fireplace Features | Basement, GreatRoom |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 4289.0 |
| Half Baths | 1 |
| Laundry Features | LaundryRoom |
| Total Bedrooms | 4 |
| Below Grade Finished Area | 2121.0 |
| WaterHeaterFuel | ENERGYSTARQualifiedWaterHeater, NaturalGas |
| LivingAreaSource | PublicRecords |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 5 |
Exterior Features
| Fencing | FencingRequiredwithPool |
|---|---|
| Parking Features | ThreeCarGarage, Attached, ElectricityinGarage, GarageDoorOpener, SideEntrance |
| Lot Features | CornerLot, Sprinklers |
| Water Source | Public |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 142x170x145x170 |
| Lot Size Acres | 0.56 |
| Waterfront Y/N | No |
| Road Frontage Type | Paved |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX provided courtesy of Realcomp II Ltd., via Taylor Office and The Originating MLS(found above), © 2026 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Data is updated as of September 17, 2026 11:17 AM UTC Information deemed reliable but not guaranteed.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd
Property vs Single Family Average in 48315
Price
Taxes
Year Built
Visits
