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 = 2260 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 = 2260 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 = 2260 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;

6522 Plowman Ridge
Harrisburg, PA 17112
DENISE SIEKE with Straub & Associates Real Estate, original listing - (717) 919-5585

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 7374 Square Feet
Agency: Straub & Associates Real Estate
Agency Phone: (717) 919-5585

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Come and appreciate the luxurious sophistication of this elegantly appointed home in the desirable community of Deaven Woods. This exclusive community of only 35 homes located in desirable Central Dauphin Schools is beautiful and welcoming. You will find nearly 5200 square feet on the main floors and additional living area on the lower level with an abundance of living space complete with kitchen/bar, and full bathroom and bedroom. <br /> <br /> Every area of the home is exquisitely designed space that will seamlessly accommodate family and friends alike. A delightful blend of classic French country charm, modern amenities and incredible curb appeal, this home features 5 spacious bedrooms and 4 full and 1 half bathrooms with an office on the first floor and a well appointed study on the second floor. The exterior is beautifully done in stone and stucco, with stunning landscaping and extensive hardscapeswhich include an inviting outdoor kitchen and fire pit with outdoor lighting.<br /> <br /> As you enter this beautiful home, you will be greeted with a stunning vestibule and a magnificent staircase to the 2nd floor and will note the gleaming hardwood flooring plus all of the impressive and unique ceiling finishes, huge windows and the abundance of natural sunlight fill each room with comfort and warmth. A gourmet kitchen featuring upgraded appliances and countertops, beautiful custom-made cabinetry and a large butler's pantry will make meal preparation a joy - a chef's dream come true..<br /> <br /> The formal dining room also features beautiful finishes and is spacious enough for hosting your family and friends to sumptuous meals and spontaneous pizza parties. A mud room provides ample closet space, a launch area and a powder room for a busy family to get ready to start everyday, organized and ready to go. The two beautiful studies accommodate the many ways people live and work in their home. The first floor study is complete with custom built-in cabinetry and is generously sized. Across the hall is the living room which is ready to welcome guests or clients. The family room is beautifully curated with stunning ceilings and paneling perfect to relax or host an intimate gathering, or enjoy your morning coffee as you warm yourself by the fire in the gas fireplace.. The covered patio is the entire length of the home. It has beautiful views and provides a luxurious amount of privacy. It is large enough for every summer picnic. In addition to the beautiful outdoor kitchen, there is a gas line hookup on the deck for your convenience. <br /> Upstairs you will find the Primary Suite with another stunning ceiling, lovely en-suite bathroom and a two truly generous walk-in closet. Additionally, you will find 3 additional bedrooms, and the second study with coffered ceilings and a fireplace and built-in bookshelves. A perfect place to be creative and plan your beautiful future. Two of the bedrooms share a jack and jill bathroom and a hall bath can be accessed via a captain’s door from the guest bedroom. All the rooms are very spacious with generous closet space.<br /> <br /> There is generous storage space in the lower level to ensure that all of your belongings are easily organized and accessible along with a workshop. 3 side entrance garages and nearly a half acre of paradise.<br /> <br /> Don't miss the opportunity to experience the unparalleled comfort and style of this custom home. The attention to detail, the quality of the finishes and thoughtfully curated marriage of elegance and comfort make this the home of your dreams.
MlsNumber: --
ListingId: PADA2044958


Listing Provided By: Straub & Associates Real Estate, original listing
Phone: (717) 919-5585
Office Phone: (717) 919-5585
Agent Name: DENISE SIEKE
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 = 2260 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 Scott Moore
Scott Moore
ASCIIIron Valley Real Estate
Call Today!: (223) 488-0937

Local Mortgage Pro

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 = 2260 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;
Real Estate Expert Photo for Jeffrey Murdorf NMLS#2542881
Jeffrey Murdorf NMLS#2542881
ASCIIMonopoly Mortgage Advisors NMLS: 2619513
Call Today!: (717) 400-8399

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App