BEAUTIFUL 3 BEDROOM 3 BATH CONDO. FIREPLACE, MAPLE AND GRANITE KITCHEN AND CEILING FANS. PROPERTY SOLD 'AS IS' BUYER RESPONSIBLE FOR ANY MUNICIPAL REQUIREMENTS AND BUYER TO VERIFY ALL INFORMATION. FREDDIE MAC IS OFFERING A 2 YEAR HOME WARRANTY AND UP TO 3% SELLER PAID CLOSING COST FOR OWNER OCCUPANTS. SELLING AGENT BONUS AVAILABLE ON INITIAL OWNER/OCCUPANT OFFERS.
Last Agent to Sell the Property
Kent Colpaert
Bearing GroupLicense #MISPE-6502334886Listed on: 08/05/2011
Last Buyer's Agent
Susan Faison
Century 21 Market Tech RealtorsLicense #MISPE-6501231565
Property Details
Home Type
Condominium
Est. Annual Taxes
$2,904
Year Built
Built in 2007
HOA Fees
$175 Monthly HOA Fees
Parking
2 Car Garage
Interior Spaces
2,007 Sq Ft Home
2-Story Property
Basement
Bedrooms and Bathrooms
3 Bedrooms
3 Full Bathrooms
Community Details
The Sandstone At The Retreat Condo #956 Subdivision
Listing and Financial Details
Assessor Parcel Number 0824325147
Property Details
Home Type
Condominium
Est. Annual Taxes
$2,904
Year Built
Built in 2007
Lot Details
0
HOA Fees
$175 per month
Listing Details
Originating MLS: MiRealSource
Class: RESIDENTIAL
Type Of Property: Condominium
Structure Style: 2 Story
Year Built: 2007
Mail City: Macomb
Special Features: RealEstateOwned
Property Sub Type: Condos
Stories: 2
Interior Features
Basement: Yes
Bedrooms: 3
Bedroom 1: On Entry Level,
Dimensions: 16 x 12
Bedroom 2: On Upper Floor,
Dimensions: 14 x 12
Bedroom 3: On Entry Level,
Dimensions: 11 x 11
Full Bathrooms: 3
Total Bathrooms: 3
Kitchen: On Entry Level,
Dimensions: 16 x 12
Living Room: On Entry Level,
Dimensions: 17 x 13
Above Grade Finished Sq Ft: 2007
Total Finished Sq Ft: 2007
Exterior Features
Foundation: Basement
Garage/Parking
Garage Spaces: 2
Garage: Yes
Utilities
Sewer: Public Sanitary
Water: Public Water
Condo/Co-op/Association
HOA Fees: 175
HOA Fee Frequency: Monthly
Association Fee: Yes
Lot Info
Assessor Parcel Number: 0824325147
Geo Subdivision: MI
Tax Info
Summer Tax: Year: 2010, Amount: $1,904.00
Winter Tax: Year: 2010, Amount: $1,000.00
MLS Schools
School District: New Haven Community Schools
Ownership History
DateNameOwned ForOwner Type
Apr 2025 - PresentLewis Hannah Jean and Lewis Greg4 Months
Private Individual
Purchase Details
Closed on
Apr 23, 2025
Sold by
Lewis Hannah Jean
Bought by
Lewis Hannah Jean and Lewis Greg
Current Estimated Value
$410,994
Jul 2021 - Apr 2025Lewis Hanna Jean3 Years and 9 Months
Private Individual
Purchase Details
Listed on
Jun 18, 2021
Closed on
Jul 15, 2021
Sold by
Vanhoorne Mary
Bought by
Lewis Hanna Jean
Seller's Agent
Jason Garvan
Realty Professionals
Buyer's Agent
Eric Wilhelm
Real Estate One Inc-Shelby
List Price
$340,000
Sold Price
$340,000
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.58%
Aug 2019 - Jul 2021Vanhoome Mary1 Year and 11 Months
Private Individual
Purchase Details
Listed on
Jun 6, 2019
Closed on
Aug 9, 2019
Sold by
Lavender Cynthia
Bought by
Vanhoome Mary
Seller's Agent
Laura Pazdzierz
Brookstone, Realtors LLC
Buyer's Agent
Deborah Serra
Serra & Associates Real Estate Inc
List Price
$309,000
Sold Price
$275,000
Premium/Discount to List
-$34,000
-11%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.62%
Mar 2012 - Aug 2019Lavender Cynthia7 Years and 5 Months
Private Individual
Purchase Details
Listed on
Jan 26, 2012
Closed on
Mar 23, 2012
Sold by
Federal Home Loan Mortgage Corporation
Bought by
Lavender Cynthia
Seller's Agent
Kent Colpaert
Bearing Group
Buyer's Agent
Susan Faison
Temporary Inactive Users
List Price
$159,900
Sold Price
$150,000
Premium/Discount to List
-$9,900
-6.19%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.55%
Original Mortgage
$146,197
Interest Rate
4.25%
Mortgage Type
FHA
Jan 2011 - Mar 2012Federal Home Loan Mortgage Corp1 Year and 2 Months
Company
Purchase Details
Closed on
Jan 14, 2011
Sold by
Devore David K and Devore Christina M
Bought by
Federal Home Loan Mortgage Corp
Jul 2007 - Jan 2011Devore David K and Devore Christina M3 Years and 6 Months
Private Individual
Purchase Details
Closed on
Jul 20, 2007
Sold by
Pulte Land Co Llc
Bought by
Devore David K and Devore Christina M
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Great spotless first floor ranch condo. in move-in condition. Features living room with doorwall to terrace. Brand new carpet. Neutral paint/decor. Water & trash included in fee. Main/hall bath recently remodeled with marble tile shower walls & floor, raised panel vanity & one piece top. Oak kitchen with a full set of included appliances and island with overhang for seating. Breakfast area next
Collateral Analytics
Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.
Not Available
Collateral Analytics does not have data for the current month. Please view the chart for historical values.
ICE
ICE Mortgage Technology
ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.
Not Available
ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.
First American
First American
First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.
Not Available
First American does not have data for the current month. Please view the chart for historical values.
Quantarium
Quantarium
Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.
Not Available
Quantarium does not have data for the current month. Please view the chart for historical values.
Average Value
Not Available
List Price
Sold Price
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
Tax AssessmentTax 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.
This home is located at 49615 Hiddenbrook Dr Unit 147, Macomb, MI 48042 and is currently priced at $150,000, approximately $74 per square foot. This property was built in 2007. 49615 Hiddenbrook Dr Unit 147 is a home located in Macomb County with nearby schools including New Haven High School and Austin Catholic Academy.
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.