It's in the top 10% of views. Tour it before it's gone!
Today:
About this home
Welcome to The White Farmhouse Manor at Ascot—a 2023 renovated modern estate on a 1-acre corner lot. Features 25–30 ft cathedral ceilings, solid pine wide-plank hardwoods, Restoration Hardware lighting, and privacy-tinted windows with motorized shades. The gourmet kitchen offers a quartz island, Z-Line gas range, double oven, hidden fridge, and butler's pantry with a water bottle filler. Main-floor primary suite boasts a fireplace, pool deck access, spa bath with bidet toilet, makeup vanity with champagne bar, and custom closet with laundry #1. Upstairs includes a 2nd primary suite, 2 en suite bedrooms, media room with half bath, and laundry #2. Outdoor resort features a renovated gunite pool, water features, outdoor kitchen/fireplace, covered patios, plus a new 570 sq ft 1-bed/1-bath guest house with full kitchen & fireplace. Includes 3-car epoxy garage (heated/cooled 3rd bay workshop + EV charger), 5 total fireplaces, central vac, and whole-home filter. Zoned for Dutch Fork Schools!
Ascot Estates, located between Two Notch Road and I-20, is a residential and suburban Columbia neighborhood with curving cul-de-sacs and mature tree cover. The neighborhood reads as classic late-20th-century Columbia, with brick-front homes, broad lawns, and a quiet, inward-facing street pattern. The area’s everyday energy concentrates around the Two Notch Road and Polo Road corridor, where local strip plazas and service storefronts set the pace. Community touchstones nearby include Sesquicentennial State Park for wooded trails and lake views, the Columbia Place mall site’s retail cluster, and the Village at Sandhill for dining and events. Short drives connect to Northeast Columbia’s greenways, big-box corridors, and commuter routes while keeping the streetscape calm.
Provided by Walk Score and Local Logic
Market insights
$1,450,000
DAYS ON MARKET
1 days
The average home goes pending in 56 days.
SALE-TO-LIST
98.5%
Most homes are selling 2% below list price.
LIST PRICE
$1,450,000
Median sale price in this area is $274,433. (81% lower than this home)
PRICE DROP
0 price drops
28% of homes in this area have had a price drop in the past month.
Property details
Interior
Exterior
Finance
Kitchen
Bathroom
Bedroom
Living
Dining
Interior features
Central vacuum
Kitchen island
Pantry
Walk-in closets
Storage
Wet bar
French doors
Fireplace in the den, family room, and primary bedroom
Bedrooms
5 bedrooms: 1 on the main level, 3 on the upper level, and 1 in the second living quarters
Bathrooms
5 full bathrooms: 1 on the main level, 3 on the upper level, and 1 in the second living quarters
2 half bathrooms: 1 on the main level and 1 on the upper level
Kitchen
Bar fridge
Dishwasher
Disposal
Double oven
Gas cooktop
Refrigerator
Warming drawer
Wine refrigerator
Laundry & utility
Washer
Dryer
Washer/dryer
Laundry areas in the bathroom, on the main level, and on the upper level
Flooring
Tile
Wood
Heating & cooling
Central heating
Central air conditioning
Ceiling fans
Exterior features
Balcony
Patio
In-ground irrigation
Outdoor kitchen
Fenced yard
Private in-ground pool
Home design
Single-family residence
Two levels
Parking
Three-car attached garage
Circular driveway
Driveway
Garage door opener
Side-facing garage
Electric vehicle charging station
Security
Security system
Construction
Brick construction
Slab foundation
Utilities
City water
Public sewer
HOA & community
Mandatory HOA with annual dues of $1,200
Community amenities include a clubhouse, outdoor pool, playground, and tennis courts
Architectural review restrictions
Other
Guest house with a separate entrance and kitchen facilities
Electricity and solar
View estimated energy costs and solar savings for this home
Exquisite modern Tudor estate in Ascot Estates, fully renovated in 2023 on a pristine 1-acre corner lot with a circular drive. This masterpiece features a 4800 sq ft main home plus a 570 sq ft detached guest house (ADU). Step into a grand cathedral entry leading to soaring 25–30 ft ceilings, solid pine wide-plank hardwoods, Restoration Hardware lighting, and floor-to-ceiling windows with motorized shades and privacy/heat tinting. The gourmet kitchen is a chef’s dream: oversized quartz island with a hidden appliance rack, Z-Line gas range, double oven with warming drawer, Z-Line wine cabinet, adjacent scullery kitchen, and a walk-in pantry with a built-in filtered water station. The main-floor primary suite is a true sanctuary with a private fireplace and direct pool access. Its luxury spa bath boasts a European bidet, soaking tub, vanity with professional beauty lighting, and custom wine/champagne bar. The custom walk-in closet includes 2 hidden safes and connects to a main-floor laundry. Up stairs features a 2nd primary suite, 2 additional ensuite bedrooms, a media room with half bath, and a 2nd laundry room. Outdoors, enjoy a resort-style oasis with a salt-water gunite pool, water features, outdoor kitchen, fireplace, covered patios, and inner courtyard. The detached ADU guest house is a full studio apartment with a full kitchen, bath, fireplace, and laundry hookups. The 3-car garage includes epoxy floors and an EV charger; the climate-controlled 3rd bay features a center island for a workshop or package station. Highlights include 5 fireplaces, whole-home water filtration, central vac, and award-winning Dutch Fork schools! Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.
CANOPYMLS as Distributed by MLS Grid #4414230
Aug 12, 2026
Listed
$1,450,000
$269/sq ft
Public Records
Jul 8, 2024
Sold
$1,290,000
$240/sq ft
Consolidated MLS #578003
May 2, 2024
Contingent
—
Apr 15, 2024
Price Changed
$1,420,000
$264/sq ft
Jan 29, 2024
Listed
$1,500,000
$279/sq ft
Public Records
Oct 28, 2022
Sold
$710,000
$132/sq ft
Consolidated MLS #544817
Oct 6, 2022
Price Changed
$719,900
$134/sq ft
Sep 22, 2022
Price Changed
$739,900
$137/sq ft
Jul 7, 2022
Listed
$749,900
$139/sq ft
Public Records
Jun 20, 2022
Sold
$710,000
$132/sq ft
Public Records
Oct 28, 2013
Sold
$570,000
$106/sq ft
Public Records
Nov 14, 2003
Sold
$592,000
$110/sq ft
Public Records
Oct 3, 1997
Sold
$65,000
$12/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$35,823 (+56.4%)
$90,000 + $1,200,000
$1,290,000
2024
$22,905 (+15.2%)
$90,000 + $730,000
$820,000
2023
$19,887 (+453.8%)
$80,000 + $630,000
$710,000
2022
$3,591 (−2.3%)
$80,000 + $405,400
$485,400
2021
$3,677 (−4.4%)
$80,000 + $405,400
$485,400
2020
$3,845 (+0.8%)
$80,000 + $405,400
$485,400
2019
$3,814 (−3.3%)
$80,000 + $405,400
$485,400
2018
$3,945 (+2.7%)
$72,500 + $497,500
$570,000
2017
$3,840 (+0.5%)
$72,500 + $497,500
$570,000
2016
$3,820 (−8.0%)
$72,500 + $497,500
$570,000
2014
$4,154 (+4.5%)
$72,500 + $497,500
$570,000
2013
$3,974
$3,620 + $19,450
$23,070
Public record
Beds
4
Baths
4
Stories
1.5
Lot width
—
Lot depth
—
Lot size
1 Acre
Year renovated
2000
Finished Sq. Ft.
4,820
Unfinished Sq. Ft.
—
Total Sq. Ft.
4,820
Year built
2000
Style
Single Family Residential
County
Richland County
APN
053020401
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 2, 2026.
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
2/10 Fire Factor
0.15% chance of being in a wildfire in next 30 years
6/10 Heat Factor
7 hot days expected this year, 16 days in 30 years
Wind Factor
We're working on getting current and accurate wind risk information for this home.
Air Factor
We're working on getting current and accurate air risk information for this home.
Provided by First Street
Historical weather
Irmo, SC • 29063
Average low and high temperatures (°F)
53
33
60
40
72
48
79
56
80
62
89
70
91
75
83
70
84
64
74
54
68
47
57
38
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Redfin Estimate
We cannot show automated home-value estimates for this home.
Tour for free, no strings attached
Make a winning offer with the help of a local agent