Andover RE
Powered by 
- 0
- 2
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$779,000
Monthly Est:$3,877
4 Beds
3 Baths2 full baths + 1 half bath
2,572sqft
4760 Queens Ct, Gladwin, MI 48624
$779,000
$3,877/moEst:
Get Pre-Approved
Single Family Residence
Built in 1999
$53.75/mo HOA
23,522.4 sqft lot
$303/sq.ft
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.
- Houzeo last checked: 8 minutes ago
- Listing updated: September 28, 2026 at 1:14 pm
- Listing Provided by: John Judge (231) 645-9379 , Jeff Pyciak | Coldwell Banker Schmidt - Onekama (231) 559-0147
- Source: Realcomp MLS-MI | MLS#: 67026051371
- Originating MLS: Mason Oceana Manistee Board of REALTORS
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
1999
HOA Fees
$53.75/mo
Finished Area
2,572 sqft
Lot Size
23,522.4 sqft lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
67026051371
MLS Status
Active
Days on Market
12
Cumulative Days on Market
3
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$645/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Golf
Tennis
Club House
Pool
Other
AirportRunway
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Interior
Sewer
Public Sewer
Cooling
Ceiling Fans, Central Air
Interior Features
Vaulted Ceilings, Window Treatments
Window Features
Insulated Windows, Low Emissivity Windows, Screens, Skylights
Flooring
Carpet, Laminate, Linoleum, Wood
Appliances
Dishwasher, Dryer, Microwave, Oven, Refrigerator, Range, Washer, Water Softener Owned
Heating
Forced Air, Natural Gas
Construction
Year Built
Year Built: 1999
Home type
Single Family Residence
Foundation Details
Crawl Space
Roof
Asphalt, Shingle
Construction Materials
Vinyl Siding
Architectural Style
Other
Utilities & Energy
Parking Features
Attached, Concrete, Garage Door Opener
Fireplace Features
Gas Log, Living Room
Laundry Features
Gas Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
Water Source
Private, Well
Association Amenities
Airport Runway, Clubhouse, Golf Course, Other, Pool, Tennis Courts
Pool Features
Indoor
Utilities
Natural Gas Connected, Phone Available, Phone Connected
Security Features
Other
Other Features
Community Features
Airport Runway
Subdivision Name
Sugar Springs
Lot Features
Cul De Sac, Level, Landscaped Ground Cover
Price History
| Date | Event | Price |
|---|---|---|
09/25/2026 Source: | Listed for Sale | $779,000 $303/sqft |
Nearby Homes
Find Homes by Property Features in Gladwin, MI
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Oct 08, 2026, 07:00AM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX provided courtesy of Realcomp II Ltd. via Andover Real Estate & Houzeo, Copyright 2026 Realcomp II Ltd. Shareholders Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Listing Information presented by local MLS brokerage: Andover Real Estate, local REALTOR®- Scott Rubin - (248)206-3666 . Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. © 2024 Realcomp II Ltd. MLS. All Rights Reserved.
Advertising Broker: Andover Real Estate | Andover Real Estate