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;

321 N Main St
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: $319,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2214 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: 1960
Notes: Lovelylandscaped 1/3 acre within the city limits of Halfway, Oregon. The property has a lovely, sturdily built home, with newer flooring, handcrafted mantel and hearth with Blaze King insert and newer windows. It has designer touches of a French country cottage. Nestled at the foot of the southern end of the Wallowa Mountains, Pine Valley is a hidden gem, and the charming community of Halfway is its own tiny town. This property with a lovely home with a charming garden shed and 2 outbuildings has much to recommend it. The home is well cared for, in excellent condition and is move-in ready. It is next to the grade school playground but we have a small student population and the noise is minimal. It has 3 bedrooms, so there is plenty of room for a family as well! Pine Eagle Charter School grades pre-12 offers very innovative programs and very small class sizes. High-speed, fiber optic internet provides excellent service and if one wishes to work remotely this works well. Pine Valley is a recreation mecca. 17 miles from Hells Canyon and the Snake River and Hewit Park Reservoir it offers great fishing, rafting, kayaking, etc. We have wonderful creeks for fishing as well. This area is popular for hunting deer, elk, bear and so on, and a fabulous area for wildlife, photography, and birds. Winter sports abound. 250 miles of groomed snowmoble trails is epic. The mountains offer hiking, trekking, and llama packing and close to the entrance to the Eagle Cap Wilderness. Surrounded by USFS and BLM land this is an outdoor enthusiast's dream. The community itself is friendly and a great place to raise kids if you have them.
MlsNumber: --
ListingId: 23342992


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