Newly built semidetached house in Puig de Ros, LLucmajor

{
    "id": 3839,
    "reference": "16013-B",
    "name": "Luxury apartment with spectacular views of the sea in Colonia Sant Jordi",
    "description": "<p>Modern architecture in perfect harmony with the natural environment of Colonia de Sant Jordi. An exclusive design project just 2 minutes from the beach of Es Trenc and the Mallorcan Salinas, 40 minutes from the airport and 50 minutes from the center of Palma.<\/p>\r\n",
    "description_long": "<p>New development, duplex apartment built with a modern design, large terraces and gardens in a fantastic location in Colonia de Sant Jordi. Undoubtedly one of the most popular destinations among mallorcan people to enjoy their holidays due to its family atmosphere, restaurants, bars, with a beautiful boulevard by the sea and next to some of the most beautiful beaches of the island such as Es Trenc or Es Carb\u00f3. The development has views to the sea and is a few meters from the beach.<\/p>\r\n\r\n<p>The House has 198 m2 built and 102 m2 of terraces and has the following distribution: on the ground floor, with a large living room, kitchen, 1 bedroom and 1 bathroom and 2 bedrooms with en suite bathrooms on the first floor.<\/p>\r\n\r\n<p>The communal areas offer a garden area with terrace and pool of 45 m2, a clubhouse with changing rooms and a large parking area.<\/p>\r\n\r\n<p>No doubt an ideal place to spend your holidays in a small development with luxury homes.<\/p>\r\n\r\n<p>MallorcaSite, your real estate agency in Mallorca, recommends this property, for its location, for the spaciousness of the homes, for the views, for its design and for being built with high-end materials.<\/p>\r\n",
    "province_id": 1,
    "locality_id": 9,
    "district_id": 47,
    "type_id": null,
    "operation_id": 1,
    "price": 995000,
    "latitude": "39.317960",
    "longitude": "2.992961",
    "energy_letter": null,
    "energy_value": null,
    "emissions_letter": null,
    "emissions_value": null,
    "featured": 0,
    "featured_home": 0,
    "alt_id": null,
    "times_visited": 20226,
    "created_at": "2019-07-04 10:16:13",
    "updated_at": "2026-05-16 08:55:20",
    "state_id": 2,
    "ask_price": 0,
    "slug": "sale-duplex-others-semidetached-villa-apartment-colonia-sant-jordi-ref-16013-b",
    "conservation_id": 2,
    "orientation_id": 2,
    "area_id": 4,
    "extras_description": "",
    "is_active": 1,
    "is_logged_users": 0,
    "is_project": 0,
    "is_license": 0,
    "is_exclusive": 0,
    "is_price_from": 0,
    "exclusive_date_limit": null,
    "price_note": "up to 1.200.000\u20ac",
    "meta_title": "",
    "meta_description": "",
    "meta_keywords": "",
    "meta_robots": "NOINDEX,FOLLOW",
    "name_secondary": "",
    "owner_id": 5764,
    "agent_id": 2407,
    "original_agent": null,
    "is_sold": 0,
    "is_hidden_other_reasons": 0,
    "is_pending_visit": 0,
    "is_discreet_marketing": 0,
    "is_have_banner": 0,
    "is_have_key": 0,
    "is_missing_images": 0,
    "is_missing_translations": 0,
    "is_missing_information": 0,
    "is_missing_sale_order": 0,
    "is_sold_external": 0,
    "annotations": "<p>Ioana 4\/7\/19 - They start building in Sept 2019, as per the policy of the company, they can only build when they have already sold half of the property, in order to finance the project. Now 2 of the apartments have been sold so they resume the construction.&nbsp;<\/p>\r\n\r\n<p>Delivery date will be March 2020, although in the contracts they write September 2020.&nbsp;<\/p>\r\n\r\n<p>***<\/p>\r\n\r\n<p>Casa B reservado! 28\/05\/18 GR<\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/Memoria de Calidades CASA D.pdf\">Memoria de Calidades CASA D.pdf<\/a><\/p>\r\n\r\n<p>NO SE PUEDE PUBLICAR EN PORTALES!!!&nbsp;<\/p>\r\n\r\n<p>Info 25\/04\/18<\/p>\r\n\r\n<p>Despu\u00e9s de revisar y haber visitado de nuevo el mercado de Colonia de Sant Jordi, hemos decidido modificar un poco las memorias de calidades de la promoci\u00f3n, ajustando los precios de las plantas bajas. Hace dos semanas estuvimos en la obra , confirmaros que &nbsp;hay vista mar desde cada una de ellas, incluso en las plantas bajas. Ahora est\u00e1 terminada la estructura y por moratoria vacacional no podemos continuar hasta octubre, que en dicho mes retomaremos las obras, teniendo la obra terminada en verano de 2019. Adjuntamos los precios nuevos bajando los precios de las plantas bajas quitado las piscinas de las plantas bajas &nbsp;y ajustado algunos puntos en la memoria de calidades, ( la piscina comunitaria y del \u00e1tico se mantiene y si los clientes de los bajos quieren piscinas la previsi\u00f3n est\u00e1 hecha , con lo que por un importe extra se puede tener ).<\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/5401dossier-5eh-csj-espanol11142017compressed.pdf\">5401_DOSSIER 5eh CSJ ESPA\u00d1OL_11142017.compressed.pdf<\/a><\/p>\r\n\r\n<p>PRECIOS NUEVOS:<\/p>\r\n\r\n<p>CASA A: 650M euros \/ CASA B: 695M euros \/ CASA C: 985M euros \/ CASA D: 1.200M euros<\/p>\r\n\r\n<p>Por el AGENTE COMERCIALIZADOR (RBI, S.L.U.); La Sra. Marta Frutos Mulero, con domicilio a efectos de notificaciones en la calle Atenas n\u00ba 30 (07817 SANT JORDI DE SES SALINES - IBIZA) y con correo electr\u00f3nico martaf@odrealestate.es. Tel\u00e9fono de contacto 692 93 53 25.<\/p>\r\n\r\n<p>El AGENTE COMERCIALIZADOR registrar\u00e1 en su base de datos todos los clientes introducidos por el AGENTE COLABORADOR una vez \u00e9ste \u00faltimo le haya facilitado la informaci\u00f3n b\u00e1sica de los clientes. Esta informaci\u00f3n b\u00e1sica comprende lo siguiente; nombre, apellidos, nacionalidad, ciudad, c\u00f3digo postal y correo electr\u00f3nico. A partir de los 6 meses de haberse registrado el cliente, cualquier otra agencia podr\u00e1 registrar ese mismo cliente a su nombre.&nbsp;<\/p>\r\n\r\n<p>El AGENTE COLABORADOR se obliga a enviar cada vez que realice una reserva o formalice un contrato de compraventa, la siguiente documentaci\u00f3n e informaci\u00f3n relativa a sus clientes;&nbsp;<\/p>\r\n\r\n<p>- D.N.I., pasaporte o N.I.E.<span>&nbsp;<\/span><\/p>\r\n\r\n<p>- Estado civil.&nbsp;<\/p>\r\n\r\n<p>- Profesi\u00f3n.<span>&nbsp;<\/span><\/p>\r\n\r\n<p>- N\u00famero de cuenta de donde proviene el dinero ingresado en concepto de reserva y\/o arras.&nbsp;<\/p>\r\n\r\n<p>- Y cualquier otra documentaci\u00f3n que solicite el AGENTE COMERCIALIZADOR.<span>&nbsp;<\/span><\/p>\r\n\r\n<p>- Formulario de Informaci\u00f3n Obligatoria del Comprador (F.I.C.).&nbsp;<\/p>\r\n\r\n<p>\r\n\t<br>\r\n<\/p>\r\n\r\n<p>Si el AGENTE COLABORADOR introduce el cliente, gestiona y cierra la venta, los honorarios a percibir ser\u00e1n del <strong>6%&nbsp;<\/strong>del precio de compraventa.&nbsp;<\/p>\r\n\r\n<p>- Si el AGENTE COMERCIALIZADOR introduce el cliente, pero la posterior gesti\u00f3n y cierre de la venta es realizada por el AGENTE COLABORADOR, la comisi\u00f3n a percibir es del <strong>3 %&nbsp;<\/strong>del precio de compraventa.<span>&nbsp;<\/span><\/p>\r\n\r\n<p><strong>HITO % DE HONORARIOS&nbsp;<\/strong><\/p>\r\n\r\n<p>A la firma contrato privado 40%<span>&nbsp;<\/span><\/p>\r\n\r\n<p>A la firma de la escritura p\u00fablica 60%&nbsp;<\/p>",
    "is_good_investment": 0,
    "is_urgent_sale": 0,
    "alquilada_hasta": null,
    "is_alquilada": 0,
    "address": "",
    "name_hidden": "FIVE ELEMENTS HOMES (5EH)  OD REAL ESTATE - House B - first floor",
    "is_published_external_portals": 0,
    "matterport": null,
    "matterport_public": 0,
    "matterport_token": null,
    "images": [
        {
            "id": 79781,
            "disk_name": "5d1dd1ed4217b821646937.jpg",
            "file_name": "5d1dc4a0cd5ee461545744.jpg",
            "file_size": 546682,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79781,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed4\/5d1dd1ed4217b821646937.jpg",
            "extension": "jpg"
        },
        {
            "id": 79782,
            "disk_name": "5d1dd1ed54052128917309.jpg",
            "file_name": "5d1dc4a0d48e1853896099.jpg",
            "file_size": 842241,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79782,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed54052128917309.jpg",
            "extension": "jpg"
        },
        {
            "id": 79783,
            "disk_name": "5d1dd1ed556cb079738766.jpg",
            "file_name": "5d1dc4a0d5f2d114791990.jpg",
            "file_size": 522271,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79783,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed556cb079738766.jpg",
            "extension": "jpg"
        },
        {
            "id": 79784,
            "disk_name": "5d1dd1ed5724a626033528.jpg",
            "file_name": "5d1dc4a0d7a3e849265252.jpg",
            "file_size": 818674,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79784,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed5724a626033528.jpg",
            "extension": "jpg"
        },
        {
            "id": 79785,
            "disk_name": "5d1dd1ed58758147806703.jpg",
            "file_name": "5d1dc4a0d8ef4770336391.jpg",
            "file_size": 451600,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79785,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed58758147806703.jpg",
            "extension": "jpg"
        },
        {
            "id": 79786,
            "disk_name": "5d1dd1ed59a7c425708134.jpg",
            "file_name": "5d1dc4a0da217705400870.jpg",
            "file_size": 494181,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79786,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed59a7c425708134.jpg",
            "extension": "jpg"
        },
        {
            "id": 79787,
            "disk_name": "5d1dd1ed5b221184397838.jpg",
            "file_name": "5d1dc4a0db8b4944931753.jpg",
            "file_size": 780161,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79787,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed5b221184397838.jpg",
            "extension": "jpg"
        },
        {
            "id": 79788,
            "disk_name": "5d1dd1ed5c714939630277.jpg",
            "file_name": "5d1dc4a0dcc4b807339367.jpg",
            "file_size": 430780,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79788,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed5c714939630277.jpg",
            "extension": "jpg"
        },
        {
            "id": 79789,
            "disk_name": "5d1dd1ed5d9c4987237060.jpg",
            "file_name": "5d1dc4a0de129730212757.jpg",
            "file_size": 528060,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79789,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed5d9c4987237060.jpg",
            "extension": "jpg"
        },
        {
            "id": 79790,
            "disk_name": "5d1dd1ed5ee01898969619.jpg",
            "file_name": "5d1dc4a0df4b9987190591.jpg",
            "file_size": 529874,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79790,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed5\/5d1dd1ed5ee01898969619.jpg",
            "extension": "jpg"
        },
        {
            "id": 79791,
            "disk_name": "5d1dd1ed6029b144035253.jpg",
            "file_name": "5d1dc4a0e0aa3551816392.jpg",
            "file_size": 1151435,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79791,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6029b144035253.jpg",
            "extension": "jpg"
        },
        {
            "id": 79792,
            "disk_name": "5d1dd1ed6176e968954506.jpg",
            "file_name": "5d1dc4a0e204c657577749.jpg",
            "file_size": 316910,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79792,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6176e968954506.jpg",
            "extension": "jpg"
        },
        {
            "id": 79793,
            "disk_name": "5d1dd1ed62ec0376245015.jpg",
            "file_name": "5d1dc4a0e3131772692886.jpg",
            "file_size": 175534,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79793,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed62ec0376245015.jpg",
            "extension": "jpg"
        },
        {
            "id": 79794,
            "disk_name": "5d1dd1ed6450e393859618.jpg",
            "file_name": "5d1dc4a0e454c820087531.jpg",
            "file_size": 781496,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79794,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6450e393859618.jpg",
            "extension": "jpg"
        },
        {
            "id": 79795,
            "disk_name": "5d1dd1ed65bca481306552.jpg",
            "file_name": "5d1dc4a0e5ab9174016155.jpg",
            "file_size": 647177,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79795,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed65bca481306552.jpg",
            "extension": "jpg"
        },
        {
            "id": 79796,
            "disk_name": "5d1dd1ed66f30439123140.jpg",
            "file_name": "5d1dc4a0e6fd7864448122.jpg",
            "file_size": 600156,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79796,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed66f30439123140.jpg",
            "extension": "jpg"
        },
        {
            "id": 79797,
            "disk_name": "5d1dd1ed68262222984089.jpg",
            "file_name": "5d1dc4a0e8462372674941.jpg",
            "file_size": 480900,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79797,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed68262222984089.jpg",
            "extension": "jpg"
        },
        {
            "id": 79798,
            "disk_name": "5d1dd1ed69619591633258.jpg",
            "file_name": "5d1dc4a0e9824393925311.jpg",
            "file_size": 559791,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79798,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed69619591633258.jpg",
            "extension": "jpg"
        },
        {
            "id": 79799,
            "disk_name": "5d1dd1ed6ae88427050676.jpg",
            "file_name": "5d1dc4a0eaf8e214958662.jpg",
            "file_size": 1880347,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79799,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6ae88427050676.jpg",
            "extension": "jpg"
        },
        {
            "id": 79800,
            "disk_name": "5d1dd1ed6cdec711207187.jpg",
            "file_name": "5d1dc4a0ece9d396552841.jpg",
            "file_size": 1862602,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79800,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6cdec711207187.jpg",
            "extension": "jpg"
        },
        {
            "id": 79801,
            "disk_name": "5d1dd1ed6ecdb187377997.jpg",
            "file_name": "5d1dc4a0eee12190792862.jpg",
            "file_size": 1559673,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79801,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed6\/5d1dd1ed6ecdb187377997.jpg",
            "extension": "jpg"
        },
        {
            "id": 79802,
            "disk_name": "5d1dd1ed70a66122793255.jpg",
            "file_name": "5d1dc4a0f0bfe826003613.jpg",
            "file_size": 1804144,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79802,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed7\/5d1dd1ed70a66122793255.jpg",
            "extension": "jpg"
        },
        {
            "id": 79803,
            "disk_name": "5d1dd1ed729f2934805223.jpg",
            "file_name": "5d1dc4a0f2ba8252515668.jpg",
            "file_size": 2484089,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79803,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed7\/5d1dd1ed729f2934805223.jpg",
            "extension": "jpg"
        },
        {
            "id": 79804,
            "disk_name": "5d1dd1ed74be8615554136.jpg",
            "file_name": "5d1dc4a100c69945166353.jpg",
            "file_size": 2243346,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 79804,
            "created_at": "2019-07-04 10:16:13",
            "updated_at": "2019-07-04 10:16:13",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/5d1\/dd1\/ed7\/5d1dd1ed74be8615554136.jpg",
            "extension": "jpg"
        }
    ],
    "district": {
        "id": 47,
        "name": "Colonia Sant Jordi",
        "locality_id": 9,
        "alt_id": 1847,
        "times_searched": 0,
        "latitude": "39.317960",
        "longitude": "2.992961",
        "related_page": "mallorca-pueblos-de-mallorca-ses-salines-colonia-sant-jordi.htm",
        "no_results_message": ""
    }
}

{
    "id": 5821,
    "reference": "68112-a",
    "name": "Newly built semidetached house in Puig de Ros, LLucmajor",
    "description": "<p data-end=\"457\" data-start=\"116\">In the peaceful residential area of Puig de Ros, on the southern coast of Mallorca, a new development arises for those who wish to live surrounded by nature without giving up the proximity to Palma. The homes, with contemporary architecture, are distributed over two floors and stand out for their spacious, bright, and functional layouts.<\/p>\r\n\r\n<p data-end=\"787\" data-start=\"459\">\r\n\t<br>\r\n<\/p>\r\n",
    "description_long": "<p data-end=\"457\" data-start=\"116\">In the peaceful residential area of Puig de Ros, on the southern coast of Mallorca, a new development arises for those who wish to live surrounded by nature without giving up the proximity to Palma. The homes, with contemporary architecture, are distributed over two floors and stand out for their spacious, bright, and functional layouts.<\/p>\r\n\r\n<p data-end=\"787\" data-start=\"459\">Each house has a private garden and swimming pool, creating the perfect setting to enjoy the Mediterranean climate all year round. The interiors, designed with modern lines and high-quality materials, offer comfort and warmth, with open-plan kitchens, bright living areas, and large windows connecting to the outdoor terraces.<\/p>\r\n\r\n<p data-end=\"1060\" data-start=\"789\">The location adds a special value: close to spectacular cliffs, crystal-clear coves, and a first-class golf course. All this in a quiet residential atmosphere, with services, international schools, and excellent connections to the city, just twenty minutes away by car.<\/p>\r\n\r\n<p data-end=\"1193\" data-start=\"1062\">An ideal place both for families and for those seeking a modern retreat by the sea, in one of the island\u2019s most attractive areas.<\/p>\r\n\r\n<p data-end=\"1349\" data-start=\"1195\">MallorcaSite, your real estate agency in Mallorca, recommends this property for its high quality, excellent location, and being a new-build development.<\/p>\r\n",
    "province_id": 1,
    "locality_id": 9,
    "district_id": 118,
    "type_id": null,
    "operation_id": 1,
    "price": 1000000,
    "latitude": "39.450033",
    "longitude": "2.751483",
    "energy_letter": "B",
    "energy_value": "31",
    "emissions_letter": "B",
    "emissions_value": "9",
    "featured": 1,
    "featured_home": 0,
    "alt_id": null,
    "times_visited": 9694,
    "created_at": "2026-03-11 11:28:00",
    "updated_at": "2026-05-16 07:26:23",
    "state_id": null,
    "ask_price": 0,
    "slug": "sale-semidetached-villa-villa-puig-de-ros-ref-68112-a",
    "conservation_id": 2,
    "orientation_id": null,
    "area_id": 2,
    "extras_description": "",
    "is_active": 1,
    "is_logged_users": 0,
    "is_project": 0,
    "is_license": 0,
    "is_exclusive": 0,
    "is_price_from": 1,
    "exclusive_date_limit": null,
    "price_note": "",
    "meta_title": "",
    "meta_description": "",
    "meta_keywords": "",
    "meta_robots": "INDEX,FOLLOW",
    "name_secondary": "",
    "owner_id": 4885,
    "agent_id": 2407,
    "original_agent": null,
    "is_sold": 0,
    "is_hidden_other_reasons": 0,
    "is_pending_visit": 0,
    "is_discreet_marketing": 0,
    "is_have_banner": 0,
    "is_have_key": 0,
    "is_missing_images": 0,
    "is_missing_translations": 0,
    "is_missing_information": 0,
    "is_missing_sale_order": 1,
    "is_sold_external": 0,
    "annotations": "<p>23.4.26 <strong><u>Eneida Views:<\/u><\/strong><\/p>\r\n\r\n<p><strong>Casa CH-3A - 1.020.000 euros<\/strong><\/p>\r\n\r\n<p><strong>Casa CH-6B \u2013 1.040.000 euros\u2013 Casa Piloto completamente amueblada.<\/strong><\/p>\r\n\r\n<p><strong>Casa CH-7A \u2013 1.000.000 euros<\/strong><\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/V15 certificado-202312071512_signed.pdf\">V15 certificado-202312071512_signed.pdf<\/a><\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/V6 certificado-202312071256_signed.pdf\">V6 certificado-202312071256_signed.pdf<\/a><\/p>\r\n\r\n<p>25.11.25&nbsp;<\/p>\r\n\r\n<p><strong><span>Casa CH-1A - 1.105.000 euros&nbsp;<\/span><\/strong><\/p>\r\n\r\n<p><strong><span>Casa Piloto, muebles inclu\u00eddos en el precio.<\/span><\/strong><\/p>\r\n\r\n<p><strong><span>Casa CH-3A - &nbsp;1.020.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span>Casa CH-3B - 1.076.000euros - muebles incluidos en el precio<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-6B - 980.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7A - 999.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7B - 980.000 euros<\/span><\/strong><\/p>\r\n\r\n<p>7.10.25 <strong><u><span>Eneida Views:<\/span><\/u><\/strong><strong><span>&nbsp;<\/span><\/strong><\/p>\r\n\r\n<p><strong><span>Casa CH-1A - 1.105.000 euros \u2013 Casa Piloto con muebles inclu\u00eddos en el precio.<\/span><\/strong><\/p>\r\n\r\n<p><strong><span>Casa CH-3B - 1.131.000 euros - muebles incluidos en el precio<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-6B - 980.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7A - 999.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7B - 980.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-8A - 1.045.000 euros<\/span><\/strong><\/p>\r\n\r\n<p>30.5.25 <strong><u><span lang=\"EN-GB\">Eneida Views:<\/span><\/u><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-3B - 1.031.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-6B - 1.040.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7A - 1.065.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-7B - 1.045.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-8A - 1.065.000 euros<\/span><\/strong><\/p>\r\n\r\n<p><strong><span lang=\"PT\">Casa CH-8B - 1.045.000 euros<\/span><\/strong><\/p>\r\n\r\n<p>11.4.25&nbsp;<\/p>\r\n\r\n<p><span>Casa CH-3B - 1.040.000 euros<\/span><\/p>\r\n\r\n<p><span>Casa CH-6B - &nbsp; &nbsp;995.000 euros<\/span><\/p>\r\n\r\n<p><span>Casa CH-7A - 1.020.000 euros<\/span><\/p>\r\n\r\n<p><span>Casa CH-7B - 1.000.000 euros<\/span><\/p>\r\n\r\n<p><span lang=\"PT\">Casa CH-8A - 1.020.000 euros<\/span><\/p>\r\n\r\n<p><span lang=\"PT\">Casa CH-8B - 1.000.000 euros<\/span><\/p>\r\n\r\n<p>video hecho por Aedas 12.6.24 &nbsp;\r\n\t<a href=\"https:\/\/youtu.be\/BT-r3oq4XeM\"><\/a><a href=\"https:\/\/youtu.be\/BT-r3oq4XeM\">https:\/\/youtu.be\/BT-r3oq4XeM<\/a>&nbsp;<\/p>\r\n\r\n<p>30\/11\/23&nbsp;<\/p>\r\n\r\n<p><strong><u>Los precios de las viviendas disponibles (m\u00e1s 10%IVA):<\/u><\/strong><\/p>\r\n\r\n<p><strong>Casa CH-2A -1.175.000 euros<\/strong><\/p>\r\n\r\n<p><strong>Casa CH-3B - 1.150.000 euros<\/strong><\/p>\r\n\r\n<p><strong>Casa &nbsp;CH-6B - 1.050.000 euros<\/strong><\/p>\r\n\r\n<p><strong>Casa CH-7A - 1.110.000 euros&nbsp;<\/strong><\/p>\r\n\r\n<p>Fecha estimada para entregar los llaves tenemos planeada para <strong>tercer trimestre<\/strong>\r\n\t<strong><em>&nbsp;2024.<\/em><\/strong><\/p>\r\n\r\n<p>9\/6\/22 En este momento no tenemos las casas disponibles para venta, las casas est\u00e1n bloqueadas debido de verificaci\u00f3n de la tarifa del precio. El proyecto Eneida Views 5 casas. kh<\/p>\r\n\r\n<p><a href=\"https:\/\/www.aedashomes.com\/casas-en-venta-obra-nueva-eneida-views-llucmajor\">https:\/\/www.aedashomes.com\/casas-en-venta-obra-nueva-eneida-views-llucmajor<\/a><\/p>",
    "is_good_investment": 0,
    "is_urgent_sale": 0,
    "alquilada_hasta": null,
    "is_alquilada": 0,
    "address": "Calle Busqueret, 07609",
    "name_hidden": "Eneida Views \/ 16 viviendas \/ queda 3A & 7A \/ portales internacionales si",
    "is_published_external_portals": 0,
    "matterport": null,
    "matterport_public": 0,
    "matterport_token": null,
    "images": [
        {
            "id": 128087,
            "disk_name": "68d13f9c22c28693440771.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-3.jpg",
            "file_size": 1255343,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 1,
            "created_at": "2025-09-22 12:22:52",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9c2\/68d13f9c22c28693440771.jpg",
            "extension": "jpg"
        },
        {
            "id": 128089,
            "disk_name": "68d13f9ca1b2d833682215.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-4.jpg",
            "file_size": 606872,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 2,
            "created_at": "2025-09-22 12:22:52",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9ca\/68d13f9ca1b2d833682215.jpg",
            "extension": "jpg"
        },
        {
            "id": 128105,
            "disk_name": "68d13fa12cbc5664485802.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_.jpg",
            "file_size": 757880,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 3,
            "created_at": "2025-09-22 12:22:57",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/a12\/68d13fa12cbc5664485802.jpg",
            "extension": "jpg"
        },
        {
            "id": 128086,
            "disk_name": "68d13f9c15fbb255491433.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-2.jpg",
            "file_size": 795928,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 4,
            "created_at": "2025-09-22 12:22:52",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9c1\/68d13f9c15fbb255491433.jpg",
            "extension": "jpg"
        },
        {
            "id": 128088,
            "disk_name": "68d13f9c9d303698819463.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-5.jpg",
            "file_size": 217350,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 5,
            "created_at": "2025-09-22 12:22:52",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9c9\/68d13f9c9d303698819463.jpg",
            "extension": "jpg"
        },
        {
            "id": 128090,
            "disk_name": "68d13f9d2ef11560818505.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-6.jpg",
            "file_size": 378154,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 6,
            "created_at": "2025-09-22 12:22:53",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9d2\/68d13f9d2ef11560818505.jpg",
            "extension": "jpg"
        },
        {
            "id": 128091,
            "disk_name": "68d13f9d31e4e360965756.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-7.jpg",
            "file_size": 382846,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 7,
            "created_at": "2025-09-22 12:22:53",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9d3\/68d13f9d31e4e360965756.jpg",
            "extension": "jpg"
        },
        {
            "id": 128092,
            "disk_name": "68d13f9da97b1109366667.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-8.jpg",
            "file_size": 382043,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 8,
            "created_at": "2025-09-22 12:22:53",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9da\/68d13f9da97b1109366667.jpg",
            "extension": "jpg"
        },
        {
            "id": 128093,
            "disk_name": "68d13f9dc32bb252497989.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-9.jpg",
            "file_size": 518120,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 9,
            "created_at": "2025-09-22 12:22:53",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9dc\/68d13f9dc32bb252497989.jpg",
            "extension": "jpg"
        },
        {
            "id": 128094,
            "disk_name": "68d13f9e3eafd033154599.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-10.jpg",
            "file_size": 307262,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 10,
            "created_at": "2025-09-22 12:22:54",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9e3\/68d13f9e3eafd033154599.jpg",
            "extension": "jpg"
        },
        {
            "id": 128095,
            "disk_name": "68d13f9e4e518321583005.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-11.jpg",
            "file_size": 297567,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 11,
            "created_at": "2025-09-22 12:22:54",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9e4\/68d13f9e4e518321583005.jpg",
            "extension": "jpg"
        },
        {
            "id": 128096,
            "disk_name": "68d13f9ec0289874674152.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-12.jpg",
            "file_size": 349582,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 12,
            "created_at": "2025-09-22 12:22:54",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9ec\/68d13f9ec0289874674152.jpg",
            "extension": "jpg"
        },
        {
            "id": 128097,
            "disk_name": "68d13f9ecafc8037991033.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-13.jpg",
            "file_size": 254158,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 13,
            "created_at": "2025-09-22 12:22:54",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9ec\/68d13f9ecafc8037991033.jpg",
            "extension": "jpg"
        },
        {
            "id": 128098,
            "disk_name": "68d13f9f58226418055982.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-14.jpg",
            "file_size": 383332,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 14,
            "created_at": "2025-09-22 12:22:55",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9f5\/68d13f9f58226418055982.jpg",
            "extension": "jpg"
        },
        {
            "id": 128099,
            "disk_name": "68d13f9f65be7488427704.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-15.jpg",
            "file_size": 394700,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 15,
            "created_at": "2025-09-22 12:22:55",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9f6\/68d13f9f65be7488427704.jpg",
            "extension": "jpg"
        },
        {
            "id": 128100,
            "disk_name": "68d13f9fdd1f1197473689.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-16.jpg",
            "file_size": 441146,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 16,
            "created_at": "2025-09-22 12:22:55",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9fd\/68d13f9fdd1f1197473689.jpg",
            "extension": "jpg"
        },
        {
            "id": 128101,
            "disk_name": "68d13f9febd53659648467.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-17.jpg",
            "file_size": 441850,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 17,
            "created_at": "2025-09-22 12:22:55",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/9fe\/68d13f9febd53659648467.jpg",
            "extension": "jpg"
        },
        {
            "id": 128102,
            "disk_name": "68d13fa0725fc066817675.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-18.jpg",
            "file_size": 569897,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 18,
            "created_at": "2025-09-22 12:22:56",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/a07\/68d13fa0725fc066817675.jpg",
            "extension": "jpg"
        },
        {
            "id": 128103,
            "disk_name": "68d13fa087ac6544433015.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-19.jpg",
            "file_size": 578884,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 19,
            "created_at": "2025-09-22 12:22:56",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/a08\/68d13fa087ac6544433015.jpg",
            "extension": "jpg"
        },
        {
            "id": 128104,
            "disk_name": "68d13fa12633b587455410.jpg",
            "file_name": "Casa en Puigderos ref 68112 - a -_-20.jpg",
            "file_size": 920734,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 20,
            "created_at": "2025-09-22 12:22:57",
            "updated_at": "2025-09-23 10:08:45",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/13f\/a12\/68d13fa12633b587455410.jpg",
            "extension": "jpg"
        }
    ],
    "district": {
        "id": 118,
        "name": "Puig de Ros",
        "locality_id": 9,
        "alt_id": 182,
        "times_searched": 0,
        "latitude": "39.450033",
        "longitude": "2.751483",
        "related_page": "puig-de-ros.htm",
        "no_results_message": ""
    }
}

{
    "id": 5815,
    "reference": "68117",
    "name": "Mediterranean Living in Puigderos",
    "description": "<p data-end=\"510\" data-start=\"193\">In the peaceful and sought-after residential area of Puig de Ros, this Mediterranean-style home is presented, recently renovated with exquisite taste and meticulous attention to every detail. A residence that combines contemporary design with warmth and brightness, creating spaces ready to be enjoyed from day one.<\/p>\r\n\r\n<p data-end=\"790\" data-start=\"512\">\r\n\t<br>\r\n<\/p>\r\n",
    "description_long": "<p data-end=\"510\" data-start=\"193\">In the peaceful and sought-after residential area of Puig de Ros, this Mediterranean-style home is presented, recently renovated with exquisite taste and meticulous attention to every detail. A residence that combines contemporary design with warmth and brightness, creating spaces ready to be enjoyed from day one.<\/p>\r\n\r\n<p data-end=\"790\" data-start=\"512\">The property offers three spacious bedrooms and three full bathrooms, laid out to ensure privacy and comfort. The open-plan kitchen, modern and functional, becomes the heart of the home: a space designed both for everyday living and for hosting guests in a relaxed atmosphere.<\/p>\r\n\r\n<p data-end=\"990\" data-start=\"792\">One of the major highlights is its generously sized basement, fitted with custom wardrobes and offering multiple possibilities of use: from a private gym to a games room or a family leisure space.<\/p>\r\n\r\n<p data-end=\"1303\" data-start=\"992\">The exterior reflects the authentic Mediterranean lifestyle: a well-kept garden, a saltwater pool perfect for cooling off on warmer days, and a covered terrace that allows outdoor enjoyment all year round\u2014whether for al fresco dining, reading moments, or simply contemplating the serenity of the surroundings.<\/p>\r\n\r\n<p data-end=\"1640\" data-start=\"1305\">Comfort is guaranteed thanks to details that make a real difference: a garage with an electric car charger, pellet fireplace, mosquito nets on all windows, home automation system, water softener, and osmosis. Custom-made furniture provides an extra touch of functionality and style, reinforcing the idea of a home ready to move into.<\/p>\r\n\r\n<p data-end=\"1969\" data-start=\"1642\">The location adds even more value: just minutes from the exclusive Mhares Beach Club, perfect for enjoying sunsets by the sea, and from El Delta tennis club. Puig de Ros combines the tranquility of a residential community with proximity to Palma and the airport, offering the ideal balance between peace and urban connection.<\/p>\r\n\r\n<p data-end=\"2304\" data-start=\"1971\">In short, this home in Puig de Ros represents the perfect balance between Mediterranean design, contemporary comfort, and a privileged location. A property with character, designed for those who wish to immediately settle into an elegant and functional home, surrounded by the unique lifestyle offered by Mallorca\u2019s southern coast.<\/p>\r\n\r\n<p data-end=\"2501\" data-start=\"2306\">MallorcaSite.com recommends this property for the experience it offers: living the Mediterranean from the serenity of Puig de Ros, with spaces conceived to share, relax, and enjoy every moment.<\/p>\r\n",
    "province_id": 1,
    "locality_id": 9,
    "district_id": 118,
    "type_id": null,
    "operation_id": 1,
    "price": 1420000,
    "latitude": "39.450033",
    "longitude": "2.751483",
    "energy_letter": "D",
    "energy_value": "125",
    "emissions_letter": "E",
    "emissions_value": "39",
    "featured": 1,
    "featured_home": 0,
    "alt_id": null,
    "times_visited": 1372,
    "created_at": "2025-09-15 15:15:49",
    "updated_at": "2026-05-16 01:27:30",
    "state_id": null,
    "ask_price": 0,
    "slug": "sale-semidetached-villa-puig-de-ros-ref-68117",
    "conservation_id": 3,
    "orientation_id": 2,
    "area_id": 2,
    "extras_description": "",
    "is_active": 1,
    "is_logged_users": 0,
    "is_project": 0,
    "is_license": 0,
    "is_exclusive": 0,
    "is_price_from": 0,
    "exclusive_date_limit": null,
    "price_note": "",
    "meta_title": "",
    "meta_description": "",
    "meta_keywords": "",
    "meta_robots": "NOINDEX,FOLLOW",
    "name_secondary": "",
    "owner_id": 13662,
    "agent_id": 1604,
    "original_agent": null,
    "is_sold": 0,
    "is_hidden_other_reasons": 0,
    "is_pending_visit": 0,
    "is_discreet_marketing": 0,
    "is_have_banner": 0,
    "is_have_key": 0,
    "is_missing_images": 0,
    "is_missing_translations": 0,
    "is_missing_information": 0,
    "is_missing_sale_order": 1,
    "is_sold_external": 0,
    "annotations": "<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/Encargo de venta Ref 68117.pdf\">Encargo de venta Ref 68117.pdf<\/a><\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/CEE-9311F.pdf\">CEE-9311F.pdf<\/a><\/p>\r\n\r\n<p><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/etiq.pdf\">etiq.pdf<\/a><\/p>\r\n\r\n<p>Chimenea de palets<\/p>\r\n\r\n<p>Todo reformado<\/p>\r\n\r\n<p>Piscina reformada de sal &nbsp;<\/p>\r\n\r\n<p>Alarma<span>&nbsp;<\/span><\/p>\r\n\r\n<p><span><a class=\"fr-file\" href=\"https:\/\/static-9d29.kxcdn.com\/storage\/app\/media\/uploaded-files\/WhatsApp Image 2025-09-22 at 11.24.36.jpeg\">WhatsApp Image 2025-09-22 at 11.24.36.jpeg<\/a><\/span><\/p>\r\n\r\n<p>\r\n\t<br>\r\n<\/p>",
    "is_good_investment": 0,
    "is_urgent_sale": 0,
    "alquilada_hasta": null,
    "is_alquilada": 0,
    "address": "https:\/\/maps.app.goo.gl\/HYAzYXvChF3EhSwQ6",
    "name_hidden": "",
    "is_published_external_portals": 1,
    "matterport": null,
    "matterport_public": 0,
    "matterport_token": null,
    "images": [
        {
            "id": 128025,
            "disk_name": "68d12f14256dc755876373.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-12.jpg",
            "file_size": 1653222,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 1,
            "created_at": "2025-09-22 11:12:20",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/142\/68d12f14256dc755876373.jpg",
            "extension": "jpg"
        },
        {
            "id": 128026,
            "disk_name": "68d12f145cc71244075787.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-13.jpg",
            "file_size": 1022743,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 2,
            "created_at": "2025-09-22 11:12:20",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/145\/68d12f145cc71244075787.jpg",
            "extension": "jpg"
        },
        {
            "id": 128038,
            "disk_name": "68d12f1794f67680859783.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-24.jpg",
            "file_size": 574805,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 3,
            "created_at": "2025-09-22 11:12:23",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/179\/68d12f1794f67680859783.jpg",
            "extension": "jpg"
        },
        {
            "id": 128021,
            "disk_name": "68d12f12f402d056506581.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-8.jpg",
            "file_size": 318486,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 4,
            "created_at": "2025-09-22 11:12:19",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/12f\/68d12f12f402d056506581.jpg",
            "extension": "jpg"
        },
        {
            "id": 128015,
            "disk_name": "68d12f10ef96a416215882.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-3.jpg",
            "file_size": 475500,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 5,
            "created_at": "2025-09-22 11:12:16",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/10e\/68d12f10ef96a416215882.jpg",
            "extension": "jpg"
        },
        {
            "id": 128019,
            "disk_name": "68d12f127b965998852225.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-6.jpg",
            "file_size": 554367,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 6,
            "created_at": "2025-09-22 11:12:18",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/127\/68d12f127b965998852225.jpg",
            "extension": "jpg"
        },
        {
            "id": 128018,
            "disk_name": "68d12f11e9840396339994.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-4.jpg",
            "file_size": 490948,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 7,
            "created_at": "2025-09-22 11:12:17",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/11e\/68d12f11e9840396339994.jpg",
            "extension": "jpg"
        },
        {
            "id": 128033,
            "disk_name": "68d12f1679c6f001938184.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-20.jpg",
            "file_size": 405294,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 8,
            "created_at": "2025-09-22 11:12:22",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/167\/68d12f1679c6f001938184.jpg",
            "extension": "jpg"
        },
        {
            "id": 128017,
            "disk_name": "68d12f11dda0e921821821.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-5.jpg",
            "file_size": 309614,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 9,
            "created_at": "2025-09-22 11:12:17",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/11d\/68d12f11dda0e921821821.jpg",
            "extension": "jpg"
        },
        {
            "id": 128041,
            "disk_name": "68d12f1873688584826307.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_.jpg",
            "file_size": 423861,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 10,
            "created_at": "2025-09-22 11:12:24",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/187\/68d12f1873688584826307.jpg",
            "extension": "jpg"
        },
        {
            "id": 128022,
            "disk_name": "68d12f130e64f725277857.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-9.jpg",
            "file_size": 286136,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 11,
            "created_at": "2025-09-22 11:12:19",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/130\/68d12f130e64f725277857.jpg",
            "extension": "jpg"
        },
        {
            "id": 128027,
            "disk_name": "68d12f14be5fe816107625.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-14.jpg",
            "file_size": 1447973,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 12,
            "created_at": "2025-09-22 11:12:20",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/14b\/68d12f14be5fe816107625.jpg",
            "extension": "jpg"
        },
        {
            "id": 128024,
            "disk_name": "68d12f13b2714715730119.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-11.jpg",
            "file_size": 1194190,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 13,
            "created_at": "2025-09-22 11:12:19",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/13b\/68d12f13b2714715730119.jpg",
            "extension": "jpg"
        },
        {
            "id": 128028,
            "disk_name": "68d12f14ee548585296600.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-15.jpg",
            "file_size": 620851,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 14,
            "created_at": "2025-09-22 11:12:20",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/14e\/68d12f14ee548585296600.jpg",
            "extension": "jpg"
        },
        {
            "id": 128029,
            "disk_name": "68d12f155160b014814388.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-16.jpg",
            "file_size": 503909,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 15,
            "created_at": "2025-09-22 11:12:21",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/155\/68d12f155160b014814388.jpg",
            "extension": "jpg"
        },
        {
            "id": 128023,
            "disk_name": "68d12f1380f72017428303.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-10.jpg",
            "file_size": 259628,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 16,
            "created_at": "2025-09-22 11:12:19",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/138\/68d12f1380f72017428303.jpg",
            "extension": "jpg"
        },
        {
            "id": 128030,
            "disk_name": "68d12f157a0e8384569915.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-17.jpg",
            "file_size": 360175,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 17,
            "created_at": "2025-09-22 11:12:21",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/157\/68d12f157a0e8384569915.jpg",
            "extension": "jpg"
        },
        {
            "id": 128031,
            "disk_name": "68d12f15ecdb0041273761.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-18.jpg",
            "file_size": 347806,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 18,
            "created_at": "2025-09-22 11:12:21",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/15e\/68d12f15ecdb0041273761.jpg",
            "extension": "jpg"
        },
        {
            "id": 128016,
            "disk_name": "68d12f10ef96a555408669.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-2.jpg",
            "file_size": 534569,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 19,
            "created_at": "2025-09-22 11:12:16",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/10e\/68d12f10ef96a555408669.jpg",
            "extension": "jpg"
        },
        {
            "id": 128032,
            "disk_name": "68d12f160fb2f287643060.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-19.jpg",
            "file_size": 504161,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 20,
            "created_at": "2025-09-22 11:12:22",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/160\/68d12f160fb2f287643060.jpg",
            "extension": "jpg"
        },
        {
            "id": 128034,
            "disk_name": "68d12f16867c1790058380.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-21.jpg",
            "file_size": 324264,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 21,
            "created_at": "2025-09-22 11:12:22",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/168\/68d12f16867c1790058380.jpg",
            "extension": "jpg"
        },
        {
            "id": 128040,
            "disk_name": "68d12f182fc3f413744054.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-27.jpg",
            "file_size": 884230,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 22,
            "created_at": "2025-09-22 11:12:24",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/182\/68d12f182fc3f413744054.jpg",
            "extension": "jpg"
        },
        {
            "id": 128020,
            "disk_name": "68d12f1280a9e781639023.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-7.jpg",
            "file_size": 369119,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 23,
            "created_at": "2025-09-22 11:12:18",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/128\/68d12f1280a9e781639023.jpg",
            "extension": "jpg"
        },
        {
            "id": 128036,
            "disk_name": "68d12f170b484461425300.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-22.jpg",
            "file_size": 226730,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 24,
            "created_at": "2025-09-22 11:12:23",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/170\/68d12f170b484461425300.jpg",
            "extension": "jpg"
        },
        {
            "id": 128035,
            "disk_name": "68d12f170999f131110417.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-23.jpg",
            "file_size": 251787,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 25,
            "created_at": "2025-09-22 11:12:23",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/170\/68d12f170999f131110417.jpg",
            "extension": "jpg"
        },
        {
            "id": 128037,
            "disk_name": "68d12f17935a7911052150.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-25.jpg",
            "file_size": 344803,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 26,
            "created_at": "2025-09-22 11:12:23",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/179\/68d12f17935a7911052150.jpg",
            "extension": "jpg"
        },
        {
            "id": 128039,
            "disk_name": "68d12f17e5cb9789395266.jpg",
            "file_name": "Casa en Puigderos ref 68117 -_-26.jpg",
            "file_size": 315738,
            "content_type": "image\/jpeg",
            "title": null,
            "description": null,
            "field": "images",
            "sort_order": 27,
            "created_at": "2025-09-22 11:12:23",
            "updated_at": "2025-09-22 11:29:19",
            "path": "https:\/\/static-9d29.kxcdn.com\/storage\/app\/uploads\/public\/68d\/12f\/17e\/68d12f17e5cb9789395266.jpg",
            "extension": "jpg"
        }
    ],
    "district": {
        "id": 118,
        "name": "Puig de Ros",
        "locality_id": 9,
        "alt_id": 182,
        "times_searched": 0,
        "latitude": "39.450033",
        "longitude": "2.751483",
        "related_page": "puig-de-ros.htm",
        "no_results_message": ""
    }
}