- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes





Street View
$359,000
Monthly Est:$1,787
4 Beds
- 3 Baths
3 full baths
2,560sqft
2900 Aintree, Columbia, SC 29223
$359,000
$1,787/moEst:
Get Pre-Approved
Single Family Residence
Built in 2025
$-- HOA
12,196.8 sqft lot
$140/sq.ft
Description
PRICE DROP!! AND THAT'S NOT ALL SELLERS ARE ALSO PROVIDING $10,000 TOWARDS CLOSING COST OR RATE BUYDOWN!! NO HOA! 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.
- Houzeo last checked: 2 hours ago
- Listing updated: November 2, 2026 at 1:12 pm
- Listing Provided by: Lisa Lawson | Better Homes & Gardens RE Palmetto
- Source: Consolidated MLS-SC | MLS#: 645143

Property Details
Status
Pending
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
2025
HOA Fees
-
Finished Area
2,560 sqft
Lot Size
12,196.8 sqft lot
Basement Area
- sqft
MLS Name
Consolidated MLS
MLS Number
645143
Days on Market
19

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 4
Bathrooms: 3
Bedroom 3
Level: Main
Primary Bedroom
Level: Main
Bedroom 2
Level: Main
Bedroom 4
Level: Second
Interior
Cooling
Central
Sewer
Public
Interior Features
Garage Opener, Smoke Detector
Heating
Electric
Construction
Year Built
Year Built: 2025
Home type
Single Family Residence
Architectural Style
Traditional
Construction Materials
Stone, Vinyl
Foundation Details
Slab
Utilities & Energy
Parking Features
Garage Attached, Front Entry
Fireplace Features
Gas Log Natural
Pool Features
Above Ground Pool
Water Source
Public
Other Features
Subdivision Name
Briarwood
Price History
| Date | Event | Price |
|---|---|---|
11/02/2026 Source: | Pending | $359,000 +5.62% $140/sqft |
02/09/2026 Source: | Off Market | $339,900 $133/sqft |
Nearby Homes
Find Homes by Property Features in Columbia, SC
Based on information from the Consolidated Multiple Listing Service (Alternatively, from Columbia MLS or CMLS) through Nov 04, 2026, 12:45PM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. © 2026 Consolidated Multiple Listing Service, Inc. All Rights Reserved.
Advertising Broker: Nicholas Huscroft | Chosen Realty









