select * from (Select a.`postalCode`,a.`uniturl`, `region`, `bathrooms`, `bedrooms`,`registration_number`, `sleeps`,en_US_VRBO as href, `thumbnailUrl`, `headline`, description, `state`, `city`, `country`, `source`, `property_type`, `address`,round(price) as price,minimum_nights, `rating`, `review_count`,`latitude`, `longitude`,case when propertyName='' then trim(address) else CONCAT(CONCAT(propertyName,'(',trim(address)),'',')') end as addre,propertyName,
(6371 *
acos(
cos( radians( 21.2759167 ) ) *
cos( radians( `latitude` ) ) *
cos(
radians( `longitude` ) - radians( -157.8233677 )
) +
sin(radians(21.2759167)) *
sin(radians(`latitude`))
)
) as distance from `vacationrentalindex` a inner join vacationrentalindexfeed b on a.uniturl=b.unitUrl and a.headline!='' and a.thumbnailUrl!='' and b.enabled=1 and b.blocked=0 ) as vw where 1 and round(price)>0 and bedrooms>=0 AND (`headline` like '%cottage%') AND sleeps>=1 order by rating desc LIMIT 0, 50
We are located on the west side of the Big Island of Hawaii, directly above Kailua-Kona, on the side of Mt Hualalai, in Holualoa, with an awesome ocean and coastline view! Please read our reviews because the view from the cottage lanai is better...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Holualoa
Sweeping views of the Pacific Ocean and surrounding countryside welcome in beautiful golden sunrises over this one-bedroom, one bathroom private cottage. Stroll among the fenced 6 acres where you will find over 300 fruit and palm trees and ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Pepeekeo
Capture the magic of this romantic cottage. Large picture windows, open beam ceilings and sky lights bring views of lush tropical gardens with towering Cook pines. Two covered lanais for pupus, mai-tais and outside dining. After an ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Hanalei
Charming beachfront cottage right on Kailua Beach!
licensed NUC no 90/TVU-0326 Serenity Beachfront Cottage. This delightful 2 bedroom/1 bath vacation rental cottage puts you right in the middle of world renowned Kailua Beach. Enjoy ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kailua
On Maui's sunny south shore, is the romantic Honu’ea cottage, where quiet peaceful living is a way of life. Honu'ea (Hawksbill Turtle) is named after the endangered turtles that come and nest on the sandy shores in front of the property. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
*Please read full description!
Sleeping 6, our large private garden cottage is located just 50 steps away from Kailua Beach. The lush garden setting offers a large air conditioned bedroom that sleeps 4 (queen size bed and 2 twin beds), ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Kailua
On the Kona side, safe and away from the volcanic activity, the Cottage awaits you.
The perfect, peaceful getaway for those on a honeymoon or looking for a relaxing, romantic experience. This warm, welcoming, newly-built and finely ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
Cozy, private rain forest retreat cottage situated above Kona in the Kaloko Mauka Honua'ula Forest Reserve. Located on a 3-acre property, this cottage is set away in a lush forest of Ohia trees and Hapu'u tree ferns. Enjoy the sweet aroma of ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
UALANI RETREAT
Fully Licensed & Permitted
Locally Owned & Operated B&B
Permit # BBPH 2012/0002
...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haiku
Maui Permit #BBPH 2009/0002 , Hawaii Permit #SUP2 2002/0005
Hawaii Tax I.D. TA035-442-8928-01 TMK (2)2-7-035-010-0000
Maui's Ultimate Private, Romantic Cottage! ...a unique architectural Polynesian Pole home on Magical Maui. ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Haiku-Pauwela
No detail overlooked! A serene custom-designed studio retreat in the treetops of Volcano, Hawaii. Tree cottage includes a beautiful kitchen, spacious bathroom with indoor/outdoor shower, private driveway, top-level lanai off the living area for ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Volcano
Private cottage, gorgeous 720 sq ft one bedroom, full kitchen, bathroom, spacious living/dining area. Covered lanai with gas grill, patio seating, covered gazebo area with hammocks and hanging chairs. Conveniently located right off famous ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Pahoa
This studio cottage sits on 5 acres of orchard, gulch and gardens with the Kohala coast as a backdrop. The owners farm the back 20 acres with cattle, sheep, goats and chickens. We are located midway between the towns of Hawi and Kapa'au--both...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaau
Entabeni Cottage, sits above the Road to Hana overlooking the Pacific Ocean on the north shore of Maui, Hawaii.
Maui County License & Permit: BBPH 2013/0006 and SUP2 2012/0011
Entabeni Cottage is a fully-equipped, 830 square foot ...
- 1 bedroom
- 2 bathroom
- Sleeps 2
Hawaii> Hana
Calendar may not reflect accurate availability. Please contact owner with custom requests. 8085547738
Enjoy this lovely and elegant cottage, one short block from world famous Lanikai beach! This beautiful cottage boasts stunning acacia ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua
Classic island cottage with tropical gardens all around. Comfortable home near the ocean on sunny South Shore just steps away from Baby Beach, a wonderful seasonal swimming/snorkeling beach. There is Air conditioning in both bedrooms. The yard ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Poipu
Tucked into the Lanai Villas section of the tropical Poipu Kai Resort, Maikalani is a Kauai vacation rental home exquisitely decorated and outfitted with all the necessities of home, including zoned air conditioning. Located on the lush green ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Hale Leialoha is a beautiful 2 bed 2 bath plantation style cottage located in "upcountry" Maui in the picturesque town of Haiku. Our Maui vacation rental is permitted (BBPH 2017/0004, SUP 2017/0010) and perfect for your memorable Hawaiian ...
- 2 bedroom
- 2 bathroom
- Sleeps 6
Hawaii> Haiku-Pauwela
Tropical Garden Cottages—One Block from Beach
Why stay at Fern Grotto Inn? The reasons are as numerous as our glowing guest reviews. In fact, Fern Grotto Inn recently became the best-rated vacation rental on TripAdvisor and was featured...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kapaa
Coco Cottage at Poipu Beach is a classic, sugar plantation-style home located on the sunny south shore of Kauai. Completely rebuilt, it offers beautiful furnishings, a fully equipped kitchen, full-size washer and dryer, two air-conditioned ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Clear the calendar and say 'Aloha' to your next tropical getaway at this 1-bed, 1-bath vacation rental cottage in Kailua-Kona. Perched on the west coast of the Big Island, this quaint getaway showcases Hawaii's best snorkeling, surfing, diving ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kailua-Kona
We invite you to stay in our quaint and nicely decorated Haiku Surf Cottage on the North shore of Maui. IMPORTANT!!! Beware of scammers advertising our home on CL. Only available to rent from Amy - the real owner.
SUMMARY: Walk out the...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haiku-Pauwela
The International Colony Club is a collection of uniquely "Hawaiian" cottages situated on meticulously landscaped grounds located right in the middle of the North Kaanapali Golf Course. Kaanapali beach, famous for incredible beauty and some of ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Lahaina
Beautifully built and decorated luxury private cottage in a tropical garden with ultra-quiet split AC systems and ceiling fans in every room, whole house water filtration system, resort-style landscaping and lighting.
Check out our VIDEO ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kihei
Welcome to Haleakala Cottage at Huelo Point Lookout, your ideal starting point for a Hawaiian adventure, especially if you're planning to explore the iconic Road to Hana. Our cozy cottage on Maui's unspoiled north shore is surrounded by lush ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Haiku
Experience the best in Maui Hawaii when you stay in this 2bedroom/2 bathroom private Hawaiian plantation style cottage located within minutes of the Luxury Resorts including The Four Seasons, Maui Wailea & The Grand Wailea Resort on Maui’s ...
- 2 bedroom
- 3 bathroom
- Sleeps 4
Hawaii> Kihei
If Kauai has reinstalled the 10-to14-day Quarantine requirement for your dates, we will fully refund your costs, even though our regular cancellation policy is more strict. A quarantine is not a vacation!
Just steps from Poipu Beach and...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Poipu Beach
TMK: 4-2-8-018-005-0001-000
This custom designed Hawaiian plantation style cottage is located just off the Brennecke's beach side of Poipu Beach Park, 100 steps to the beach!
This spacious house was designed and built in 2013 to ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
Opened for guests in 2010, the original HULILI FARM COTTAGE (pronounced who-lee-lee) has welcomed so many wonderful guests that it became time to enable more people to enjoy the farm. Introducing Pineapple Cottage! Please check out our reviews ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hakalau
Beautiful island style cottage with sunset views and tropical garden. If you want to experience true Hawaiian living in an eco-friendly natural, non smoking environment this is your place. Have a soak in the tub, pick fresh herbs, veggies and ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Captain Cook
Hana's Heaven - a charming 2 bedroom cottage complete with full kitchen, living room and 3 lanais. Wake every day to the sunrise and ocean expanse. Off the beaten track, this home away from home is quiet and serene, the perfect place to relax ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Hana
Come stay with us at our tropical and clean, 2 Bedroom, 1 Bath Cottage. Our cottage is across the street from a 5 Mile long beach in Sunny, Quiet, North Kihei. It takes only 30 seconds (45 seconds if you walk really slow!) to walk to the beach...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
The Sea Glass Cottage offers an unforgettable Garden Isle vacation. This custom-designed Hawaiian style Cottage is located just steps from Poipu Beach. The 2-bedroom, 2 bath Sea Glass Cottage graciously combines the beauty and simplicity of a ...
- 2 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Koloa
New home construction next door started in Jan 2022
This luxury Kauai vacation rental is located in the luxury resort community of Kukuiula. This fabulous new home has lovely distant ocean views from both the main living area and the ...
- 4 bedroom
- 5 bathroom
- Sleeps 10
Hawaii> Koloa
Ocean front- Nestled between Historic He`eia Bay and Keauhou Bay- Kinohi at He`eia
Welcome to He`eia Bay Hale. Comfortable and bright, this house and guest cottage has 5 bedrooms and 3 bathrooms in the main house and two queen size ...
- 6 bedroom
- 4 bathroom
- Sleeps 14
Hawaii> Kailua-Kona
Immerse yourself in paradise at our tranquil completely restored vintage beach cottage. We're located in Puako, the only beachfront community on the Kohala coast on the Big Island of Hawaii.
Puako was an ancient fishing village and is ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kamuela
Incredible COTTAGE! with a new Separate Suite! How can you vacation in Hawaii and not have an ocean view!! Authentic Hawaii vacation retreat in Hawaii Kai-East Side of Oahu! Get away from the hustle and bustle of everyday day life, rejuvenate, ...
- 1 bedroom
- 1 bathroom
- Sleeps 6
Hawaii> Honolulu
30 Day Minimum Stay Required
Share the romance and beauty of the North Shore with your entire family: 2 separate fully appointed living spaces with high end amenities great your every moment of your vacation.
Swing open the gate ...
- 4 bedroom
- 4 bathroom
- Sleeps 8
Hawaii> Waialua
Welcome to Hale Kokio, a well loved getaway, designed for two. This is the place to stay on North Shore Kauai for relaxation, privacy and island living. Enjoy a quiet setting and a convenient location. The newly updated cottage is designed with...
- 2 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kilauea
Throw a pebble into the Pacific Ocean from your lanai.
Hale Aloha is a detached, very private, oceanfront guest house located in the magical neighborhood of Puako, next to Mauna Lani Resort on the Big Island of Hawaii.
Ocean breezes and ...
- 0 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Waimea
Relax & enjoy the peace & quiet, coastal ocean views, lush tropical setting & complete privacy at your modern cottage with private lanai.
Palm Cottage is ideal for a quiet vacation, honeymoon or just a peaceful getaway. Come to quiet, ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Haiku-Pauwela
New build spacious cottage in quiet upscale neighborhood just steps away from famous China Walls. The unit is detached from the main house with its own private entrance. It includes a private grassy patio with a plumeria tree. Covered ...
- 1 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Honolulu
PLEASE READ PRIOR TO BOOKING: If you have more than 10 guests the cottage will need to be booked as Maui's rental permit law requires 2 guests per room. That being said, children under the age of 3 can stay with their parents in the same room ...
- 6 bedroom
- 4 bathroom
- Sleeps 12
Hawaii> Kihei
Cottage is located on the back side of a one acre manicured property. It is private from the main house the landscaping keeps you from seeing the house when sitting on the back lanai where the BBQ and sitting area is located. There is one off...
- 3 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kaneohe
Hawaii Tax I.D. NO. W67125384-01
Hale Alaula, or House of the Sunset Glow, is a renovated cottage located right on a beautiful sandy beach in sunny Puako. As you can see from the pictures, the house is full of modern and newly furnished ...
- 1 bedroom
- 2 bathroom
- Sleeps 4
Hawaii> Kamuela
G & Z Upcountry Bed & Breakfast Cottage, situated on half an acre in Kula Maui is adjacent to the hosts' 6-acre farm. TMK 2-2-2-006-101-0000.
A large jacaranda and two avocado trees shade the wide-open lawn. At an elevation of around ...
- 1 bedroom
- 1 bathroom
- Sleeps 2
Hawaii> Kula
Couples find the privacy and space they dream of in our 1-bedroom ocean view cottage set on a hillside in sunny south Maui. Our cottage offers a fully equipped kitchen, living room, dining room and travertine bathroom. You car stays protected ...
- 1 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kihei
Mana Kauai Island Vacations presents the charming Palaka Cottage!
Recapturing bygone days, the completely renovated 2 bedroom 1 bath "Palaka" Vacation Cottage draws one back to the days of the sugar industry's plantation cottages. With ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Hanalei
"Twin Hearts", a Kauai North Shore vacation rental homestay cottage, is a wonderful private one bedroom, one bath handcrafted rental accommodation located at the ocean end of our 7.6 acre Kauai North Shore estate and farm parcel. The ...
- 2 bedroom
- 1 bathroom
- Sleeps 4
Hawaii> Kilauea
Secluded Ohana (1/1 Cottage) with Superb Ocean Views on Gorgeous Hamakua Coast Estate – The Garden House Hideaway
Constructed of Indonesian hardwoods, this fully furnished Studio Ohana sits on the beautifully landscaped grounds of an estate...
- 2 bedroom
- 1 bathroom
- Sleeps 3
Hawaii> Ninole
