NOT LISTED FOR SALE

5142 Farmstead Dr Aiken, SC 29803

Warrenville Area

Estimated Value: $1,364,701

4 Beds
3.5 Baths
4,590 Sq Ft
$297/Sq Ft Est. Value

Sale Details

Date Sold: November 8, 2024

Last sale price $1,300,000 $283 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $9,232 / mo

58 Days on Market

Highlights

  • In Ground Pool
  • 5.32 Acre Lot
  • Pond
  • Waterfront
  • Deck
  • Traditional Architecture

About This Home

As of November 2024

Exquisite Estate in Farmstead: A Sanctuary of Elegance & Comfort Welcome to an unparalleled retreat where sophistication meets tranquility. This 2017 masterpiece, nestled within the prestigious gated Farmstead subdivision, is perched on a sprawling 5.32-acre haven, boasting breathtaking pond vistas. The estate's grandeur is immediately apparent with its meticulously sculpted landscaping and a custom wrought iron entryway that ushers you into a realm of opulence. The heart of the home is a majestic living space, crowned with tray and coffered ceilings, adorned with polished black walnut floors, and warmed by a bespoke brick fireplace. The open-concept design seamlessly integrates the living room with a culinary paradise, featuring state-of-the-art appliances, pristine granite countertops, and an inviting breakfast nook. Savor your morning espresso on the covered back porch, where tongue-and-groove ceilings and intricate gables create an idyllic backdrop for wildlife observation. The owner's suite is a sanctuary in itself, offering direct porch access, a sumptuous bathroom with dual vanities, a standalone soaking tub, a walk-in shower, and a tailor-made closet. Guests will delight in their private suite, while the main level also accommodates a chic half bath, a substantial laundry facility, and a three-car garage. The upper attic, accessible via stairs, presents generous floored space for storage. Descend to the finished basement, a testament to luxury with plush carpeting, a wet bar, a wine room behind an antique door, a versatile room with extensive storage, and two additional bedrooms sharing a comprehensive bath with pool access. The outdoor realm enchants with a fenced pool and ample space for grand soirees. The residence also features a roughed-in elevator shaft and an expansive 1500 square feet of unfinished potential, inviting you to infuse your personal touch. This home isn't just a dwelling; it's a dream sculpted into reality, awaiting your arrival.

Last Agent to Sell the Property

Nicholas Williams

Coldwell Banker Best Life Realty License #SC106196 Listed on: 07/04/2024

Coldwell Banker Best Life Realty

Last Buyer's Agent

Lindsey Vance

Real Broker LLC/Aiken License #SC95360

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 Details

Home Type

  • Single Family

Year Built

  • Built in 2017

Lot Details

  • 5.32 Acre Lot
  • Waterfront
  • Landscaped
  • Lot Has A Rolling Slope
  • Front Yard Sprinklers

HOA Fees

  • $83 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Driveway

Home Design

  • Traditional Architecture
  • Brick Veneer
  • Raised Foundation
  • Block Foundation
  • Composition Roof
  • HardiePlank Type
  • Stone

Interior Spaces

  • 4,590 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • 2 Fireplaces
  • Gas Fireplace
  • Combination Kitchen and Living
  • Breakfast Room
  • Formal Dining Room
  • Fire and Smoke Detector
  • Property Views

Kitchen

  • Eat-In Kitchen
  • Range
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Solid Surface Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet

Attic

  • Attic Floors
  • Permanent Attic Stairs

Finished Basement

  • Heated Basement
  • Walk-Out Basement
  • Basement Fills Entire Space Under The House
  • Exterior Basement Entry

Pool

  • In Ground Pool
  • Fence Around Pool

Outdoor Features

  • Pond
  • Deck
  • Patio
  • Porch

Utilities

  • Cooling Available
  • Zoned Heating
  • Well
  • Septic Tank
  • High Speed Internet

Community Details

  • Farmstead Subdivision

Listing and Financial Details

  • Assessor Parcel Number 072-12-06-003
  • Seller Concessions Not Offered

Home Details

Home Type

Single Family

Year Built

Built in 2017

Lot Details

5.32 Acres

HOA Fees

$83 per month

Parking

3

Listing Details

  • Cooling System: Electric
  • Property Type: Residential
  • Property Sub Type: Single Family Residence
  • Architectural Style: Traditional
  • Unit Levels: Two
  • Lot Size Acres: 5.32
  • Road Surface Type: Paved
  • Horses: No
  • Subdivision Name: Farmstead
  • Above Grade Finished Sq Ft: 4590.0
  • Carport Y N: No
  • Garage Yn: Yes
  • New Construction: No
  • General Property Info:List PriceSqFt: 294.12
  • Appliances Microwave: Yes
  • Appliances Refrigerators: Yes
  • Special Features: VirtualTour

Interior Features

  • Interior Amenities: Solid Surface Counters, Walk-In Closet(s), Wet Bar, Kitchen Island, Eat-in Kitchen, Pantry, High Speed Internet
  • Appliances: Microwave, Range, Refrigerator, Dishwasher, Disposal
  • Has Basement: Exterior Entry, Finished, Full, Heated, Patio, Walk-Out Access
  • Flooring: Carpet, Hardwood, Stone, Tile, Wood
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • KitchenDining Features:Breakfast Room: Yes
  • KitchenDining Features:Formal Dining Room: Yes
  • KitchenDining Features:Pantry: Yes
  • Appliances Dishwasher: Yes
  • Appliances Range: Yes
  • Interior Features:Smoke Detector(s): Yes
  • Interior Features:Walk-In Closet(s): Yes
  • Fireplace Features:Gas: Yes
  • KitchenDining Features:Eat-in Kitchen: Yes
  • KitchenDining Features:KitchenFamily Room Combo: Yes
  • Interior Features:Kitchen Island2: Yes
  • Interior Features:Solid Surface Counters: Yes
  • Basement Features:Exterior Entry: Yes
  • Attic Features:Floored: Yes
  • Attic Features:Permanent Stairs: Yes
  • Attic Features:Roughed-In: Yes
  • Community Features:None4: Yes
  • Interior Features:Wet Bar: Yes
  • Basement Features:Walk-Out Access: Yes
  • Basement Features:Full: Yes
  • Basement Features:Finished: Yes
  • Basement Features:Patio: Yes
  • Basement Features:Heated: Yes

Exterior Features

  • ExteriorFeatures: None
  • Roof: Composition
  • Construction Type: Brick Veneer, HardiPlank Type, Stone
  • Foundation Details: Block, Raised
  • Patio And Porch Features: Deck, Patio, Porch
  • Pool Features: Fenced, In Ground
  • Waterfront: Yes
  • Construction Materials:Brick Veneer: Yes
  • Lot Features:Landscaped: Yes
  • Lot Features:Sprinklers In Front: Yes
  • Patio And Porch Features:Patio2: Yes
  • Construction Materials:HardiPlank Type: Yes
  • Construction Materials:Stone2: Yes
  • Patio And Porch Features:Porch: Yes
  • Patio And Porch Features:Deck: Yes
  • Lot Features:Rolling Slope: Yes
  • Lot Features:Views: Yes
  • Lot Features:Waterfront: Yes
  • Lot Features:Pond: Yes
  • Exterior Features:None6: Yes
  • Lot Features:Pond Site: Yes

Garage/Parking

  • Garage Spaces: 3.0
  • Parking Features: Driveway
  • Attached Garage: No
  • General Property Info:Garage: Yes
  • General Property Info:Garage Spaces: 3.0
  • Parking Features:Driveway: Yes

Utilities

  • Sewer: Septic Tank
  • Heating: Zoned, Electric, Fireplace(s)
  • Water Source: Well
  • Security: Smoke Detector(s)
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Sewer Septic Tank: Yes
  • Heating:Electric: Yes
  • Heating:Fireplace(s): Yes
  • Heating:Zoned: Yes

Condo/Co-op/Association

  • Association Fee: 1000.0
  • Association Fee Frequency: Annually
  • Community Features: None
  • Association: Yes

Association/Amenities

  • General Property Info:Association: Yes
  • General Property Info:Association Fee: 1000.0
  • General Property Info:Association Fee Frequency: Annually
  • Horse Amenities:None12: Yes

Lot Info

  • Horse Amenities: None
  • Lot Features: Rolling Slope, Views, Waterfront, Landscaped, Pond, Pond Site, Sprinklers In Front
  • Parcel #: 072-12-06-003
  • Lot Size Sq Ft: 231739.2

Building Info

  • Year Built: 2017

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 4, 2024
Closed on
Nov 4, 2024
Sold by
Bought by
Seller's Agent
Nicholas Williams
Coldwell Banker Best Life Realty
Buyer's Agent
Lindsey Vance
Real Broker LLC/Aiken
List Price
$1,350,000
Sold Price
$1,300,000
Premium/Discount to List
-$50,000
-3.7%
Views
74
Current Estimated Value
$1,364,701

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$64,701
Avg. Annual Appreciation
2.77%
Original Mortgage
$910,000
Outstanding Balance
$891,272
Interest Rate
6.08%
Mortgage Type
New Conventional
Estimated Equity
$473,429

Purchase Details

Listed on
Jan 26, 2023
Closed on
May 4, 2023
Sold by
Bought by
Seller's Agent
Gail Gingrey Team
Meybohm Real Estate - Aiken
Buyer's Agent
Non Member
Non Member Office
List Price
$1,485,000
Sold Price
$1,290,000
Premium/Discount to List
-$195,000
-13.13%
Views
77

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.53%
Original Mortgage
$1,032,600
Interest Rate
6.27%
Mortgage Type
Balloon

Purchase Details

Closed on
Dec 18, 2006
Sold by
Bought by

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$185,000
Interest Rate
6.31%
Mortgage Type
Credit Line Revolving
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Aiken, SC

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
$1,300,000 None Listed On Document
$1,290,000 None Listed On Document
$185,000 None Available
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open $910,000
Previous Owner $1,032,600
Previous Owner $777,750
Previous Owner $656,000
Previous Owner $185,000
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/08/2024 11/08/24 Sold $1,300,000 -3.7% $283 / Sq Ft
09/01/2024 09/01/24 Pending -- -- --
07/04/2024 07/04/24 For Sale $1,350,000 +4.7% $294 / Sq Ft
05/23/2023 05/23/23 Sold $1,290,000 0.0% $281 / Sq Ft View Prior Sale
05/23/2023 05/23/23 Sold $1,290,000 -13.1% $281 / Sq Ft View Prior Sale
04/10/2023 04/10/23 Pending -- -- --
01/26/2023 01/26/23 For Sale $1,485,000 +6.1% $324 / Sq Ft
09/06/2022 09/06/22 Price Changed $1,399,000 -5.8% $305 / Sq Ft
07/25/2022 07/25/22 For Sale $1,485,000 -- $324 / Sq Ft
Source: Aiken Association of REALTORS®

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $19,938 $77,370
2023 $2,979 $29,040 $5,310 $593,180
2022 $2,904 $29,040 $0 $0
2021 $2,910 $29,040 $0 $0
2020 $2,828 $27,830 $0 $0
2019 $2,828 $27,830 $0 $0
2018 $2,839 $27,830 $5,310 $22,520
2017 $1,862 $0 $0 $0
2016 $1,863 $0 $0 $0
2015 $1,798 $0 $0 $0
2014 $1,800 $0 $0 $0
2013 -- $0 $0 $0
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Aiken Association of REALTORS®

MLS Number: 212680

Aiken Association of REALTORS®

APN: 072-12-06-003

Your Personal Tour Guide

Ask me questions while you tour the home.