$779,000
Gladwin, MI 48624
MLS# 26051371
4 beds | 3 baths | 2572 sqft
1 / 74
Property Description
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.
Details
Location & Property Info
Cross Streets: Queens Way
Property Sub-Type: Single Family Residence
Municipality: Butman Twp
Subdivision: Sugar Springs
Office/Contract Info
Auction or For Sale: For Sale
List Price/SqFt: 302.88
General Property Info
New Construction: No
Lot Dimensions: 100x265x125x200
Road Frontage: 100
Garage Y/N: Yes
Garage Spaces: 2
Fireplace: Yes
Total Fireplaces: 1
Waterfront: Yes
Body of Water: Lake Lancelot
Income Property: No
Basement: No
Total Rooms AG: 14
Total Fin SqFt All Levels: 2572
SqFt Above Grade: 2572
Below Grade Finished SqFt: 0
Below Grade Unfinished SqFt: 0
Building Total SqFt: 2572
Total Beds Above Grade: 4
Statewide Lakes & Rivers: Lake Lancelot
Main Level Primary: Yes
Stories: 2
School District: Gladwin
Association YN: Yes
Lot Measurement: Acres
Lot Acres: 0.54
Lot Square Footage: 23304
Year Built: 1999
Total Bedrooms: 4
Full Baths: 2
Half Baths: 1
Total Baths: 3
Tax Info
Taxable Value: 166523
SEV: 271100
For Tax Year: 2026
Seller's Annual Property Tax: 7541
Tax Year: 2026
Homestead %: 0
Spec Assessment & Type: Unknown
Tax ID #: 060-160-000-127-00
Remarks & Misc
Public Remarks: 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.
Legal: 20 1W QUEENS REALM SUB LOT 127
Waterfront Options
Water Access Y/N: Yes
Water Frontage: 125
Water Type
Lake: 1
Water Fea. Amenities
All Sports: 1
Dock: 1
Private Frontage: 1
View: 1
Lot Description
Cul-De-Sac: 1
Level: 1
Street Type
Paved: 1
Public: 1
Util Avail at Street
Cable Available: 1
Electricity Available: 1
High Speed Internet: 1
Natural Gas Available: 1
Phone Available: 1
Utilities Attached
High Speed Internet: 1
Natural Gas Connected: 1
Phone Connected: 1
Sewer
Public Sewer: 1
Water
Private Water: 1
Well: 1
Terms Available
Cash: 1
Conventional: 1
Mineral Rights
Unknown: 1
Association Info.
Approx. Assoc Fee: 645
Assoc. Fee Payable: Annually
Laundry Features
Gas Dryer Hookup: 1
Laundry Room: 1
Main Level: 1
Sink: 1
Washer Hookup: 1
Assoc. Amenities
Airport Landing Strip: 1
Campground: 1
Clubhouse: 1
Golf Membership: 1
Indoor Pool: 1
Tennis Court(s): 1
Trail(s): 1
Exterior Material
Vinyl Siding: 1
Assoc. Fee Incl.
Other: 1
Roofing
Asphalt: 1
Shingle: 1
Parking Features
Attached: 1
Garage Door Opener: 1
Heat Source
Natural Gas: 1
Sale Conditions
None: 1
Heat Type
Forced Air: 1
Air Conditioning
Central Air: 1
Access Feat
Accessibility Features: No
Upper Rooms
Upper Bedrooms: 3
Upper Full Baths: 1
Upper Level Square Feet: 981
Total Baths Above Grade: 3
Main Rooms
Main Bedrooms: 1
Main Full Baths: 1
Main Half Baths: 1
Main Level SQFT: 1591
Lower Rooms
Lower Finished SQFT: 0
Total Lower SQFT: 0
Driveway
Concrete: 1
Substructure
Crawl Space: 1
Windows
Insulated Windows: 1
Low-Emissivity Windows: 1
Screens: 1
Skylight(s): 1
Kitchen Features
Center Island: 1
Fireplace
Gas Log: 1
Living Room: 1
Additional Items
Ceiling Fan(s): 1
Garage Door Opener: 1
Generator: 1
Vaulted Ceilings: 1
Window Treatments: 1
Appliances
Dishwasher: 1
Dryer: 1
Microwave: 1
Oven: 1
Range: 1
Refrigerator: 1
Washer: 1
Water Softener Owned: 1
Water Heater
Electric: 1
Flooring
Carpet: 1
Laminate: 1
Linoleum: 1
Wood: 1
Other Equipment
Generator: 1
Security Features
Other: 1
Landscape
Ground Cover: 1
Architectural Style
Other: 1
Possession
Negotiable: 1
Location Property Info
County: Gladwin
Street #: 4760
Street Name: Queens
Suffix: Court
State: MI
Zip Code: 48624
Zip (4): 8223
OfficeContract Info
Status: Active
List Price: $779,000
Current Price: $779,000
Listing Date: 2026-09-25
Remarks Misc
Directions: West M18 to Round Lake Rd. go North 3 miles to Grass Lake Rd. go East 1 mile to Queens Way, go south till you get to Queens Ct. follow all the way down to the end. 4760 Queens Ct.
Property Features
Water Type: Lake
Laundry Features: Gas Dryer Hookup; Laundry Room; Main Level; Sink; Washer Hookup
Exterior Material: Vinyl Siding
Roofing: Asphalt; Shingle
Windows: Insulated Windows; Low-Emissivity Windows; Screens; Skylight(s)
Substructure: Crawl Space
Lot Description: Cul-De-Sac; Level
Sewer: Public Sewer
Water: Private Water; Well
Utilities Attached: High Speed Internet; Natural Gas Connected; Phone Connected
Util Avail at Street: Cable Available; High Speed Internet; Natural Gas Available; Phone Available
Kitchen Features: Center Island
Fireplace: Gas Log; Living Room
Additional Items: Ceiling Fan(s); Garage Door Opener; Generator; Vaulted Ceilings; Window Treatments
Appliances: Dishwasher; Dryer; Microwave; Oven; Range; Refrigerator; Washer; Water Softener Owned
Heat Source: Natural Gas
Heat Type: Forced Air
Air Conditioning: Central Air
Water Heater: Electric
Flooring: Carpet; Laminate; Linoleum; Wood
Other Equipment: Generator
Security Features: Other
Landscape: Ground Cover
Parking Features: Attached; Garage Door Opener
Architectural Style: Other
Driveway: Concrete
Street Type: Paved; Public
Mineral Rights: Unknown
Terms Available: Cash; Conventional
Possession: Negotiable
Sale Conditions: None
Room Information
| Room Name | Length | Width | Level |
| Kitchen | 11.00 | 16.00 | Main |
| Dining Room | 12.00 | 14.00 | Main |
| Living Room | 24.00 | 20.00 | Main |
| Other | 15.00 | 12.00 | Main |
| Primary Bedroom | 16.00 | 17.00 | Main |
| Primary Bathroom | 9.00 | 9.00 | Main |
| Laundry | 9.00 | 8.00 | Main |
| Bathroom 1 | 6.00 | 5.00 | Main |
| Family Room | 28.00 | 14.00 | Upper |
| Bathroom 3 | 13.00 | 5.00 | Upper |
| Bedroom 2 | 13.00 | 11.00 | Upper |
| Bedroom 3 | 13.00 | 11.00 | Upper |
| Bedroom 4 | 14.00 | 17.00 | Upper |
Listing Office: Coldwell Banker Schmidt - Onekama
Listing Agent: John Judge
Last Updated: September - 25 - 2026
The data relating to real estate on this web site comes in part from the Internet Data Exchange program of the MLS of MICHRIC , and site contains live data. IDX information is provided exclusively 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.