$3,250,000
SOLD OCT 1, 2025
6 Beds
8 Baths
8,800 Sq Ft
0.96 Acres

Recently Sold

$369 Per Sq Ft

2% Below List Price

3 Days on Market

Highlights

  • Heated Pool and Spa
  • Open Floorplan
  • Fireplace in Primary Bedroom
  • Providence Spring Elementary Rated A-
  • French Provincial Architecture
  • Private Lot

About This Home

As of October 2025

Tucked away in highly desirable Providence Plantation, this estate is an entertainer's dream! This home features a multitude of interior & exterior gathering spaces, saltwater pool/spa & lush mature landscaping in a private cul-de-sac setting! The main level of the home features expansive accordion style doors leading to a large terrace with breath-taking views of the back yard oasis--pool & spa, pool cabana & covered veranda w/ fireplace. The primary bedroom has 3 separate closets, a luxurious bath with heated floors and is located on the main level as well as a guest suite with zero entry shower and wide doors to accommodate any mobility challenges. Each secondary bedroom has an ensuite. The additional lower level 2 car garage provides no steps to enter which is ideal for multi-generational living! The lower level has an oversized guest suite, kitchen/bar area, theater room, wine cellar, billiard room, and exercise room with sauna! Don't miss this meticulously maintained home!

Last Agent to Sell the Property

David Kostelnik

Corcoran HM Properties Brokerage Email: davidkostelnik@hmproperties.com License #301380 Listed on: 08/15/2025

Corcoran HM Properties

Co-Listed By

Tina Kostelnik

Corcoran HM Properties Brokerage Email: davidkostelnik@hmproperties.com License #301381

Last Buyer's Agent

Elizabeth Peacock Sikora

Ivester Jackson Christie's License #333671

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2006

Lot Details

  • Cul-De-Sac
  • Back Yard Fenced
  • Private Lot
  • Irrigation
  • Wooded Lot
  • Property is zoned N1-A

Parking

  • 4 Car Attached Garage
  • Basement Garage

Home Design

  • French Provincial Architecture
  • Stone Veneer
  • Stucco

Interior Spaces

  • 2-Story Property
  • Open Floorplan
  • Wet Bar
  • Built-In Features
  • Bar Fridge
  • Gas Fireplace
  • Mud Room
  • Entrance Foyer
  • Family Room with Fireplace
  • Living Room with Fireplace
  • Den with Fireplace
  • Finished Basement
  • Walk-Out Basement
  • Walk-In Attic
  • Laundry Room

Kitchen

  • Breakfast Bar
  • Range Hood
  • Dishwasher
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Garden Bath

Pool

  • Heated Pool and Spa
  • Heated In Ground Pool
  • Fence Around Pool

Outdoor Features

  • Covered Patio or Porch
  • Terrace

Schools

  • Providence Spring Elementary School
  • Crestdale Middle School
  • Providence High School

Utilities

  • Forced Air Heating and Cooling System

Community Details

  • Property has a Home Owners Association
  • Voluntary home owners association
  • Providence Plantation Subdivision

Listing and Financial Details

  • Assessor Parcel Number 227-423-41

Home Details

Home Type

Single Family

Year Built

Built in 2006

Lot Details

0

Parking

4

Listing Details

  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: French Provincial
  • Year Built: 2006
  • Road Surface Type: Concrete, Paved
  • Unit Levels: Two
  • Ratio CurrentPrice/TotalPropertyHLA: 369.32
  • Geocode Confidence: High
  • Attribution Contact: davidkostelnik@hmproperties.com
  • Special Features: VirtualTour

Interior Features

  • Foundation Details: Basement
  • Fireplace: Yes
  • Interior Amenities: Attic Walk In, Breakfast Bar, Built-in Features, Drop Zone, Entrance Foyer, Garden Tub, Kitchen Island, Open Floorplan, Walk-In Closet(s), Wet Bar
  • Lower Level Sq Ft: 0
  • Main Level Sq Ft: 3421
  • Third Level Sq Ft: 0
  • Sq Ft Unheated Third: 1593
  • Sq Ft Unheated Total: 2226
  • Sq Ft Unheated Upper: 633
  • Sq Ft Upper: 2400
  • Appliances: Bar Fridge, Dishwasher, Disposal, Exhaust Hood
  • Above Grade Finished Sq Ft: 5821
  • Has Basement: Finished, Walk-Out Access
  • Basement YN: Yes
  • Full Bathrooms: 6
  • Half Bathrooms: 2
  • Total Bedrooms: 6
  • Below Grade Sq Ft: 2979
  • Fireplace Features: Den, Family Room, Gas, Living Room, Primary Bedroom
  • Living Area: 8800
  • Bedroom Main: 2
  • Bedroom Basement: 1

Exterior Features

  • Exterior Features: In-Ground Hot Tub / Spa, In-Ground Irrigation
  • New Construction: No
  • Construction Type: Site Built
  • Fencing: Back Yard
  • Pool Features: Fenced, Heated, In Ground, Pool/Spa Combo
  • Exclusions: Painted canvas in dining room
  • Construction Type: Hard Stucco, Stone Veneer
  • Patio And Porch Features: Covered, Patio, Porch, Rear Porch, Terrace

Garage/Parking

  • Main Level Garage YN: 1
  • Carport Y N: No
  • Garage Spaces: 4
  • Garage Yn: Yes
  • Open Parking: No
  • Parking Features: Basement, Attached Garage, Garage Faces Side

Utilities

  • Heating: Forced Air
  • Sewer: Public Sewer
  • Laundry Features: Laundry Room, Main Level
  • Cooling: Central Air
  • Water Source: City

Condo/Co-op/Association

  • Hoa Subject To Dues: Voluntary
  • Senior Community: No
  • Association: Yes

Schools

  • Middle Or Junior School: Crestdale
  • HOA Subject To: Optional

Lot Info

  • Lot Features: Cul-De-Sac, Private, Wooded
  • Lot Size Units: Acres
  • Parcel Number: 227-423-41
  • Additional Parcels: No
  • Zoning Specification: N1-A

MLS Schools

  • Elementary School: Providence Spring
  • High School: Providence

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 15, 2025
Closed on
Sep 30, 2025
Sold by
Rivas Revocable Trust and Rivas Eric J
Bought by
Sharp Hadley Jean and Martin Benjamin David
Seller's Agent
David Kostelnik
Corcoran HM Properties
Buyer's Agent
Elizabeth Peacock Sikora
Ivester Jackson Christie's
List Price
$3,300,000
Sold Price
$3,250,000
Premium/Discount to List
-$50,000
-1.52%
Views
16
Current Estimated Value
$2,818,053

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$431,947
Avg. Annual Appreciation
-43.47%
Original Mortgage
$2,275,000
Outstanding Balance
$2,275,000
Interest Rate
5.5%
Mortgage Type
New Conventional
Estimated Equity
$543,053

Purchase Details

Closed on
Dec 17, 2024
Sold by
Rivas Eric J and Rivas Rochelle E
Bought by
Rivas Revocable Trust and Rivas

Purchase Details

Listed on
Apr 4, 2018
Closed on
Aug 31, 2018
Sold by
Bare Michael R and Bare Patricia V
Bought by
Rivas Eric J and Rivas Rochelle E
Seller's Agent
Matt Boyd
Berkshire Hathaway HomeServices Carolinas Realty
Buyer's Agent
Kirsten Muller
ProStead Realty
List Price
$1,499,999
Sold Price
$1,400,000
Premium/Discount to List
-$99,999
-6.67%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
9.99%
Original Mortgage
$940,000
Interest Rate
4.5%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
May 25, 2006
Sold by
Farrell Todd M and Farrell Susan
Bought by
Bare Michael R and Bare Patricia

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$650,000
Interest Rate
6.41%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Dec 22, 2003
Sold by
Garland Russell T and Garland Noelle R
Bought by
Farrell Todd M and Farrell Susan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$552,000
Interest Rate
4.87%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

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

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Type Sale Price Title Company
Warranty Deed $3,250,000 Nh Title Group
Deed -- None Listed On Document
Deed -- None Listed On Document
Warranty Deed $1,400,000 None Available
Warranty Deed $890,000 Investors Title Insurance Co
Warranty Deed $690,000 First American Title Insuran
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $2,275,000 New Conventional
Previous Owner $940,000 Adjustable Rate Mortgage/ARM
Previous Owner $650,000 Fannie Mae Freddie Mac
Previous Owner $552,000 Purchase Money Mortgage
Closed $68,900 No Value Available
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
10/01/2025 10/01/25 Sold $3,250,000 -1.5% $369 / Sq Ft
08/18/2025 08/18/25 Pending -- -- --
08/15/2025 08/15/25 For Sale $3,300,000 +135.7% $375 / Sq Ft
08/31/2018 08/31/18 Sold $1,400,000 -6.7% $156 / Sq Ft View Prior Sale
05/08/2018 05/08/18 Pending -- -- --
04/04/2018 04/04/18 For Sale $1,499,999 -- $167 / Sq Ft
Source: Canopy MLS (Canopy Realtor® Association)

Tax History Compared to Growth

Source: Public Records

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 $13,815 $1,807,630 $332,500 $1,475,130
2024 $13,815 $1,804,200 $332,500 $1,471,700
2023 $13,373 $1,804,200 $332,500 $1,471,700
2022 $13,713 $1,408,000 $203,500 $1,204,500
2021 $13,702 $1,408,000 $203,500 $1,204,500
2020 $13,694 $1,408,000 $203,500 $1,204,500
2019 $13,679 $1,408,000 $203,500 $1,204,500
2018 $21,341 $1,621,100 $108,000 $1,513,100
2017 $21,047 $1,621,100 $108,000 $1,513,100
2016 $21,037 $1,621,100 $108,000 $1,513,100
2015 $21,026 $1,621,100 $108,000 $1,513,100
2014 $23,316 $1,810,500 $120,000 $1,690,500
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Canopy MLS (Canopy Realtor® Association)

MLS Number: 4290192

Canopy MLS (Canopy Realtor® Association)

APN: 227-423-41