Mellieha, Finished Villa

stdClass Object
(
    [ref] => 039531
    [webRef] => 039531
    [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] => 2900000.00
    [oldPrice] => 2900000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Mellieha, Finished Villa
    [title] => Mellieha, Finished Villa
    [longDescription] => 
An opportunity to acquire a one of a kind seven bedroom FULLY DETACHED VILLA (approx. 1,500 sqm of land) that is located in a very peaceful area of Santa Marija Estate, enjoying breathtaking country and sea views. Property is elevated and accessible from two roads and moreover the main entrance is on the highest level of the house, guaranteeing excellent views from all its main living spaces. The heated pool, jacuzzi and decking area is perfect for entertaining and is totally private. Further complementing this property is a drive in surrounded by a beautiful mature garden that leads to a ten car garage. One of a kind property and location, must be viewed to be appreciated!

    [specifications] => 
    [itemsIncludedInPrice] => Gibja 150,000 Gallon, Stove and Lift
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 7
    [bathrooms] => 7
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2019-10-14 00:00:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-05-06 15:02:30
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 1500.00
    [areaSqm] => 1500.00
    [internalAreaSqm] => 0.00
    [externalAreaSqm] => 0.00
    [plotAreaSqm] => 1500.00
    [weight] => 0
    [features] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 43
                    [sortOrder] => 0
                    [feature] => Airconditioning
                    [isAvailable] => 
                    [value] => Yes
                )

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

            [2] => stdClass Object
                (
                    [id] => 104
                    [sortOrder] => 0
                    [feature] => Basement
                    [isAvailable] => 
                    [value] => No
                )

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

            [4] => stdClass Object
                (
                    [id] => 6
                    [sortOrder] => 0
                    [feature] => Bathroom 2 Type
                    [isAvailable] => 
                    [value] => Spare
                )

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

            [6] => stdClass Object
                (
                    [id] => 96
                    [sortOrder] => 0
                    [feature] => Bathroom 4 Type
                    [isAvailable] => 
                    [value] => Ensuite
                )

            [7] => stdClass Object
                (
                    [id] => 7
                    [sortOrder] => 0
                    [feature] => Bedroom 1 Dims
                    [isAvailable] => 
                    [value] => 4.5m by 6.1m
                )

            [8] => stdClass Object
                (
                    [id] => 8
                    [sortOrder] => 0
                    [feature] => Bedroom 2 Dims
                    [isAvailable] => 
                    [value] => 4.4m by 4.5m
                )

            [9] => stdClass Object
                (
                    [id] => 44
                    [sortOrder] => 0
                    [feature] => Bedroom 3 Dims
                    [isAvailable] => 
                    [value] => 4.3m by 4.5m
                )

            [10] => stdClass Object
                (
                    [id] => 50
                    [sortOrder] => 0
                    [feature] => Bedroom 4 Dims
                    [isAvailable] => 
                    [value] => 4.5m by 6.1m
                )

            [11] => stdClass Object
                (
                    [id] => 100
                    [sortOrder] => 0
                    [feature] => Bedroom 5 Dims
                    [isAvailable] => 
                    [value] => 3.8m by 5.2m
                )

            [12] => stdClass Object
                (
                    [id] => 106
                    [sortOrder] => 0
                    [feature] => Bedroom 6 Dims
                    [isAvailable] => 
                    [value] => 4.7m by 4.5m
                )

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

            [14] => stdClass Object
                (
                    [id] => 11
                    [sortOrder] => 0
                    [feature] => Dining Room Dims
                    [isAvailable] => 
                    [value] => 5.05m by 9.12m
                )

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

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

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

            [18] => stdClass Object
                (
                    [id] => 41
                    [sortOrder] => 0
                    [feature] => Garage No of Cars
                    [isAvailable] => 
                    [value] => 10
                )

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

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

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

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

            [23] => stdClass Object
                (
                    [id] => 20
                    [sortOrder] => 0
                    [feature] => Kitchen Dims
                    [isAvailable] => 
                    [value] => 5.28m by 6.21m
                )

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

            [25] => stdClass Object
                (
                    [id] => 23
                    [sortOrder] => 0
                    [feature] => Living Room Dims
                    [isAvailable] => 
                    [value] => 5.5m by 6.65m
                )

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

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

            [28] => stdClass Object
                (
                    [id] => 26
                    [sortOrder] => 0
                    [feature] => No of Bathrooms
                    [isAvailable] => 
                    [value] => 5
                )

            [29] => stdClass Object
                (
                    [id] => 27
                    [sortOrder] => 0
                    [feature] => No of Bedrooms
                    [isAvailable] => 
                    [value] => 7
                )

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

            [31] => stdClass Object
                (
                    [id] => 54
                    [sortOrder] => 0
                    [feature] => Reception Dims
                    [isAvailable] => 
                    [value] => 6.8m by 8.6m
                )

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

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

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

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

            [36] => stdClass Object
                (
                    [id] => 47
                    [sortOrder] => 0
                    [feature] => Shower 2 Type
                    [isAvailable] => 
                    [value] => Ensuite
                )

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

            [38] => stdClass Object
                (
                    [id] => 55
                    [sortOrder] => 0
                    [feature] => Store Room Dimensions
                    [isAvailable] => 
                    [value] => 2m by 2.6m
                )

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

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

            [41] => stdClass Object
                (
                    [id] => 70
                    [sortOrder] => 0
                    [feature] => Study Dimensions
                    [isAvailable] => 
                    [value] => 5m by 4.7m
                )

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

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

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

            [45] => stdClass Object
                (
                    [id] => 49
                    [sortOrder] => 0
                    [feature] => Terrace Front Dimensions 1
                    [isAvailable] => 
                    [value] => 10.1m by 5m
                )

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

            [47] => stdClass Object
                (
                    [id] => 35
                    [sortOrder] => 0
                    [feature] => Toilets No of
                    [isAvailable] => 
                    [value] => 1
                )

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

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

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

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

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1529239
                    [property_id] => 039531
                    [file_name] => 1_039531.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => f7f08258-5c21-4279-a100-aa831af36619.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1529240
                    [property_id] => 039531
                    [file_name] => 2_039531.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => f7f08258-5c21-4279-a100-aa831af36619.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1529241
                    [property_id] => 039531
                    [file_name] => 3_039531.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => fee830b0-a7ba-4446-8528-bdfa8fe9a34f.jpg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1529242
                    [property_id] => 039531
                    [file_name] => 4_039531.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => 2eefe201-043a-47ba-819f-2eb71d94bccc.jpg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1529243
                    [property_id] => 039531
                    [file_name] => 5_039531.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => f6f9bca2-a7a4-4af6-8325-9b8e1a96668d.jpg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1529244
                    [property_id] => 039531
                    [file_name] => 6_039531.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/jpeg
                    [original_file_name] => 0ce6c573-5e89-455d-8676-43b64bbb584c.jpg
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => TECR
            [full_name] => Teresa Camilleri Rausi
            [agent_code] => TCR
            [img_file_name] => teresa-camilleri-rausi.jpg
            [img_name] => acdd3024-68cb-4a2e-9ae8-70f0cdf7a223.jpg
            [branch_id] => 6
            [branch_name] => St Julians Office
            [branch_email] => [email protected]
            [description] => Property Sales Consultant in St. Julian's. Teresa has a general interest in people's wellbeing and she believes that finding the right home is very significant in a person's life story. Having an academic background in the caring profession and having always had an interest in real estate, Teresa is now taking on the path of helping people find the home of their dreams. Teresa chose to work with Frank Salt Real Estate as it's reputable for its transparency and seriousness. During her spare time, she enjoys reading, listening to music, sailing, travelling and being with family and friends.
            [designation] => 
            [contact_number] => 0035699293739
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-04-14T12:46:31.000000Z
    [updated_at] => 2026-04-27T15:54:48.000000Z
)