Mellieha, Finished Villa

stdClass Object
(
    [ref] => 042172
    [webRef] => 042172
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-04-27 00:00:00
    [marketType] => ForSale
    [commercial] => 0
    [development] => 
    [developmentID] => 
    [locality] => 54
    [locality_details] => stdClass Object
        (
            [id] => 54
            [localityName] => Mellieha
            [zoneId] => 4
            [parentLocalityId] => 
        )

    [propertyType] => 9
    [propertyType_details] => stdClass Object
        (
            [id] => 9
            [description] => Villa
            [sortSequence] => 
            [propertyTypeGroupId] => 8
        )

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

    [price] => 6900000.00
    [oldPrice] => 6900000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Mellieha, Finished Villa
    [title] => Mellieha, Finished Villa
    [longDescription] => 
A unique, elevated, DETACHED VILLA built on approx 2,200 sqm of land, located on high grounds in Santa Maria Estate, enjoying panoramic country and sea views. This villa is spread out over three floors with an approximate internal square meterage of 1,500, with ground floor comprising of a 10 car garage, an entrance hall with a lift which leads to the above floor, a large room intended to be a cinema room and a 2 bedroom flat let. The first floor is made up of an indoor pool, a gym, an outdoor pool and three rooms whilst the upper most floor comprises of three double bedrooms all en suite, master with walk in wardrobe, a kitchen, living and dining room which open up onto a terrace with breath taking sea and town views.

    [specifications] => 
    [itemsIncludedInPrice] => Partly Furnished
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 7
    [bathrooms] => 5
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2021-10-05 00:00:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-08-12 14:41:55
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 0.00
    [areaSqm] => 0.00
    [internalAreaSqm] => 1550.00
    [externalAreaSqm] => 0.00
    [plotAreaSqm] => 2200.00
    [weight] => 0
    [features] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 165
                    [sortOrder] => 1
                    [feature] => UCA
                    [isAvailable] => 
                    [value] => No
                )

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

            [2] => stdClass Object
                (
                    [id] => 7
                    [sortOrder] => 110
                    [feature] => Bedroom 1 Dims
                    [isAvailable] => 
                    [value] => 3.5m by 6.5m
                )

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

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

            [5] => stdClass Object
                (
                    [id] => 50
                    [sortOrder] => 140
                    [feature] => Bedroom 4 Dims
                    [isAvailable] => 
                    [value] => 3.6m by 5m
                )

            [6] => stdClass Object
                (
                    [id] => 100
                    [sortOrder] => 150
                    [feature] => Bedroom 5 Dims
                    [isAvailable] => 
                    [value] => 3.6m by 5m
                )

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

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

            [9] => stdClass Object
                (
                    [id] => 6
                    [sortOrder] => 190
                    [feature] => Bathroom 2 Type
                    [isAvailable] => 
                    [value] => Ensuite
                )

            [10] => stdClass Object
                (
                    [id] => 94
                    [sortOrder] => 200
                    [feature] => Bathroom 3 Type
                    [isAvailable] => 
                    [value] => Ensuite
                )

            [11] => stdClass Object
                (
                    [id] => 35
                    [sortOrder] => 220
                    [feature] => Toilets No of
                    [isAvailable] => 
                    [value] => 2
                )

            [12] => stdClass Object
                (
                    [id] => 63
                    [sortOrder] => 230
                    [feature] => Toilet 1 Type
                    [isAvailable] => 
                    [value] => Spare
                )

            [13] => stdClass Object
                (
                    [id] => 71
                    [sortOrder] => 240
                    [feature] => Toilet 2 Type
                    [isAvailable] => 
                    [value] => Spare
                )

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

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

            [16] => stdClass Object
                (
                    [id] => 47
                    [sortOrder] => 270
                    [feature] => Shower 2 Type
                    [isAvailable] => 
                    [value] => Spare
                )

            [17] => stdClass Object
                (
                    [id] => 29
                    [sortOrder] => 300
                    [feature] => Receptions No of
                    [isAvailable] => 
                    [value] => 1
                )

            [18] => stdClass Object
                (
                    [id] => 54
                    [sortOrder] => 305
                    [feature] => Reception Dims
                    [isAvailable] => 
                    [value] => 16.5m by 7.5m
                )

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

            [20] => stdClass Object
                (
                    [id] => 11
                    [sortOrder] => 315
                    [feature] => Dining Room Dims
                    [isAvailable] => 
                    [value] => 3.5m by 8.5m
                )

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

            [22] => stdClass Object
                (
                    [id] => 20
                    [sortOrder] => 325
                    [feature] => Kitchen Dims
                    [isAvailable] => 
                    [value] => 5m by 7m
                )

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

            [24] => stdClass Object
                (
                    [id] => 23
                    [sortOrder] => 335
                    [feature] => Living Room Dims
                    [isAvailable] => 
                    [value] => 9.5m by 10m
                )

            [25] => stdClass Object
                (
                    [id] => 69
                    [sortOrder] => 339
                    [feature] => Study
                    [isAvailable] => 
                    [value] => Yes
                )

            [26] => stdClass Object
                (
                    [id] => 70
                    [sortOrder] => 340
                    [feature] => Study Dimensions
                    [isAvailable] => 
                    [value] => 3.5m by 3.5m
                )

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

            [28] => stdClass Object
                (
                    [id] => 17
                    [sortOrder] => 360
                    [feature] => Hall
                    [isAvailable] => 
                    [value] => 1
                )

            [29] => stdClass Object
                (
                    [id] => 39
                    [sortOrder] => 400
                    [feature] => Washroom
                    [isAvailable] => 
                    [value] => 1
                )

            [30] => stdClass Object
                (
                    [id] => 104
                    [sortOrder] => 410
                    [feature] => Basement
                    [isAvailable] => 
                    [value] => Yes
                )

            [31] => stdClass Object
                (
                    [id] => 95
                    [sortOrder] => 415
                    [feature] => Basement No of Rooms
                    [isAvailable] => 
                    [value] => 1
                )

            [32] => stdClass Object
                (
                    [id] => 67
                    [sortOrder] => 420
                    [feature] => Flatlet
                    [isAvailable] => 
                    [value] => Separate entrance
                )

            [33] => stdClass Object
                (
                    [id] => 119
                    [sortOrder] => 425
                    [feature] => Flatlet No of Bedrooms
                    [isAvailable] => 
                    [value] => 2
                )

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

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

            [36] => stdClass Object
                (
                    [id] => 40
                    [sortOrder] => 445
                    [feature] => Garage Level
                    [isAvailable] => 
                    [value] => Street level
                )

            [37] => stdClass Object
                (
                    [id] => 51
                    [sortOrder] => 446
                    [feature] => Garage Type
                    [isAvailable] => 
                    [value] => Private
                )

            [38] => stdClass Object
                (
                    [id] => 57
                    [sortOrder] => 500
                    [feature] => Swimming Pool
                    [isAvailable] => 
                    [value] => Yes
                )

            [39] => stdClass Object
                (
                    [id] => 59
                    [sortOrder] => 501
                    [feature] => Swimming Pool Type
                    [isAvailable] => 
                    [value] => Private
                )

            [40] => stdClass Object
                (
                    [id] => 58
                    [sortOrder] => 505
                    [feature] => Swimming Pool (dims)
                    [isAvailable] => 
                    [value] => 5.5m by 9m
                )

            [41] => stdClass Object
                (
                    [id] => 64
                    [sortOrder] => 510
                    [feature] => Garden (dims)
                    [isAvailable] => 
                    [value] => 10m by 18m
                )

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

            [43] => stdClass Object
                (
                    [id] => 49
                    [sortOrder] => 633
                    [feature] => Terrace Front Dimensions 1
                    [isAvailable] => 
                    [value] => 8m by 17m
                )

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

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

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

            [47] => stdClass Object
                (
                    [id] => 14
                    [sortOrder] => 720
                    [feature] => Finish
                    [isAvailable] => 
                    [value] => Very Good
                )

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

            [49] => stdClass Object
                (
                    [id] => 45
                    [sortOrder] => 740
                    [feature] => Refurbished
                    [isAvailable] => 
                    [value] => Yes
                )

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

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

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

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

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

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

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1489803
                    [property_id] => 042172
                    [file_name] => 1_042172.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => 7169b16a-3826-412c-8bd9-095724a63ece.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1489804
                    [property_id] => 042172
                    [file_name] => 2_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => 7169b16a-3826-412c-8bd9-095724a63ece.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1489805
                    [property_id] => 042172
                    [file_name] => 3_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => a0aeee9b-6c71-47af-a59b-3bcb286558c5.jpg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1606685
                    [property_id] => 042172
                    [file_name] => 4_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => 303bd310-b196-412f-b4a2-d9f99e9d7294.jpg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1606686
                    [property_id] => 042172
                    [file_name] => 5_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => 67347556-b312-4338-9a0e-f2cf72bcfbf5.jpg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1606687
                    [property_id] => 042172
                    [file_name] => 6_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/jpeg
                    [original_file_name] => 4abca963-f1b0-4b56-8323-e6180803bfc4.jpg
                    [seo_url] => 
                )

            [6] => stdClass Object
                (
                    [file_id] => 1606688
                    [property_id] => 042172
                    [file_name] => 7_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 7
                    [mime] => image/jpeg
                    [original_file_name] => b4283c20-acea-48e7-b16d-bc7d1731cb1e.jpg
                    [seo_url] => 
                )

            [7] => stdClass Object
                (
                    [file_id] => 1606689
                    [property_id] => 042172
                    [file_name] => 8_042172.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 8
                    [mime] => image/jpeg
                    [original_file_name] => 94e27a6b-4d84-47dd-a30d-0a11ccf387c6.jpg
                    [seo_url] => 
                )

            [8] => stdClass Object
                (
                    [file_id] => 1606690
                    [property_id] => 042172
                    [file_name] => 9_042172.pdf
                    [file_type] => Plan
                    [sequence_no] => 9
                    [mime] => application/pdf
                    [original_file_name] => cb831a02-d329-41ac-a76e-3a71b1f6a34f.pdf
                    [seo_url] => 
                )

            [9] => stdClass Object
                (
                    [file_id] => 1606691
                    [property_id] => 042172
                    [file_name] => 10_042172.pdf
                    [file_type] => Plan
                    [sequence_no] => 10
                    [mime] => application/pdf
                    [original_file_name] => 08c9bfa2-5b3f-4007-ab4c-f4372f2cbb6b.pdf
                    [seo_url] => 
                )

            [10] => stdClass Object
                (
                    [file_id] => 1606692
                    [property_id] => 042172
                    [file_name] => 11_042172.pdf
                    [file_type] => Plan
                    [sequence_no] => 11
                    [mime] => application/pdf
                    [original_file_name] => d1acec78-886d-466b-bc4d-32fc47aecdc2.pdf
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => NP
            [full_name] => Nicholas Portelli
            [agent_code] => NPP
            [img_file_name] => nicholas-portelli.jpg
            [img_name] => e4433817-2254-4942-a783-4f0bf3319708.jpg
            [branch_id] => 6
            [branch_name] => St Julians Office
            [branch_email] => [email protected]
            [description] => Nicholas Portelli is a Senior Property Sales Consultant at Head Office in St. Julians. Nicholas began his career with Frank Salt Real Estate in 2012 and he loves the diversity of the job; he is a warm, energetic, people-oriented person with a genuine passion for helping others. He prides himself on his professionalism, integrity and reliability, and willingly goes the extra mile to deliver an exceptional service experience to his clients. Nicholas believes property is an excellent investment prospect and relishes being involved in his clients' wealth creation and asset management. Nicholas speaks Maltese and English. In his leisure time, he has a passion for sports and socializing.
            [designation] => 
            [contact_number] => 0035679284030
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-04-08T15:13:37.000000Z
    [updated_at] => 2026-04-27T15:54:48.000000Z
)