174 Aspen Pine Dr
Clarksville, TN 37043
- 3 beds
- 2 baths
- 1,831 sqft
- $259 per sqft
- 2025 build
- – on site
BEAUTIFULLY CRAFTED contemporary masterpiece, designed for modern living with thoughtful details throughout. Boasting a bright white exterior that stands out with style and sophistication, this home offers the perfect blend of luxury, comfort, and functionality. Make your grand entrance through the 8ft front door to the spacious entry foyer where you’ll be greeted with an open-concept floor plan (seamlessly connecting the living, dining, and kitchen areas) and the most thoughtfully designed split-bedroom layout, ensuring privacy for all family members and guests. The home features warm neutrals throughout, creating a serene and inviting atmosphere. The spacious master suite is a true retreat; offering a generously sized bedroom with a luxurious, uniquely customized en-suite bathroom. Enjoy the convenience of direct access to the laundry room through the master closet, making chores that much easier. Step outside the rear 8ft door to the back patio and relax by the stunning stone fireplace—perfect for cozy evenings or hosting outdoor gatherings. Dual ceiling fans ensure a comfortable temperature year-round, regardless of the weather, making this space ideal for enjoying the outdoors in any season.
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 May 4, 2025
•
MLS# 2822435 —
The Building
-
Year Built:2025
-
Year Built Details:NEW
-
New Construction:true
-
Construction Materials:Fiber Cement
-
Architectural Style:Contemporary
-
Roof:Shingle
-
Stories:1
-
Levels:One
-
Basement:Crawl Space
-
Other Equipment:Air Purifier
-
Patio And Porch Features:Patio, Covered
-
Security Features:Carbon Monoxide Detector(s), Smoke Detector(s)
-
Building Area Units:Square Feet
-
Building Area Total:1831
-
Building Area Source:Builder
-
Above Grade Finished Area:1831
-
Above Grade Finished Area Units:Square Feet
-
Above Grade Finished Area Source:Builder
-
Below Grade Finished Area Source:Builder
-
Below Grade Finished Area Units:Square Feet
Interior
-
Interior Features:Built-in Features, Ceiling Fan(s), Entrance Foyer, Extra Closets, Open Floorplan, Pantry, Walk-In Closet(s), Primary Bedroom Main Floor
-
Flooring:Vinyl
-
Fireplace:true
-
Fireplaces Total:1
-
Fireplace Features:Gas
-
Laundry Features:Electric Dryer Hookup, Washer Hookup
Room Dimensions
-
Living Area:1831
-
Living Area Units:Square Feet
-
Living Area Source:Builder
Location
-
Directions:I24 to Exit 8 - East on Rossview Road. Left onto Rollow Ln. Right on Dunlop Ln. **Set GPS to Kirkwood Church** Left on Kirkwood Road. Right into The Park at Oliver Farms subdivision - Left onto Aspen Pine Drive - Property will be on the left.
-
Latitude:36.59945539
-
Longitude:-87.21011679
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Lot Features:Level
-
Lot Size Acres:0.26
-
Lot Size Area:0.26
-
Lot Size Units:Acres
-
Lot Size Source:Calculated from Plat
-
View:false
-
Property Attached:false
Listing Agent
- Contact info:
- Agent phone:
- (931) 216-6911
- Office phone:
- (931) 552-1700
Taxes
-
Tax Lot:19
-
Tax Annual Amount:999
Beds
-
Bedrooms Total:3
-
Main Level Bedrooms:3
Baths
-
Total Baths:2
-
Full Baths:2
The Listing
-
Special Listing Conditions:Standard
Heating & Cooling
-
Heating:Central
-
Heating:true
-
Cooling:Ceiling Fan(s), Central Air
-
Cooling:true
Utilities
-
Utilities:Water Available
-
Sewer:Public Sewer
-
Water Source:Public
Appliances
-
Appliances:Dishwasher, Disposal, Microwave, Refrigerator, Stainless Steel Appliance(s), Smart Appliance(s)
Schools
-
Elementary School:Kirkwood Elementary
-
Middle Or Junior School:Kirkwood Middle
-
High School:Kirkwood High
The Community
-
Subdivision Name:Park at Oliver Farms
-
Senior Community:false
-
Waterfront:false
-
Pool Private:false
-
Association:true
-
Association Amenities:Sidewalks, Underground Utilities
-
$52Association Fee:
-
Association Fee Includes:Trash
-
Association Fee Frequency:Monthly
-
Association Fee 2:275
-
Association Fee 2 Frequency:One Time
Parking
-
Parking Total:2
-
Parking Features:Garage Door Opener, Garage Faces Front
-
Garage:true
-
Attached Garage:true
-
Garage Spaces:2
-
Covered Spaces:2
-
Carport:false
Monthly cost estimate

Asking price
$475,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. |
$2,543
|
Taxes | $83 |
Insurance | $130 |
HOA fees | $52 |
Utilities | $144 See report |
Total | $2,952/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).
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 |
---|---|---|---|---|
4/24/25
Apr 24, 2025
|
Listed / Active | REALTRACS | $475,000 |