Qawra 3 Bedroom Sea View Apartment

stdClass Object
(
    [ref] => 70-9271559
    [webRef] => 70-9271559
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-08-21 00:00:00
    [marketType] => ForSale
    [commercial] => 0
    [development] => 
    [developmentID] => 
    [locality] => 81
    [locality_details] => stdClass Object
        (
            [id] => 81
            [localityName] => Qawra
            [zoneId] => 4
            [parentLocalityId] => 
        )

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

    [propertyStatus] => 6
    [propertyStatus_details] => stdClass Object
        (
            [id] => 6
            [description] => Furnished
            [sortSequence] => 
        )

    [price] => 478000.00
    [oldPrice] => 478000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Qawra 3 Bedroom Sea View Apartment
    [title] => Qawra 3 Bedroom Sea View Apartment
    [longDescription] => 
A bright and spacious corner apartment situated in the sought-after Aquarium area, offering beautiful open sea views. Upon entering, the property features a welcoming living room leading onto a front terrace, followed by a separate dining room and kitchen. The layout further comprises 2 double bedrooms, 1 single bedroom, a main bathroom, and a separate shower room. The apartment is very bright and airy, benefiting from large windows throughout, with no overlooking shafts. Freehold, with use of the roof, and situated on the 2nd floor. No lift. An excellent family home in a desirable location.

    [specifications] => 
    [itemsIncludedInPrice] => 
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 3
    [bathrooms] => 2
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2026-08-21 09:02:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-08-21 15:10:54
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 80.00
    [areaSqm] => 80.00
    [internalAreaSqm] => 76.00
    [externalAreaSqm] => 4.00
    [plotAreaSqm] => 0.00
    [weight] => 0
    [features] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 22
                    [sortOrder] => 10
                    [feature] => Lift
                    [isAvailable] => 
                    [value] => No
                )

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

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

            [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.5m by 3.6m
                )

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

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

            [7] => stdClass Object
                (
                    [id] => 26
                    [sortOrder] => 170
                    [feature] => No of Bathrooms
                    [isAvailable] => 
                    [value] => 1
                )

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

            [9] => stdClass Object
                (
                    [id] => 33
                    [sortOrder] => 250
                    [feature] => Showers No of
                    [isAvailable] => 
                    [value] => 1
                )

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

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

            [12] => stdClass Object
                (
                    [id] => 11
                    [sortOrder] => 315
                    [feature] => Dining Room Dims
                    [isAvailable] => 
                    [value] => 3.07m by 4.09m
                )

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

            [14] => stdClass Object
                (
                    [id] => 20
                    [sortOrder] => 325
                    [feature] => Kitchen Dims
                    [isAvailable] => 
                    [value] => 3.06m by 2.28m
                )

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

            [16] => stdClass Object
                (
                    [id] => 23
                    [sortOrder] => 335
                    [feature] => Living Room Dims
                    [isAvailable] => 
                    [value] => 2.9m by 3.5m
                )

            [17] => stdClass Object
                (
                    [id] => 2
                    [sortOrder] => 600
                    [feature] => Balconies (Front)
                    [isAvailable] => 
                    [value] => 1
                )

            [18] => stdClass Object
                (
                    [id] => 4
                    [sortOrder] => 605
                    [feature] => Balcony Front Dimensions
                    [isAvailable] => 
                    [value] => 3.6m by 1.04m
                )

            [19] => stdClass Object
                (
                    [id] => 18
                    [sortOrder] => 710
                    [feature] => Has Views
                    [isAvailable] => 
                    [value] => Yes
                )

            [20] => stdClass Object
                (
                    [id] => 37
                    [sortOrder] => 712
                    [feature] => Type of View
                    [isAvailable] => 
                    [value] => Sea views
                )

            [21] => stdClass Object
                (
                    [id] => 38
                    [sortOrder] => 715
                    [feature] => Views Standard
                    [isAvailable] => 
                    [value] => Excellent
                )

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

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

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

            [25] => stdClass Object
                (
                    [id] => 43
                    [sortOrder] => 750
                    [feature] => Airconditioning
                    [isAvailable] => 
                    [value] => Yes
                )

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

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

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1715826
                    [property_id] => 70-9271559
                    [file_name] => 1_70-9271559.jpeg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => 60bf9134-2071-4e09-abd8-1fca4d10cd98.jpeg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1715827
                    [property_id] => 70-9271559
                    [file_name] => 2_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => 60bf9134-2071-4e09-abd8-1fca4d10cd98.jpeg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1715828
                    [property_id] => 70-9271559
                    [file_name] => 3_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => 5621868a-9306-401b-957f-ea7ca2bc63a4.jpeg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1715829
                    [property_id] => 70-9271559
                    [file_name] => 4_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => 1d037faa-2b6f-4925-9f12-5889f0cb7ae4.jpeg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1715830
                    [property_id] => 70-9271559
                    [file_name] => 5_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => 3f4c8915-b850-425e-9e41-e70034265d02.jpeg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1715831
                    [property_id] => 70-9271559
                    [file_name] => 6_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/jpeg
                    [original_file_name] => 9886718d-2c7f-44a4-b605-0a967dfa18a5.jpeg
                    [seo_url] => 
                )

            [6] => stdClass Object
                (
                    [file_id] => 1715832
                    [property_id] => 70-9271559
                    [file_name] => 7_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 7
                    [mime] => image/jpeg
                    [original_file_name] => ac266384-c9de-4459-bc5e-17b18c4d2f0e.jpeg
                    [seo_url] => 
                )

            [7] => stdClass Object
                (
                    [file_id] => 1715833
                    [property_id] => 70-9271559
                    [file_name] => 8_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 8
                    [mime] => image/jpeg
                    [original_file_name] => bf061160-7e0c-4286-a663-55e19fc0f562.jpeg
                    [seo_url] => 
                )

            [8] => stdClass Object
                (
                    [file_id] => 1715834
                    [property_id] => 70-9271559
                    [file_name] => 9_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 9
                    [mime] => image/jpeg
                    [original_file_name] => ca7d793a-5ae7-4636-ae5b-bb1aae7a344c.jpeg
                    [seo_url] => 
                )

            [9] => stdClass Object
                (
                    [file_id] => 1715835
                    [property_id] => 70-9271559
                    [file_name] => 10_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 10
                    [mime] => image/jpeg
                    [original_file_name] => 6a2b38a3-1ecc-434e-aa4b-b4e8ae1b692a.jpeg
                    [seo_url] => 
                )

            [10] => stdClass Object
                (
                    [file_id] => 1715836
                    [property_id] => 70-9271559
                    [file_name] => 11_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 11
                    [mime] => image/jpeg
                    [original_file_name] => a90a31a5-a8e4-463c-b9d1-9e7e06ed1fee.jpeg
                    [seo_url] => 
                )

            [11] => stdClass Object
                (
                    [file_id] => 1715837
                    [property_id] => 70-9271559
                    [file_name] => 12_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 12
                    [mime] => image/jpeg
                    [original_file_name] => 926f0713-c945-4dca-ad9f-cb6516d94726.jpeg
                    [seo_url] => 
                )

            [12] => stdClass Object
                (
                    [file_id] => 1715838
                    [property_id] => 70-9271559
                    [file_name] => 13_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 13
                    [mime] => image/jpeg
                    [original_file_name] => 3c396ab0-28f3-46c6-a9c8-9832feb55fdf.jpeg
                    [seo_url] => 
                )

            [13] => stdClass Object
                (
                    [file_id] => 1715839
                    [property_id] => 70-9271559
                    [file_name] => 14_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 14
                    [mime] => image/jpeg
                    [original_file_name] => c090bcfa-d7da-4623-957c-483140dbb542.jpeg
                    [seo_url] => 
                )

            [14] => stdClass Object
                (
                    [file_id] => 1715840
                    [property_id] => 70-9271559
                    [file_name] => 15_70-9271559.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 15
                    [mime] => image/jpeg
                    [original_file_name] => 40fa8a09-d7b5-4cb3-9e18-f43d9ca58f19.jpeg
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => MARMAY
            [full_name] => Marisa Mayo
            [agent_code] => MOMA
            [img_file_name] => marisa-mayo.jpg
            [img_name] => 36d214f4-2030-4452-9dc1-a8d11da6db2f.jpg
            [branch_id] => 9
            [branch_name] => St. Paul's Bay Office
            [branch_email] => [email protected]
            [description] => Marisa embarked on her career with Frank Salt Real Estate as a Manager’s Assistant, gaining valuable experience in a fast-paced office environment. This allowed her to observe the rewarding and independent careers of her colleagues, who inspired her to pursue a more hands-on role. She made the bold decision to transition into a sales consultant position, seeking new challenges and an opportunity to meet new people and build connections.

As a family-oriented person, Marisa takes great pride in supporting her children's endeavours and creating lasting memories together. Balancing personal interests with time spent with friends and family, she finds fulfilment in life's everyday pleasures!
            [designation] => 
            [contact_number] => 0035679979945
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-08-21T15:03:54.000000Z
    [updated_at] => 2026-08-21T17:10:47.000000Z
)