Sale Semidetached Detached Town house Manor House Old town palace Country house Establiments Rustic: 1 of 369 properties

{
    "is_exclusive": 0,
    "is_price_from": 0,
    "name_hidden": "",
    "featured": 0,
    "original_agent": null,
    "agent_id": 1604,
    "owner_id": 11935,
    "id": 5281,
    "reference": "2818",
    "operation_id": 1,
    "state_id": null,
    "name": "Country house to renovate with in Establiments",
    "price": 2750000,
    "price_note": "",
    "description": "<p>This spectacular estate is for sale in the town of Establiments, just 5 minutes from the vibrant city of Palma, on the island of Mallorca. Located in a rustic area, surrounded by the serene Mediterranean nature, this property offers the perfect opportunity to enjoy the tranquility of the countryside together with the convenience of being close to an urban center.<\/p>\r\n\r\n<p>\r\n\t<br>\r\n<\/p>\r\n",
    "slug": "sale-villa-country-house-establiments-ref-2818",
    "ask_price": 0,
    "latitude": "39.625318",
    "longitude": "2.619172",
    "type_id": null,
    "district_id": 58,
    "is_logged_users": 0,
    "is_active": 1,
    "is_sold": 0,
    "is_sold_external": 0,
    "created_at": "2023-10-01 09:43:00",
    "is_discreet_marketing": 0,
    "is_missing_information": 0,
    "is_missing_images": 0,
    "is_missing_translations": 0,
    "is_hidden_other_reasons": 0,
    "matterport": null,
    "conservation_id": 4,
    "images": [
        {
            "id": 119523,
            "disk_name": "662fb0f271499217947887.jpg",
            "file_name": "Finca Establiments ref 2818 dron -_-3.jpg",
            "file_size": 662976,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 1,
            "created_at": "2024-04-29 14:38:42",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/662\/fb0\/f27\/662fb0f271499217947887.jpg",
            "extension": "jpg"
        },
        {
            "id": 119526,
            "disk_name": "662fb0f355e81435782592.jpg",
            "file_name": "Finca Establiments ref 2818 dron -_.jpg",
            "file_size": 991485,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 2,
            "created_at": "2024-04-29 14:38:43",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/662\/fb0\/f35\/662fb0f355e81435782592.jpg",
            "extension": "jpg"
        },
        {
            "id": 119524,
            "disk_name": "662fb0f27310d629233329.jpg",
            "file_name": "Finca Establiments ref 2818 dron -_-2.jpg",
            "file_size": 923552,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 3,
            "created_at": "2024-04-29 14:38:42",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/662\/fb0\/f27\/662fb0f27310d629233329.jpg",
            "extension": "jpg"
        },
        {
            "id": 119525,
            "disk_name": "662fb0f35136b287986045.jpg",
            "file_name": "Finca Establiments ref 2818 dron -_-4.jpg",
            "file_size": 1547938,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 4,
            "created_at": "2024-04-29 14:38:43",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/662\/fb0\/f35\/662fb0f35136b287986045.jpg",
            "extension": "jpg"
        },
        {
            "id": 112930,
            "disk_name": "64a2b0dac86ca073856049.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-10.jpg",
            "file_size": 1033539,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 5,
            "created_at": "2023-07-03 11:28:26",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/dac\/64a2b0dac86ca073856049.jpg",
            "extension": "jpg"
        },
        {
            "id": 112934,
            "disk_name": "64a2b0dd0dc28132341484.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-14.jpg",
            "file_size": 841110,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 6,
            "created_at": "2023-07-03 11:28:29",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/dd0\/64a2b0dd0dc28132341484.jpg",
            "extension": "jpg"
        },
        {
            "id": 112929,
            "disk_name": "64a2b0da107aa665040384.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-8.jpg",
            "file_size": 604863,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 7,
            "created_at": "2023-07-03 11:28:26",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/da1\/64a2b0da107aa665040384.jpg",
            "extension": "jpg"
        },
        {
            "id": 112923,
            "disk_name": "64a2b0d773511293202960.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-2.jpg",
            "file_size": 906749,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 8,
            "created_at": "2023-07-03 11:28:23",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d77\/64a2b0d773511293202960.jpg",
            "extension": "jpg"
        },
        {
            "id": 112933,
            "disk_name": "64a2b0dc22575690639711.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-13.jpg",
            "file_size": 770886,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 9,
            "created_at": "2023-07-03 11:28:28",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/dc2\/64a2b0dc22575690639711.jpg",
            "extension": "jpg"
        },
        {
            "id": 112922,
            "disk_name": "64a2b0d6ba017112226911.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-3.jpg",
            "file_size": 1048544,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 10,
            "created_at": "2023-07-03 11:28:22",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d6b\/64a2b0d6ba017112226911.jpg",
            "extension": "jpg"
        },
        {
            "id": 112928,
            "disk_name": "64a2b0da040f9397965614.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-9.jpg",
            "file_size": 893401,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 11,
            "created_at": "2023-07-03 11:28:26",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/da0\/64a2b0da040f9397965614.jpg",
            "extension": "jpg"
        },
        {
            "id": 112932,
            "disk_name": "64a2b0dc029ff991623613.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-12.jpg",
            "file_size": 757228,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 12,
            "created_at": "2023-07-03 11:28:28",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/dc0\/64a2b0dc029ff991623613.jpg",
            "extension": "jpg"
        },
        {
            "id": 112925,
            "disk_name": "64a2b0d8659dd854976937.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-4.jpg",
            "file_size": 1074273,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 13,
            "created_at": "2023-07-03 11:28:24",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d86\/64a2b0d8659dd854976937.jpg",
            "extension": "jpg"
        },
        {
            "id": 112924,
            "disk_name": "64a2b0d865182185179578.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-5.jpg",
            "file_size": 1285287,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 14,
            "created_at": "2023-07-03 11:28:24",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d86\/64a2b0d865182185179578.jpg",
            "extension": "jpg"
        },
        {
            "id": 112927,
            "disk_name": "64a2b0d923710662374853.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-6.jpg",
            "file_size": 481247,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 15,
            "created_at": "2023-07-03 11:28:25",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d92\/64a2b0d923710662374853.jpg",
            "extension": "jpg"
        },
        {
            "id": 112926,
            "disk_name": "64a2b0d9162bc074433835.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-7.jpg",
            "file_size": 667007,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 16,
            "created_at": "2023-07-03 11:28:25",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/d91\/64a2b0d9162bc074433835.jpg",
            "extension": "jpg"
        },
        {
            "id": 112931,
            "disk_name": "64a2b0db1b2f9788757918.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-11.jpg",
            "file_size": 855908,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 17,
            "created_at": "2023-07-03 11:28:27",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/db1\/64a2b0db1b2f9788757918.jpg",
            "extension": "jpg"
        },
        {
            "id": 112935,
            "disk_name": "64a2b0dd28ae8249039867.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-15.jpg",
            "file_size": 1051216,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 18,
            "created_at": "2023-07-03 11:28:29",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/dd2\/64a2b0dd28ae8249039867.jpg",
            "extension": "jpg"
        },
        {
            "id": 112937,
            "disk_name": "64a2b0dddaceb731069038.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_-16.jpg",
            "file_size": 972694,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 19,
            "created_at": "2023-07-03 11:28:29",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/ddd\/64a2b0dddaceb731069038.jpg",
            "extension": "jpg"
        },
        {
            "id": 112936,
            "disk_name": "64a2b0ddd3153141767235.jpg",
            "file_name": "Finca in Establiments near Palma ref 2818 -_.jpg",
            "file_size": 526287,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 20,
            "created_at": "2023-07-03 11:28:29",
            "updated_at": "2024-04-29 14:38:58",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/64a\/2b0\/ddd\/64a2b0ddd3153141767235.jpg",
            "extension": "jpg"
        }
    ],
    "type": [
        {
            "id": 10,
            "name": "Villa",
            "alt_id": 301,
            "times_searched": 0,
            "type_id": 8,
            "icon": "",
            "sort_order": null,
            "pivot": {
                "estate_id": 5281,
                "type_id": 10
            }
        },
        {
            "id": 11,
            "name": "Country house",
            "alt_id": 302,
            "times_searched": 0,
            "type_id": 8,
            "icon": "icontype-classic-house",
            "sort_order": 2,
            "pivot": {
                "estate_id": 5281,
                "type_id": 11
            }
        }
    ],
    "ownerx": {
        "id": 11935,
        "name": "Juan Carlos",
        "email": "jc@martorellhumbert.com",
        "permissions": null,
        "is_activated": true,
        "activated_at": "2023-07-03 09:27:24",
        "last_login": null,
        "created_at": "2023-07-03 09:27:01",
        "updated_at": "2023-07-24 09:01:23",
        "username": "jc@martorellhumbert.com",
        "surname": "Martorell",
        "deleted_at": null,
        "last_seen": null,
        "is_guest": 0,
        "is_superuser": 0,
        "phone": "673 70 15 10",
        "phone_extra": [],
        "email_extra": [],
        "newsletter": null,
        "adress": "",
        "city": null,
        "country": null,
        "origin_id": null,
        "type_id": null,
        "user_id": null,
        "state_id": null,
        "commission": null,
        "web_occupation": null,
        "web_description": null,
        "web_linkedin": null,
        "web_is-active": 0,
        "alt_id": 0,
        "web_content_html": null,
        "web_video": null,
        "web_slug": null,
        "referer": "Amigo Jaime Vidal",
        "category": "buy",
        "locale_id": 2,
        "signature": null,
        "assigned_id": 4787
    },
    "districtx": {
        "id": 58,
        "name": "Palma - Establiments",
        "locality_id": 8,
        "alt_id": 141,
        "times_searched": 0,
        "latitude": "39.625318",
        "longitude": "2.619172",
        "related_page": "mallorca-pueblos-de-mallorca-palma-establiments.htm",
        "no_results_message": ""
    },
    "district": {
        "id": 58,
        "name": "Palma - Establiments",
        "locality_id": 8,
        "alt_id": 141,
        "times_searched": 0,
        "latitude": "39.625318",
        "longitude": "2.619172",
        "related_page": "mallorca-pueblos-de-mallorca-palma-establiments.htm",
        "no_results_message": ""
    }
}