Skip to Content
Yankee by Lustro

Suites at Yankee by Lustro

16 suites available

61 Adebiyi Street, Off University Road, Onike, Yaba, Lagos, Lagos

← Change Property
Banana Island at Yankee by Lustro Available
Executive Suite

Banana Island

King Up to 2
Per Night ₦80,000.00
Johannesburg at Yankee by Lustro Available
Royal Suite

Johannesburg

King Up to 4
Per Night ₦80,000.00
Vegas at Yankee by Lustro Available
Royal Suite

Vegas

King Up to 4
Per Night ₦80,000.00
Fiji at Yankee by Lustro Available
Standard Suite

Fiji

King Up to 2
Per Night ₦60,000.00
Mauritius at Yankee by Lustro Available
Deluxe Suite

Mauritius

King Up to 2
Per Night ₦60,000.00
Maldives at Yankee by Lustro Available
Executive Suite

Maldives

King Up to 2
Per Night ₦100,000.00
Haven at Yankee by Lustro Available
Standard Suite

Haven

Single Up to 2
Per Night ₦100,000.00
Costa Del Sol at Yankee by Lustro Available
Standard Suite

Costa Del Sol

Single Up to 2
Per Night ₦100,000.00
Saint Pierre at Yankee by Lustro Available
Standard Suite

Saint Pierre

Single Up to 2
Per Night ₦100,000.00
Doha at Yankee by Lustro Available
Royal Suite

Doha

Single Up to 2
Per Night ₦80,000.00
Zanzibar at Yankee by Lustro Available
Deluxe Suite

Zanzibar

Queen Up to 2
Per Night ₦70,000.00
Milan at Yankee by Lustro Available
Standard Suite

Milan

Single Up to 2
Per Night ₦70,000.00
Saint Tropez at Yankee by Lustro Available
Standard Suite

Saint Tropez

Single Up to 2
Per Night ₦70,000.00
Puerto Banus at Yankee by Lustro Available
Standard Suite

Puerto Banus

King Up to 2
Per Night ₦60,000.00
Rio at Yankee by Lustro Available
Deluxe Suite

Rio

Queen Up to 2
Per Night ₦60,000.00
San Lucas at Yankee by Lustro Available
Standard Suite

San Lucas

Double Up to 2
Per Night ₦60,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

16 suites available

Banana Island at Yankee by Lustro Available
Executive Suite · Yankee by Lustro

Banana Island

King Up to 2
Per Night ₦80,000.00
Johannesburg at Yankee by Lustro Available
Royal Suite · Yankee by Lustro

Johannesburg

King Up to 4
Per Night ₦80,000.00
Vegas at Yankee by Lustro Available
Royal Suite · Yankee by Lustro

Vegas

King Up to 4
Per Night ₦80,000.00
Fiji at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Fiji

King Up to 2
Per Night ₦60,000.00
Mauritius at Yankee by Lustro Available
Deluxe Suite · Yankee by Lustro

Mauritius

King Up to 2
Per Night ₦60,000.00
Maldives at Yankee by Lustro Available
Executive Suite · Yankee by Lustro

Maldives

King Up to 2
Per Night ₦100,000.00
Haven at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Haven

Single Up to 2
Per Night ₦100,000.00
Costa Del Sol at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Costa Del Sol

Single Up to 2
Per Night ₦100,000.00
Saint Pierre at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Saint Pierre

Single Up to 2
Per Night ₦100,000.00
Doha at Yankee by Lustro Available
Royal Suite · Yankee by Lustro

Doha

Single Up to 2
Per Night ₦80,000.00
Zanzibar at Yankee by Lustro Available
Deluxe Suite · Yankee by Lustro

Zanzibar

Queen Up to 2
Per Night ₦70,000.00
Milan at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Milan

Single Up to 2
Per Night ₦70,000.00
Saint Tropez at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Saint Tropez

Single Up to 2
Per Night ₦70,000.00
Puerto Banus at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

Puerto Banus

King Up to 2
Per Night ₦60,000.00
Rio at Yankee by Lustro Available
Deluxe Suite · Yankee by Lustro

Rio

Queen Up to 2
Per Night ₦60,000.00
San Lucas at Yankee by Lustro Available
Standard Suite · Yankee by Lustro

San Lucas

Double Up to 2
Per Night ₦60,000.00