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 = 249' at line 10
San Diego, United States Sunset Sands is a lovely 2 bedroom ocean front condominium located in beautiful Mission Beach, San Diego, California. The condo is situated on a 2 block wide spit that separates the ocean beach from Mission Bay. Mission Beach is a continuous 3 mile stretch of clean, soft sand. And Mission Bay is itself an incredible scenic water playland. And all this is still only 5 minutes from Sea World, and 20 minutes from the airport, downtown, the zoo, La Jolla, and many other attractions. Whether on a business trip or a vacation, you will never stay in a motel or hotel room again after staying here. You will find your experience away from home far more pleasant and satisfying at Sunset Sands. The unit is comfortably and newly furnished in a classic contemporary style. It was designed with the ocean in mind. You have spectacular views from all the main living areas. And the master bedroom faces the ocean, featuring a large window ocean view. There are 2 cable TV's, VCR's and a stereo system, as well as some CD's, tapes, games, puzzles, and books. The kitchen has all you need for cooking a gourmet meal to baking a pie. Serving for 8 is provided along with lots of sizes of pots and pans, storage bins, utensils, etc. One thing is for sure, if you are going to cook, you can't do without the big things or the little things! Sunset Sands is located directly on 3 continuous miles of beautiful Mission Beach. The beach is large, not crowded and very clean. The surf is exhilarating to play in, with or without the boogie boards. And the sunsets are unforgettable. The neighborhood is friendly, and is a wonderful mix of people. You see surfers, retirees, families on vacation, young couples holding hands, and everything in between. The holiday or 'laid back' atmosphere prevails. You will find everything you need during your stay in the immediate area. Sunset Sands is professionally managed to make your stay go smoothly. The staff will help you get situated and will be available for anything you need. They can provide short term rental for special needs items such as a baby crib, etc. The unit is available year-round and is very reasonably priced. We welcome everyone. San Diego is known as the 'Weather Capital of the World.' It and its surrounds have mild temperatures all year. Visitors from overseas are discovering its attractiveness, as well as some Easterner's who have given up on Florida! Escape your heat or cold to visit Sunset Sands. The city is loaded with world class and world famous attraction for you to enjoy during your stay. Or you can rest, relax, and recuperate here. It is the one place where you can do everything, or you can do nothing!