4790 Queens Ct, Gladwin, MI 48624
OFF MARKET

$527,900

Trulia Estimate
  • 5 Beds
  • 2.5 Baths
  • 2,024 sqft (on 0.51 acres)

4790 Queens Ct, Gladwin, MI 48624

Est. Refi. Payment $3,274/mo*
Refinance Your Home
Currently Off Market - Sold Jul 14, 2023 for $456,000

Home Value

Trulia Estimate
$528K
Since last month
Decreased$10K (-1.9%)
Since last year
Increased$9K (+1.8%)
Since last sale
Increased$69K (+15.1%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +128% in the last 10 years
MonthEstimated value
2026
August 2026$525K
July 2026$535K
June 2026$517K
May 2026$500K
April 2026$498K
March 2026$502K
February 2026$491K
January 2026$489K
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
0.11
Single-Family Home
$395,000
08/11/26
3
2
2,128
0.19
Single-Family Home
$458,000
11/04/25
3
2
1,976
0.28
Single-Family Home
$525,000
10/31/25
3
2
1,962
0.39
Single-Family Home
$495,000
10/24/25
3
2.5
2,994
0.35
Single-Family Home
$231,500
11/07/25
3
3
2,552
0.50
Single-Family Home
$685,000
08/21/26
4
3
3,637
0.54
Single-Family Home
$365,000
12/30/25
3
2
2,630
0.29
Single-Family Home
$185,000
07/09/26
3
2
1,212
0.50
Single-Family Home
$225,225
10/09/25
3
2
1,482

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
0.04
$180,500
-
-
-
Off Market
0.09
$302,300
3
2
2,150
Off Market
0.11
$395,000
3
2
2,128
Recently Sold
0.10
-
-
-
-
Off Market
0.14
-
-
-
-
Off Market
0.13
$522,700
4
3.5
3,608
Off Market
0.14
-
-
-
-
Off Market
0.18
$496,300
3
2
2,200
Off Market
0.19
$458,000
3
2
1,976
Recently Sold
0.17
-
-
-
-
Off Market
0.16
$475,900
3
2
2,240
Off Market

Local Information

  • Map ViewExplore the area around 4790 Queens Ct.
  • Schools1 Preschool School2 Elementary Schools1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

Home Highlights

Property Type
Single-Family Home
Year Built
1973
Lot Size
0.51 acres
Living Area
2,024 sqft
Price/Sqft
$261
Parking
Garage
HOA
$53/Monthly

About this House

Waterfront Home on All-Sports private lake. Beautiful 1/2 acre lot on Lake Lancelott. This 5BR/3BA Ranch style home has sandy beach area , removable dock, mature trees, full basement. 2 plus car garage. Home is 2024 square feet of open living space with vaulted ceiling and large door walls that give you beautiful water views. Home is in perfect condition throughout with updated quarts kitchen counters. Come enjoy all the ammenities of Sugar Springs with two gorgeous lakes, two beautiful golf courses, restaurant and pub, heated saline indoor pool and fitness center, tennis, activity centers, beaches and picnic areas with bath houses, boat slips, boat launces, and much more!!
4790 Queens Ct, Gladwin, MI 48624 is a 5 bedroom, 3 bathroom, 2,024 sqft single-family home built in 1973. It last sold for $456,000 on Jul 14, 2023 (9% below the $499,900 asking price). This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $527,900, with a rent estimate of $2,113/month.
Last check for updates: about 7 hours ago
Listed by ALMA HORTON TIER, (989) 948-4509
SUGAR SPRINGS REAL ESTATE
Bought with: IVIE BAKER, (989) 429-0124, Baker-Kehoe Realty LLC
Originating MLS: Clare Gladwin Board of REALTORS
Source: MiRealSource, MLS#50106299

Home Details for 4790 Queens Ct

Interior Features

Interior Details
Basement: Block,Full,Sump Pump,Crawl SpaceNumber of Rooms: 11Types of Rooms: Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Bathroom 1, Bathroom 2, Dining Room, Great Room, Kitchen, Living Room
Beds & Baths
Number of Bedrooms: 5Main Level Bedrooms: 5Number of Bathrooms: 3Number of Bathrooms (full): 2Number of Bathrooms (half): 1Number of Bathrooms (main level): 2
Dimensions and Layout
Living Area: 2024 Square Feet
Appliances & Utilities
Utilities: Cable Available, Natural Gas Connected, Phone Connected, Sewer Connected, Underground Utilities, Water Connected, Internet DSL Available, Internet SpectrumAppliances: Electric Water HeaterLaundry: Main Level
Heating & Cooling
Heating: Forced Air,Natural Gas,Space HeaterHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Forced Air
Fireplace & Spa
Number of Fireplaces: 1No Fireplace
Windows, Doors, Floors & Walls
Flooring: Wood
Levels, Entrance, & Accessibility
Stories: 1Levels: OneFloors: Wood

Exterior Features

Exterior Home Features
Patio / Porch: DeckFoundation: BasementNo Private Pool
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageNo Attached GarageNo Open ParkingParking Spaces: 3Parking: 3 or More Spaces,Detached
Frontage
WaterfrontWaterfront: All Sports Lake, Boat Facility, Dock/Pier Facility, Lake Front, Waterfront, Beach Front, Sandy BottomRoad Frontage: CountryOn Waterfront
Water & Sewer
Sewer: Public SanitaryWater Body: Lake Lancelott
Farm & Range
Frontage Length: 115
Finished Area
Finished Area (above surface): 2024 Square Feet

Days on Market

Cumulative Days on Market: 72

Property Information

Year Built
Year Built: 1973
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family ResidenceStructure Type: ResidentialArchitecture: Ranch
Building
Construction Materials: Vinyl SidingNot a New Construction
Property Information
Parcel Number: 06016000013000

Price & Status

Price
List Price: $499,900
Status Change & Dates
Off Market Date: Fri Jun 30 2023Possession Timing: Close Of Escrow

Active Status

MLS Status: Closed

Location

Direction & Address
City: GladwinCommunity: Sugar Springs
School Information
Elementary School District: Gladwin Community SchoolsJr High / Middle School District: Gladwin Community SchoolsHigh School District: Gladwin Community Schools

Building

Building Area
Building Area: 3424 Square Feet

HOA

HOA Name: Sugar SpringsAssociation for this Listing: Clare Gladwin Board of REALTORSHas an HOAHOA Fee: $630/Annually

Lot Information

Lot Area: 0.51 acres

Listing Info

Special Conditions: Private

Offer

Listing Agreement Type: Exclusive Right To SellListing Terms: Cash, Conventional

Miscellaneous

BasementMls Number: 50106299Above Grade Unfinished Area: 2024Days In Mls: 71

Price and Tax history

DateEventPrice
Jul 14, 2023
Source: MiRealSource #50106299
Sold
$456,000
Jun 30, 2023
Source: MiRealSource #50106299
Pending
$499,900
Jun 5, 2023
Source: MiRealSource #50106299
PriceChange
$499,900
Price decreased by 6%
Apr 20, 2023
Source: MiRealSource #50106299
Listed For Sale
$529,000
Feb 27, 1996
Source: N/A
Sold
$120,100

Market trends in Gladwin

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
Sale-to-List Price
Price per sq ft
Available listings
137
8
MoM

What Locals Say about Gladwin

At least 32 Trulia users voted on each feature.
  • 82 % Say car is needed

  • 79 % Say yards are well-kept

  • 77 % Say parking is easy

  • 74 % Say it's dog friendly

  • 68 % Say kids play outside

  • 68 % Say people would walk alone at night

  • 67 % Say it's quiet

  • 67 % Say there's wildlife

  • 58 % Say there's holiday spirit

  • 57 % Say it's walkable to restaurants

  • 57 % Say neighbors are friendly

  • 57 % Say there are sidewalks

  • 44 % Say they plan to stay for at least 5 years

  • 43 % Say it's walkable to grocery stores

  • 32 % Say streets are well-lit

  • 29 % Say there are community events

Sourced by Trulia users. Learn more about our methodology.
  • Jean Rose
    "There are lots of outdoor activities available, including hiking, biking, water sports, trail riding, etc."
  • Jean Rose
    "I love watching the Amish in their buggies. People stop and help when you have car trouble. Lots of hiking nearby."
  • K.J.A
    "Biggest concern is deer. They like to jump out in front of cars. I recommend getting deer whistles for your car. Also, speed limits seem to be just suggestions, as no one follows them. "
  • Sewsweet66
    "We’ve lived in this area for 10 years, it is a wonderful place to raise your children and vacation! There are many lakes for sports and a beautiful river for floats. We love it here"
  • Chris T.
    "Not many places to take small children to have fun. A couple of bowling alleys and a ice skating arena is about as good as it gets. "
  • Bob H.
    "Everyone keeps area looking very nice. Neighbors are friendly and helpful. Have lived and raised family for 37 years here. Very family friendly area to live in."
  • Audrey M.
    "Love taking your dog on walks through North Park trails. There isn’t many places that allow dogs to go inside which is not uncommon tho."
  • Shubel.greg
    "The sidewalks make it easy to walks dogs. The parks and walk along the river are dog friendly. Cats are not as popular. "
  • Shubel g.
    "Gladwin is the county seat. There are numerous events throughout the year that involve the various neighborhoods. Many are coordinated by the Chamber of Commerce. "
  • JAW6581
    "Lake living which entails water sports and fishing. There are many golf courses in the area under a sixty minute drive that are reasonably priced. The drive from Troy is a little over an hour drive."
  • Tiarose 1.
    "I've lived in gladwin for over 6 years and I love the country side and the woods. i love night sky's by the lakes it's absolutely beautiful "
  • Thomas R.
    "GREAT LOCATION. YOU COULD WALK EVERYWHERE IF YOU WANTED TO."
  • taylorandassociates69
    "I moved here 21 years ago and love the peace and quiet. It is truly a sportsperson's paradise. I own a Construction and Property Management Company. I wouldn't live or work anywhere else. It's location is under a hours drive to Mt Pleasant & Midland Just 1.5 hours to Lansing & Traverse City. It's location is perfect to escape the stress of city life, yet close for your guests and family to travel to visit! "
  • M c.
    "This is a beautiful setting to raise a family or a great place for a retirement property. I spent many years enjoying every thing the area has to offer. Check it out!"
  • Brenda G.
    "Very nice community. Well kept, friendly neighbors- seem to look after each other. Placid no wake fishing lake. Quiet peacefull setting. Located between Clare and Gladwin. Close to many lakes and state land for the out doors enthusiest."

LGBTQ Local Legal Protections

Source MLS: MiRealSource Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource. The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.
Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc. Click here for more information

Frequently asked questions about 4790 Queens Ct

  • What is 4790 Queens Ct estimated to be worth?
    Trulia's estimated value for 4790 Queens Ct in Gladwin, MI is $527,900.
  • What is the price history for 4790 Queens Ct?
    4790 Queens Ct in Gladwin, MI last sold for $456,000 in July 2023.
  • Is Gladwin a buyer's or seller's market?
    Gladwin is currently a buyer's market, based on recent for-sale activity.
  • What do residents say about Gladwin?
    Residents describe Gladwin, MI as well-kept, easy to park in, and dog-friendly. Most residents say you need a car. See recently sold homes in Gladwin, MI.
  • Does 4790 Queens Ct have air conditioning?
    Yes, 4790 Queens Ct in Gladwin, MI has air conditioning.
  • Does 4790 Queens Ct have laundry facilities?
    Yes, 4790 Queens Ct in Gladwin, MI has laundry facilities.

Apartments for Rent

Skip to last item
  • Results are loading
Skip to first item

Off Market Homes Near 4790 Queens Ct

Skip to last item
Skip to first item

Homes for sale near 4790 Queens Ct

Skip to last item
Skip to first item
Skip to last item
  • Results are loading
Skip to first item