string(5637) "{ "error": "", "req": "SELECT el.*, e.*, el.avocat_adjudicateur_id as adjudicateur, g.nom as nom_porteur, e.tel_porteur_contact, g.adresse as adresse_porteur, g.telephone as tel_porteur, g.fax as fax_porteur, t.intitule as nom_lieu_vente, t.adresse as adresse_lieu_vente, t.adresse_complementaire as adresse_c_lieu_vente, t.code_postal as cp_lieu_vente, t.localite as localite_lieu_vente, t.telephone as tel_lieu_vente FROM encheres_lots as el LEFT JOIN encheres as e ON e.enchere_id = el.enchere_id LEFT JOIN utilisateur as u ON e.porteur_affaire_id = u.id LEFT JOIN groupe as g ON g.id = u.groupe LEFT JOIN tribunal_commerce as t ON t.id = e.lieu_vente_id LEFT JOIN encheres_lot_nature as n ON n.id = el.nature_bien WHERE e.internet='1' AND ( DATE(e.date_source) <= DATE(NOW()) ) AND el.lot_id='8663' ORDER BY e.date_enchere , el.lot_id LIMIT 0,10 ", "result": "true", "table": "encheres", "w": [ { "lot_id": "8663", "enchere_id": "21008", "date_creation": "2018-01-06", "date_maj": "2018-01-06 01:00:00", "encheres_lot_status": "", "lot_ref": "113069", "nature_bien": "Appartement", "date_enchere": "2018-02-05", "mise_a_prix": "60000", "adjudication": "0", "adjudication_detail": "", "baisse": "", "occupation": "", "syndic": "", "surface": "0", "surface_carrez": "0", "surface_terrain": "0", "nombre_pieces": "0", "nombre_chambres": "0", "dpe": "", "ges": "", "title": "DEUX TERRAINS A B\u00c2TIR CONTIGUS \u00e0 PRADES LE LEZ", "descriptif": "DEUX TERRAINS A B\u00c2TIR CONTIGUS , cadastr\u00e9(e) section AR n\u00b0 158, 22.", "commentaire": "", "type_visites": "libre", "lot_adresse": "Chemin de Bellevue, 34730 PRADES LE LEZ", "lot_adresse_suite": "", "lot_code_postal": "34730", "lot_code_commune": "", "lot_commune": "PRADES LE LEZ", "lot_departement": "34", "lot_region": "", "lot_pays": "", "lot_lat": "43.694656", "lot_lng": "3.880730", "tgi_code_postal": "34000", "tgi_code_commune": "", "tgi_departement": "", "tgi_region": "", "avocat_adjudicateur_id": "0", "avocat_adjudicateur_nom": "", "facebook_id": "", "lieu_vente_id": "232", "porteur_affaire_id": "4856", "porteur_affaire_contact": "Ma\u00eetre SALLES", "poursuivant": "", "source_id": "0", "enchere_status": "F", "enchere_ref": "113069", "heure_debut": "14:00:00", "type_vente": "Judiciaire", "date_source": "2018-01-06", "annonce": null, "internet": "1", "date_export": "2018-01-09", "departement": "34", "frais": "0.00", "reference_ccv": "", "avocat_postulant_id": "0", "source_import": "VLIMMO", "reserve_abonnes": "1", "consignation": "0", "tel_porteur_contact": null, "adjudicateur": "0", "nom_porteur": null, "adresse_porteur": "", "tel_porteur": null, "fax_porteur": null, "nom_lieu_vente": "TJ DE MONTPELLIER", "adresse_lieu_vente": "Place Pierre Flotte, Salle n\u00b07 Pi", "adresse_c_lieu_vente": "", "cp_lieu_vente": "34000", "localite_lieu_vente": "MONTPELLIER", "tel_lieu_vente": "04 67 12 60 00", "journal": "inconnu", "lieu_vente": "TJ DE MONTPELLIER", "nb_jours": "enchere_done", "alias": "deux-terrains-a-batir-contigus-a-prades-le-lez", "url": "https:\/\/www.petitesaffiches.fr\/encheres-immobilieres\/vente\/immobiliere\/judiciaire\/deux-terrains-a-batir-contigus-a-prades-le-lez-8663.html", "ts_date_source": "1515193200", "ts_date_enchere_lot": "1517785200", "image_path": "https:\/\/annonces-legales.petites-affiches.fr\/vae\/image\/", "images": [ "img_1_e_e58b2c94bb6c7a019f0f4fa3835c8209ffeef266_l_8663.jpg" ], "adjudication_html": "Adjudication : <\/b>0,00\u20ac ", "avocat_postulant": "", "avocat_adjudicateur": "", "visites": [ { "id": "2805", "lot_id": "8663", "date": "2018-01-24", "heure_debut": "09:00:00", "heure_fin": "10:00:00", "lieu": "SUR PLACE", "contact": "", "contact_id": "0", "telephone": "", "portable": "", "fax": "", "email": "", "etat": "1", "type_visite": "Libre" } ], "vignette": "https:\/\/annonces-legales.petites-affiches.fr\/vae\/json\/vignette\/e58b2c94bb6c7a019f0f4fa3835c8209ffeef266" } ], "pagination_arr": { "nombre_pages": 1, "num_rows_all": 1, "num_rows_limit": 10, "rel_next": "\/vente-aux-encheres-immobilieres-p0.html", "rel_prev": "", "curr_page_num": 1, "next_page_num": "0" } }" Impression Lot : 113069 - Petites Affiches des Alpes-Maritimes

DEUX TERRAINS A BÂTIR CONTIGUS à PRADES LE LEZ