Bob Ender
BEDS4
BATHS2 full 1 partial
SQUARE FEET2,572
MLS#26051371
STATUSActive
PROPERTY TYPEResidential - Single Family
SUBDIVISIONSugar Springs
SCHOOLGladwin
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.
Property Features
Property Type: Residential - Single Family
Basement: Crawl Space
Cooling: Central Air
Fireplaces: 1
Garage: 2 car attached
Heating: Forced Air
Home Style: Other
Lot Size: 0.54 Acres
Roof Type: Asphalt, Shingle
Taxes: $7,541
Year Built: 1999
Feature Descriptions
Appliances: Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer, Water Softener Owned
Association Amenities: Airport Landing Strip, Campground, Clubhouse, Golf Membership, Indoor Pool, Tennis Court(s), Trail(s)
Association Fee Includes: Other
Days on Site: 24
Electric: Generator
Exterior: Vinyl Siding
Fireplace: Gas Log, Living Room
Fireplace Y/N: Yes
Flooring: Carpet, Laminate, Linoleum, Wood
HOA: Yes
HOA Fee: 645/Annually
Interior: Ceiling Fan(s), Broadband, Garage Door Opener, Center Island
Lake Name: Lake Lancelot
Laundry: Gas Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
Lot: Level, Cul-De-Sac
Lot Dimensions: 100x265x125x200
Parcel Number: 060-160-000-127-00
Parking: Garage Door Opener, Attached
Road Surface: Paved
Rooms Total: 14
Sewer: Public
Sub Type: Single Family Residence
Utilities: Phone Available, Natural Gas Available, Electricity Available, Cable Available, Phone Connected, Natural Gas Connected, High-Speed Internet
Water: Private Water, Well
Waterfront: Lake
Window: Low-Emissivity Windows, Skylight(s), Screens, Insulated Windows, Window Treatments
Local Schools
School District: Gladwin
Listed By / Shown By
Listed By
Agency Name: Coldwell Banker Schmidt - Onekama
Agent Name: John Judge
Agency Phone: 231-559-0147
Shown By
Agent Name: Bob Ender
Agent Phone: (734) 558-8257
Agency Title: Key Realty
 | The property comes from the Member MLS's of the Michigan Regional Information Center, LLC (MichRIC). Copyright 2026 Michigan Regional Information Center, LLC (MichRIC). All rights reserved. Information deemed reliable, but not guaranteed. Data Last Updated 10/20/2026. |
Estimate Your Payment
Estimated Payment
$ 5,213.13 per month $4,357.50 Principal & Interest $628.42 Property Tax $227.21 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598 | Illinois LIC# 481014661 640 S Washington St. Suite 212, Naperville, IL 60540
Agent License Information: Brokerage/Company License Number: MI-65-05366134
4760 Queens Court | MLS# 26051371
This single family home located at 4760 Queens Court, Gladwin, MI 48624 is currently listed for sale with an asking price of $779,000. This property was built in 1999 and has 4 bedrooms and 2 full and 1 partial baths with 2572 sq. ft. Queens Court is located in the Sugar Springs subdivision within the Gladwin school district. Search Sugar Springs real estate on bobender.ikeyrealty.com today.