Skip to Content
Lustro Lagos

Suites at Lustro Lagos

10 suites available

37A, Ibukun Olu Street, Akoka, Yaba, Lagos, Lagos

← Change Property
The Prestige Suite at Lustro Lagos Available
Royal Suite

The Prestige Suite

King Up to 4 110m²
Per Night ₦220,000.00
The Lustro Royal Suite at Lustro Lagos Available
Royal Suite

The Lustro Royal Suite

King Up to 4 95m²
Per Night ₦180,000.00
The Executive Premier at Lustro Lagos Available
Executive Suite

The Executive Premier

King Up to 2 58m²
Per Night ₦95,000.00
The Yaba Deluxe at Lustro Lagos Available
Deluxe Suite

The Yaba Deluxe

King Up to 2 45m²
Per Night ₦65,000.00
The Ibukun Suite at Lustro Lagos Available
Standard Suite

The Ibukun Suite

King Up to 2 32m²
Per Night ₦45,000.00
The Business Suite at Lustro Lagos Available
Executive Suite

The Business Suite

King Up to 2 58m²
Per Night ₦95,000.00
The Lagos Deluxe at Lustro Lagos Available
Deluxe Suite

The Lagos Deluxe

Queen Up to 2 45m²
Per Night ₦65,000.00
The Garden View Suite at Lustro Lagos Available
Deluxe Suite

The Garden View Suite

Queen Up to 2 45m²
Per Night ₦65,000.00
The Akoka Suite at Lustro Lagos Available
Standard Suite

The Akoka Suite

King Up to 2 32m²
Per Night ₦45,000.00
The Cosy Nest at Lustro Lagos Available
Standard Suite

The Cosy Nest

Double Up to 2 28m²
Per Night ₦40,000.00
// Parse filters $property = $_GET['property'] ?? ''; $checkin = $_GET['checkin'] ?? ''; $checkout = $_GET['checkout'] ?? ''; $guests = (int)($_GET['guests'] ?? 0); $category = $_GET['category'] ?? ''; $sortBy = $_GET['sort'] ?? 'featured'; $search = $_GET['search'] ?? ''; // Build query $where = ["p.status = 'active'", "r.is_available = 1"]; $params = []; if ($property) { $where[] = 'p.slug = ?'; $params[] = $property; } if ($category) { $where[] = 'rc.slug = ?'; $params[] = $category; } if ($guests) { $where[] = 'r.capacity >= ?'; $params[] = $guests; } if ($search) { $where[] = '(r.name LIKE ? OR r.description LIKE ?)'; $params[] = "%$search%"; $params[] = "%$search%"; } // Exclude fully booked rooms for date range if ($checkin && $checkout) { $where[] = "r.id NOT IN (SELECT room_id FROM bookings WHERE status IN ('confirmed','checked_in') AND check_in_date < ? AND check_out_date > ?)"; $params[] = $checkout; $params[] = $checkin; } $orderMap = ['price_asc'=>'r.price_per_night ASC','price_desc'=>'r.price_per_night DESC','featured'=>'r.is_featured DESC, r.price_per_night DESC']; $order = $orderMap[$sortBy] ?? $orderMap['featured']; $sql = "SELECT r.*, p.name as property_name, p.slug as property_slug, rc.name as category_name, rc.slug as category_slug, (SELECT image_path FROM room_images ri WHERE ri.room_id = r.id AND ri.is_primary = 1 LIMIT 1) as primary_image, (SELECT COUNT(*) FROM bookings b WHERE b.room_id = r.id AND b.status IN ('confirmed','checked_in') AND b.check_out_date >= CURDATE()) as active_bookings FROM rooms r JOIN properties p ON p.id = r.property_id JOIN room_categories rc ON rc.id = r.category_id WHERE " . implode(' AND ', $where) . " ORDER BY $order"; $rooms = db()->fetchAll($sql, $params); $properties = db()->fetchAll("SELECT * FROM properties WHERE status = 'active' ORDER BY sort_order"); $categories = db()->fetchAll("SELECT DISTINCT rc.* FROM room_categories rc JOIN rooms r ON r.category_id = rc.id JOIN properties p ON p.id = r.property_id WHERE p.status = 'active' ORDER BY rc.name"); require_once dirname(__DIR__) . '/includes/header.php'; ?>
Available Suites

Find Your Perfect Suite

10 suites available

The Prestige Suite at Lustro Lagos Available
Royal Suite · Lustro Lagos

The Prestige Suite

King Up to 4 110m²
Per Night ₦220,000.00
The Lustro Royal Suite at Lustro Lagos Available
Royal Suite · Lustro Lagos

The Lustro Royal Suite

King Up to 4 95m²
Per Night ₦180,000.00
The Executive Premier at Lustro Lagos Available
Executive Suite · Lustro Lagos

The Executive Premier

King Up to 2 58m²
Per Night ₦95,000.00
The Yaba Deluxe at Lustro Lagos Available
Deluxe Suite · Lustro Lagos

The Yaba Deluxe

King Up to 2 45m²
Per Night ₦65,000.00
The Ibukun Suite at Lustro Lagos Available
Standard Suite · Lustro Lagos

The Ibukun Suite

King Up to 2 32m²
Per Night ₦45,000.00
The Business Suite at Lustro Lagos Available
Executive Suite · Lustro Lagos

The Business Suite

King Up to 2 58m²
Per Night ₦95,000.00
The Lagos Deluxe at Lustro Lagos Available
Deluxe Suite · Lustro Lagos

The Lagos Deluxe

Queen Up to 2 45m²
Per Night ₦65,000.00
The Garden View Suite at Lustro Lagos Available
Deluxe Suite · Lustro Lagos

The Garden View Suite

Queen Up to 2 45m²
Per Night ₦65,000.00
The Akoka Suite at Lustro Lagos Available
Standard Suite · Lustro Lagos

The Akoka Suite

King Up to 2 32m²
Per Night ₦45,000.00
The Cosy Nest at Lustro Lagos Available
Standard Suite · Lustro Lagos

The Cosy Nest

Double Up to 2 28m²
Per Night ₦40,000.00