SELECT p.property_id, p.source_id FROM properties p LEFT JOIN cities_sites_xref csx ON p.city_id = csx.city_id LEFT JOIN sources_sites_xref ssx ON csx.site_id = ssx.site_id LEFT JOIN sources s ON ssx.source_id = s.source_id AND p.source_id = s.source_id WHERE s.is_active = '1' AND csx.site_id = 36 AND p.city_id = 23 AND p.is_active = '1' GROUP BY p.property_id, p.source_id ORDER BY RAND(UNIX_TIMESTAMP(CURDATE()))
BEST FEATURES!Across the street from closets beach accessSingle level floor plan 2 Golf Carts Decking front and back of home!This classic N.C. beach home is as gorgeous as they get, with plenty of extras that make for a ideal beach vacation. The...
This home rents Friday to Friday in the summer seasonWelcome to this newly revamped family-friendly vacation home, where comfortable appeal meets a touch of luxury. The home got a fresh makeover, and it's all set to make your family vacation a real...
BEST FEATURES!• Lagoon & Ocean Vistas!• Across from closest beach access• Freshly refreshed Villa Come and visit our striking three bedroom Villa located on Bald Head Island! Not only does this home have Ocean Vistas from the loft deck, but...
Star Fish and Coffee is an oceanfront, three-bedroom home with direct boardwalk access to the ocean, 803A Killegray Ridge, offers a beach home ideal for appreciating an island hideaway. This home offers a front-row view of the Atlantic Ocean and the...
BEST FEATURES!Secluded Enormous Home Breezeway connecting other half of home for privacy Located in middle of island close to amenities2 Golf Carts Get ready to discover this captivating 5-bedroom home, hidden in a maritime forest at your own...
IMPORTANT *Spring and Summer units PLEASE reserve club membership on club website.*This home is available for daily, weekly, & monthly rental located on Bald Head Island East Beach dune ridge. Offers guests sunrise ocean vistas, afternoon winds...
"3 Mermaids" on Bald Head IslandHighlights:Sleeps 9 in 3 bedrooms - King Master Suite | Guest Room with King | Guest Room with One Queen and Two Twin and one Trundle 3 Full and 1 Half Baths BHI and Shoals Club*Pet FriendlyOne 6 seat golf cart Drip...
Welcome to The Hiding Place! We are certain you will fall in appreciate with Bald Head Island and never want to leave. Our pretty home is located in the maritime forest among sizable oak trees with handsome hanging Spanish moss. We adore living in...
2024 NEW TO MARKET and Freshly Painted 2025515 S. Bald Head Wynd"Southern Charm"Highlights:Ocean and Sunset Vistas5 Bedrooms4.5 BathsSleeps 10 (Q/Q/Q/Q/TT)BHI Club*2 Golf Carts– 2x 4-seater golf carts Bunn Coffee Maker SystemBeach Chairs...
Welcome aboard! Picture yourself unwinding on a extravagant yacht – is there anything more calming?Step aboard the Sea-Suite, a opulent 67-foot Burger Motor Yacht. It features a master suite with a queen-size bed and private bath, plus two more...
(5B, 4.5 BA, 3K, 4T, Sleeps 10; 2 4-person golf carts, Saturday Turn in Peak Sea, CHECK OUT 11:00AM / CHECK IN 5:30PM) Unwind while appreciating ocean breezes through the sea oats at Sea Oats Cottage-a five-bedroom, 4.5-bath PET FRIENDLY second row...
BEST FEATURES!Outdoor shower!Screened in porchExpansive patio for grilling2 min. cart ride to the beachGet ready for an impressive stay at 'A Walk on Sunshine'! This 2 bedroom, 2 bath home in Keeper's Landing has everything you need. Upstairs, savor...
BEST FEATURES!Golf Course View2 Decks overlooking Bald HeadRecently modernized Short distance to closest beach accessSplendid 3 bedroom and 3 bath villa located directly on the 18th green of the golf course with great lagoon vistas! We are walking...
BEST FEATURES!Top floor condoCommunity poolCentrally located on island 2 golf cartsJust a Splash away from the pool in the Royal James neighborhood located in the middle of Bald Head Island. This condo offers a top floor with a balcony overlooking...
Cavernous 5-bedroom, 4.5 bath home with lavish vistas of South Beach, bespoke-constructed by Henson Building Corporation. Access to gorgeous South Beach is an simple two mins. walk. The main home features 4 bedrooms and 3.5 completely refreshed...
Uniquely located for an active vacation on this exclusive North Carolina barrier island, “Park Place” lies steps from The Commons Park, a 3-min. walk down a private alleyway to marvelous East Beach, and a 5-min. walk from a swim, or dinner, at...
"Villa Umi" on Bald Head Island Highlights:Sleeps 10 in 3 bedrooms - King Master Suite, Queen Guest Room, and a Bunk Room with 5 Double Beds 2 Full and One-Half BathsShoals Club* Two 4 Seat Golf Carts Drip Coffee Maker and Keurig Linens and Towel...
(5BR, 4.5BA Sleeps 16, 2K, 4Q, 3 BK, 2 Golf Carts, Sunday Turn in Peak Season, CHECK OUT 10:00AM/ CHECK IN 5:30PM) Shifting Sands is the ultimate in BHI oceanfront living! Great vistas and ample decks/porches for sizable family gatherings. Savor the...