Madliena Unconverted Farmhouse with permits

stdClass Object
(
    [ref] => 923386
    [webRef] => 923386
    [marketStatus] => OnMarket
    [expiryDateTime] => 2037-04-23 00:00:00
    [marketType] => ForSale
    [commercial] => 0
    [development] => 
    [developmentID] => 
    [locality] => 45
    [locality_details] => stdClass Object
        (
            [id] => 45
            [localityName] => Madliena
            [zoneId] => 2
            [parentLocalityId] => 
        )

    [propertyType] => 28
    [propertyType_details] => stdClass Object
        (
            [id] => 28
            [description] => Farmhouse
            [sortSequence] => 
            [propertyTypeGroupId] => 22
        )

    [propertyStatus] => 7
    [propertyStatus_details] => stdClass Object
        (
            [id] => 7
            [description] => Unconverted
            [sortSequence] => 
        )

    [price] => 3850000.00
    [oldPrice] => 3850000.00
    [premium] => 
    [rentPeriod] => 
    [dateAvailable] => 
    [priceOnRequest] => 0
    [description] => Madliena Unconverted Farmhouse with permits
    [title] => Madliena Unconverted Farmhouse with permits
    [longDescription] => 
Madliena - Set in a tranquil part of this sought after area is this 4000sqm property consisting of an unconverted farmhouse with surrounding land, having direct access from the street. Property has permit approved for a 3 bedroom bungalow with underlying basement, a large pool and surrounding land. Property is a one of a kind!
 
    [specifications] => 
    [itemsIncludedInPrice] => permits approved, property has an old quarry inside that can be changed into a multi storey garage or other purposes.
    [soleAgents] => 
    [propertyBlock] => 
    [bedrooms] => 3
    [bathrooms] => 6
    [total_bathrooms] => 
    [contactDetails] => 
    [isPropertyOfTheMonth] => 0
    [isHotProperty] => 
    [dateOnMarket] => 2025-10-15 00:00:00
    [dateOffMarket] => 
    [datePriceReduced] => 2026-08-12 14:42:05
    [virtualTourUrl] => 
    [showOn3rdPartySites] => 
    [pricesStartingFrom] => 0
    [hotPropertyTitle] => 
    [area] => 0.00
    [areaSqm] => 0.00
    [internalAreaSqm] => 250.00
    [externalAreaSqm] => 4207.00
    [plotAreaSqm] => 4408.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] => 3
                )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            [16] => stdClass Object
                (
                    [id] => 54
                    [sortOrder] => 305
                    [feature] => Reception Dims
                    [isAvailable] => 
                    [value] => 0m by 0m
                )

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

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

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

            [20] => stdClass Object
                (
                    [id] => 20
                    [sortOrder] => 325
                    [feature] => Kitchen Dims
                    [isAvailable] => 
                    [value] => 3.5m by 4.5m
                )

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

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

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

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

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

            [26] => stdClass Object
                (
                    [id] => 58
                    [sortOrder] => 505
                    [feature] => Swimming Pool (dims)
                    [isAvailable] => 
                    [value] => 3.5m by 12m
                )

            [27] => stdClass Object
                (
                    [id] => 64
                    [sortOrder] => 510
                    [feature] => Garden (dims)
                    [isAvailable] => 
                    [value] => 100m by 40m
                )

            [28] => stdClass Object
                (
                    [id] => 56
                    [sortOrder] => 530
                    [feature] => Surrounding Garden
                    [isAvailable] => 
                    [value] => Yes
                )

            [29] => stdClass Object
                (
                    [id] => 103
                    [sortOrder] => 540
                    [feature] => Side Garden
                    [isAvailable] => 
                    [value] => Yes
                )

            [30] => stdClass Object
                (
                    [id] => 113
                    [sortOrder] => 545
                    [feature] => Side Garden (dims)
                    [isAvailable] => 
                    [value] => 50m by 10m
                )

            [31] => stdClass Object
                (
                    [id] => 66
                    [sortOrder] => 590
                    [feature] => Courtyard (Dims)
                    [isAvailable] => 
                    [value] => 0m by 0m
                )

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

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

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

            [35] => stdClass Object
                (
                    [id] => 65
                    [sortOrder] => 730
                    [feature] => Conversion
                    [isAvailable] => 
                    [value] => Fair
                )

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

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

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

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

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

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

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

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

        )

    [files] => Array
        (
            [0] => stdClass Object
                (
                    [file_id] => 1228663
                    [property_id] => 923386
                    [file_name] => 1_923386.jpg
                    [file_type] => MainImage
                    [sequence_no] => 1
                    [mime] => image/jpeg
                    [original_file_name] => bdedefb5-6242-4eec-bb08-bfd21d168795.jpg
                    [seo_url] => 
                )

            [1] => stdClass Object
                (
                    [file_id] => 1228664
                    [property_id] => 923386
                    [file_name] => 2_923386.jpg
                    [file_type] => OtherImages
                    [sequence_no] => 2
                    [mime] => image/jpeg
                    [original_file_name] => bdedefb5-6242-4eec-bb08-bfd21d168795.jpg
                    [seo_url] => 
                )

            [2] => stdClass Object
                (
                    [file_id] => 1228665
                    [property_id] => 923386
                    [file_name] => 3_923386.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 3
                    [mime] => image/jpeg
                    [original_file_name] => 7479bc27-02e2-4a70-b633-51d25f545b4f.jpeg
                    [seo_url] => 
                )

            [3] => stdClass Object
                (
                    [file_id] => 1228666
                    [property_id] => 923386
                    [file_name] => 4_923386.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 4
                    [mime] => image/jpeg
                    [original_file_name] => 9f608f9a-df59-4acc-a5b1-ac58446bc48a.jpeg
                    [seo_url] => 
                )

            [4] => stdClass Object
                (
                    [file_id] => 1228667
                    [property_id] => 923386
                    [file_name] => 5_923386.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 5
                    [mime] => image/jpeg
                    [original_file_name] => e13643de-af50-4286-a7d3-0e13de9a55aa.jpeg
                    [seo_url] => 
                )

            [5] => stdClass Object
                (
                    [file_id] => 1228668
                    [property_id] => 923386
                    [file_name] => 6_923386.jpeg
                    [file_type] => OtherImages
                    [sequence_no] => 6
                    [mime] => image/jpeg
                    [original_file_name] => 65f8af20-9294-46f2-b169-98765aee97ab.jpeg
                    [seo_url] => 
                )

        )

    [consultant] => stdClass Object
        (
            [id] => CHTV
            [full_name] => Charlene Tabone Valetta
            [agent_code] => CTV
            [img_file_name] => charlene-tabone-valetta.jpg
            [img_name] => 062b2827-304d-4f4c-8b45-a3a945195d46.jpg
            [branch_id] => 8
            [branch_name] => Sliema Sales Office
            [branch_email] => [email protected]
            [description] => 
Charlene is a seasoned real estate professional known for her warm, hands-on approach. She supports clients through every step of the buying or selling process, connecting them with trusted legal and financial experts to ensure a smooth experience. Passionate about her work, Charlene brings energy, care, and integrity to every deal. Outside work, she enjoys open-water swimming, hiking with her daughter, walking her dog, and exploring her love for cooking and interior design.
            [designation] => 
            [contact_number] => 0035699040012
            [email] => [email protected]
            [isAvailable] => 1
        )

    [latitude] => 
    [longitude] => 
    [showInSearches] => 1
    [threeDWalkThrough] => 
    [isManagedProperty] => 0
    [linkedPropertyRef] => 
    [created_at] => 2026-03-19T09:05:56.000000Z
    [updated_at] => 2026-04-23T16:05:47.000000Z
)