Sliema – Exceptional Seafront 3-Bedroom Apartment

stdClass Object
(
    [ref] => 01-9271421
    [webRef] => 01-9271421
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-08-19 00:00:00
    [marketType] => ForSale
    [commercial] => 0
    [development] => 
    [developmentID] => 
    [locality] => 104
    [locality_details] => stdClass Object
        (
            [id] => 104
            [localityName] => Sliema
            [zoneId] => 2
            [parentLocalityId] => 
        )

    [propertyType] => 3
    [propertyType_details] => stdClass Object
        (
            [id] => 3
            [description] => Apartment
            [sortSequence] => 
            [propertyTypeGroupId] => 3
        )

    [propertyStatus] => 5
    [propertyStatus_details] => stdClass Object
        (
            [id] => 5
            [description] => Finished
            [sortSequence] => 
        )

    [price] => 0.00
    [oldPrice] => 0.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 1
    [description] => Sliema – Exceptional Seafront 3-Bedroom Apartment
    [title] => Sliema – Exceptional Seafront 3-Bedroom Apartment
    [longDescription] => 
Sliema – Exceptional Seafront 3-Bedroom Apartment

A truly stunning SEAFRONT 215 square meter apartment enjoying breathtaking views of Sliema Creek, Valletta Bastions and Manoel Island. Set within an impressive waterfront block in one of Sliema’s most sought-after locations, this spacious property offers a generous sitting/dining room, study, split-level TV room, fitted kitchen with breakfast area, three bedrooms, main bedroom with walk-in wardrobe and en-suite, separate bathroom, guest toilet and laundry room. Complementing the property is a large private terrace, perfect for enjoying the spectacular waterfront views, together with a private garage space. Freehold. An exceptional opportunity to acquire a prestigious seafront residence in a prime Sliema location.

    [specifications] => Requires total renovation
    [itemsIncludedInPrice] => Keys with me. Please contact me with regards to price. Does not want a price to be listed for the property.
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 3
    [bathrooms] => 0
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2026-08-13 11:19:17
    [dateOffMarket] => 
    [datePriceReduced] => 
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 215.00
    [areaSqm] => 215.00
    [internalAreaSqm] => 200.00
    [externalAreaSqm] => 15.00
    [plotAreaSqm] => 0.00
    [weight] => 0
    [features] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 22
                    [sortOrder] => 10
                    [feature] => Lift
                    [isAvailable] => 
                    [value] => Yes
                )

            [1] => stdClass Object
                (
                    [id] => 15
                    [sortOrder] => 20
                    [feature] => Floor No
                    [isAvailable] => 
                    [value] => 7
                )

            [2] => stdClass Object
                (
                    [id] => 9
                    [sortOrder] => 30
                    [feature] => Block of
                    [isAvailable] => 
                    [value] => 15
                )

            [3] => stdClass Object
                (
                    [id] => 27
                    [sortOrder] => 100
                    [feature] => No of Bedrooms
                    [isAvailable] => 
                    [value] => 3
                )

            [4] => stdClass Object
                (
                    [id] => 7
                    [sortOrder] => 110
                    [feature] => Bedroom 1 Dims
                    [isAvailable] => 
                    [value] => 3.3m by 3.2m
                )

            [5] => stdClass Object
                (
                    [id] => 8
                    [sortOrder] => 120
                    [feature] => Bedroom 2 Dims
                    [isAvailable] => 
                    [value] => 3m by 2m
                )

            [6] => stdClass Object
                (
                    [id] => 44
                    [sortOrder] => 130
                    [feature] => Bedroom 3 Dims
                    [isAvailable] => 
                    [value] => 5.5m by 4.3m
                )

            [7] => stdClass Object
                (
                    [id] => 5
                    [sortOrder] => 180
                    [feature] => Bathroom 1 Type
                    [isAvailable] => 
                    [value] => Spare
                )

            [8] => stdClass Object
                (
                    [id] => 46
                    [sortOrder] => 260
                    [feature] => Shower 1 Type
                    [isAvailable] => 
                    [value] => Ensuite
                )

            [9] => stdClass Object
                (
                    [id] => 12
                    [sortOrder] => 310
                    [feature] => Dining Rooms
                    [isAvailable] => 
                    [value] => 1
                )

            [10] => stdClass Object
                (
                    [id] => 21
                    [sortOrder] => 320
                    [feature] => Kitchens
                    [isAvailable] => 
                    [value] => 1
                )

            [11] => stdClass Object
                (
                    [id] => 24
                    [sortOrder] => 330
                    [feature] => Living Rooms
                    [isAvailable] => 
                    [value] => 1
                )

            [12] => stdClass Object
                (
                    [id] => 23
                    [sortOrder] => 335
                    [feature] => Living Room Dims
                    [isAvailable] => 
                    [value] => 8m by 5m
                )

            [13] => stdClass Object
                (
                    [id] => 34
                    [sortOrder] => 350
                    [feature] => Store Rooms
                    [isAvailable] => 
                    [value] => 1
                )

            [14] => stdClass Object
                (
                    [id] => 55
                    [sortOrder] => 355
                    [feature] => Store Room Dimensions
                    [isAvailable] => 
                    [value] => 0.6m by 0.8m
                )

            [15] => stdClass Object
                (
                    [id] => 16
                    [sortOrder] => 440
                    [feature] => Garages (No of)
                    [isAvailable] => 
                    [value] => 1
                )

            [16] => stdClass Object
                (
                    [id] => 41
                    [sortOrder] => 443
                    [feature] => Garage No of Cars
                    [isAvailable] => 
                    [value] => 1
                )

            [17] => stdClass Object
                (
                    [id] => 40
                    [sortOrder] => 445
                    [feature] => Garage Level
                    [isAvailable] => 
                    [value] => Semi-basement
                )

            [18] => stdClass Object
                (
                    [id] => 48
                    [sortOrder] => 630
                    [feature] => Terrace (Front)
                    [isAvailable] => 
                    [value] => Yes
                )

            [19] => stdClass Object
                (
                    [id] => 49
                    [sortOrder] => 633
                    [feature] => Terrace Front Dimensions 1
                    [isAvailable] => 
                    [value] => 3m by 5m
                )

            [20] => stdClass Object
                (
                    [id] => 14
                    [sortOrder] => 720
                    [feature] => Finish
                    [isAvailable] => 
                    [value] => Fair
                )

            [21] => stdClass Object
                (
                    [id] => 31
                    [sortOrder] => 735
                    [feature] => Roof (Use of)
                    [isAvailable] => 
                    [value] => None
                )

            [22] => stdClass Object
                (
                    [id] => 25
                    [sortOrder] => 738
                    [feature] => Location
                    [isAvailable] => 
                    [value] => Seafront
                )

            [23] => stdClass Object
                (
                    [id] => 53
                    [sortOrder] => 770
                    [feature] => Privacy
                    [isAvailable] => 
                    [value] => Yes
                )

            [24] => stdClass Object
                (
                    [id] => 10
                    [sortOrder] => 780
                    [feature] => Bus Stop
                    [isAvailable] => 
                    [value] => Close by
                )

            [25] => stdClass Object
                (
                    [id] => 30
                    [sortOrder] => 790
                    [feature] => Roads made
                    [isAvailable] => 
                    [value] => Yes
                )

            [26] => stdClass Object
                (
                    [id] => 32
                    [sortOrder] => 800
                    [feature] => Shops
                    [isAvailable] => 
                    [value] => Close by
                )

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1714679
                    [property_id] => 01-9271421
                    [file_name] => 1_01-9271421.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => 65769128-4113-49c9-8c91-83cf82cd57ea.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1714680
                    [property_id] => 01-9271421
                    [file_name] => 2_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => 65769128-4113-49c9-8c91-83cf82cd57ea.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1714681
                    [property_id] => 01-9271421
                    [file_name] => 3_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => 4e3774a6-a352-4985-965a-1d14896f8149.jpg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1714682
                    [property_id] => 01-9271421
                    [file_name] => 4_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => cc1afa0b-d6d5-421e-9a62-89e63634396b.jpg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1714683
                    [property_id] => 01-9271421
                    [file_name] => 5_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => 70c01fb2-6400-4b50-8096-a9c7bd9cb2f4.jpg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1714684
                    [property_id] => 01-9271421
                    [file_name] => 6_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/jpeg
                    [original_file_name] => 1dfbaaa1-e117-4587-ae2f-dc45dcaaf895.jpg
                    [seo_url] => 
                )

            [6] => stdClass Object
                (
                    [file_id] => 1714685
                    [property_id] => 01-9271421
                    [file_name] => 7_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 7
                    [mime] => image/jpeg
                    [original_file_name] => f7a63a5e-716a-43f4-a313-b706f9bab961.jpg
                    [seo_url] => 
                )

            [7] => stdClass Object
                (
                    [file_id] => 1714686
                    [property_id] => 01-9271421
                    [file_name] => 8_01-9271421.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 8
                    [mime] => image/jpeg
                    [original_file_name] => 2b32a030-22b5-43f9-a054-8c34e8bc835b.jpg
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => BELM
            [full_name] => Bertille Lungaro Mifsud
            [agent_code] => BLM
            [img_file_name] => bertille-lungaro-mifsud.jpg
            [img_name] => bc60210f-a0a0-4980-92cf-15fe22746704.jpg
            [branch_id] => 6
            [branch_name] => St Julians Office
            [branch_email] => [email protected]
            [description] => Bertille Lungaro Mifsud is Senior Property Sales Consultant in St Julians Branch. Bertille comes from a varied working background, having been involved with Language Schools, printing press, the hospitality industry as well as accountancy. Her career in real estate took off in 1998 and started working with Frank Salt Real Estate in 2007. Bertille focuses on delivering the right property and investment to her clients satisfactory suit and making the process a smooth and enjoyable transition. Her personal interests in her free time are reading, going on nature walks and relaxing with family and friends.
            [designation] => 
            [contact_number] => 0035679476640
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-08-19T09:04:28.000000Z
    [updated_at] => 2026-08-19T09:04:28.000000Z
)