query(" SELECT id, name, slug, base_price, max_guests, bedrooms, bathrooms, featured_image, description FROM apartments WHERE is_available = 1 AND is_featured = 1 ORDER BY sort_order ASC LIMIT 6 "); if ($featured_result) { while ($row = $featured_result->fetch_assoc()) { $featured_apartments[] = $row; } } // Get all apartments for display $all_apartments = []; $apartments_result = $conn->query(" SELECT id, name, slug, base_price, max_guests, bedrooms, bathrooms, featured_image, description FROM apartments WHERE is_available = 1 ORDER BY sort_order ASC "); if ($apartments_result) { while ($row = $apartments_result->fetch_assoc()) { $all_apartments[] = $row; } } // Get amenities $amenities = []; $amenities_result = $conn->query(" SELECT name, icon_class, category FROM amenities ORDER BY sort_order ASC LIMIT 8 "); if ($amenities_result) { while ($row = $amenities_result->fetch_assoc()) { $amenities[] = $row; } } // Get approved testimonials $testimonials = []; $testimonials_result = $conn->query(" SELECT guest_name, rating, title, comment FROM reviews WHERE is_approved = 1 ORDER BY created_at DESC LIMIT 3 "); if ($testimonials_result) { while ($row = $testimonials_result->fetch_assoc()) { $testimonials[] = $row; } } ?>
Your home away from home with premium amenities, 24/7 security, and unmatched comfort
Explore ApartmentsChoose from our selection of premium serviced apartments
No apartments available at the moment. Please check back later.
Featured
= htmlspecialchars(substr($apartment['description'] ?? '', 0, 100)) ?>...
Everything you need for a comfortable and luxurious stay
Happy Guests
Recommended
Support
Rating
Real experiences from our valued guests
"Amazing experience! The apartment was spotless, staff was incredibly helpful, and the location is perfect. Will definitely return!"
"One of the best serviced apartments in Lusaka. The penthouse was breathtaking, and the service was top-notch. Highly recommended!"
"Excellent value for money. The team went above and beyond to make our stay memorable. The pool and amenities were fantastic."
"= htmlspecialchars(substr($testimonial['comment'], 0, 150)) ?>..."
Book your stay today and enjoy unparalleled comfort in the heart of Lusaka
Book Your Stay NowGet in touch with us for reservations or inquiries
38403 Ibex Hill, Off Twin Palms Road
Opposite Memorial Park, Lusaka, Zambia
+260 960750014
+260 960750014
bookings@havenluxapartments.com
Monday - Friday: 8:00 AM - 8:00 PM
Saturday - Sunday: 9:00 AM - 6:00 PM