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;

520 S Pebble Beach
Crescent City, CA 95531

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,250,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1550
Agency: Investment Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1968
Notes: Where the Redwoods meet the sea! This stunning oceanfront home in Crescent City, California is truely a dream home, offering a perfect blend of coastal living and modern luxury. Nestled on a prime location along the Pacific coastline with the Battery Point Lighthouse just a short distance view. This recently renovated property boasts breathtaking ocean views from the massive new Milgard windows in the living room,master bedroom & office/guest bedroom, making it a dream come true for those who appreciate the serenity & beauty of the ocean. Natural light floods the interior's open concept, creating a seamless connection between the indoor and outdoor spaces. These outdoor living spaces consist of a covered deck, off the master bedroom & office/guest perfect to enjoy a morning cup of coffee. Also there's a uncovered deck area below which is very rare in the area. Ideal for watching sunsets, hosting guests and barbecues. In addition,with beach access, this home offers the ultimate coastal experience. Stroll out onto the pristine shoreline for morning walks and beachcombing. Inquire for a complete list of upgrades & improvements. Features do include a Ductless Heat Pump, Vinyl flooring, Barn doors,Master bedroom Jet bathtub, Bathroom Heated floors, Kitchen Quartz Counter tops, Double oven, Stove Pot filler, Wine Refrig., Hammered copper Kitchen sink,Two dishwashers,Popup outlets and USB outlets. This home is a perfect size for retirement, 2nd residence or vacation home, offering lower maintinance & care. Make this oceanfront dream home yours today & enjoy the coastal lifestyle to the fullest. Be sure to view the drone photos,virtual tour and floor plan. All the furnishings can be negotiated with the sale. Currently operated as a Vacation Rental as " Couples Cove Romantic Get Away" On Airbnb. The Airbnb bookings could remain with the property.
MlsNumber: 230442


Listing Provided By: Investment Realty, original listing
Name: Investment Realty
Phone: (707) 954-6683
Office Name: INVESTMENT REALTY HOMES INC.
Office Phone: (707) 954-6683
Agent Name: STUART NICHOLS
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