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

605 Horseshoe Trail Drive
Lebanon, PA 17042

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $880,000
Beds: 4
Baths: 4
Status: Active
SqFt: 4095
Agency: Lusk & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2002
Notes: Welcome to this beautiful, custom built English Country Cottage nestled on 1.3 acres in a wooded<br /> community, minutes from Mount Gretna PA. Every detail meticulously thought out including<br /> custom kitchen cabinetry with honed granite countertops, composite farm sink and pantry. Gleaming walnut hardwood and tiled floors, arched doorways, wainscoting and crown moldings throughout the home reflect a warm elegance. Flexible dining space accommodates intimate family meals and can expand for entertaining family and friends.<br /> Enjoy the two-story great room with wood burning fireplace, antique mantle surround,<br /> built-in cabinetry, wall of windows and expansive views! Relax while watching a movie or reading a good book in the adjacent living/media room that boasts French doors, a coffered ceiling, and Bose surround sound.<br /> Retire or wake up in the grand upper-level owners' suite which includes a soaking tub, tiled shower, heated floor, built-in cabinetry and large walk-in closet. An open railing hallway leads to three bedrooms and an additional full bathroom on the other side of the second floor, providing privacy for the<br /> owner and family or overnight guests.<br /> The lower level boasts an expansive daylight, walkout family room with tray ceiling, ambiance lighting and another woodburning fireplace appointed with stone chimney surround and wood mantle. A Third full bath compliments the finished space with antique vanity and stall shower. The unfinished portion of the basement provides ample storage options, workshop space, pet washing station, easy access to water treatment system, mechanicals and to the outdoors.<br /> The oversized composite deck with retractable awning, an exterior spiral staircase leading to the covered veranda, extensive floral landscaping, walkways and hardscaping with built in benches, fountain and waterfall give wonderful choices for outdoor entertaining and relaxing. Views from all vantage points are spectacular in every season. <br /> Minutes to Mount Gretna, Hershey, Harrisburg, Harrisburg Airport, PA Turnpike, Lancaster, Lebanon Valley College, medical facilities, schools and shopping.
MlsNumber: PALN2014030


Listing Provided By: Lusk & Associates, original listing
Name: Lusk & Associates
Phone: (717) 291-9101
Office Name: Lusk & Associates Sotheby's International Rea
Office Phone: (717) 291-9101
Agent Name: Sherry Merrill
Disclaimer: Copyright © 2024 Bright MLS. 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 = 2276 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 Lorraine Heist
Lorraine Heist
ASCIIIron Valley Real Estate
Call Today!: (717) 882-6447

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App