AlkDrPgSql Object
(
    [oRow:protected] => Array
        (
            [libelle_type_proprietaire] => DE PARTICULIER A PARTICULIER
            [id_proprietaire] => 233
            [nom_proprietaire] => FRIN
            [prenom_proprietaire] => benjamin
            [login_proprietaire] => Benjaminfrin
            [commune_intitule] => MALESTROIT
            [commune_intitule_2] => MALESTROIT
            [id_annonce] => 632
            [new_num_vo] => 1
            [new_lettre] => 
            [nom_voie] => ALL DUC DE COSSE BRISSAC
            [type_logement_libelle] => Maison
            [meuble] => 0
            [garage] => 0
            [jardin] => 0
            [etage] => 
            [surface] => 80
            [pieces] => T4
            [telephone_proprietaire] => 
            [mobile_proprietaire] => 
            [email_proprietaire] => b.frin@pays-ploermel.fr
            [desc_supp] => 
            [classe_energetique] => 
            [annee_construction] => 
            [id_doc_1] => 0
            [nom_doc_1] => carre_2_39F092.png
            [ext_doc_1] => png
            [id_doc_1m] => 0
            [nom_doc_1m] => carre_2_39F092.png
            [ext_doc_1m] => png
            [id_doc_2] => 0
            [nom_doc_2] => carre_2_39F092.png
            [ext_doc_2] => png
            [id_doc_2m] => 0
            [nom_doc_2m] => carre_2_39F092.png
            [ext_doc_2m] => png
            [id_doc_3] => 0
            [nom_doc_3] => carre_2_39F092.png
            [ext_doc_3] => png
            [id_doc_3m] => 0
            [nom_doc_3m] => carre_2_39F092.png
            [ext_doc_3m] => png
            [type_chauffage] => 
            [type_chauffage_autre_desc] => 
            [date_debut_location] => 30/04/2020
            [loyer] => 500
            [charges] => 50
            [date_debut_publication] => 30/03/2020
            [date_fin_publication] => 30/04/2020
            [date_suppression] => 
        )

    [iCountField:protected] => 50
    [dsParent:protected] => AlkDsPgSql Object
        (
            [oRes:protected] => Resource id #648
            [iCurDr:protected] => 1
            [iCountDr:protected] => 1
            [iCountTotDr:protected] => 1
            [strSql:protected] => set search_path to alkanet, public,alkarto,public;  SELECT DISTINCT 
 tp.libelle_type_proprietaire 
 , prop.id_proprietaire, prop.nom_proprietaire, prop.prenom_proprietaire, prop.login_proprietaire 
 , com1.tex2 as COMMUNE_INTITULE, com2.tex2 as COMMUNE_INTITULE_2 
 , ann.id_annonce 
 , adr.new_num_vo, adr.new_lettre, adr.nom_voie 
 , tlog.libelle as TYPE_LOGEMENT_LIBELLE 
 , ann.meuble, ann.garage, ann.jardin, ann.etage, ann.surface, ann.pieces 
 , prop.telephone_proprietaire, prop.mobile_proprietaire, prop.email_proprietaire 
 , ann.desc_supp, ann.classe_energetique, annee_construction 
 , doc1.id_doc as ID_DOC_1,  doc1.nom_origine as NOM_DOC_1,  doc1.extension as EXT_DOC_1 
 , doc1m.id_doc as ID_DOC_1M, doc1m.nom_origine as NOM_DOC_1M, doc1m.extension as EXT_DOC_1M 
 , doc2.id_doc as ID_DOC_2,  doc2.nom_origine as NOM_DOC_2,  doc2.extension as EXT_DOC_2 
 , doc2m.id_doc as ID_DOC_2M, doc2m.nom_origine as NOM_DOC_2M, doc2m.extension as EXT_DOC_2M 
 , doc3.id_doc as ID_DOC_3,  doc3.nom_origine as NOM_DOC_3,  doc3.extension as EXT_DOC_3 
 , doc3m.id_doc as ID_DOC_3M, doc3m.nom_origine as NOM_DOC_3M, doc3m.extension as EXT_DOC_3M 
 , ann.type_chauffage, ann.type_chauffage_autre_desc 
 , (to_char( ann.date_debut_location, 'DD/MM/YYYY')) as date_debut_location, ann.loyer, ann.charges 
 , (to_char( ann.date_debut_publication, 'DD/MM/YYYY')) as date_debut_publication, (to_char( ann.date_fin_publication, 'DD/MM/YYYY')) as date_fin_publication 
 , (to_char( ann.date_suppression, 'DD/MM/YYYY')) as date_suppression 
 FROM obc_petites_annonces.pa_annonce ann 
   LEFT JOIN obc_petites_annonces.pa_libelle_logement     tlog  ON ( ann.type_logement = tlog.type_logement ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc1  ON ( ann.id_doc_1 = doc1.id_doc ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc1m ON ( ann.id_doc_1_min = doc1m.id_doc ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc2  ON ( ann.id_doc_2 = doc2.id_doc ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc2m ON ( ann.id_doc_2_min = doc2m.id_doc ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc3  ON ( ann.id_doc_3 = doc3.id_doc ) 
   LEFT JOIN obc_petites_annonces.admin_document                doc3m ON ( ann.id_doc_3_min = doc3m.id_doc ) 
   LEFT JOIN obc_petites_annonces.adresse_num_rues        adr   ON ( ann.id_elemgraph = adr.id_elemgraph_lib ) 
     LEFT JOIN obc_petites_annonces.cad_commune                 com1  ON ( CAST( adr.id_commune AS text) = CAST( com1.id_geo AS text) ) 
     LEFT JOIN obc_petites_annonces.cad_commune                 com2  ON ( CAST( ann.id_commune AS text) = CAST( com2.id_geo AS text) ) 
   LEFT JOIN obc_petites_annonces.pa_proprietaire         prop  ON ( ann.id_proprietaire = prop.id_proprietaire ) 
     LEFT JOIN obc_petites_annonces.pa_type_proprietaire  tp    ON ( prop.id_type_proprietaire = tp.id_type_proprietaire ) 
 WHERE 1=1 
 AND ( NOW()::DATE, INTERVAL '1 days') OVERLAPS ( ann.date_debut_publication::DATE, ann.date_fin_publication::DATE) AND ann.date_debut_publication is not null  
 AND ann.date_suppression IS NULL  ORDER BY id_annonce desc 
            [iFirst:protected] => 0
            [iLast:protected] => 9
            [bEof:protected] => 1
            [tabDr:protected] => Array
                (
                )

            [lastErr:protected] => 
            [bErr:protected] => 1
            [tabTypeAssoc:protected] => Array
                (
                )

            [tabType:protected] => Array
                (
                    [0] => varchar
                    [1] => int4
                    [2] => varchar
                    [3] => varchar
                    [4] => varchar
                    [5] => varchar
                    [6] => varchar
                    [7] => int4
                    [8] => float8
                    [9] => varchar
                    [10] => varchar
                    [11] => varchar
                    [12] => varchar
                    [13] => varchar
                    [14] => varchar
                    [15] => varchar
                    [16] => numeric
                    [17] => varchar
                    [18] => varchar
                    [19] => varchar
                    [20] => varchar
                    [21] => text
                    [22] => varchar
                    [23] => int4
                    [24] => int4
                    [25] => varchar
                    [26] => varchar
                    [27] => int4
                    [28] => varchar
                    [29] => varchar
                    [30] => int4
                    [31] => varchar
                    [32] => varchar
                    [33] => int4
                    [34] => varchar
                    [35] => varchar
                    [36] => int4
                    [37] => varchar
                    [38] => varchar
                    [39] => int4
                    [40] => varchar
                    [41] => varchar
                    [42] => varchar
                    [43] => varchar
                    [44] => text
                    [45] => numeric
                    [46] => numeric
                    [47] => text
                    [48] => text
                    [49] => text
                )

            [tabFields:protected] => Array
                (
                    [0] => libelle_type_proprietaire
                    [1] => id_proprietaire
                    [2] => nom_proprietaire
                    [3] => prenom_proprietaire
                    [4] => login_proprietaire
                    [5] => commune_intitule
                    [6] => commune_intitule_2
                    [7] => id_annonce
                    [8] => new_num_vo
                    [9] => new_lettre
                    [10] => nom_voie
                    [11] => type_logement_libelle
                    [12] => meuble
                    [13] => garage
                    [14] => jardin
                    [15] => etage
                    [16] => surface
                    [17] => pieces
                    [18] => telephone_proprietaire
                    [19] => mobile_proprietaire
                    [20] => email_proprietaire
                    [21] => desc_supp
                    [22] => classe_energetique
                    [23] => annee_construction
                    [24] => id_doc_1
                    [25] => nom_doc_1
                    [26] => ext_doc_1
                    [27] => id_doc_1m
                    [28] => nom_doc_1m
                    [29] => ext_doc_1m
                    [30] => id_doc_2
                    [31] => nom_doc_2
                    [32] => ext_doc_2
                    [33] => id_doc_2m
                    [34] => nom_doc_2m
                    [35] => ext_doc_2m
                    [36] => id_doc_3
                    [37] => nom_doc_3
                    [38] => ext_doc_3
                    [39] => id_doc_3m
                    [40] => nom_doc_3m
                    [41] => ext_doc_3m
                    [42] => type_chauffage
                    [43] => type_chauffage_autre_desc
                    [44] => date_debut_location
                    [45] => loyer
                    [46] => charges
                    [47] => date_debut_publication
                    [48] => date_fin_publication
                    [49] => date_suppression
                )

            [strDbEncoding:protected] => UTF-8
            [bFetchAll:protected] => 
            [bUseInternalCache:protected] => 
            [bUseCache:protected] => 
            [iCacheExpire:protected] => 0
            [strCacheName:protected] => alkanet
            [strCacheFieldIndex:protected] => 
            [tabDrIndex:protected] => Array
                (
                )

            [tabLangue:protected] => Array
                (
                    [0] => Array
                        (
                            [bdd] => _FR
                            [rep] => fr
                        )

                )

            [nbLangue:protected] => 1
            [conn] => Resource id #644
        )

    [tabLangue:protected] => Array
        (
            [0] => Array
                (
                    [bdd] => _FR
                    [rep] => fr
                )

        )

    [nbLangue:protected] => 1
)

Communauté de communes
du Val d'Oust
et de Lanvaux

 

Les petites annonces locatives

Augmenter la taille des caractèresRéduire la taille des caractèresEnvoyer à un amiImprimer la pageS'abonner au flux rssPartager cette information

Vous recherchez un logement ? Vous trouverez ci-après les petites annonces de particulier à  particulier et des professionnels de l'immobilier qui reprend l'ensemble des annonces disponibles.

Vous pouvez aussi faire une recherche multi-critères, visionner les photos et visualiser précisémment la situation géographique du logement en location. Pour cela, il vous suffit de vous rendre dans la barre de recherche "rechercher une annonce" ci-dessous.

Vous êtes propriétaire d'un logement et vous souhaitez le mettre en location ? Il vous suffit de déposer une annonce ci-dessous. Attention ! Afin de déposer une annonce, il est indispensable de créer un compte dans la rubrique "déposer une annonce".

Déposer une annonce

Créer un compte
Récupérer mon mot de passe


Rechercher une annonce

 €

 €

   1500 €