Agent profile image in chat bubble
Agent profile image in chat header

Jim Blehm

Team Owner, Realtor® | The Blehm Group | Keller Williams

Agent profile image in message

By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
main property photo 47
main property photo 48
main property photo 49
main property photo 50
main property photo 51
main property photo 52
main property photo 53
main property photo 54
main property photo 55
main property photo 56
main property photo 57
main property photo 58
main property photo 59
main property photo 60
main property photo 61
main property photo 62
main property photo 63
main property photo 64
main property photo 65
main property photo 66
main property photo 67
main property photo 68
main property photo 69
main property photo 70
main property photo 71
main property photo 72
main property photo 73
View All (74)
property photo 1
property photo 2
property photo 3
4760 Queens Ct , Gladwin, MI 48624
$779,000
Est. Payment: $1,731.11/mo
4 Bed
3 Bath
2572 Sqft
0.53 Acres
Status: active | Days on site: 3
Get Pre-Qualified
m638 - mjjud,mjpy
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from Jim Blehm, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
Agent profile image
Jim Blehm
Team Owner, Realtor®
View agent profile
Email
Call

House 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.
Show more

Highlights

Listed by John Judge , 231-645-9379 and Jeff Pyciak , 517-740-1726 Coldwell Banker Schmidt - Onekama , 231-559-0147. MichRIC

Property Type

Residential
Lot/Acreage
0.53

HOA Fee

645 Annually

Year Built

1999

County

Gladwin

 Neighborhood

Sugar Springs

 School District

Gladwin

Listing ID

26051371

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:3
  • ▪ Full Bathrooms:2
  • ▪ 1/2 Bathrooms:1
Appliances:Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer, Water Softener Owned
Air Cond:Central Air
Fireplaces:Gas Log,Living Room
Floor:Carpet,Laminate,Linoleum,Wood
Basement:Crawl Space
Other:
  • ▪ Additional:Ceiling Fan(s), Broadband, Garage Door Opener, Center Island, Master on Main
Water:Private Water,Well

Exterior Features

Lot:Level,Cul-De-Sac,Lake,Waterfront
Roof:Asphalt,Shingle
Sewer:Public
Parking Features:Garage Door Opener,Attached
Principal Interest
$1,731
Taxes
$628
HOA
$645

Home Price

$779,000

Loan Details

30 yrs
0%

Down Payment

20%
$155,800
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$1,731.11

Principal

Taxes

HOA

Principal Taxes HOA Total
Monthly $1,731.11 $628.42 $645.00 $3,004.53
Yearly $20,773.33 $7,541.00 $7,740.00 $36,054.33
Total $623,200.00 $226,230.00 $232,200.00 $1,081,630.00
Lender profile image
Brian Belinger
Loan Originator
Email
Call
Visit
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Nov 2026

Average Price

All Price Ranges
N/A
Nov 2026

Average Days on Market

All Price Ranges
N/A
Nov 2026
Market insight data is pulled from the same city as the listing being viewed (Gladwin, MI).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Information provided by Southwestern Michigan Regional Information Center, LLC and is deemed reliable but not guaranteed accurate.

Data last updated: 2026-11-01T14:17:27.000Z

© 2026 MichRIC