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 = 1090 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1090 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 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 = 1090 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 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;

12439 Poplar Woods Dr
Goshen, KY 40026

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,199,000
Beds: 6
Baths: 5
Status: Active
SqFt: 4367
Agency: Keller Williams Realty Louisville Highlands

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2018
Notes: Nestled on just under an acre of serene landscape, discover a luxurious, custom-built 6-bedroom, 4.5 bath home that exudes elegance and tranquility. The exterior of the home is beautifully accented with custom lighting, creating a warm and inviting ambiance. Embrace the private views and suburban/rural ambiance while enjoying the convenience of being nearby to the esteemed North Oldham schools.<br /> <br /> This 4,367 sq. ft. architectural masterpiece is meticulously designed to cater to your family's needs. The grand fireplace and expansive windows are the stunning focal points of the great room, the main living area, which boasts ample space for entertaining on a grand scale. The gourmet eat-in kitchen is a chef's dream, featuring a magnificent island that comfortably seats five, abundant counter and cabinet space, and seamlessly flowing into a beautiful screened-in deck, perfect for alfresco dining or lounging. Two elegantly sized decks, including a two-level covered deck with the top portion being screened in, provide additional outdoor living spaces to bask in the natural surroundings.<br /> <br /> If formal entertaining is your desire, the exquisite dining room with wainscoting and crown molding offers a picturesque view, creating an inviting atmosphere for guests. Throughout the home, luxurious quartz or granite countertops, excluding the laundry room, are exquisitely matched to the cabinetry and the home's elegant theme. The primary bedroom on the main level overlooks the private backyard oasis and features a sumptuous 5-piece bathroom with marble floors, gorgeous tile, and a spacious walk-in closet with custom built ins.<br /> <br /> Upstairs, you'll find four generously sized bedrooms, two with convenient jack-and-jill baths, one suite with a private bath, and one bedroom that can access the bath from the hallway. Each bedroom features large windows, allowing natural light to pour in, creating a bright and airy ambiance. The main level, second-floor landing, and basement entertainment area boast rich hardwood floors, adding warmth and sophistication.<br /> <br /> Downstairs, you'll be greeted by a spacious basement that can be transformed into a state-of-the-art theater room, a grand family room, or an entertainment area, complete with soaring 10-foot ceilings. The walk-out basement leads to a beautifully crafted wood deck, offering another breathtaking view of the backyard, which also features a designated fire pit area for cozy evenings under the stars. The basement is rounded out with a bedroom, bathroom, storage, and mechanical areas, providing versatility and convenience. Schedule your showing today!
MlsNumber: 1658672


Listing Provided By: Keller Williams Realty Louisville Highlands, original listing
Name: Keller Williams Realty Louisville Highlands
Phone: (502) 459-5509
Office Name: Keller Williams Realty- Louisville
Office Phone: (502) 459-5509
Agent Name: Trish Segrest
Disclaimer: Copyright © 2024 Greater Louisville Association of REALTORS ®. 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 = 1090 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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 Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App