Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2500 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2500 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2500 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

4592 Abednego Rd
Greenbrier, TN 37073
Kim Weyrauch with Keller Williams - Clarksville, original listing - (931) 648-8500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4600 Square Feet
Agency: Keller Williams - Clarksville
Agency Phone: (931) 648-8500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Unique custom built, one owner home boasts a generous 4600 sq ft of living space featuring 5 bedrooms and 5 custom bathrooms, one of which provides direct access to the pool area. Nestled on 7.3 acres, the estate includes a 3-acre cleared section at the rear. The home is characterized by its full brick and stone exterior, complemented by a concrete driveway. Energy efficiency is ensured with spray foam insulation throughout the entire house, including the garage, which features insulated oversized doors equipped with LiftMaster wall mount openers accessible via an app. The finished walk-out basement has its own temperature-controlled unit and offers 10 ceilings (9 5 with a drop ceiling). Additional amenities include a Rain Soft water softener and filtration system, a Rain Soft air purification system, and a Generac full-home propane generator installed during the original build. The 1000-gallon propane tank is discreetly buried in the side yard. The property is securely enclosed by aluminum black fencing and professionally landscaped. Outdoor relaxation is enhanced by an in-ground vinyl stealth pool (14 x 28) with a Dolphin pool cleaner, a 6-person hot tub, and a private deck off the master bedroom. The gourmet kitchen is a chef's dream, featuring double ovens, a gas cooktop, and an oversized granite island with a copper farm sink. All kitchen appliances, including a wine fridge, will stay. The spa-like master bath includes a large soaking tub, perfect for relaxation. The laundry room is equipped with a deep sink and ample upper and lower cabinets. The washer and dryer will remain with the house. The home showcases a variety of premium flooring, including Hardwood Oak, Luxury Vinyl Tile, ceramic tile, laminate, and carpet. All showers are fully tiled, adding a touch of luxury to the bathrooms. Architectural details abound with coffered ceilings in the great room, a tray ceiling with crown moldings in the master bedroom, and crown molding in the front living room.
MlsNumber: --
ListingId: 2686267


Listing Provided By: Keller Williams - Clarksville, original listing
Phone: (931) 546-8500
Office Phone: (931) 648-8500
Agent Name: Kim Weyrauch
Disclaimer: Copyright © 2024 Keller Williams Realty, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2500 AND i.igate IN ('usahud','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Ashley Grayson
Ashley Grayson
ASCIIPurpose Realty & Auction
Call Today!: (615) 691-2650

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App