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;

97910 Holly Ln
Brookings, OR 97415
Amanda Keady with RE/MAX Ultimate Coastal Properties, original listing - (541) 425-7494

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2268 Square Feet
Agency: RE/MAX Ultimate Coastal Properties
Agency Phone: (541) 425-7494

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2003
Notes: SEA AND SKY await you at this OCEANFRONT home overlooking Sporthaven Beach in Brookings. Comfortably spacious, this beautiful home is nestled in a quiet neighborhood, making it easy to become immersed in the sights and sounds of the Pacific. Enticing ocean views greet you in the front of the home from the attractively landscaped flagstone courtyard. Upon entering the single-level residence, eyes are drawn to the deck’s expansive view, which encompasses Chetco Point and St. George Reef lighthouse. From its vaulted ceilings to its classic hardwood floors, this open-concept home with abundant natural light is designed for easy living. The great room affords plenty of space for family and friends and boasts a propane fireplace and a separate sitting nook. The dining area with an ocean view bay window adjoins the well-appointed gourmet kitchen, complete with quality stainless steel appliances, granite countertops, and an extensive assortment of kitchenware. The primary bedroom boasts a propane fireplace, a sitting area open to the covered portion of the deck, and two enormous walk-in closets. A roomy second bedroom offers an ensuite while the third bedroom affords attractive French doors and deck access. Completing the home’s easy living are the central vacuum system, the ample storage cabinets in the laundry room, the extra-deep two-car garage, and the low-maintenance yard. Furnishings included with the sale; home being sold as-is. Call today for a tour of this luxury oceanfront home! Trustees will review offers no sooner than Nov 5.
MlsNumber: --
ListingId: 24341185


Listing Provided By: RE/MAX Ultimate Coastal Properties, original listing
Phone: (541) 425-7494
Office Phone: (541) 425-7494
Agent Name: Amanda Keady
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