Welcome to an amazing waterfront property in Sugar Springs Development. The location offers 230 acres of private Lake Lancelot access along with a list of amenities available for your use. Golf, Club house, Indoor heated pool, Tennis, Pickle ball and Basketball Courts. A campground, trails to hike and cross country ski along with an air strip and more. This 4-bedroom, 2.5-bath well kept home has a comfortable floor plan giving incredible lake views from almost every seat in the house. Vaulted Living Room with a fireplace along with the loft accents the open floor plan. A dinning room off the kitchen ties into a sunroom and through the patio slider leads you to the composite deck for entertaining or relaxing. Located at the end of the Cul-de-sac adds to the privacy. This property has all the benefits of lakeside living with much more.
Active
$779,000
4760 Queens Ct, Gladwin, MI 48624
4beds
2,572sqft
Single Family Residence
Built in 1999
0.54 Acres Lot
$739,500 Zestimate®
$303/sqft
$54/mo HOA
What's special
Waterfront propertyComfortable floor plan
- 51 days
- 494
- 24
Zillow last checked:
Listing updated:
Listed by:
John Judge 231-645-9379,
Coldwell Banker Schmidt - Onekama 231-559-0147,
Jeff Pyciak 517-740-1726,
Coldwell Banker Schmidt - Onekama
Source: MichRIC,MLS#: 26051371
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
- Main level bedrooms: 1
Primary bedroom
- Level: Main
- Area: 272
- Dimensions: 16.00 x 17.00
Bedroom 2
- Level: Upper
- Area: 143
- Dimensions: 13.00 x 11.00
Bedroom 3
- Level: Upper
- Area: 143
- Dimensions: 13.00 x 11.00
Bedroom 4
- Level: Upper
- Area: 238
- Dimensions: 14.00 x 17.00
Primary bathroom
- Level: Main
- Area: 81
- Dimensions: 9.00 x 9.00
Bathroom 1
- Level: Main
- Area: 30
- Dimensions: 6.00 x 5.00
Bathroom 3
- Level: Upper
- Area: 65
- Dimensions: 13.00 x 5.00
Dining room
- Level: Main
- Area: 168
- Dimensions: 12.00 x 14.00
Family room
- Level: Upper
- Area: 392
- Dimensions: 28.00 x 14.00
Kitchen
- Level: Main
- Area: 176
- Dimensions: 11.00 x 16.00
Laundry
- Level: Main
- Area: 72
- Dimensions: 9.00 x 8.00
Living room
- Level: Main
- Area: 480
- Dimensions: 24.00 x 20.00
Other
- Level: Main
- Area: 180
- Dimensions: 15.00 x 12.00
Heating
- Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer, Water Softener Owned
- Laundry: Gas Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
Features
- Ceiling Fan(s), Center Island
- Flooring: Carpet, Laminate, Linoleum, Wood
- Windows: Low-Emissivity Windows, Skylight(s), Screens, Insulated Windows, Window Treatments
- Basement: Crawl Space
- Number of fireplaces: 1
- Fireplace features: Gas Log, Living Room
Interior area
- Total structure area: 2,572
- Total interior livable area: 2,572 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener, Attached
- Garage spaces: 2
Features
- Stories: 2
- Pool features: Association Indoor Pool
- On waterfront: Yes
- Waterfront features: Lake
- Body of water: Lake Lancelot
Lot
- Size: 0.54 Acres
- Dimensions: 100 x 265 x 125 x 200
- Features: Level, Cul-De-Sac, Ground Cover
Details
- Parcel number: 06016000012700
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Other
- Property subtype: Single Family Residence
Materials
- Vinyl Siding
- Roof: Asphalt,Shingle
Condition
- New construction: No
- Year built: 1999
Utilities & green energy
- Sewer: Public Sewer
- Water: Private, Well
- Utilities for property: Phone Available, Natural Gas Available, Electricity Available, Cable Available, Phone Connected, Natural Gas Connected
Community & HOA
Community
- Security: Other
- Subdivision: Sugar Springs
HOA
- Has HOA: Yes
- Amenities included: Airport/Runway, Campground, Clubhouse, Golf Membership, Indoor Pool, Tennis Court(s), Trail(s)
- Services included: Other
- HOA fee: $645 annually
Location
- Region: Gladwin
Financial & listing details
- Price per square foot: $303/sqft
- Tax assessed value: $166,523
- Annual tax amount: $7,541
- Date on market: 9/25/2026
- Listing terms: Cash,Conventional
- Electric utility on property: Yes
- Road surface type: Paved
Estimated market value
$739,500
$703,000 - $776,000
$2,814/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/25/2026 | Listed for sale | $779,000$303/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $7,114 +0.7% | $271,100 +0.9% |
| 2025 | $7,067 +4% | $268,800 +10.6% |
| 2024 | $6,792 | $243,100 +10.9% |
| 2023 | -- | $219,200 +15.6% |
| 2022 | -- | $189,700 +1.6% |
| 2021 | -- | $186,700 +8.3% |
| 2020 | -- | $172,400 +15.4% |
| 2018 | -- | $149,400 +5.6% |
| 2017 | -- | $141,500 +8.4% |
| 2016 | -- | $130,500 |
| 2015 | -- | -- |
| 2014 | -- | $126,100 +0.9% |
| 2013 | -- | $125,000 -4.8% |
| 2011 | -- | $131,300 +7.2% |
| 2010 | -- | $122,500 |
Find assessor info on the county website
Monthly payment
Est. payment









