Lexington and surrounding area at 2005 Red Tulip Court, Lexington
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 2 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 3 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 4 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 5 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 6 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 7 of 8
Lexington and surrounding area at 2005 Red Tulip Court, Lexington, photo 8 of 8
8 photos

$394,900

2005 Red Tulip Court
Lexington, SC 29073
Bedrooms
4
Bathrooms
3.5
Living area
3,366 sqft
Year built
2026

About this home

Introducing the NEW Orchard floorplan now offered in The Ridge at Longview Community. Designed with resort style amenities including a community clubhouse & pool, picnic cabana, playground, athletic field & sidewalks throughout the community for riding bikes, walking dogs, or peaceful walks, Longview has it all! The Orchard floorplan offers the perfect blend of open gathering spaces, private retreats, & everyday convenience, making it an ideal choice for comfortable living & entertaining. The heart of the home is the open-concept main level, where the gourmet kitchen flows seamlessly into the dining area & spacious family room with a cozy fireplace. The kitchen features a stainless-steel hood above the gas range, a built-in wall oven, and beautiful quartz countertop island with room for seating, creating an inviting space for meal prep, casual dining, & conversation. A designated office area on the main level, complete with a built-in desk & drawers, provides a convenient workspace for managing daily tasks or working from home. The main level also includes a study with french doors offering an area for a home library, art/craft studio or guest overflow during family gatherings. At the back of the home, the covered patio with an attached uncovered patio extends the living space outdoors & is perfect for relaxing or entertaining. Upstairs, the huge primary suite offers an impressive retreat with a large walk-in closet and a luxury ensuite featuring a garden tub, separate tiled shower, dual vanities, and thoughtful finishes. Additional upstairs guest bedrooms each include walk-in closets, providing excellent storage and comfort for family or guests. The second level also features a spacious laundry room and a versatile flex space that can be used as a playroom, media room, home gym, or additional office area. No detail was overlooked in this beautiful floorplan! This neighborhood offers seamless access to I-20, Downtown Lexington, Columbia Metropolitan Airport, Downtown Columbia, and more. Contact our Neighborhood Sales Manager today to book a private tour and learn more about the construction timeline. Photos are stock photos, & design options & colors may vary. D

Property details

MLS #
643413
Property type
Lexington and surrounding area
Subdivision
Ridge at Longview
Status
Active
Days on market
15
On market date
September 9, 2026
Stories
2
Total bathrooms
3.5
Garage spaces
2
Parking spaces
N/A
Lot size
0.26 acres
Loading map…

Nearby schools

Within 10 miles · public school directory data (NCES)

Elementary
Deerfield Elementary
0.74 mi away · Grades -1-5
Zoned school (attendance boundary, 2015-16 data)
4.0
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: Good (2025)
Enrollment
808
Student:teacher ratio
13.0:1
District
Lexington 01
Middle
Carolina Springs Middle
1.5 mi away · Grades 6-8
Zoned school (attendance boundary, 2015-16 data)
3.3
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: Average (2025)
Enrollment
901
Student:teacher ratio
13.7:1
District
Lexington 01
High
White Knoll High
2.41 mi away · Grades 9-12
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
2,165
Student:teacher ratio
15.5:1
District
Lexington 01

Walkability

Blended score for Lexington's center: EPA's National Walkability Index (street network, transit, land-use mix) combined with nearby-amenity density. 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).

22
Car-dependent
out of 100
EPA National Walkability Index
6.5 / 20 -- Below average walkable
Nearby-amenity density
5 / 100
Restaurants & cafes0
Grocery stores0
Parks0
Schools1
Transit stops0
Pharmacies0

Market position

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

On the market 15 days -- 44 fewer days than Lexington's current average of 59 days.
For reference, the median list price across 614 active listings in Lexington right now is $339,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,528/mo
$78,980 down
$315,920 loan
Principal & interest$2,049
Property tax (est.)$329
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by Consolidated MLS (COLUMBIA) via Trestle/CoreLogic. Last updated 5 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.