Columbia Northeast at 2900 Aintree Drive, Columbia
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 2 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 3 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 4 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 5 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 6 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 7 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 8 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 9 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 10 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 11 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 12 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 13 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 14 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 15 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 16 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 17 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 18 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 19 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 20 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 21 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 22 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 23 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 24 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 25 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 26 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 27 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 28 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 29 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 30 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 31 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 32 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 33 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 34 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 35 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 36 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 37 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 38 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 39 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 40 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 41 of 42
Columbia Northeast at 2900 Aintree Drive, Columbia, photo 42 of 42
42 photos

$369,000

2900 Aintree Drive
Columbia, SC 29223
Bedrooms
4
Bathrooms
3
Living area
2,560 sqft
Year built
2025

About this home

OPEN HOUSE SUNDAY 10/18 FROM 1P-3P. Forget new construction. Your move in paradise is here! Why wait to build and spend thousands on post-closing upgrades when this stunning four-bedroom, three-bath modern farmhouse is ready for you today, sitting on a prime 0.28 corner lot. This home delivers an undeniable wow factor the second you step through the front door. Dream kitchen entails quartz countertops, premium appliances, massive center island, and a walk-in pantry, perfect for everyday cooking and hosting and a pot filler for your convenience. The cozy family room showcases a modern LED fireplace and open sight lines throughout. The owner suite is tucked away on the main floor alongside two additional bedrooms, giving you the ultimate main-level convenience. A huge flexible upstairs loft area, which could be a game room, media center, or home office, plus a dedicated private bedroom and full bathroom, ideal for guests or an in-law suite. The ultimate backyard resort upgrades include above-ground pool, brand new vinyl privacy fence, solar panels, insulated shed with electricity, underground French drain system, and full gutters. that's not all, this home comes with two ten-builder warranty, still in place for peace of mind. Also an attached two-car garage and irrigation system. You simply won't find this much space, luxury, and high-value upgrades at this price point. Schedule your viewing today before it's gone. Disclaimer: CMLS has not reviewed and, therefore, does not endorse vendors who may appear in listings.

Property details

MLS
Consolidated MLS
MLS #
645143
Property type
Columbia Northeast
Subdivision
BRIARWOOD
Status
Active
Days on market
1
On market date
October 16, 2026
Stories
2
Total bathrooms
3
Garage spaces
2
Parking spaces
N/A
Lot size
0.28 acres
Loading map…

Nearby schools

Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card.

Elementary
E. L. Wright Middle
0.11 mi away · Grades 0-8
Zoned school (attendance boundary, 2015-16 data)
3.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
1,372
Student:teacher ratio
15.6:1
District
Richland 02
Middle
Dent Middle
2.12 mi away · Grades 6-8
Nearest school -- attendance-zone data not available here
4.0
Local Score (student-teacher ratio only (preliminary -- will incorporate state test-score data once available)) -- not an official state rating
Enrollment
1,133
Student:teacher ratio
13.2:1
District
Richland 02
High
Richland Northeast High
1.89 mi away · Grades 9-12
Zoned school (attendance boundary, 2015-16 data)
2.6
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: Below Average (2025)
Enrollment
1,435
Student:teacher ratio
14.6:1
District
Richland 02

Walkability

Blended score for Columbia's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).

60
Somewhat walkable
out of 100
EPA National Walkability Index
8.5 / 20 -- Below average walkable
Google Places amenity density
85 / 100
Restaurants & cafes20
Grocery stores4
Parks0
Schools7
Transit stops13
Pharmacies4

Market position

How this listing compares to current activity in Columbia, from live MLS data.

On the market 1 days -- 60 fewer days than Columbia's current average of 61 days.
For reference, the median list price across 1,374 active listings in Columbia right now is $249,900.

Mortgage calculator

Estimate only - actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$2,372/mo
$73,800 down
$295,200 loan
Principal & interest$1,915
Property tax (est.)$308
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by Consolidated MLS (COLUMBIA) via Trestle/CoreLogic. Last updated 1 days ago.

Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.