Seller's Agent in 2025
Doug Andrus
Keller Williams Realty Lakeside
(313) 980-3933
2 in this area
22 Total Sales
16903 Sandstone Cir Macomb, MI 48042
3
Beds
4
Baths
3,188
Sq Ft
$340/mo
HOA Fee
Highlights
- Cathedral Ceiling
- Main Floor Bedroom
- Porch
- Richard J. Duncan Elementary Rated A-
- Breakfast Area or Nook
- 2 Car Attached Garage
About This Home
As of May 2025This immaculate 3-bedroom, 4 full bathroom condominium offers approximately 2,010 sq ft of beautifully maintained living space. From the moment you step inside, you’ll feel the pride of ownership and attention to detail that sets this home apart. The spacious living room welcomes you with vaulted ceilings, a cozy fireplace, and a custom dry bar — creating the perfect setting for relaxing or entertaining. The updated kitchen features granite countertops, a stylish backsplash, abundant cabinetry, and a bright breakfast nook overlooking the private patio. Convenience meets comfort with a first-floor laundry and a primary suite complete with a walk-in closet and a fully renovated bathroom, showcasing quartz countertops, new tile, sleek glass shower doors, and polished chrome fixtures. Second floor features a bedroom, and full bath. Downstairs, the finished basement offers a fantastic bonus space with a wet bar, fridge, full bathroom, and ample storage — ideal for guests, hobbies, or game nights. Additional highlights include vinyl laminate, a 2-car garage, reverse osmosis system for the kitchen, a whole-house water filter, newer furnace, central A/C, and hot water tank, and a sump pump with back-up system. Thoughtfully designed accessibility features add both functionality and peace of mind. This move-in-ready gem is as practical as it is polished — a must-see. 1-Yr home warranty provided.
Last Agent to Sell the Property
Keller Williams Realty Lakeside License #MISPE-6506041512 Listed on: 04/08/2025
Property Details
Home Type
- Condominium
Est. Annual Taxes
Year Built
- Built in 1998
HOA Fees
- $340 Monthly HOA Fees
Home Design
- Split Level Home
- Brick Exterior Construction
Interior Spaces
- 1.5-Story Property
- Wet Bar
- Cathedral Ceiling
- Ceiling Fan
- Window Treatments
- Entryway
- Living Room with Fireplace
- Finished Basement
- Sump Pump
- Home Security System
Kitchen
- Breakfast Area or Nook
- Oven or Range
- Microwave
- Dishwasher
Bedrooms and Bathrooms
- 3 Bedrooms
- Main Floor Bedroom
- Walk-In Closet
- Bathroom on Main Level
- 4 Full Bathrooms
Laundry
- Dryer
- Washer
Parking
- 2 Car Attached Garage
- Garage Door Opener
Outdoor Features
- Patio
- Porch
Utilities
- Forced Air Heating and Cooling System
- Heating System Uses Natural Gas
- Gas Water Heater
Listing and Financial Details
- Assessor Parcel Number 20-08-17-151-030
Community Details
Overview
- O'brien Assoc Mgmt HOA
- Cobblestone Ridge III Subdivision
Pet Policy
- Call for details about the types of pets allowed
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Apr 8, 2025
Closed on
May 29, 2025
Sold by
Ulanski Family Revocable Trust and Ulanski Lawrence J
Bought by
Koltvedt Dreama J
Seller's Agent
Doug Andrus
Keller Williams Realty Lakeside
Buyer's Agent
Robert Seggie
Keller Williams Paint Creek
List Price
$385,000
Sold Price
$400,000
Premium/Discount to List
$15,000
3.9%
Views
117
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$3,921
Avg. Annual Appreciation
-2.94%
Original Mortgage
$100,000
Outstanding Balance
$99,741
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$296,338
Purchase Details
Closed on
Dec 18, 1998
Sold by
Cobblestone Ridge Develo
Bought by
Ulanski Family Trust
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | $400,000 | First Premier Title | |
| Warranty Deed | $400,000 | First Premier Title | |
| Deed | $204,900 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $100,000 | New Conventional | |
| Closed | $100,000 | New Conventional |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/29/2025 05/29/25 | Sold | $400,000 | +3.9% | $125 / Sq Ft |
| 04/21/2025 04/21/25 | Pending | -- | -- | -- |
| 04/08/2025 04/08/25 | For Sale | $385,000 | -- | $121 / Sq Ft |
Source: Michigan Multiple Listing Service
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $2,672 | $169,000 | $0 | $0 |
| 2024 | $1,772 | $153,900 | $0 | $0 |
| 2023 | $1,678 | $147,300 | $0 | $0 |
| 2022 | $2,424 | $126,200 | $0 | $0 |
| 2021 | $2,361 | $123,700 | $0 | $0 |
| 2020 | $1,545 | $120,500 | $0 | $0 |
| 2019 | $2,165 | $116,700 | $0 | $0 |
| 2018 | $2,134 | $109,300 | $0 | $0 |
| 2017 | $2,105 | $107,510 | $18,500 | $89,010 |
| 2016 | $1,981 | $107,510 | $0 | $0 |
| 2015 | $1,956 | $107,200 | $0 | $0 |
| 2014 | $1,956 | $83,090 | $12,500 | $70,590 |
| 2011 | $554 | $74,290 | $10,500 | $63,790 |
Source: Public Records
Agents Affiliated with this Home
-
Doug Andrus
-
Savannah Habba
Seller Co-Listing Agent in 2025
Savannah Habba
Keller Williams Realty Lakeside
(586) 804-4968
34 in this area
152 Total Sales
-
Robert Seggie
Buyer's Agent in 2025
Robert Seggie
Keller Williams Paint Creek
(586) 207-7685
4 in this area
106 Total Sales
Map
Source: Michigan Multiple Listing Service
MLS Number: 50170841
APN: 20-08-17-151-030
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
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 2025 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.
Nearby Homes
- 52105 Westfield Dr Unit 31
- 17018 Sandstone Cir Unit 50
- 17012 Coral Ln
- 17122 Garland Dr Unit 130
- 16726 Gemstone Dr Unit 82
- 16768 Pearlcreek Ct Unit 39
- 16724 Shale Ct
- 52240 Fish Creek Dr
- 16876 Pebble Ct Unit 120
- 16816 Pebble Ct Unit 81
- 52448 Cedar Mill Dr
- 52921 Paint Creek Dr Unit 2
- 51900 Romeo Plank Rd
- 53295 Springhill Meadows Dr
- 53242 Clarion Dr
- 15531 Mountainside Dr
- 53363 Azalea Dr
- 15435 Dorothy Dr
- 53571 Azalea Dr
- 50318 Greycoat Ln