Quiénes Somos
Noticias
Contacto
Quiénes Somos
Noticias
Contacto
Inmobiliaria
Construcciones
SERVICIOS INMOBILIARIOS Y DE CONSTRUCCION
Since 1973
CONSTRUCCIONES PROCASA
: QUE LA EXPERIENCIA DE CONSTRUIRSE UNA CASA SEA AGRADABLE Y POSITIVA
Ref.
Tipo
Todos
Solo viviendas
Casa
Piso/Apartamento
Estudio
Terreno
Parking
Amarre
Local
Inmueble singular
Población
Todos
SELECT distinct poblaciones.poblacion, poblaciones.id, poblaciones.poblacion FROM poblaciones RIGHT JOIN inmuebles ON poblaciones.id = inmuebles.poblaciones_id WHERE inmuebles.id not in ( 2204,2390,2372,1773,2393,2618,2422,3019,2387,2930,2399,2479,2906,2251,2780,2671,3052,3020,2905,2887,2632,3078,1815,2492,3126,2613,1844,3064,1842,1843,2389,2907,3067,3003,2865,2704,2532,2071,2335,2067,1997,2878,2718,1895,648,2728,2645,3004,2572,2786,3000,2583,1431,3149,2864,1627,3039,3145,2582,2336,2073,3243,3146,3242,3241,3150,3247,3239,84,3131,2595,3777,3776,3650,3061,3054,3034,3043,2125,2981,3116,3918,3137,3869,3919,2398,3893,3537,3903,3908,3909,3906,3888,3060,2776,2598,2587,2534,3876,3887,3889,3884,1056,3880,3176,3143,3135,658,3256,3726,3878,3733,3860,1807,3760,3834,3502,2925,2818,3115,3587,3485,3857,2638,2524,3818,3810,2220,2166,2044,3229,3232,2762,3844,3793,3851,1109,3826,3800,3823,3628,2806,3805,3897,3364,3873,3147,2023,1874,3784,3571,1594,1719,3008,3284,3290,3825,3835,3756,3198,2955,3829,2275,3313,3316,2670,3312,3431,3274,3319,3323,3326,3334,1154,3332,3253,3343,3352,3351,3473,3790,2391,3362,3333,3804,3803,3123,3588,3808,3525,3809,3812,2345,3373,3269,3489,2975,2628,3065,3437,3481,3441,3405,3494,3501,3127,3504,3389,3391,3392,3244,3257,3785,3515,3514,3516,3509,3107,3526,3528,2236,3512,3532,3898,2550,3403,3406,3407,3417,3410,3314,2512,3426,3440,3442,2725,3261,3401,3453,3458,2899,3942,3941,3943,3457,3341,3238,2629,1524,3368,3464,2217,2980,3099,3468,3465,2707,3469,3470,3474,3042,2518,3390,1507,3447,3449,2128,3538,3541,3542,3553,3478,3551,3557,3499,3524,2944,3566,3567,3568,3572,3480,3569,3837,3934,3936,3840,3581,3584,3582,3772,3930,3886,3570,3916,3911,3534,3586,3425,3592,3021,3153,3285,3598,3597,3591,3138,3484,3565,3491,3616,3476,3623,3627,3633,3212,3503,3483,3641,3652,3630,3490,3520,3521,3200,3663,3665,3657,3667,3671,2557,3531,3677,3680,3681,3461,3682,3684,3121,2814,3693,3696,3697,3703,3399,3649,3702,3705,3712,3717,3719,3689,2143,3686,2953,3354,3708,3731,3735,3180,3738,3737,3732,3740,3655,3050,3747,3746,3498,3751,3750,2867,3648,3758,3752,3761,3736,3765,3757,1611,3117,3555,3768,3769,3954,3614,3816,3646,3780,3418,3957,4152,3981,4150,3989,3990,3992,3815,3998,3997,3993,3996,4002,2561,4006,3994,4010,3947,4011,4014,4012,4019,4020,4018,4017,3966,2721,3087,4021,4022,3155,4028,4031,4032,4033,4034,3763,4038,4008,4041,3975,3724,4042,3979,4043,3416,4045,4046,3988,4050,4055,4057,3850,4058,2500,4062,4064,4065,4053,4074,4075,4077,4078,4083,4082,4084,4073,4087,4089,3487,4094,4051,4096,4099,4097,3778,3479,4026,3624,4091,4015,4110,3931,4112,4111,4095,4117,2771,4125,4134,4135,4141,4071,4142,4085,4122,4161,4162,4163,4160,4165,4172,4173,3293,4171,4175,4179,4178,4191,4185,4186,4195,4194,4193,334,4180,4005,3675,4199,4197,4198,4217,3432,4221,3929,4222,4063,4224,4202,4233,3944,3978,4211,4226,3369,4208,4239,4118,4240,3626,4249,4247,3902,3599,4132,4254,3325,4184,4255,4256,4246,4261,4263,4126,4266,4273,4190,3718,2405,3250,4280,4284,4269,4282,4272,2850,4029,3622,4292,4159,4288,4294,4204,4303,4296,4301,4300,3721,3744,4315,4129,4314,3291,4327,4331,4335,4332,4345,4351,4355,4362,4361,3741,3742,4354,4357,4348,4295,4367,4365,4368,4371,4048,4157,4532,4321,4079,4377,4376,4298,4364,4237,3743,4338,4166,4387,4394,4391,4374,4397,4297,4390,4400,4401,4402,3875,4396,4405,4403,4352,4423,4432,4393,3610,4433,4437,3315,4442,4337,3999,4000,4458,4435,4456,4452,4454,4460,4455,4457,4467,4470,4417,3124,4475,4476,4448,4415,4481,4245,3576,4484,4492,4496,4494,4076,4505,4093,4478,4464,4474,4329,4250,4070,4451,4516,4105,2219,4510,3858,4243,4524,4216,4514,4525,4527,4414,4537,4535,4534,4530,4540,4542,4543,4546,4526,4438,4183,4550,4552,4551,4562,4286,4565,4567,4564,3701,4336,4582,4568,4318,4281,4593,4596,4493,4591,4592,4594,4598,3546,4382,4608,4607,4605,3518,4597,4333,4614,4602,4617,4618,4016,4486,4440,4583,4563,4453,4588,5779,4587,4579,4623,4279,4472,4625,4626,4558,4577,4628,4629,4630,4635,4363,3258,4643,4646,4648,4655,4653,4522,4656,4652,4661,4601,4662,4585,4664,4665,4667,4366,4615,4672,4676,4206,2562,4677,4275,4681,4642,4683,4528,4686,4690,4418,4694,4701,4699,4700,4697,4709,4711,4722,4723,4650,4734,4732,4741,4726,4746,4750,4751,4719,3709,3529,4420,4449,4521,4571,4756,4757,4688,4760,4692,4765,4770,4771,4061,4772,4733,4783,4779,4790,4797,4753,4800,4421,4584,4806,4809,4811,4814,4816,4817,4818,4762,4820,4821,4823,4824,4822,4825,4826,4830,4835,4776,5071,4839,4849,4848,4856,4859,4862,4861,4867,4852,4868,4407,4866,4863,4869,4575,4873,4877,4879,4882,4876,4886,4888,4887,4815,4901,4903,4889,4907,4906,4707,4359,4908,4875,4640,4794,4912,3378,4917,4914,4241,4918,4924,4905,4923,4925,4497,4920,4754,4858,4927,4936,4647,4891,4940,4349,4943,3861,4406,4896,4954,4953,4928,3617,4964,4744,4777,4842,4780,4966,4619,4969,4970,4736,4976,4975,4840,4981,4983,4987,4986,4985,4989,4802,4984,4838,4644,4792,5001,5000,4994,4885,5010,5018,5015,5024,5025,5027,5031,5029,5030,5032,4997,5040,5043,5050,5052,4781,5042,5059,4979,5047,5046,5064,4851,5066,5068,5069,5045,5058,4465,4259,5072,4410,5078,5079,5081,5086,5087,5088,4718,4773,5091,5094,5095,4833,4971,5096,5097,5099,5101,5102,5106,5109,4974,4747,4290,5092,4491,5124,5127,5128,4995,5142,5235,5154,5157,4881,5150,5146,5149,4330,4935,5113,5002,5037,5162,5163,5144,5165,5175,4533,5181,5184,5186,5188,5190,5189,5195,5202,4844,5204,5266,4541,5114,4466,5213,5214,5098,5221,4819,5222,5224,5129,5041,5203,5223,4937,5105,5108,5201,5193,5080,5228,5229,4836,5159,5230,5182,4948,5244,5241,5183,5246,5247,5251,5253,5255,5256,5198,5245,4980,5191,4356,5269,5272,4187,5274,4857,5278,5281,5282,5283,4973,5286,243,5288,5290,5294,4963,5293,4939,5295,5296,5297,5299,4992,5270,5300,5303,5304,5305,5306,5307,5308,5309,5311,5312,5313,5314,5315,5055,4289,5316,5319,5323,5320,5328,5327,5104,4436,5334,5333,5341,5340,5338,5344,5345,5346,5351,4787,5174,5354,5287,5363,5362,5365,5366,4339,5367,5379,5378,5364,5376,5400,5388,5390,5391,5394,5387,4547,5417,5419,5399,5121,5426,5433,5427,5436,5444,5445,5267,5434,5462,5464,5463,5220,5470,5480,5471,5503,5507,5508,5506,5431,5511,5513,5156,5495,5171,4693,3814,5535,5534,5516,5509,5494,5493,5500,5537,5520,5583,5587,5596,5585,4982,5491,5020,5482,4729,5609,5611,5613,5618,5601,5533,5589,5595,5623,5164,5626,5628,5051,5486,5326,4934,5073,5070,5645,5446,5647,5650,5649,5651,5652,5655,5659,5660,5661,5689,5690,5692,5694,5693,5215,5716,5717,5600,4317,5590,5720,5111,5724,5727,4654,5732,5610,5562,5741,5280,5743,5742,5745,5483,5747,5731,5598,5755,5756,5729,5760,5761,5763,5765,5603,5723,5528,5775,5777,5778,5465,5790,5772,5751,5792,5602,5796,5797,5767,5519,5726,5192,5802,5449,5466,5435,5825,4990,5811,5806,5832,5834,5754,5831,5794,5846,5847,5586,5835,5425,4574,5826,5648,5855,5859,5860,5840,5865,5866,5864,5526,5522,5833,5871,5874,5560,5875,5878,5867,5852,5926,5301,5525,5892,5880,5781,5900,5905,5454,5627,5920,5776,5917,5910,5817,5869,5940,5919,5921,5946,5937,5472,5902,5791,5959,5890,5962,5973,5982,5978,5780,5975,4506,5963,5995,5988,5783,5758,6001,5536,6009,5941,6016,5996,5558,6021,5999,6018,5851,5958,5737,3456,5416,6033,6030,5964,5897,6034,6032,6036,6038,5868,6047,6048,6049,6052,4717,5420,6060,6074,4386,6044,5955,5597,5829,5970,4641,6097,6096,6100,5459,6105,6026,5983,5861,5974,6122,5938,6132,5715,6113,5881,6106,6148,5807,6138,5944,6012,5984,5827,5980,6128,6025,5591,6078,6152,6149,5839,5994,6154,6163,6164,5924,5989,6172,6090,5877,6177,6183,6184,6187,6173,6178,5961,6200,6199,6203,6130,6205,6206,6011,6223,6224,6225,6227,6229,6231,6232,6057,6234,6236,6237,6170,6248,6254,6262,6264,6265,6266,6168,5793,5922,6282,6214,6088,6291,6292,6294,6295,6299,6167,4258, 0) AND (inmuebles.publicar <> 2 OR (inmuebles.publicar = 2 AND inmuebles.asociados_id = 6)) AND inmuebles.publicar <> 1 AND inmuebles.activo = 1 ORDER BY poblaciones.poblacion
Avinyonet de Puigventós
Cadaqués
Castelló d'Empúries
Cistella
Empuriabrava
Figueres
Llançà
Masarac
Mollet de Peralada
Palau-saverdera
Pau
Peralada
Port de la Selva, El
Roses
Sant Llorenç de la Muga
Sant Pere Pescador
Santa Llogaia d'Àlguema
Vila-sacra
Vilajuïga
Zona
Todos
Habitaciones
Todos
+ 1
+ 2
+ 3
+ 4
+ 5
+ 6
+ 7
+ 8
+ 9
> 10
Precio
Todos
0 € - 200.000 €
200.000 € - 350.000 €
350.000 € - 500.000 €
500.000 € - 750.000 €
+ 750.000 €
Ordenar por
Defecto
Precio de menor a mayor
Precio de mayor a menor
Tipo
Zona
Añadidos o modificados en los últimos 15 días
Añadidos o modificados en el último mes
Vistas al Mar
Amarre
Buscar
Mapa
