770 Franklin Tree Drive NW
Concord, NC 28027
- 4 beds
- 4 baths
- 4,374 sqft
- 12,197 sqft lot
- $217 per sqft
- 2012 build
- – on site
SPEECHLESS...that is literally what you will be once you see this amazing home in person. Full-brick Shea Homes Alpine home w/3-car garage must be seen to be appreciated. The deep rocking chair stone & wood-accented front porch just begs you to relax & stay a while. Step inside & revel in the abundant features & upgrades which include: gorgeous hrdwd floors throughout main level (tile in laundry & full BA), expansive foyer flanked by DR & OFC w/built-ins, designer details like tray ceilings, trim work, neutral paint, show-stopping KIT, keeping rm & connected great rm combination, incredible amount of counter space/cabinets in the KIT & butler's pantry. Not one, not two, but THREE fireplaces make for many cozy evenings, custom built-ins in various areas, convenient 1st floor drop zone/laundry/family central. Beautiful 1st floor primary! Oversized BON RM, loft, 3 BRs & 2BAs complete the 2nd floor. AMAZING screen porch & paver patio w/firepit. You will never want to leave. Welcome Home!!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Feb 21, 2025
•
MLS# 4224596 —
The Building
-
Year Built:2012
-
New Construction:false
-
Construction Type:Site Built
-
Subtype:Single Family Residence
-
Construction Materials:Brick Full
-
Builder Name:Shea Homes
-
Builder Model:Alpine
-
Roof:Shingle
-
Foundation Details:Crawl Space
-
Levels:Two
-
Basement:false
-
Patio And Porch Features:Deck, Front Porch, Patio, Rear Porch, Screened, Other - See Remarks
-
Door Features:French Doors, Insulated Door(s), Storm Door(s)
-
Security Features:Security System, Smoke Detector(s)
-
SqFt Upper:1819
-
Above Grade Finished Area:4374
Interior
-
Features:Attic Other, Attic Stairs Pulldown, Breakfast Bar, Built-in Features, Garden Tub, Kitchen Island, Open Floorplan, Pantry, Walk-In Closet(s), Walk-In Pantry
-
Flooring:Carpet, Hardwood, Tile
-
Living Area:4374
-
Fireplace:true
-
Fireplace Features:Gas Log, Gas Unvented, Gas Vented, Great Room, Keeping Room, Porch
Location
-
Latitude:35.398498
-
Longitude:-80.754955
The Property
-
Type:Residential
-
Lot Size Dimensions:Per Plat
-
Lot Size Area:0.28
-
Lot Size Units:Acres
-
Zoning Specification:RV
-
Exterior Features:Fire Pit
-
Other Equipment:Surround Sound
-
Road Responsibility:Publicly Maintained Road
-
Road Surface Type:Concrete, Paved
Listing Agent
- Contact info:
- Agent phone:
- (704) 965-6866
- Office phone:
- (704) 892-5518
Taxes
-
Parcel Number:4670-74-0548-0000
-
Tax Assessed Value:857330
Beds
-
Bedrooms Total:4
-
Bedroom Main:1
-
Bedroom Upper:3
Baths
-
Baths:4
-
Full Baths:3
-
Half Baths:1
-
Full Baths Main:1
-
Half Baths Main:1
-
Full Baths Upper:2
The Listing
-
Special Listing Conditions:None
Heating & Cooling
-
Heating:Forced Air
-
Cooling:Ceiling Fan(s), Central Air
Utilities
-
Utilities:Cable Available, Electricity Connected, Fiber Optics, Gas, Underground Power Lines, Underground Utilities
-
Sewer:Public Sewer
-
Water Source:City
Appliances
-
Appliances:Convection Microwave, Dishwasher, Disposal, Gas Cooktop, Gas Water Heater, Microwave, Plumbed For Ice Maker, Refrigerator, Wall Oven
-
Laundry Features:Electric Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
Schools
-
Elementary School:Cox Mill
-
Middle School:Harris Road
-
High School:Cox Mill
The Community
-
Subdivision Name:Winding Walk
-
Community Features:Clubhouse, Game Court, Outdoor Pool, Playground, Sport Court, Street Lights, Tennis Court(s), Walking Trails
-
Association Name:Main Street Management
-
Association Fee:$275
-
Association Fee Paid:Quarterly
-
Proposed Special Assessment:No
-
HOA Subject To:Required
-
Pool Features:In Ground, Outdoor Pool
-
Senior Community:false
-
Development Status:Completed
Parking
-
Parking Features:Driveway, Attached Garage, Garage Door Opener, Garage Faces Front, Keypad Entry
-
Garage:true
-
Garage Spaces:3
-
Main Level Garage:Yes
-
SqFt Garage:779
-
Carport:false
-
Open Parking:false
Monthly cost estimate

Asking price
$950,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$5,086
|
Taxes | N/A |
Insurance | $261 |
HOA fees | $92 |
Utilities | $173 See report |
Total | $5,612/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
2/19/25
Feb 19, 2025
|
Listed / Active | CMLS | $950,000 |