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

37459 Boulder Flat Ln
Halfway, OR 97834
Denise Cairns with Keller Williams PDX Central, original listing - (503) 548-4848

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 2176 Square Feet
Agency: Keller Williams PDX Central
Agency Phone: (503) 548-4848

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1935
Notes: Welcome to 37459 Boulder Flat Lane in Halfway, Oregon. This lovely and most captivating property has been completely restored, and with a new building construction and has a massive amount of upgrades and creative additions of the highest quality in all buildings. It is a Shangrala private retreat nestled in beautiful Pine Valley, nestled at the foot of the southern end of the Wallowa Mountains in NE Oregon. With four separate living spaces, including the main house, this property allows for great flexibility for use and enjoyment as a private home, Air B and B, retreat center or vacation home. It has a large shop/garage and small gym area, mature orchard, pond, greenhouse, and established gardens. This area in NE Oregon is famous for fabulous epic recreation, hunting, fishing, snowmobiling, hiking, etc. 17 miles from the Snake River and the Hells Canyon Recreation Area and literally 5 minutes to the national forest. The property has water rights and an excellent well with an upgraded pump, well piping and wire, and a pond with ducks! A brand-new septic system was installed in June 2024. It also has a state-of-the-art water softener and filtration system in the main house. The sunroom or great room is a custom newer addition with floor-to-ceiling windows, fabulous light and southern views. The library or game room has been totally renovated with a new ceiling, waterproof vinyl plank, all new windows, french doors, a concrete patio, and a wood-burning stove. The studio is a new build of the highest quality. The living room and kitchen, and master bedroom have been completely renovated with the highest quality materials.The exterior has been completely renovated with new board and batten siding , cedar shingles and much more.The guest house has been totally restored.
MlsNumber: --
ListingId: 24013870


Listing Provided By: Keller Williams PDX Central, original listing
Phone: (503) 548-4848
Office Phone: (503) 548-4848
Agent Name: Denise Cairns
Disclaimer: Copyright © 2024 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