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

1075 S Pebble Beach
Crescent City, CA 95531

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $895,900
Beds: 3
Baths: 3
Status: Active
SqFt: 2060
Agency: Reel Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1979
Notes: Location Location Location! Well-appointed modern beach house situated back from the cliffs along the iconic Pebble Beach Drive overlooking the spectacular rocky shoreline of the great Pacific Northwest. Fabulous, inobstructilble views from almost every room in the house, upstairs and down, with beach access right in front of the house! Brother Johnathon Park is a mere block away, Battery Point Light house just to the south and Whalers Island just to the north with bike and foot paths along Pebble Beach Drive to all, you can see these points in the pictures. Pebble Beach sits just below this home and is known for its staller agate hunting and great vantage points for watching the migration of the great Grey Whales. Just to the North of Pebble is Point St. George which offers miles of unspoiled sandy beach that you will often have all to yourself. All of the bedrooms in this home are huge and have large walk-in closets. The master bedroom is downstairs and has a large walk-in low lip shower. There is a deep jacuzzi tub in the upstairs bathroom and did I mention the amazing amount of storage in this home! Home features a half bath downstairs perfectly situated for guests. Just off the living room behind double glass doors is what could be a fourth bedroom, office, gym, or craft room. 50-year dimensional composite shingles on the roof, Custom cabinets from Johnston's Cabinets and gorgeous granite countertops throughout the home speak to the quality built into this fabulous find! virtual tour https://youtu.be/cHVMZOh9IkY. This home is currently used as a vacation rental. The Seller is willing to convey fully furnished and transfer all technology associated with the vacation rental to the new owner. View site at https://abnb.me/y0a2ZtK4Cvb
MlsNumber: 230009


Listing Provided By: Reel Properties, original listing
Name: Reel Properties
Phone: (541) 244-8118
Office Name: Reel Properties, INC
Office Phone: (707) 460-6425
Agent Name: ROBIN HARTWICK
Disclaimer: Copyright © 2024 Del Norte Association of Realtors. 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