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

1716 Olmsted Way E
Camp Hill, PA 17011

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 6
Baths: Full: 6, ½: 3
Status: Active
SqFt: 10720 Square Feet
Agency: Berkshire Hathaway HomeServices Homesale Realty
Agency Phone: (717) 761-7900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: This stunning 12,000 square foot estate is the perfect blend of elegance, luxury and comfort. Located on a perfectly landscaped well-established double lot in The Cliffs, the property is private, yet close to everything. It can easily accommodate multi-generational households with use of the Carriage House, which can also be used as private guest quarters. Main home features two story Foyer and turned staircase, formal Living Room, formal Dining Room with terrific woodwork and hardwood floors, Family Room with coffered ceilings, beautiful built-ins, Butler's Pantry, incredible Solarium with Vaulted ceiling, Great Room with coffered ceilings and a loft for added entertainment / play space, first floor Gym and heated Garage. French country Kitchen has ample seating while still feeling cozy and has a tremendous view of the resort-like in-ground heated salt water pool & entertainment area, all while pleasing the most discerning chef. Great Room with loft can serve as a play or game room. If an at-home workspace is needed, the recently upgraded Office has custom built-ins and is conveniently located next to the gym and new half bath. First floor Bedroom, full Bath with steam shower and Laundry are on the first floor of the main house as well, ideal for residents who need first floor accommodations. The second floor features 4 bedrooms and 3 full bathrooms and can be accessed by the elevator off the Foyer. The amazing Primary Ensuite has a tray ceiling, a huge walk-in closet with dressing area, built-in storage filled with natural light, a walk-in cedar closet and storage. The basement houses storage and the Tuscan wine cellar complete with temperature controlled storage, curved wooden doors and wrought iron accents. You won't want to miss the Guest House, with elevator shaft ready for the mechanics, indoor Endless pool with treadmill, Locker Room with shower / changing area, Bedroom with walk-in closet, Kitchen, Dining area, Family Room, heated 3 car garage. Other upgrades include electric car charger, Generac generator, water sprinkling system, outdoor Kitchen and Shower, Fire Pit, multiple outdoor sitting and play spaces. This type of property simply does not come along often in Central PA.
MlsNumber: --
ListingId: PACB2042128


Listing Provided By: Berkshire Hathaway HomeServices Homesale Realty, original listing
Phone: (717) 805-8748
Office Phone: (717) 761-7900
Agent Name: Dana Little
Disclaimer: Copyright © 2025 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 = 2259 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 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 Mitzi Heaton
Mitzi Heaton
ASCIIColdwell Banker
Call Today!: (717) 577-5159

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App