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

4 Davis Alley
Loysville, PA 17047
MELANIE WOODWARD with RSR, REALTORS, LLC, original listing - (717) 763-1212

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $430,000
Beds: 2
Baths: Full: 1, ½: 1
Status: Active
SqFt: 6800 Square Feet
Agency: RSR, REALTORS, LLC
Agency Phone: (717) 763-1212

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: One-of-a-Kind Historic Church Conversion Blending Timeless Charm with Artistic Luxury<br /> Step into a home like no other—an inspired transformation of a former UCC church into a modern masterpiece, where thoughtful design meets historic elegance. From the moment you enter the main foyer, you’re welcomed by Brazilian Cherry hardwood, tumbled travertine, and a custom medallion inlay, setting the tone for a truly unique residence.<br /> The expansive main-level great room is an entertainer’s dream, boasting warm cherry floors, stunning wall textures, and a box-and-beam ceiling accented with tongue-and-groove detail. This space radiates character and comfort—perfect for hosting or relaxing with loved ones.<br /> At the heart of the home lies the chef’s kitchen, a showcase of refined taste with Italian porcelain tile, a large central island, marble countertops with intricate edging, a custom-tiled backsplash, and stainless steel appliances—including an oversized six-burner gas range with custom hood. A breakfast bar and dedicated dining area make this space ideal for everyday meals or festive gatherings.<br /> A designer powder room on the main level impresses with tumbled travertine walls, elegant shelving, and artisan finishes.<br /> Venture upstairs via a beautifully reimagined split staircase, where the home’s rich past meets contemporary comfort. The second-level great room stuns with 19-foot ceilings, restored original hardwood floors, new French doors, and exquisite crown molding—ideal as a family room, game lounge, or creative space.<br /> Off this great room is a spacious loft, artfully crafted with Red Oak floors, columned half-walls, and custom window wells—perfect as an office, library, or additional lounge. A stylish bedroom with a barn door, generous closet, and 10-foot ceilings completes this level.<br /> Indulge in the spa-like primary bath featuring a jetted tub with pedestal base, vessel sinks on a custom vanity, and Turkish travertine that extends seamlessly into a walk-in shower with slab glass enclosure.<br /> Outside, the detached three-car garage offers epoxy flooring and ample space for storage, hobbies, or parking—alongside additional off-street spots.<br /> Whether you're searching for a stunning personal residence or exploring a unique commercial opportunity (verify zoning with township), this remarkable property delivers on every level. Homes of this caliber and character are rare—schedule your private tour today!
MlsNumber: --
ListingId: PAPY2007246


Listing Provided By: RSR, REALTORS, LLC, original listing
Phone: (717) 497-1404
Office Phone: (717) 763-1212
Agent Name: MELANIE WOODWARD
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 = 2288 AND i.igate IN ('usahud','inhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'inhud', 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 David Waishwile
David Waishwile
ASCIIHomesale Realty
Call Today!: (805) 206-0312

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App