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

95650 N Bank Rogue River Rd
Gold Beach, OR 97444
Vera-Anne Wallace with Vera-Anne International Real Estate, original listing - (541) 373-0617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,199,999
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3331 Square Feet
Agency: Vera-Anne International Real Estate
Agency Phone: (541) 373-0617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Welcome to The Rogue River House. This exquisite craftsman custom home is located on the north bank of the beautiful Rogue River in Gold Beach, Oregon. Perfectly located up river where it is commonly sunny and buffered from the strong Oregon coastal winds with a coveted waterway dock permit, it boasts 3331 square feet of warm and inviting living space that beckons you to relax and enjoy nature. From the moment you enter the foyer, it's apparent that every detail has been beautifully thought out and meticulously planned. Countless amenities include a large windowed great room with amazing river views, Illinois river rock fireplace, gourmet kitchen with an oversized honed/live edge island, six burner dual fuel Thermador commercial range, secondary 30" wall oven and microwave, warming drawer, trash compactor and abundant beautiful quarter sawn oak soft-close cabinetry. The great room opens into the pool table/bar with its Frank Lloyd Wright stained glass Andersen windows above a custom built-in window seat. Invite friends to gather and enjoy a game of pool and the adjacent bar with climate controlled wine room. The large Master Suite is a dream with amazing river views, full height stacked stone gas fireplace, dual vanities, soaking tub and large closet. Each bedroom has an attached full bath and walk-in closet. The large deck off the great room will host big parties for all your friends and family. There's a BBQ area with a built-in vent. The oversized three car garage has an additional side garage for riding lawnmower or other recreational toys, plus a workshop, large storage area and mechanical room. Home is entirely furnished with Mission style Stickley furniture. Make this beauty your own.
MlsNumber: --
ListingId: 23214144


Listing Provided By: Vera-Anne International Real Estate, original listing
Phone: (541) 373-0617
Office Phone: (541) 373-0617
Agent Name: Vera-Anne Wallace
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