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

415 N Main St
Pendleton, OR 97801
Shannon Hartley with Hearthstone Real Estate, original listing - (541) 344-5958

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 4
Baths: Full: 2, ½: 2
Status: Active
SqFt: 3679 Square Feet
Agency: Hearthstone Real Estate
Agency Phone: (541) 344-5958

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1916
Notes: Step into history with this stunning, beautifully preserved 1916 home in the heart of Pendleton, Oregon. Just a short walk across the river from Pendleton’s bustling main street, location allows you to frequent local shops, restaurants, and immerse yourself in the rich culture of the city. Offering an impressive 3,679 square feet of living space, this classic craftsman seamlessly blends historic charm with modern functionality, making it the perfect choice for both hosting and everyday family living. Masterfully designed, this home offers endless possibilities for relaxation as well as entertainment. The layout includes 4 spacious bedrooms, 2 full baths, and 2 half baths. A true highlight of this home is the luxurious master bedroom, which comes complete with an attached sunroom offering breathtaking views of the surrounding Blue Mountains and the cityscape. The finished basement provides additional living and storage space and comes complete with a billiards table and old-time saloon bar, making fun get-togethers with friends a breeze. Outside is perfect in the warmer months for grilling on the deck and eating under the covered area while taking in the views. The exterior also includes a detached garage/workshop that includes a gas heater. Workshop and parking is accessed by a private back alley. During peak blooming seasons, visitors will be greeted by a stunning display of carefully curated flora that makes this property truly special. The location and pristine shape of this 1916 home is hard to come by in this historic city. Get it while you can!
MlsNumber: --
ListingId: 693213786


Listing Provided By: Hearthstone Real Estate, original listing
Phone: (541) 344-5958
Office Phone: (541) 344-5958
Agent Name: Shannon Hartley
Disclaimer: Copyright © 2025 Regional Multiple Listing Services. 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