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
Single-familyProperty Type
2026Year Built
0.26 acresLot Size
$117Price/Sq.Ft.
$52/moHOA Dues
2 car garageParking
Listed by Paul Perkins• SM South Carolina Brokerage LLC
Greater Lexington, located between the Saluda River and Lake Murray, is a suburban and commercial West Columbia neighborhood with lake-country scenery and a busy retail corridor. The neighborhood’s character concentrates around the U.S. 378 (Sunset Blvd) and I-20 interchange, where big-box plazas, local eateries, and steady traffic set the daily rhythm. The Icehouse Amphitheater, State Street’s indie shops, and Savage Craft Ale Works act as cultural pillars beyond the main arterials. Housing ranges from mid-century ranches to newer subdivisions, with pockets of wooded lots near creeks. Commuter routes radiate toward Columbia, while riverfront paths and lake access shape weekends. Public parks and sports complexes add open space between shopping centers and neighborhoods.
Provided by Walk Score and Local Logic
Offer insights
2005 Red Tulip Ct · $394,900
$396K and above
75% chance or better to win
Why $396K+ is a strong offer
DAYS ON MARKET
32 days
The average home goes pending in 58 days.
SALE-TO-LIST
98.4%
Most homes are selling 2% below list price.
About offer insights
Property details
Interior
Exterior
Finance
Interior features
Ceiling fans throughout
Garage door opener
Smoke detectors
Attic access
Electric fireplace (1)
Bedrooms
Master suite on second floor with double vanity, garden tub, private bath, separate shower, walk-in closet, tray ceilings
Bedroom 2 on second floor with private bath and walk-in closet
Bedrooms 3 and 4 on second floor with double vanities, shared Jack-and-Jill bath, and walk-in closets
Bedroom 5 with private bath and walk-in closet
Bathrooms
Three full bathrooms
One half bathroom
Multiple baths include double vanities and private/Jack-and-Jill configurations
Kitchen
Eat-in kitchen with island and pantry
Quartz countertops and tiled backsplash
Laminate flooring
Built-in gas cooktop with convection capabilities
Built-in stove/range
Built-in microwave
Dishwasher
Garbage disposal
Laundry & utility
Laundry on second floor (electric)
Heated laundry space
Tankless gas water heater
Flooring
Carpet in bedrooms
Tile in select areas
Laminate flooring in great room and kitchen
Heating & cooling
Central cooling with split system and zoned controls
Gas heating with split system and zoned controls on both levels
Exterior features
Covered back porch
Patio
Partial gutters
Sprinkler system
Paved road access
Home design
Two-story home
Exterior finished in stone and vinyl
Parking
Attached garage with 2 spaces (main level)
Construction
Slab foundation
Utilities
Public water
Public sewer
HOA & community
Homeowners association present
Community amenities include clubhouse, pool, playground, common area maintenance, and street light maintenance
Other
Community pool and new-construction builder warranty
Electricity and solar
View estimated energy costs and solar savings for this home
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Finished Sq. Ft.
—
Unfinished Sq. Ft.
—
Total Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Lexington County
APN
—
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 26, 2026.
Historical weather
Lexington, SC • 29073
Average low and high temperatures (°F)
54
32
62
39
73
47
80
56
81
63
89
70
93
74
84
70
84
63
75
54
68
47
57
37
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
100/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 1% for direct sun exposure in Lexington. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.9 hrs
6.8 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 2005 Red Tulip Ct
$395,506
$606 over list price of $395K
More resources
Rental earnings
Est. $2,720 per month, based on comparable rentals
Tour for free, no strings attached
Make a winning offer with the help of a local agent