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 = 129' at line 10 Travel Information and Hotel Reservations
Paia, United States If you want to stay in a peaceful, healthy environment, this is the place for you. Spyglass House is a very magical oceanfront property located on the North Shore of Maui, 1/2 mile from the surf town of Paia. There are 3 houses, situated around a bricktop courtyard and sunken tiled Jacuzzi, all 30 feet from the waters edge. Hear the sound of the crashing waves, feel the cool ocean breezes, bask in the warm Maui sun. The Main House has three bedrooms, and two bathrooms, on the Ground Floor, and three bedrooms, and two bathrooms, upstairs, each with a kitchen for you to use, living room and expansive lanai. There are 21 stained glass windows throughout the house, hard wood floors, and high ceilings. Rooms can be rented individually, sharing a kitchen with the other two rooms in that unit, or by the unit as a private home. The Dolphin House has three bedrooms, and two bathrooms, also with full kitchen, living room, and expansive lanai. There are full length arched windows in the living room overlooking the water, which give the house a charming light feeling. We also have a new house on the beach next door with two private oceanfront apartments on one wing and three more bedrooms on another wing of the small mansion.
