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
New construction
Price cut: $22.7K (9/18)
$394,900
2005 Red Tulip Ct, Lexington, SC 29073
4beds
3,366sqft
Single Family Residence
Built in 2026
0.26 Acres Lot
$394,600 Zestimate®
$117/sqft
$52/mo HOA
What's special
Cozy fireplaceBuilt-in wall ovenStudy with french doorsGourmet kitchenOpen-concept main levelSpacious laundry roomLarge walk-in closet
- 29 days
- 82
- 7
Likely to sell faster than
Zillow last checked:
Listing updated:
Listed by:
Paul Perkins,
SM South Carolina Brokerage LLC
Source: Consolidated MLS,MLS#: 643413
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 4
- Full bathrooms: 3
- 1/2 bathrooms: 1
- Partial bathrooms: 1
- Main level bathrooms: 1
Rooms
- Room types: Loft, Office
Primary bedroom
- Features: Double Vanity, Tub-Garden, Bath-Private, Separate Shower, Walk-In Closet(s), Tray Ceiling(s), Ceiling Fan(s), Closet-Private, Separate Water Closet
- Level: Second
Bedroom 2
- Features: Bath-Private, Walk-In Closet(s), Closet-Private
- Level: Second
Bedroom 3
- Features: Double Vanity, Bath-Shared, Walk-In Closet(s), Closet-Private
- Level: Second
Bedroom 4
- Features: Double Vanity, Bath-Shared, Walk-In Closet(s), Closet-Private
- Level: Second
Bedroom 5
- Features: Bath-Private, Closet-Private
Great room
- Level: Main
Kitchen
- Features: Eat-in Kitchen, Kitchen Island, Pantry, Floors-Laminate, Backsplash-Tiled, Counter Tops-Quartz
- Level: Main
Heating
- Gas 1st Lvl, Gas 2nd Lvl, Split System, Zoned
Cooling
- Central Air, Split System, Zoned
Appliances
- Included: Built-In Range, Convection Oven, Counter Cooktop, Gas Range, Dishwasher, Disposal, Gas Water Heater, Microwave Built In, Stove Exhaust Vented Exte, Tankless Water Heater
- Laundry: Electric, Heated Space
Features
- Ceiling Fan(s)
- Flooring: Laminate, Carpet, Tile
- Has basement: No
- Attic: Attic Access
- Number of fireplaces: 1
- Fireplace features: Electric
Interior area
- Total structure area: 3,366
- Total interior livable area: 3,366 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage Door Opener
- Attached garage spaces: 2
Features
- Stories: 2
- Patio & porch: Patio
- Exterior features: Gutters - Partial
Lot
- Size: 0.26 Acres
- Features: Sprinkler
Details
- Parcel number: 00641101442
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Craftsman,Traditional
- Property subtype: Single Family Residence
Materials
- Stone, Vinyl
- Foundation: Slab
Condition
- New Construction
- New construction: Yes
- Year built: 2026
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Electricity Connected
Community & HOA
Community
- Features: Pool
- Security: Smoke Detector(s)
- Subdivision: Ridge at Longview
HOA
- Has HOA: Yes
- Services included: Clubhouse, Common Area Maintenance, Playground, Street Light Maintenance
- HOA fee: $620 annually
Location
- Region: Lexington
Financial & listing details
- Price per square foot: $117/sqft
- Tax assessed value: $70,000
- Annual tax amount: $139
- Date on market: 9/9/2026
- Listing agreement: Exclusive Right To Sell
- Road surface type: Paved
Estimated market value
$394,600
$375,000 - $414,000
$2,929/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/18/2026 | Price change | $394,900-5.4%$117/sqft |
Source: | ||
| 9/10/2026 | Price change | $417,605+0.2%$124/sqft |
Source: | ||
| 8/26/2026 | Listed for sale | $416,825$124/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $139 | $300 |
| 2024 | -- | -- |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 29073
Nearby schools
Schools provided by the listing agent
- Elementary: Deerfield
- Middle: Carolina Springs
- High: White Knoll
- District: Lexington One
Source: Consolidated MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.






