Cospicua, Finished Guest House

stdClass Object
(
    [ref] => 045446
    [webRef] => 045446
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-04-27 00:00:00
    [marketType] => ForSale
    [commercial] => 1
    [development] => 
    [developmentID] => 
    [locality] => 14
    [locality_details] => stdClass Object
        (
            [id] => 14
            [localityName] => Cospicua
            [zoneId] => 8
            [parentLocalityId] => 
        )

    [propertyType] => 33
    [propertyType_details] => stdClass Object
        (
            [id] => 33
            [description] => Guest House
            [sortSequence] => 
            [propertyTypeGroupId] => 7
        )

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

    [price] => 1195000.00
    [oldPrice] => 1195000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Cospicua, Finished Guest House
    [title] => Cospicua, Finished Guest House
    [longDescription] => Corner 3 storey PALAZZINO in good structure condition - Situated on a lovely square in the best part of this lovely village and a stone throw away from Vittoriosa and the Marina. The property is truly unique and can be easily transformed into a guest house with a restaurant, several large rooms, and a rooftop pool with al fresco dining and an underground four- roomed basement. A true gem in this locality with a great potential to covert and rooftop enjoying marvelous views of the three cities. Freehold 

    [specifications] => 
    [itemsIncludedInPrice] => Possibility of lift.
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 5
    [bathrooms] => 4
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2024-03-06 00:00:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-04-27 14:26:37
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 0.00
    [areaSqm] => 0.00
    [internalAreaSqm] => 0.00
    [externalAreaSqm] => 0.00
    [plotAreaSqm] => 0.00
    [weight] => 0
    [features] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 43
                    [sortOrder] => 0
                    [feature] => Airconditioning
                    [isAvailable] => 
                    [value] => No
                )

            [1] => stdClass Object
                (
                    [id] => 140
                    [sortOrder] => 0
                    [feature] => Bathrooms/Showers en-suite
                    [isAvailable] => 
                    [value] => 2
                )

            [2] => stdClass Object
                (
                    [id] => 120
                    [sortOrder] => 0
                    [feature] => Bathrooms/Showers public
                    [isAvailable] => 
                    [value] => 2
                )

            [3] => stdClass Object
                (
                    [id] => 10
                    [sortOrder] => 0
                    [feature] => Bus Stop
                    [isAvailable] => 
                    [value] => Within walking distance
                )

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

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

            [6] => stdClass Object
                (
                    [id] => 99
                    [sortOrder] => 0
                    [feature] => Heating
                    [isAvailable] => 
                    [value] => None
                )

            [7] => stdClass Object
                (
                    [id] => 136
                    [sortOrder] => 0
                    [feature] => Kitchens/Kitchenettes (no of)
                    [isAvailable] => 
                    [value] => 1
                )

            [8] => stdClass Object
                (
                    [id] => 132
                    [sortOrder] => 0
                    [feature] => Loading Bay
                    [isAvailable] => 
                    [value] => Yes
                )

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

            [10] => stdClass Object
                (
                    [id] => 123
                    [sortOrder] => 0
                    [feature] => Male Toilets
                    [isAvailable] => 
                    [value] => 2
                )

            [11] => stdClass Object
                (
                    [id] => 141
                    [sortOrder] => 0
                    [feature] => No of Bedrooms:
                    [isAvailable] => 
                    [value] => 5
                )

            [12] => stdClass Object
                (
                    [id] => 142
                    [sortOrder] => 0
                    [feature] => No of Beds
                    [isAvailable] => 
                    [value] => 5
                )

            [13] => stdClass Object
                (
                    [id] => 83
                    [sortOrder] => 0
                    [feature] => No of Floors (above street lev.)
                    [isAvailable] => 
                    [value] => 1
                )

            [14] => stdClass Object
                (
                    [id] => 84
                    [sortOrder] => 0
                    [feature] => Passing trade
                    [isAvailable] => 
                    [value] => Yes
                )

            [15] => stdClass Object
                (
                    [id] => 85
                    [sortOrder] => 0
                    [feature] => Permit/Licence
                    [isAvailable] => 
                    [value] => No
                )

            [16] => stdClass Object
                (
                    [id] => 87
                    [sortOrder] => 0
                    [feature] => Roads
                    [isAvailable] => 
                    [value] => Made
                )

            [17] => stdClass Object
                (
                    [id] => 31
                    [sortOrder] => 0
                    [feature] => Roof (Use of)
                    [isAvailable] => 
                    [value] => Ownership
                )

            [18] => stdClass Object
                (
                    [id] => 32
                    [sortOrder] => 0
                    [feature] => Shops
                    [isAvailable] => 
                    [value] => Within walking distance
                )

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

            [20] => stdClass Object
                (
                    [id] => 165
                    [sortOrder] => 
                    [feature] => UCA
                    [isAvailable] => 
                    [value] => No
                )

            [21] => stdClass Object
                (
                    [id] => 38
                    [sortOrder] => 0
                    [feature] => Views Standard
                    [isAvailable] => 
                    [value] => Very Good
                )

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1468359
                    [property_id] => 045446
                    [file_name] => 1_045446.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => 1c33526a-1b4e-488a-8cdd-20b438f0456c.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1468360
                    [property_id] => 045446
                    [file_name] => 2_045446.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => 1c33526a-1b4e-488a-8cdd-20b438f0456c.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1468361
                    [property_id] => 045446
                    [file_name] => 3_045446.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => 63e5dacc-8969-47c0-8417-5fafc6990141.jpg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1614184
                    [property_id] => 045446
                    [file_name] => 4_045446.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => ff67ecb6-0149-400e-a905-ab38ac0376d1.jpg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1614185
                    [property_id] => 045446
                    [file_name] => 5_045446.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => 6a05b61d-99c9-4a53-92ee-04efbfbd1d18.jpg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1614186
                    [property_id] => 045446
                    [file_name] => 6_045446.pdf
                    [file_type] => Plan
                    [sequence_no] => 6
                    [mime] => application/pdf
                    [original_file_name] => cc704781-7868-447f-94fa-094d0e998391.pdf
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => MC
            [full_name] => Marisa Camilleri
            [agent_code] => MC
            [img_file_name] => marisa-camilleri.jpg
            [img_name] => e64e023e-454c-4a74-8450-0b1501871bb0.jpg
            [branch_id] => 6
            [branch_name] => St Julians Office
            [branch_email] => [email protected]
            [description] => Marisa Camilleri is a Senior Property Sales Consultant at our St Julians Branch. She started her career in real estate in 1988 with Frank Salt Real Estate and is a proven and well respected leader in the property industry, enjoying a sterling reputation. She specialises in residential sales and is energetic, with a genuine passion for helping others. She prides herself on her professionalism, integrity and reliability and willingly goes the extra mile to deliver an exceptional service experience to her clients. Marisa believes property is an excellent investment prospect and relishes being involved in her clients' wealth creation and in finding the right property for their requirements.
            [designation] => 
            [contact_number] => 0035699471392
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-04-08T13:33:55.000000Z
    [updated_at] => 2026-04-27T15:53:20.000000Z
)