**CURRENTLY BEING BUILT*** Welcome to your future home on a 1.29-acres, perfectly positioned on Hole #1 of The Leaning Tree Golf Course. This new construction offers vaulted ceilings, a space-conscious layout, and stunning golf course views. The master suite features vaulted ceilings, a large walk-in closet, and a master bath with ceramic tile shower. High-end finishes include granite countertops, vinyl wood flooring, and soft-close kitchen cabinets.The home includes one bedroom finished in the basement that is ready for future expansion. Enjoy a 16x12 covered porch with a cathedral ceiling and steps to the backyard. The property also features a two-car garage and offers customization options for fixtures, paint colors, flooring, and tile. Utilities include a well and septic system, with natural gas available. This home will be built with attention to detail, combining modern design and functionality. Enjoy stunning golf course views and make this customizable, new construction your own.
Room Types: First Floor Bedroom, First Floor Laundry, First Flr Primary Bedroom, Living Room, Primary Bedroom, Primary Bathroom, First Flr Full Bathroom, Primary Bdrm Suite
Dining Room: On Main Floor,
Dimensions: 12 x 11
Dining Room Floor Covering: Laminate
Kitchen: On Main Floor,
Dimensions: 11 x 10
Kitchen Floor Covering: Laminate
Living Room: On Main Floor,
Dimensions: 20 x 17
Living Room Floor Covering: Laminate
Below Grade Sq Ft: 1500
Finished Below Grade Sq Ft: 1500
Above Grade Finished Sq Ft: 1500
Total Finished Sq Ft: 3000
Exterior Features
Exterior: Brick, Stone, Vinyl Siding
Exterior Features: Deck, Patio, Porch
Foundation: Basement
Frontage: 170
Road: Gravel
Frontage Type: Road
Garage/Parking
Garage: Attached Garage, Electric in Garage, Gar Door Opener
Garage Spaces: 2
Parking: Garage
Garage: Yes
Utilities
Heating: Forced Air
Heating Fuel: LP/Propane Gas
Sewer: Septic
Water: Private Well
Water Heater: Electric
Cooling: Ceiling Fan(s), Central A/C
Lot Info
Assessor Parcel Number: 31-025-4001-035
Zoning: Residential
Lot Dimensions: 170x339
Acreage: 1.29
Geo Subdivision: MI
Tax Info
Summer Tax: Year: 2023, Amount: $353.02
Winter Tax: Year: 2023, Amount: $107.85
Taxable Value: 10000
Total Tax: Amount: $460.87
SEV Year: 2023
MLS Schools
School District: Memphis Community Schools
Ownership History
DateNameOwned ForOwner Type
Dec 2024 - PresentTurner Cassandra and Turner Phillip6 Months
Private Individual
Purchase Details
Listed on
Jun 19, 2024
Closed on
Dec 18, 2024
Sold by
Phillips Jeffery
Bought by
Turner Cassandra and Turner Phillip
Seller's Agent
Janelle Ainsworth
Coldwell Banker Professionals Port Huron
Buyer's Agent
Lance Starler
Logik Realty LLC
List Price
$399,900
Sold Price
$406,260
Premium/Discount to List
$6,360
1.59%
Total Days on Market
132
Views
133
Current Estimated Value
$414,667
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$8,407
Avg. Annual Appreciation
4.45%
Original Mortgage
$380,000
Outstanding Balance
$379,030
Interest Rate
6.84%
Mortgage Type
New Conventional
Estimated Equity
$35,637
Jun 2024 - Dec 2024Phillips Jeffery6 Months
Private Individual
Purchase Details
Listed on
Dec 19, 2023
Closed on
Jun 6, 2024
Sold by
Delorenzo Kristin
Bought by
Phillips Jeffery
Seller's Agent
Jason Brickel
KW Platinum
Buyer's Agent
Janelle Ainsworth
Coldwell Banker Professionals Port Huron
List Price
$29,000
Sold Price
$26,500
Premium/Discount to List
-$2,500
-8.62%
Views
71
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8680.88%
Mar 2023 - Jun 2024Delorenzo Kristin1 Year and 3 Months
Private Individual
Purchase Details
Closed on
Mar 10, 2023
Sold by
Delorenzo James and Delorenzo Kristin
Bought by
Delorenzo Kristin
Dec 2021 - Mar 2023Delorenzo James and Delorenzo Kristin1 Year and 3 Months
Private Individual
Purchase Details
Closed on
Dec 30, 2021
Sold by
Pflueger Jr Michael J
Bought by
Delorenzo James and Delorenzo Kristin
Sep 2015 - Dec 2021Smith Creek Farms Ii Llc6 Years and 3 Months
CURRENTLY UNDER CONSTRUCTION! This future home sits on 1.36 acres along The Leaning Tree Golf Course, offering peaceful views, quality craftsmanship, and customizable finishes throughout. The layout is designed for modern living with vaulted ceilings in both the main living area and the primary suite. The primary bedroom includes a large walk-in closet and a private bathroom featuring a ceramic
Janelle AinsworthColdwell Banker Professionals Port Huron
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 554 Palms Rd, Goodells, MI 48027 and is currently priced at $406,260, approximately $135 per square foot. This property was built in 2024. 554 Palms Rd is a home located in St. Clair County with nearby schools including Memphis Elementary School and Memphis Junior/Senior High School.
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.
