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

657 Woodburne Road
Lewisberry, PA 17339
JOY DANIELS with Joy Daniels Real Estate Group, Ltd, original listing - (717) 695-3177

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3592 Square Feet
Agency: Joy Daniels Real Estate Group, Ltd
Agency Phone: (717) 695-3177

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Welcome to 657 Woodburne Rd. This enchanting Cape Cod-style residence exudes storybook charm, featuring a welcoming wrap-around porch with classic white railings that invite you to relax and enjoy the peaceful surroundings on your 1 acre lot. As you step through the front door, you're greeted by a spacious foyer that leads into the heart of the home—a stunning family room with soaring vaulted ceilings and an abundance of natural light streaming through large windows and two skylights. A pellet stove, nestled in a handcrafted stone accent corner, adds warmth and character to this cozy gathering space. To the right of the foyer, a generous dining room awaits, offering ample space for hosting family and friends. The first-floor master suite is a true retreat, featuring newer wood floors, double sinks, a custom-built shower, and a genuine wood vanity top in the master bath. Two walk-in closets offer plenty of storage, and a luxurious Jacuzzi-style tub provides the perfect spot to unwind. The kitchen boasts updated appliances, newer flooring, butcher block countertops, and soft-shut maple cabinetry adorned with elegant crown molding. Adjacent to the kitchen, a convenient mudroom offers easy access to the side entrance. Upstairs, you'll find two cozy bedrooms with plush carpeting, while the third bedroom showcases luxury vinyl plank flooring. The large balcony overlooking the family room adds a touch of grandeur to the space. Step outside from the family room onto the deck, where you can take in views of the expansive backyard, which backs up to a serene wooded area offering privacy and tranquility. The finished basement offers even more living space, including a bedroom, full bathroom, recreation room, workshop, and ample storage. Rest assured knowing that the roof was just replaced in 2023, as well as the furnace and hot water heater being new in 2024. This Cape Cod gem perfectly blends classic charm with modern convenience, making it the ideal place to call home. Don't miss the opportunity to make it yours! Truly a joy to show!!
MlsNumber: --
ListingId: PAYK2067202


Listing Provided By: Joy Daniels Real Estate Group, Ltd, original listing
Phone: (717) 695-3177
Office Phone: (717) 695-3177
Agent Name: JOY DANIELS
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 = 2305 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 Mark Meiler
Mark Meiler
ASCIIReMax Optimum
Call Today!: (717) 659-2539

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App