4790 Queens Ct
Gladwin, MI 48624
5 Beds
2.5 Baths
2,024 sqft (on 0.51 acres)
5 Beds
2.5 Baths
2,024 sqft
(on 0.51 acres)
Local Information
© Google
-- mins to
Description
Waterfront Home on All-Sports private lake. Beautiful 1/2 acre lot on Lake Lancelott. This 5BR/3BA Ranch style home has sandy beach area , removable dock, mature trees, full basement. 2 plus car garage. Home is 2024 square feet of open living space with vaulted ceiling and large door walls that give you beautiful water views. Home is in perfect condition throughout with updated quarts kitchen counters. Come enjoy all the ammenities of Sugar Springs with two gorgeous lakes, two beautiful golf courses, restaurant and pub, heated saline indoor pool and fitness center, tennis, activity centers, beaches and picnic areas with bath houses, boat slips, boat launces, and much more!!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources. This description is from July 19, 2023
Home Highlights
Parking
Garage
Outdoor
Deck
A/C
Heating & Cooling
HOA
$53/Monthly
Price/Sqft
No Info
Listed
180+ days ago
Home Details for 4790 Queens Ct
|
|---|
Interior Details Basement: Block,Full,Sump Pump,Crawl SpaceNumber of Rooms: 11Types of Rooms: Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bathroom 1, Bathroom 2, Dining Room, Great Room, Kitchen, Living Room |
Beds & Baths Number of Bedrooms: 5Main Level Bedrooms: 5Number of Bathrooms: 3Number of Bathrooms (full): 2Number of Bathrooms (half): 1Number of Bathrooms (main level): 2 |
Dimensions and Layout Living Area: 2024 Square Feet |
Appliances & Utilities Utilities: Cable Available, Natural Gas Connected, Phone Connected, Sewer Connected, Underground Utilities, Water Connected, Internet DSL Available, Internet SpectrumAppliances: Electric Water HeaterLaundry: Main Level |
Heating & Cooling Heating: Forced Air,Natural Gas,Space HeaterHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air |
Fireplace & Spa Number of Fireplaces: 1No Fireplace |
Windows, Doors, Floors & Walls Flooring: Wood |
Levels, Entrance, & Accessibility Stories: 1Levels: OneFloors: Wood |
|
|---|
Exterior Home Features Patio / Porch: DeckFoundation: BasementNo Private Pool |
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageNo Attached GarageNo Open ParkingParking Spaces: 3Parking: 3 or More Spaces,Detached |
Frontage WaterfrontWaterfront: All Sports Lake, Boat Facility, Dock/Pier Facility, Lake Front, Waterfront, Beach Front, Sandy BottomRoad Frontage: CountryOn Waterfront |
Water & Sewer Sewer: Public SanitaryWater Body: Lake Lancelott |
Farm & Range Frontage Length: 115 |
Finished Area Finished Area (above surface): 2024 Square Feet |
|
|---|
Cumulative Days on Market: 72 |
|
|---|
Year Built Year Built: 1973 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: ResidentialArchitecture: Ranch |
Building Construction Materials: Vinyl SidingNot a New Construction |
Property Information Parcel Number: 06016000013000 |
|
|---|
Price List Price: $499,900 |
Status Change & Dates Off Market Date: Fri Jun 30 2023Possession Timing: Close Of Escrow |
|
|---|
MLS Status: Closed |
|
|---|
Direction & Address City: GladwinCommunity: Sugar Springs |
School Information Elementary School District: Gladwin Community SchoolsJr High / Middle School District: Gladwin Community SchoolsHigh School District: Gladwin Community Schools |
|
|---|
Building Area Building Area: 3424 Square Feet |
|
|---|
HOA Name: Sugar SpringsAssociation for this Listing: Clare Gladwin Board of REALTORSHas an HOAHOA Fee: $630/Annually |
|
|---|
Lot Area: 0.51 acres |
|
|---|
Special Conditions: Private |
|
|---|
Listing Agreement Type: Exclusive Right To SellListing Terms: Cash, Conventional |
|
|---|
BasementMls Number: 50106299Above Grade Unfinished Area: 2024Days In Mls: 71 |
Last check for updates: about 6 hours ago
Listed by ALMA HORTON TIER, (989) 948-4509
SUGAR SPRINGS REAL ESTATE
Bought with: IVIE BAKER, (989) 429-0124, Baker-Kehoe Realty LLC
Originating MLS: Clare Gladwin Board of REALTORS
Source: MiRealSource, MLS#50106299
Price History for 4790 Queens Ct
| Date | Price | Event | Source |
|---|---|---|---|
| 07/14/2023 | $456,000 | Sold | MiRealSource #50106299 |
| 06/30/2023 | $499,900 | Pending | MiRealSource #50106299 |
| 06/05/2023 | $499,900 | PriceChange | MiRealSource #50106299 |
| 04/20/2023 | $529,000 | Listed For Sale | MiRealSource #50106299 |
| 02/27/1996 | $120,100 | Sold | N/A |
- Results are loading
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $9,846 |
| Assessment | $487,400 |
Home facts updated by county records
Comparable Sales for 4790 Queens Ct
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.19 | Single-Family Home | $458,000 | 11/04/25 | 3 | 2 | 1,976 | |
0.28 | Single-Family Home | $525,000 | 10/31/25 | 3 | 2 | 1,962 | |
0.43 | Single-Family Home | $570,000 | 08/14/25 | 4 | 3 | 2,010 | |
0.39 | Single-Family Home | $495,000 | 10/24/25 | 3 | 2.5 | 2,994 | |
0.35 | Single-Family Home | $231,500 | 11/07/25 | 3 | 3 | 2,552 | |
0.54 | Single-Family Home | $365,000 | 12/30/25 | 3 | 2 | 2,630 | |
0.64 | Single-Family Home | $630,000 | 06/25/25 | 3 | 3 | 2,044 | |
0.50 | Single-Family Home | $225,225 | 10/09/25 | 3 | 2 | 1,482 | |
0.39 | Single-Family Home | $240,000 | 12/29/25 | 2 | 2 | 1,296 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.
OFF MARKETSUGAR SPRINGS REAL ESTATE
FOR SALE0.61 ACRESParker Real Estate Group
SOLDNOV 4, 2025@properties Christie's Int'l R E Rochester
Assigned Schools
These are the assigned schools for 4790 Queens Ct.
- Gladwin Junior High School
- 6-8
- Public
- 389 Students
6/10GreatSchools RatingParent Rating AverageI get bullied and verbally harassed my the boys in my grade.the way the math teachers make us do the math makes it too complicated.people write on the bathroom walls. I wouldn’t recommend doing sparks they barely even actually help with homework the just put the kids with work in a room. The teachers assign to much work within a day.the only good teachers are Mr.Baginski, Mr.Cooper, Mrs.Hite, Mrs.Sapienza, and Mr.Salsburry. Overall I would recommend gladwin schools for your kid coming from a student/seventh graderStudent Review1y ago - Gladwin Elementary School
- PK-2
- Public
- 373 Students
NAGreatSchools RatingParent Rating AverageThe principal has lied to me and my wife on multiple occasions about the bullying of our daughter. When the teacher tried to do something about it she was reprimanded for reprimanding the student who was bullying our daughter. We removed our children from this school and homeschooled them. They have excelled in their learning. They also could not keep our one son from being bored to death in his class. He was not challenged by the work the school gave him. He would have his homework done before he left class and still had time and got in trouble for disrupting the class.Parent Review8y ago - Gladwin Intermediate School
- 3-5
- Public
- 382 Students
6/10GreatSchools RatingParent Rating AverageThis school is rude for their kids And it's giving kids bladder infections I'm not letting them go to the bathroom My childEvery year that she's been there At least one timeA year she comes back and such Peter pants because the teachers wouldn't let her go to the bathroom out ofAll the things I've experienced from the school 0 out of 10 Rating But next year My child won't be in this schoolParent Review3mo ago - Gladwin High School
- 9-12
- Public
- 447 Students
9/10GreatSchools RatingParent Rating AverageN/AParent Review16y ago 
Check out schools near 4790 Queens Ct.
What Locals Say about Gladwin
At least 32 Trulia users voted on each feature.
82 % Say car is needed
79 % Say yards are well-kept
77 % Say parking is easy
74 % Say it's dog friendly
68 % Say kids play outside
68 % Say people would walk alone at night
67 % Say it's quiet
67 % Say there's wildlife
58 % Say there's holiday spirit
57 % Say it's walkable to restaurants
57 % Say neighbors are friendly
57 % Say there are sidewalks
44 % Say they plan to stay for at least 5 years
43 % Say it's walkable to grocery stores
32 % Say streets are well-lit
29 % Say there are community events
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
- Results are loading
Homes for sale near 4790 Queens Ct
1.7 ACRES@properties Christie's Int'l R E Rochester
See more homes for sale inGladwin
Off Market Homes Near 4790 Queens Ct
SOLDMAY 13, 2026SUGAR SPRINGS REAL ESTATE
SOLDAPR 30, 2026Baker-Kehoe Realty LLC
SOLDAPR 29, 2026Keller Williams Preferred
SOLDFEB 20, 2026HOWARD HANNA REAL ESTATE SERVI
SOLDJAN 5, 2026Century 21 Curran & Oberski
SOLDNOV 14, 2025Keller Williams Paint Creek
SOLDNOV 10, 2025CGBOR Guest Listings- See more homes for sale inGladwin
Source MLS: MiRealSource
Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Click here for more information
The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Click here for more information
Homes for rent near 4790 Queens Ct
- Results are loading
4790 Queens Ct, Gladwin, MI 48624 is a 5 bedroom, 3 bathroom, 2,024 sqft single-family home built in 1973. This property is not currently available for sale. 4790 Queens Ct was last sold on Jul 14, 2023 for $456,000 (9% lower than the asking price of $499,900). The current Trulia Estimate for 4790 Queens Ct is $501,500.