Modern farmhouse perfection in the heart of downtown Concord. This thoughtfully renovated home oozes charm and feels like home the moment you walk through the door. Completely transformed from top to bottom in 2022, this stunning residence is truly move-in ready for its lucky new owners. Major upgrades completed in 2022 include new roof, plumbing, wiring, vinyl windows, exterior doors, trim, siding, front porch, crawl space with new vapor barrier, duct work, piers and insulation, HVAC, water heater, driveway, lighting, and more.
Inside, you’ll find original, gorgeous, wide plank hardwoods throughout the entire home, including very rare original chestnut floors upstairs, abundant natural light, fresh, neutral paint throughout, custom built-ins, showstopping beams throughout the main level, and a double-sided fireplace with stunning custom mantels. The beautifully designed kitchen features stainless steel appliances, granite countertops, and an abundance of cabinetry and countertop space.
The spacious primary suite on the main level offers a spa-like en-suite bath with dual vanities, gorgeous tile shower and a walk-in closet complete with custom cabinetry. Oversized secondary bedrooms, custom barn doors, and designer touches throughout showcase the incredible attention to detail poured into every inch of this home.
Enjoy evenings on the oversized deck or mornings rocking on the charming front porch saying hello to neighbors. Perfectly located in the heart of downtown Concord and just minutes from the popular social district, shopping, dining, and entertainment, this one-of-a-kind home offers the perfect blend of modern updates and timeless character.
100% financing available, No PMI and No income limits. A brochure is included in the attachments.
Active
$450,000
174 Tournament Dr SW, Concord, NC 28025
4beds
2,280sqft
Single Family Residence
Built in 1930
0.14 Acres Lot
$439,700 Zestimate®
$197/sqft
$-- HOA
What's special
Front porchAbundant natural lightCustom barn doorsCharming front porchOversized deckDesigner touches throughoutGorgeous tile shower
- 85 days
- 418
- 37
Zillow last checked:
Listing updated:
Listed by:
Heather Flohr Heather@helenadamsrealty.com,
Helen Adams Realty
Source: Canopy MLS as distributed by MLS GRID,MLS#: 4385938
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
- Main level bedrooms: 2
Primary bedroom
- Level: Main
Bedroom s
- Level: Main
Bedroom s
- Level: Upper
Bedroom s
- Level: Upper
Bathroom full
- Level: Main
Bathroom full
- Level: Main
Bathroom full
- Level: Main
Dining room
- Level: Main
Flex space
- Level: Main
Kitchen
- Level: Main
Laundry
- Level: Main
Living room
- Level: Main
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Dishwasher, Electric Water Heater, Exhaust Hood, Oven, Refrigerator
- Laundry: Laundry Room, Main Level
Features
- Built-in Features, Pantry, Walk-In Closet(s)
- Flooring: Tile, Wood
- Has basement: No
- Fireplace features: Living Room
Interior area
- Total structure area: 2,280
- Total interior livable area: 2,280 sqft
- Finished area above ground: 2,280
- Finished area below ground: 0
Property
Parking
- Total spaces: 2
- Parking features: Driveway, On Street
- Uncovered spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Front Porch
Lot
- Size: 0.14 Acres
- Dimensions: 54 x 124 x 48 x 121
- Features: Green Area
Details
- Parcel number: 56209559750000
- Zoning: RC
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farmhouse
- Property subtype: Single Family Residence
Materials
- Hardboard Siding
- Foundation: Crawl Space
Condition
- New construction: No
- Year built: 1930
Utilities & green energy
- Sewer: Public Sewer
- Water: City
Community & HOA
Community
- Subdivision: None
Location
- Region: Concord
- Elevation: 2000 Feet
Financial & listing details
- Price per square foot: $197/sqft
- Tax assessed value: $412,790
- Annual tax amount: $4,111
- Date on market: 6/1/2026
- Cumulative days on market: 70 days
- Listing terms: Cash,Conventional,FHA
- Road surface type: Concrete
Estimated market value
$439,700
$418,000 - $462,000
$2,006/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/1/2026 | Listed for sale | $450,000-3%$197/sqft |
Source: | ||
| 6/2/2023 | Sold | $464,000-0.2%$204/sqft |
Source: Public Record Report a problem | ||
| 3/8/2023 | Price change | $465,000-6.1%$204/sqft |
Source: | ||
| 1/9/2023 | Listed for sale | $495,000$217/sqft |
Source: | ||
| 11/21/2022 | Listing removed | -- |
Source: | ||
| 11/9/2022 | Price change | $495,000-3.4%$217/sqft |
Source: | ||
| 10/12/2022 | Price change | $512,500-3.1%$225/sqft |
Source: | ||
| 9/29/2022 | Price change | $529,000-8%$232/sqft |
Source: | ||
| 9/15/2022 | Listed for sale | $575,000+259.4%$252/sqft |
Source: | ||
| 8/4/2021 | Sold | $160,000-22%$70/sqft |
Source: | ||
| 7/10/2021 | Contingent | $205,000$90/sqft |
Source: | ||
| 4/16/2021 | Listed for sale | $205,000-8.4%$90/sqft |
Source: | ||
| 4/2/2021 | Listing removed | -- |
Source: | ||
| 11/6/2020 | Listed for sale | $223,900+273.2%$98/sqft |
Source: Wilkinson ERA Real Estate #3678733 Report a problem | ||
| 3/8/2018 | Sold | $60,000-44.4%$26/sqft |
Source: Public Record Report a problem | ||
| 12/22/2003 | Sold | $108,000$47/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,111 | $412,790 |
| 2024 | $4,111 +47.8% | $412,790 +81% |
| 2023 | $2,782 +77.2% | $228,000 +77.2% |
| 2022 | $1,570 +9.3% | $128,670 +9.3% |
| 2021 | $1,436 +28.8% | $117,710 +28.8% |
| 2019 | $1,115 +3.4% | $91,400 |
| 2018 | $1,079 | $91,400 |
| 2017 | $1,079 | $91,400 +1.7% |
| 2016 | -- | $89,840 |
| 2015 | -- | $89,840 |
| 2014 | $1,060 | $89,840 |
| 2013 | -- | $89,840 |
| 2012 | -- | $89,840 -12.8% |
| 2011 | -- | $103,060 |
| 2010 | -- | $103,060 |
| 2009 | -- | $103,060 |
| 2008 | -- | $103,060 +12.4% |
| 2007 | -- | $91,700 |
| 2006 | -- | $91,700 |
| 2005 | -- | $91,700 |
| 2004 | -- | $91,700 +6.5% |
| 2003 | -- | $86,100 |
| 2002 | -- | $86,100 |
| 2001 | -- | $86,100 |
| 2000 | -- | $86,100 |
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: Logan
Nearby schools
Schools provided by the listing agent
- Elementary: R Brown McAllister
- Middle: Concord
- High: Concord
Source: Canopy MLS as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.






