Skip main navigation
Active
  • $779,000

    4760 Queens Ct, Gladwin, MI 48624

    4beds
    2,572sqft
    : 
    $5,158/mo
    Get pre-qualified
    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
    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.
    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#: 26051371MLS Logo

      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

        DateEventPrice
        9/25/2026Listed for sale$779,000$303/sqft
        Source: MichRIC #26051371 Report a problem

        Public tax history

        YearProperty taxesTax 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

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 48624

        Getting around

        5 / 100
        Car-Dependent
        25 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts