Providence Plantation at it's finest! Back on market at no fault to the seller! Featuring outdoor space of over a half acre of privacy on a quiet, wooded lot with a fenced yard and oversized deck. Step inside to a perfect mix of comfort and luxury with a stunning kitchen featuring quartz countertops, wine cooler, tile backsplash, and generously sized center island plus a large eating area! Separate living area and updated powder room complete the downstairs. Dual staircases lead you upstairs to the primary suite with attached flex space that can be used as a bedroom, home office or anything you can imagine! Loft area provides additional space for entertaining, workout area or additional office!
Closed
$670,000
5016 Celeste Ct, Charlotte, NC 28270
3beds
2,768sqft
Single Family Residence
Built in 1975
0.58 Acres Lot
$672,200 Zestimate®
$242/sqft
$3,403 Estimated rent
Home value
$672,200
$625,000 - $726,000
$3,403/mo
Zestimate® history
Owner options
List your home for rent
$3,403/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,403/mo
Rent Zestimate®
Refinance and save
$3,963/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,963/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Fenced yardLoft areaOversized deckStunning kitchenLarge eating areaQuiet wooded lotGenerously sized center island
Zillow last checked:
Listing updated:
Listing Provided by:
Tania Wahl taniawahl@whitestagrealtync.com,
White Stag Realty NC LLC
Bought with:
Mark Lisy
Century 21 Murphy & Rudolph
Source: Canopy MLS as distributed by MLS GRID,MLS#: 4261177
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Upper
Family room
- Level: Main
Kitchen
- Level: Main
Loft
- Level: Upper
Heating
- Electric, Forced Air
Cooling
- Central Air
Appliances
- Included: Dishwasher, Disposal, Electric Oven, Electric Range, Refrigerator, Tankless Water Heater
- Laundry: Laundry Room, Upper Level
Features
- Has basement: No
- Fireplace features: Gas Log
Interior area
- Total structure area: 2,768
- Total interior livable area: 2,768 sqft
- Finished area above ground: 2,768
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Attached Garage, Garage on Main Level
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck
Lot
- Size: 0.58 Acres
Details
- Parcel number: 22709515
- Zoning: N1-A
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Materials
- Wood
- Foundation: Crawl Space
Condition
- New construction: No
- Year built: 1975
Utilities & green energy
- Sewer: Septic Installed
- Water: City
Community & neighborhood
Location
- Region: Charlotte
- Subdivision: Providence Plantation
Other
Other facts
- Listing terms: Cash,Conventional,VA Loan
- Road surface type: Concrete, Paved
Price history
| Date | Event | Price |
|---|---|---|
| 10/23/2025 | Sold | $670,000-0.7%$242/sqft |
Source:  Canopy MLS as distributed by MLS GRID #4261177 Report a problem | ||
| 9/25/2025 | Pending sale | $675,000$244/sqft |
Source: Canopy MLS as distributed by MLS GRID #4261177 Report a problem | ||
| 9/9/2025 | Price change | $675,000-3.4%$244/sqft |
Source: Canopy MLS as distributed by MLS GRID #4261177 Report a problem | ||
| 7/12/2025 | Price change | $699,000-2.2%$253/sqft |
Source: Canopy MLS as distributed by MLS GRID #4261177 Report a problem | ||
| 5/22/2025 | Listed for sale | $715,000+2.2%$258/sqft |
Source: Canopy MLS as distributed by MLS GRID #4261177 Report a problem | ||
| 9/11/2024 | Listing removed | $699,900-2.8%$253/sqft |
Source: Canopy MLS as distributed by MLS GRID #4174003 Report a problem | ||
| 8/22/2024 | Listed for sale | $719,900+6.7%$260/sqft |
Source: Canopy MLS as distributed by MLS GRID #4174003 Report a problem | ||
| 5/31/2023 | Sold | $675,000$244/sqft |
Source: Canopy MLS as distributed by MLS GRID #4013300 Report a problem | ||
| 3/24/2023 | Listed for sale | $675,000-3.4%$244/sqft |
Source: Canopy MLS as distributed by MLS GRID #CAR4013300 Report a problem | ||
| 2/23/2023 | Listing removed | -- |
Source: Canopy MLS as distributed by MLS GRID #CAR3896388 Report a problem | ||
| 1/17/2023 | Listed for sale | $699,000-9.8%$253/sqft |
Source: Canopy MLS as distributed by MLS GRID #3896388 Report a problem | ||
| 10/3/2022 | Listing removed | -- |
Source: Canopy MLS as distributed by MLS GRID #3896388 Report a problem | ||
| 8/25/2022 | Listed for sale | $775,000+119.5%$280/sqft |
Source: Canopy MLS as distributed by MLS GRID #3896388 Report a problem | ||
| 12/10/2019 | Sold | $353,000-5.9%$128/sqft |
Source: Canopy MLS as distributed by MLS GRID #3558878 Report a problem | ||
| 11/21/2019 | Pending sale | $375,000$135/sqft |
Source: My Townhome #3558878 Report a problem | ||
| 10/10/2019 | Listed for sale | $375,000+1.6%$135/sqft |
Source: My Townhome #3558878 Report a problem | ||
| 9/13/2019 | Listing removed | $2,275$1/sqft |
Source: Jamison Property Management #3534173 Report a problem | ||
| 8/24/2019 | Price change | $2,275-3.2%$1/sqft |
Source: Jamison Property Management #3534173 Report a problem | ||
| 7/28/2019 | Listed for rent | $2,350$1/sqft |
Source: Jamison Property Management Company Report a problem | ||
| 7/25/2019 | Listing removed | $369,000$133/sqft |
Source: Savvy + Co Real Estate #3505200 Report a problem | ||
| 7/12/2019 | Price change | $369,000-1.6%$133/sqft |
Source: Savvy + Co Real Estate #3505200 Report a problem | ||
| 6/25/2019 | Price change | $375,000-6.3%$135/sqft |
Source: Savvy + Co Real Estate #3505200 Report a problem | ||
| 6/3/2019 | Price change | $400,000-2.8%$145/sqft |
Source: Savvy + Co Real Estate #3505200 Report a problem | ||
| 5/17/2019 | Price change | $411,700-1.7%$149/sqft |
Source: Savvy + Co Real Estate #3505200 Report a problem | ||
| 10/30/2018 | Price change | $419,000-4.6%$151/sqft |
Source: Allen Tate Providence @485 #3426315 Report a problem | ||
| 9/15/2018 | Listed for sale | $439,000+91.3%$159/sqft |
Source: Allen Tate Union County New Town Road #3426315 Report a problem | ||
| 6/14/2000 | Sold | $229,500$83/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,487 +1.7% | $562,300 |
| 2024 | $4,411 | $562,300 |
| 2023 | -- | $562,300 +46.3% |
| 2022 | $3,835 | $384,400 |
| 2021 | -- | $384,400 +4.1% |
| 2020 | $3,669 +0.4% | $369,100 |
| 2019 | $3,653 +9.5% | $369,100 +48.4% |
| 2018 | $3,336 +1.9% | $248,700 |
| 2017 | $3,273 | $248,700 |
| 2016 | $3,273 | $248,700 |
| 2015 | $3,273 -2.4% | $248,700 -3% |
| 2014 | $3,354 | $256,300 |
| 2013 | -- | $256,300 |
| 2012 | -- | $256,300 -1.3% |
| 2011 | -- | $259,700 +18.3% |
| 2010 | -- | $219,600 |
| 2009 | -- | $219,600 |
| 2008 | -- | $219,600 |
| 2007 | -- | $219,600 |
| 2006 | -- | $219,600 |
| 2005 | -- | $219,600 |
| 2004 | -- | $219,600 |
| 2003 | -- | $219,600 +22.6% |
| 2002 | -- | $179,060 |
| 2001 | -- | $179,060 |
| 2000 | -- | $179,060 |
Find assessor info on the county website
Neighborhood: Providence Plantation
Nearby schools
GreatSchools rating
- 8/10Providence Spring ElementaryGrades: K-5Distance: 1 mi
- 9/10Crestdale MiddleGrades: 6-8Distance: 3.9 mi
- 9/10Providence HighGrades: 9-12Distance: 1.9 mi
Schools provided by the listing agent
- Elementary: Providence Spring
- Middle: Crestdale
- High: Providence
Source: Canopy MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$672,200
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$672,200
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Charlotte Topics
