(pdo-pgsql): SET DATESTYLE TO ISO  

(pdo-pgsql): SELECT id, country FROM countries WHERE country = 'US'  

(pdo-pgsql): SELECT id FROM product WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'  

(pdo-pgsql): SELECT experienceenddate FROM public.product WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'  

(pdo-pgsql): SELECT city, region, country_code, country_name FROM user_geo_cache WHERE ip_address = '216.73.216.205'  

(pdo-pgsql): INSERT INTO user_traffic_log (id, ip_address, city, region, country_code, country_name, page_item_id, user_agent, referrer) VALUES ( '1126ca03-7436-4c0b-840f-d3b01b713f2a', '216.73.216.205', 'Columbus', 'Ohio', 'US', 'United States', 'aa681a33-b6a7-c776-a353-b11d215bbe20', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'Direct' )  

(pdo-pgsql): SELECT id, productname, price, currency, promoprice, promostartdate, promoenddate, pricedescription, img1, productlocationcountry, productlocationtown, taggedx, bundledx, promomoicons, featuredx, videoplaceholderimgx, logobanner, experiencestartdate, experienceenddate, productlocationdetails, fullcountrynam, perioddetailsx, description, maxbookingsatonce, businessowner, event_startx, event_endx, productcategory FROM product WHERE id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'  

(pdo-pgsql): SELECT pk.id, pk.linkexperienceid6, pk.packagetypename6, pk.maxdults6, pk.maxkids6, pk.minkidage6, pk.maxkidage6, pk.packagecostx6, pk.packagepromocost6, pk.notesx6, pk.packagepromostartdate, pk.packagepromoenddate, pk.promomoiconspcg, pk.featuredxpcg, pk.consumedeliverfromdate, pk.consumedelivertodate, pk.amountaddedforeigners, pk.allowkids, pk.deductforlocalkids0to2, pk.deductforlocalkids3to6, pk.deductforlocalkid7to11, pk.deductforlocalkid12to17, pk.deductforforeignkidsto2, pk.deductforforeignkids3to6, pk.deductforforeignkid7to11, pk.deductforforeignkid12to17, pk.additionpack1explain, pk.additionpack1, pk.additionpack2explain, pk.additionpack2, pk.tradeblocdiscount, pk.tradebloc, pk.maxbookingsatonce, pk.publishx, pk.approvex, pk.event_startx, pk.event_endx, COALESCE(pk.stocktypex, 0) AS pk_stocktype, COALESCE(pk.package_offerx, 0) AS pk_package_offerx, COALESCE(pk.packagex_days_total, 0) AS pk_days_total, COALESCE(pk.activex, 0) AS pk_activex FROM public.packagesx pk JOIN public.product pr ON pr.id = pk.linkexperienceid6 WHERE pk.linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND pk.featuredxpcg = 1 AND ( COALESCE(pk.publishx,0) = 2 OR COALESCE(pk.approvex,0) = 2 OR COALESCE(pk.activex,0) = 2 )  

(pdo-pgsql): SELECT COUNT(id), SUM(stars_rated) FROM rating_stars WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND stars_rated > 0 GROUP BY experience_id  

(pdo-pgsql): SELECT DISTINCT COALESCE(at.accommodationtypesx, '') AS type_name, COALESCE(at.fontawesomexiconx, '') AS type_icon FROM public.packagesx pk INNER JOIN public.accommodationtypesx at ON at.id::text = TRIM(pk.hotelbnbother) WHERE pk.linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND TRIM(COALESCE(pk.hotelbnbother, '')) <> '' AND COALESCE(pk.publishx, 0) = 2 AND COALESCE(pk.approvex, 0) = 2 AND COALESCE(pk.activex, 0) = 2 ORDER BY type_name ASC  

(pdo-pgsql): SELECT COUNT(pk.id) FROM product p JOIN packagesx pk ON p.id = pk.linkexperienceid6 WHERE CURRENT_TIMESTAMP BETWEEN pk.packagepromostartdate AND pk.packagepromoenddate AND CURRENT_TIMESTAMP BETWEEN p.experiencestartdate AND p.experienceenddate AND p.publishx = 2 AND p.approvex = 2 AND COALESCE(pk.publishx,0) = 2 AND COALESCE(pk.approvex,0) = 2 AND COALESCE(pk.activex,0) = 2  
The Hidden Place | www.epic.africa
Home Help Deals 4 Account Share
EPIC ESCAPES® Connecting You to Africa's Magic

(pdo-pgsql): SELECT imagexfilex, text_titlex, text_bodyx FROM public.sliderimgtextx WHERE prod_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20'  

(pdo-pgsql): SELECT 1 FROM public.packagesx WHERE linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND COALESCE(publishx,0) = 2 AND COALESCE(approvex,0) = 2 AND COALESCE(activex,0) = 2 LIMIT 1  

The Hidden Place

Marsabit, Kenya

Featured Customers Feedback


(pdo-pgsql): SELECT stars_rated, comment, date_of_experience, date_of_review, name_to_display FROM rating_stars WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND date_of_review >= '2025-06-04' ORDER BY random() LIMIT 20  

(pdo-pgsql): SELECT stars_rated, comment, date_of_experience, date_of_review, name_to_display FROM rating_stars WHERE experience_id = 'aa681a33-b6a7-c776-a353-b11d215bbe20' ORDER BY random() LIMIT 20  
👤 Guest

Perfect

On-site: 2024 | Review date: Aug, 2024
👤 Guest

Excellent!

On-site: 2024 | Review date: Aug, 2024

(pdo-pgsql): SELECT 1 FROM public.packagesx pk WHERE pk.linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND COALESCE(pk.publishx,0) = 2 AND COALESCE(pk.approvex,0) = 2 AND COALESCE(pk.activex,0) = 2 LIMIT 1  

(pdo-pgsql): SELECT id, linkexperienceid6, packagetypename6, maxdults6, maxkids6, minkidage6, maxkidage6, packagecostx6, packagepromocost6, notesx6, featuredxpcg, allowkids, packagepromostartdate, packagepromoenddate, COALESCE(stocktypex, 3) AS stocktypex_resolved, stocktypexdays, consumedeliverfromdate, consumedelivertodate, COALESCE(package_offerx, 0) AS pk_package_offerx, event_startx, event_endx, COALESCE(maxbookingsatonce, 0) AS pk_max_bookings, COALESCE(packagex_days_total, 0) AS pk_days_total, COALESCE(min_stay_nights, 1) AS pk_min_stay, COALESCE(max_stay_nights, 0) AS pk_max_stay FROM public.packagesx WHERE linkexperienceid6 = 'aa681a33-b6a7-c776-a353-b11d215bbe20' AND ( COALESCE(publishx,0) = 2 OR COALESCE(approvex,0) = 2 OR COALESCE(activex,0) = 2 )  

(pdo-pgsql): SELECT pk.publishx, pk.approvex, pk.stocktypex, pk.allowkids, COALESCE(pk.lead_time_hours,0), COALESCE(pk.min_stay_nights,1), COALESCE(pk.max_stay_nights,365), pk.linkexperienceid6, pr.experiencestartdate, pr.experienceenddate, pk.packagetypename6, COALESCE(pk.activex, 0) AS pk_activex, COALESCE(pr.publishx, 0) AS pr_publishx, COALESCE(pr.approvex, 0) AS pr_approvex, pk.consumedelivertodate, pk.event_startx, pk.event_endx, COALESCE(pk.package_offerx, 0) AS package_offerx, COALESCE(pk.packagex_days_total, 0) AS days_total, COALESCE(pk.todaycutofftimex::text, '') AS today_cutoff, COALESCE(pr.productlocationcountry, '') AS prod_country FROM public.packagesx pk LEFT JOIN public.product pr ON pr.id = pk.linkexperienceid6 WHERE pk.id = 'd36475df-88b2-4fd6-9722-4cd09388e946'  
Stay packages

Allergies, accessibility needs, arrival time, special requests — anything the host should know. Letters, numbers, spaces, comma, period, hyphen only (max 150 characters).

150 characters remaining

Discount will be applied at checkout. Coupons are subject to terms.

Helps prevent automated spam.

*By continuing to checkout, you agree to our Terms of Service and Privacy Policy.

Loading weather...

OFFERS ALERT!