Mellieha, Finished Villa

stdClass Object
(
    [ref] => 039531
    [webRef] => 039531
    [marketStatus] => OnMarket
    [expiryDateTime] => 
    [marketType] => ForSale
    [commercial] => 0
    [locality] => 60
    [locality_details] => stdClass Object
        (
            [id] => 60
            [localityName] => Mellieha
            [zoneId] => 6
            [parentLocalityId] => 0
            [created_at] => 0000-00-00 00:00:00
            [updated_at] => 0000-00-00 00:00:00
        )

    [propertyType] => 13
    [propertyType_details] => stdClass Object
        (
            [id] => 13
            [description] => Villa
            [sortSequence] => 120
            [propertyTypeGroupId] => 7
            [created_at] => 0000-00-00 00:00:00
            [updated_at] => 0000-00-00 00:00:00
        )

    [propertyStatus] => 3
    [propertyStatus_details] => stdClass Object
        (
            [id] => 3
            [description] => Finished
            [sortSequence] => 20
            [created_at] => 0000-00-00 00:00:00
            [updated_at] => 0000-00-00 00:00:00
        )

    [price] => 2900000.00
    [oldPrice] => 0.00
    [premium] => 0.00
    [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] => 5
    [total_bathrooms] => 7
    [contactDetails] => Teresa Camilleri Rausi
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 0
    [dateOnMarket] => stdClass Object
        (
            [date] => 2019-10-14 00:00:00
            [timezone_type] => 3
            [timezone] => UTC
        )

    [dateOffMarket] => 
    [datePriceReduced] => 
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 0
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 1500.00
    [weight] => 7
    [features] => stdClass Object
        (
            [0] => stdClass Object
                (
                    [id] => 5
                    [sortOrder] => 100
                    [feature] => No of Bedrooms
                    [isAvailable] => 0
                    [value] => 7
                )

            [1] => stdClass Object
                (
                    [id] => 7
                    [sortOrder] => 110
                    [feature] => Bedroom 1 Dims
                    [isAvailable] => 0
                    [value] => 6.10 x 4.50 mt
                )

            [2] => stdClass Object
                (
                    [id] => 8
                    [sortOrder] => 120
                    [feature] => Bedroom 2 Dims
                    [isAvailable] => 0
                    [value] => 4.50 x 4.40 mt
                )

            [3] => stdClass Object
                (
                    [id] => 61
                    [sortOrder] => 130
                    [feature] => Bedroom 3 Dims
                    [isAvailable] => 0
                    [value] => 4.50 x 4.30 mt
                )

            [4] => stdClass Object
                (
                    [id] => 9
                    [sortOrder] => 140
                    [feature] => Bedroom 4 Dims
                    [isAvailable] => 0
                    [value] => 6.10 x 4.50 mt
                )

            [5] => stdClass Object
                (
                    [id] => 10
                    [sortOrder] => 150
                    [feature] => Bedroom 5 Dims
                    [isAvailable] => 0
                    [value] => 5.20 x 3.80 mt
                )

            [6] => stdClass Object
                (
                    [id] => 11
                    [sortOrder] => 160
                    [feature] => Bedroom 6 Dims
                    [isAvailable] => 0
                    [value] => 4.50 x 4.70 mt
                )

            [7] => stdClass Object
                (
                    [id] => 18
                    [sortOrder] => 170
                    [feature] => No of Bathrooms
                    [isAvailable] => 0
                    [value] => 5
                )

            [8] => stdClass Object
                (
                    [id] => 27
                    [sortOrder] => 250
                    [feature] => Showers No of
                    [isAvailable] => 0
                    [value] => 2
                )

            [23] => stdClass Object
                (
                    [id] => 146
                    [sortOrder] => 305
                    [feature] => Reception Dims
                    [isAvailable] => 0
                    [value] => 8.60 x 6.80 mt
                )

            [24] => stdClass Object
                (
                    [id] => 10005
                    [sortOrder] => 315
                    [feature] => Dining Room Dims
                    [isAvailable] => 0
                    [value] => 9.12 x 5.05 mt
                )

            [25] => stdClass Object
                (
                    [id] => 10006
                    [sortOrder] => 325
                    [feature] => Kitchen Dims
                    [isAvailable] => 0
                    [value] => 6.21 x 5.28 mt
                )

            [26] => stdClass Object
                (
                    [id] => 10004
                    [sortOrder] => 335
                    [feature] => Living Room Dims
                    [isAvailable] => 0
                    [value] => 6.65 x 5.50 mt
                )

            [27] => stdClass Object
                (
                    [id] => 50
                    [sortOrder] => 340
                    [feature] => Study Dimensions
                    [isAvailable] => 0
                    [value] => 1
                )

            [28] => stdClass Object
                (
                    [id] => 63
                    [sortOrder] => 355
                    [feature] => Store Room Dimensions
                    [isAvailable] => 0
                    [value] => 2.60 x 2.00 mt
                )

            [9] => stdClass Object
                (
                    [id] => 60
                    [sortOrder] => 360
                    [feature] => Hall
                    [isAvailable] => 0
                    [value] => 1
                )

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

            [11] => stdClass Object
                (
                    [id] => 148
                    [sortOrder] => 440
                    [feature] => Garages (No of)
                    [isAvailable] => 0
                    [value] => 1
                )

            [12] => stdClass Object
                (
                    [id] => 55
                    [sortOrder] => 443
                    [feature] => Garage No of Cars
                    [isAvailable] => 0
                    [value] => 10
                )

            [13] => stdClass Object
                (
                    [id] => 10501
                    [sortOrder] => 500
                    [feature] => Swimming Pool
                    [isAvailable] => 0
                    [value] => Yes
                )

            [14] => stdClass Object
                (
                    [id] => 76
                    [sortOrder] => 501
                    [feature] => Swimming Pool Type
                    [isAvailable] => 0
                    [value] => Private
                )

            [15] => stdClass Object
                (
                    [id] => 159
                    [sortOrder] => 600
                    [feature] => Balconies (Front)
                    [isAvailable] => 0
                    [value] => 3
                )

            [16] => stdClass Object
                (
                    [id] => 157
                    [sortOrder] => 630
                    [feature] => Terrace (Front)
                    [isAvailable] => 0
                    [value] => 5.00 x 10.10 mt
                )

            [17] => stdClass Object
                (
                    [id] => 10502
                    [sortOrder] => 710
                    [feature] => Has Views
                    [isAvailable] => 0
                    [value] => Excellent Sea views
                )

            [18] => stdClass Object
                (
                    [id] => 109
                    [sortOrder] => 712
                    [feature] => Type of View
                    [isAvailable] => 0
                    [value] => Sea views
                )

            [19] => stdClass Object
                (
                    [id] => 92
                    [sortOrder] => 720
                    [feature] => Finish
                    [isAvailable] => 0
                    [value] => Good
                )

            [20] => stdClass Object
                (
                    [id] => 89
                    [sortOrder] => 750
                    [feature] => Airconditioning
                    [isAvailable] => 0
                    [value] => Yes
                )

            [21] => stdClass Object
                (
                    [id] => 86
                    [sortOrder] => 800
                    [feature] => Shops
                    [isAvailable] => 0
                    [value] => Within walking distance
                )

            [22] => stdClass Object
                (
                    [id] => 10529
                    [sortOrder] => 820
                    [feature] => Plot Area
                    [isAvailable] => 0
                    [value] => 1500 sq mt
                )

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 2532194
                    [property_id] => 039531
                    [file_name] => 039531_1_1736506370.JPG
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => P_039531__MG_4650.JPG
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 2532195
                    [property_id] => 039531
                    [file_name] => 039531_2_1736506372.JPG
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => P_039531_IMG_4597.JPG
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 2532196
                    [property_id] => 039531
                    [file_name] => 039531_3_1736506373.JPG
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => P_039531_IMG_4564.JPG
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 2532197
                    [property_id] => 039531
                    [file_name] => 039531_4_1736506374.JPG
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => P_039531__MG_4603.JPG
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 2532198
                    [property_id] => 039531
                    [file_name] => 039531_5_1736506375.JPG
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => P_039531__MG_4573.JPG
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => TCR
            [fullNameField] => Teresa Camilleri Rausi
            [imageFilenameField] => TCR_1647643627.jpg
            [imageNameField] => TCR.jpg
            [branchIDField] => SJ
            [descriptionField] => 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.
            [designationField] => Property Sales Consultant
            [contactNumberField] => 00356 99293739
            [emailField] => [email protected]
            [isAvailable] => 1
            [created_at] => 2022-03-18 22:47:07
            [updated_at] => 2025-08-14 06:00:31
        )

    [latitude] => 35.962863
    [longitude] => 14.368079
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => stdClass Object
        (
            [date] => 2019-10-15 14:04:34
            [timezone_type] => 3
            [timezone] => UTC
        )

    [updated_at] => stdClass Object
        (
            [date] => 2023-11-24 16:10:06
            [timezone_type] => 3
            [timezone] => UTC
        )

)