DB Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND areas.stateID =
AND areas.areaID = 218' at line 10
San Diego, United States This beautiful Ocean Front condo is on the beach. The only thing separating you from the waves and sand is the famous boardwalk. Wake up to the sight and sound of the Pacific Ocean directly in front of you with our large picture window in the master bedroom. The living room, dining room, kitchen and master bedroom all face the ocean. The condo is located on the 2nd floor providing privacy, quiet and safety for you and your family, while allowing you to view all the beach and boardwalk action below. The condo was recently remodeled with new kitchen appliances, new hotel queen bed, new queen leather sleeper/sofa and new leather recliner. The kitchen is fully stocked with all cooking and eating utensils you will need. The master bedroom has a queen size bed and TV, the second bedroom 2 twin beds and computer, and the living room a queen sleeper/couch, recliner, TV, DVD player, VCR, and stereo. The large balcony overlooks the boardwalk and has patio seating for 6 and a gas BBQ. All linens are supplied except for beach towels. We even provide boogie boards and beach chairs. There is one parking space below the unit large enough to fit the biggest SUV. The condo is located halfway between the Pacific Beach Pier and the famed Belmont Park roller coaster. Just in back of our building are several restaurants, bike rentals, surf board rentals, apparel shops, beach shops, and surfing lession shops. Stroll up the boardwalk to find more restaurants. Daily room service is not available. This is a non-smoking unit.