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

538 Hickory Street
Hollidaysburg, PA 16648
Adam Conrad Team with Perry Wellington Realty, LLC, original listing - (814) 695-5323

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $385,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1908 Square Feet
Agency: Perry Wellington Realty, LLC
Agency Phone: (814) 695-5323

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1893
Notes: This fully renovated historic brick home, built in 1893, is a true masterpiece of timeless elegance and modern luxury. Thoughtfully restored by Centennial Resource LLC, the property preserves its original charm with features such as transom windows, original doors and hardware, intricate trim, and a beautifully crafted staircase and railing. The interior boasts 9.5-foot ceilings and large windows that flood the home with natural light. Updates include fresh paint, oak hardwood flooring, and beautifully redesigned bathrooms with ceramic floor tile, subway tile showers, Kohler vanities, and quartz countertops. The gourmet kitchen is a chef's dream, featuring dovetailed soft-close cabinets, Caesarstone quartz countertops, a Kohler sink with disposal, and stainless steel GE appliances, including a gas range.<br /> <br /> The exterior has been completely upgraded with a new roof, sheeting, and shingles, along with updated rain gutters, sidewalks, a custom patio with fabricated handrails, and durable Trex stairs. Stylish board-and-batten siding adds to the home's timeless appeal. Mechanically, the home has been modernized with new plumbing, water line, and sewer lateral, dual York gas forced air furnaces and central AC condensers, a 200 AMP electrical service with updated panel and wiring, an AO Smith tankless water heater, and a sump pump for peace of mind.<br /> <br /> Located on a large, level lot with ample off-street parking, the home is just minutes from all three Hollidaysburg schools, downtown amenities, and offers easy access to Route 36 (Penn St). This extraordinary property reflects Centennial Resource LLC's commitment to quality craftsmanship and attention to detail, offering a rare opportunity to own a historic home with modern conveniences.<br /> <br /> Check out or Matterport 3D virtual tour and schedule a showing today.
MlsNumber: --
ListingId: 76592


Listing Provided By: Perry Wellington Realty, LLC, original listing
Phone: (814) 693-5669
Office Phone: (814) 695-5323
Agent Name: Adam Conrad Team
Disclaimer: Copyright © 2025 Allegheny Highland Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App