<!--SELECT *, (select max(FechaFin) from cache_contratos WHERE CONCAT(', ', `text_property_ids`, ', ') LIKE CONCAT('%, ', `CodigoFinca`, ', %') AND FechaFin > '2025-01-18' AND FechaFin < '2025-02-18') as disponible_desde
FROM `dynamic_products`
WHERE   (
CONCAT(',',text_property_ids,',') LIKE '%,241702,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241794,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241795,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241798,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241801,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241703,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241803,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241804,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241806,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241808,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241809,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241810,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241811,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241704,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241813,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241814,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241816,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241817,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241818,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241819,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241821,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241705,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241823,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241825,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241828,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241829,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241830,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241706,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241836,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241838,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241707,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241843,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241845,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241846,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241847,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241849,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241855,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241709,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241865,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241866,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241867,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241869,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241870,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241871,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241710,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241872,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241873,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241874,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241876,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241877,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241878,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243930,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241880,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241883,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241888,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241889,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241890,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241896,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241897,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241898,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241899,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241900,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241901,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241902,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241903,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241904,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246268,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241906,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241907,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241908,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241909,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241910,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241911,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241913,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241914,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241916,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241917,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241918,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241919,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241920,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241715,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241921,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241922,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241924,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241929,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241932,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241933,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241934,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241935,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241936,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241937,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241938,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242062,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242136,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241940,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241941,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241942,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241943,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241944,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241945,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241946,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241947,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241948,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241949,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241718,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241952,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241953,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241954,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241955,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241956,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241957,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241958,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241961,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241719,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241962,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241964,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241966,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241967,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241968,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241969,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241970,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241972,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241974,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241975,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241976,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241977,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241978,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241980,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241990,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241695,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241992,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241995,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242002,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242004,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242005,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242006,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242007,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242008,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242009,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242011,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241724,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242013,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242014,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242015,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242016,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242017,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242018,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242019,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242020,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242021,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242022,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242024,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242025,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243932,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242030,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242031,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243933,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243934,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242034,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242036,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242038,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242044,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242050,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242053,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242054,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242057,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242060,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241729,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243935,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242066,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242067,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242069,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242070,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242071,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242074,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11242078,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242079,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242081,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242082,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242084,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242085,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242086,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242087,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242088,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242089,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241696,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241732,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242090,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242092,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243937,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242112,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242113,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242114,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242116,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242119,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242121,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243938,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242124,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243939,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242130,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242133,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242137,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241737,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241744,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241745,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242138,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242141,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242143,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242145,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242146,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242147,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242148,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242149,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242150,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242151,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242152,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242154,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242158,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242159,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243940,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243941,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242165,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242166,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242167,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243942,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242171,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243943,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243944,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243945,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243946,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243947,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242177,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243948,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243949,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243950,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243951,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243952,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241697,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241742,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243956,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242188,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242189,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242190,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242191,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242192,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242193,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242194,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244102,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242195,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242196,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244103,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243957,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243958,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243959,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243960,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243961,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243962,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243963,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242204,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242205,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242206,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242207,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242208,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243964,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242211,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242212,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242213,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243965,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243966,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242216,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242217,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243967,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242228,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243968,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242230,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241747,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243970,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242234,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242235,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243971,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243972,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242241,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241748,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242242,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242247,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243973,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243974,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242260,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242261,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242266,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242267,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243975,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242269,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242270,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242272,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242275,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242278,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242279,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242280,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242281,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242282,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242283,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242284,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242285,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242286,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242288,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242290,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242293,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241754,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243978,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242300,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242303,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242304,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243979,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241755,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242307,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242309,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242310,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242311,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242312,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243980,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242314,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242315,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242316,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242317,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242318,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242319,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242320,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242321,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242322,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242323,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242324,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242327,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242328,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242330,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242332,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243981,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242334,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241758,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242339,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242341,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242342,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242343,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242344,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241759,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242345,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242346,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242347,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242348,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242349,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242351,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243982,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242353,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242356,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242359,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242361,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242362,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242364,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242365,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242369,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242370,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242371,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242374,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242375,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242376,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243983,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243984,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242380,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242382,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242384,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242385,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242387,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242388,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243985,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242390,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242391,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241764,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242392,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243986,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243987,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243988,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242400,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242402,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243989,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242405,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243990,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243991,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243992,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241766,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243993,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242412,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242414,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242415,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242418,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11243995,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242420,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241767,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242421,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242423,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242424,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242425,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241768,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242429,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242430,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242431,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242432,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242433,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242434,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242435,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242438,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242439,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242440,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242441,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242444,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242447,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242456,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242454,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244431,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242451,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242477,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242467,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242470,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242465,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242469,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242472,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242466,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241700,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242480,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242481,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242482,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242484,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242485,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245203,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242501,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242502,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242506,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242504,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242505,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242507,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242508,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242512,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242513,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242514,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,243543,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,243544,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,243540,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,243541,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244112,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244115,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241780,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244072,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244875,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241784,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245246,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245317,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245366,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241789,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241790,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244237,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244238,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11244236,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245704,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245737,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245741,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245792,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11245936,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242058,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246013,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246031,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246145,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246352,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246378,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246421,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246419,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,241698,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,242292,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246466,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246511,%' ESCAPE '!'
OR  CONCAT(',',text_property_ids,',') LIKE '%,11246526,%' ESCAPE '!'
 )
AND `language` = 'en'
AND `status` = 'ACTIVED'
AND `number_venta` = 1
AND `id` != '815'
AND  `text_province` LIKE '%BARCELONA%' ESCAPE '!'
AND `text_latitude` >= 41.361979854955
AND `text_latitude` <= 41.452069945045
AND `text_longitude` >= 2.098224854955
AND `text_longitude` <= 2.188314945045
AND `number_economy` = '0'
GROUP BY `id`
ORDER BY `number_premium` DESC, `number_habitaciones` DESC, `number_alquilerprecio`, `number_ventaprecio`, `number_superficieutil` DESC
 LIMIT 21--><!doctype html>
<html lang="en-GB">

    <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<script id="Cookiebot" src="https://consent.cookiebot.com/uc.js" data-cbid="6d4a652a-2129-43b9-81f7-a51c2e37b33b" data-blockingmode="auto" type="text/javascript"></script>

    <link rel="shortcut icon" href="https://www.rightplace.es/assets/themes/www.rightplace.es/img/rightplace-favicon.png" type="image/png"/>

    <title>Putxet Calm</title>

    <meta name="robots" content="">
        <meta name="description" content="Main features
With an area of 80 m&sup2;, this apartment has two double bedrooms, a spacious living-dining room with natural light, and a separate kitchen that connects to a practical patio. It has a complete bathroom with bathtub and bidet, as well as gas radiator heating for greater comfort. 

Extras
The building has an elevator and doorman, guaranteeing comfort and security. In addition, you have the option of acquiring a parking space for 28,000 &euro;, ideal to complete this fantastic opportunity.

Privileged location
With excellent connectivity, Putxet station (Line 7 of Ferrocarrils de la Generalitat) and several bus lines nearby allow easy access to the entire city.">

    <!-- OpenGraph -->
    <meta property="og:type" content="website" />
    <meta property="og:site_name" content="">
    <meta property="og:title" content="Putxet Calm" />
            <meta property="og:url" content="https://www.rightplace.es/en/apartments/putxet-calm" />
    
      
        <meta property="og:image" content="" />
        <meta property="og:description" content="Main features
With an area of 80 m&sup2;, this apartment has two double bedrooms, a spacious living-dining room with natural light, and a separate kitchen that connects to a practical patio. It has a complete bathroom with bathtub and bidet, as well as gas radiator heating for greater comfort. 

Extras
The building has an elevator and doorman, guaranteeing comfort and security. In addition, you have the option of acquiring a parking space for 28,000 &euro;, ideal to complete this fantastic opportunity.

Privileged location
With excellent connectivity, Putxet station (Line 7 of Ferrocarrils de la Generalitat) and several bus lines nearby allow easy access to the entire city.">

    <!-- TwitterCard -->
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:url" content="https://www.rightplace.es/en/apartments/putxet-calm">    <meta name="twitter:title" content="Putxet Calm">
    <meta name="twitter:text:description" content="Main features
With an area of 80 m&sup2;, this apartment has two double bedrooms, a spacious living-dining room with natural light, and a separate kitchen that connects to a practical patio. It has a complete bathroom with bathtub and bidet, as well as gas radiator heating for greater comfort. 

Extras
The building has an elevator and doorman, guaranteeing comfort and security. In addition, you have the option of acquiring a parking space for 28,000 &euro;, ideal to complete this fantastic opportunity.

Privileged location
With excellent connectivity, Putxet station (Line 7 of Ferrocarrils de la Generalitat) and several bus lines nearby allow easy access to the entire city." />
            <meta name="twitter:image:src" content="https://www.rightplace.es/">
    
    <!-- Alternates y Hreflang -->
            <link href="https://www.rightplace.es/en/apartments/putxet-calm" rel="canonical" />
        <link href="https://www.rightplace.es/en/apartments/putxet-calm" hreflang="x-default" rel="alternate" />

                    <link href="https://www.rightplace.es/apartamentos/putxet-calm" hreflang="es" rel="alternate" />
        
        <link href="https://www.rightplace.es/en/apartments/putxet-calm" hreflang="en" rel="alternate" />
    
            <!-- Google Tag Manager -->
        <script>
            (function (w, d, s, l, i) {
                w[l] = w[l] || [];
                w[l].push({'gtm.start':
                        new Date().getTime(), event: 'gtm.js'});
                var f = d.getElementsByTagName(s)[0],
                    j = d.createElement(s), dl = l != 'dataLayer' ? '&l=' + l : '';
                j.async = true;
                j.src =
                    'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
                f.parentNode.insertBefore(j, f);
            })(window, document, 'script', 'dataLayer', 'GTM-PD7WBLN');
        </script>
        <!-- END Google Tag Manager -->
    
    <script type="text/javascript">
        var BASE_URL = "https://www.rightplace.es/";
        var THEME_PATH = "assets/themes/www.rightplace.es/";
        var HOTEL_LAT = "";
        var HOTEL_LON = "";
    </script
	
    <!-- JS -->
    <script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
    <script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>

    <script type="application/ld+json">
{
  "@context": "https://schema.org",
  "@type": "RealEstateAgent",
  "name": "RightPlace",
  "url": "https://www.rightplace.es/",
  "logo": "https://www.rightplace.es/assets/themes/www.rightplace.es/img/logos/RP_Logotype_Claim_Color_R.svg",
  "description": "RightPlace es una plataforma que conecta a propietarios con inquilinos y compradores interesados en alquilar o comprar propiedades.",
  "address": {
    "@type": "PostalAddress",
    "streetAddress": "Carrer Aragó 312, bajos",
    "addressLocality": "Barcelona",
    "postalCode": "08009",
    "addressCountry": "ES"
  },
  "contactPoint": {
    "@type": "ContactPoint",
    "telephone": "+34 933041860",
    "contactType": "customer service",
    "areaServed": "ES",
    "availableLanguage": ["Spanish", "English"]
  },
  "sameAs": [
    "https://www.facebook.com/rightplace.apartments",
    "https://www.instagram.com/rightplace.es",
    "https://www.linkedin.com/company/rightplace-apartments/"
  ]
}
</script>

<script>
function get_landings ()
{
	foo= $('html').attr('lang');
  	if ( foo =='en-GB' ) {
	  foo= 'en';
	} 
  	else
	{
		foo='es';
	} 
  	$.ajax({
    type: 'POST',
    url: 'https://www.rightplace.es/blog/wp-content/themes/oceanwp-child/get-landings-coco.ajax.php?lang_=' + foo,
    dataType: "html", // add data type
    success: function( data ) {
        
	  $('footer').last().find('.container').append(data);      
	  $('body > footer > div > div.row.justify-content-center > div:nth-child(4) > ul').append('<li><a class="toggle_lnd">Landings</a></li>');
	  $('.toggle_lnd').click ( function (){  $('.landings_coco_wawa').slideToggle();  });
        
    }
});
  

} 
 
$(document).ready ( function (){

	get_landings ();
  
  $('.nav-top a:first-child, .nav-top a:nth-child(2).nav-top a:nth-child(3), a[href="tel:+34 675 29 12 64"], a[href="tel:+34675291264"],a[href="tel:+34933041860"],a[href="tel:+34933041860 "]').click ( function(){
  	
	faa = $(this).attr('href');
 
	gtag('event', 'click_telefono', {'event_category': 'lead_coco','event_label': faa});
	ga('send', 'event', 'lead_coco', 'click_telefono',faa);
  });
  
  $('a[href="mailto:info@rightplace.es"]').click ( function(){
  	gtag('event', 'click_email', {'event_category': 'lead_coco'});
  	ga('send', 'event', 'lead_coco', 'click_email'); 
  });
  $('a[href="https://wa.me/34635691079"]').click ( function(){
	gtag('event', 'click_whatsapp', {'event_category': 'lead_coco'});
	ga('send', 'event', 'lead_coco', 'click_whatsapp');
  });
  $('a[href="https://www.rightplace.es/contacto"]').click ( function(){

	gtag('event', 'click_pag_contacto', {'event_category': 'lead_coco'});
	ga('send', 'event', 'lead_coco', 'click_pag_contacto');
  });
  
  /* Formulario página principal */
  $('#contacto .btn').click( function(){
  	
  		var foo = $('#contacto #nombre').val() + ' ' + $('#contacto #apellidos').val() + ' ' + $('#contacto #email').val() + '  ' + $('#contacto #telefono').val() ;  
  		gtag('event', 'click_boton_formulario_main', {'event_category': 'lead_coco','event_label': foo});
		ga('send', 'event', 'lead_coco', 'click_boton_formulario_main',foo);
		
	
  });
  
  
});
  
</script>
<style>
  .landings_coco_wawa .item {margin-bottom:8px;}
  .d-info-text-img .b-info.order-md-1>div {z-index: 1;}
</style>
	<link rel="preconnect" href="https://consentcdn.cookiebot.com">
	<link rel="preconnect" href="https://fonts.googleapis.com">
	<link rel="preconnect" href="https://code.jquery.com">
	<link rel="preconnect" href="https://unpkg.com">
	<link rel="preconnect" href="https://cdnjs.cloudflare.com">
	<link rel="preconnect" href="https://maps.googleapis.com">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/bootstrap.min.css">
	<link rel="stylesheet" type="text/css" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/custom.min.css?v=5" />
	<!-- Start Insights Pixel --> <script> var tD=(new Date).toISOString().slice(0,10);window.sfpid = 896290;var u="https://app.serviceform.com/analytics/sf-pixel.js?"+tD,t=document.createElement("script");t.setAttribute("type","text/javascript"),t.setAttribute("src",u),t.async=!0,(document.getElementsByTagName("head")[0]||document.documentElement).appendChild(t); </script> <!-- End Insights Pixel -->
</head>

	    <body>

                    <!-- Google Tag Manager (noscript) -->
            <noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-PD7WBLN"
                              height="0" width="0" style="display:none; visibility:hidden"></iframe></noscript>
            <!-- End Google Tag Manager (noscript) -->
        
        <header>
<nav class="navbar nav-top">
    <div class="container">
        <div class="nav-top">
            <p>
                <span class="item">Barcelona: <a href="tel:+34 933 04 18 60" target="_blank" rel="noopener">+34 933 04 18 60</a></span>
                <span class="d-none d-md-inline-block">|</span>
				<span class="item">Madrid: <a href="tel:+34 91 048 19 02" target="_blank" rel="noopener">+34 91 048 19 02</a></span>
                <span class="d-none d-md-inline-block">|</span>
                <a href="mailto:comercial@rightplace.es" target="_blank" rel="noopener"> comercial@rightplace.es</a>
                <span>|</span>
                <a href="https://wa.me/34635691079" target="_blank" rel="noopener"> <img class="ml-2" src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/whatsapp.svg" alt="Rightplace Whatsapp" title="Whatsapp" height="auto" width="17"></a>
            </p>
        </div>
    </div>
</nav>
<nav class="navbar block-menu">
    <div class="container">
        <ul class="nav navbar-nav ubicacion">
            <li class="logo">
                <a href="https://www.rightplace.es/en/">
                    <img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/logos/RP_Logotype_Claim_Color_R.svg" alt="Rightplace" title="Rightplace">
                    <p>Rightplace<br><span>Apartments that fit your life</span></p>
                </a>
            </li>
        </ul>
        <ul class="nav navbar-nav menu">
            				<li class="dropdown">
					<a href="#">Rent</a>
																																																<div class="dropdown-menu level1">
								<div class="dropdown-menu-inner">
									<div class="row">
										<div class="col-sm-12">
											<div class="inner">
												<ul class="list-unstyled p-0">
																											<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/long-term-rental"><span class="menu-title">Rent</span></a></li>
																																																																		<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/cities/rent-apartments-barcelona"><span class="menu-title">Apartments in  Barcelona</span></a></li>
																					<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/cities/rent-apartments-madrid"><span class="menu-title">Apartments in  Madrid</span></a></li>
																<li class="nav-item"><a class="nav-link" href="/apartamentos?premium=1"><span class="menu-title">Premium Apartments</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/how-it-works"><span class="menu-title">How it works</span></a></li>
																																																																																																				
												</ul>
											</div>
										</div>
									</div>
								</div>
							</div>
									</li>
            				<li class="dropdown">
					<a href="#">Owners</a>
																																																																																	<div class="dropdown-menu level1">
								<div class="dropdown-menu-inner">
									<div class="row">
										<div class="col-sm-12">
											<div class="inner">
												<ul class="list-unstyled p-0">
																											<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/our-services"><span class="menu-title">Our services</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/owners"><span class="menu-title">Owners</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/renovation-interior-design"><span class="menu-title">Renovation and decoration</span></a></li>
																																																																																<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/en/property-valuation"><span class="menu-title">Property valuation</span></a></li>
																																		
												</ul>
											</div>
										</div>
									</div>
								</div>
							</div>
									</li>
            											<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/en/buy-apartments"><span class="menu-title">Sale</span></a>
				</li>
																																																									<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/en/about-us"><span class="menu-title">About us</span></a>
				</li>
															<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/en/equipo"><span class="menu-title">Our team</span></a>
				</li>
																						<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/en/press"><span class="menu-title">News</span></a>
				</li>
							
            <li><a href="https://www.rightplace.es/blog/en/" target="_blank">Blog</a></li>
            <li class="login"><a href="https://administraciononline.aspasios.com/" class="btn" target="_blank">Login</a></li>
                                                <li class="lang"><a href="https://www.rightplace.es/es/change-language">ES</a></li>
                                                                    <!--<div class="langs">
                <li><a href="">Español</a></li>
            </div>-->
        </ul>
        <ul id="menu-toggle" class="nav navbar-nav d-lg-none">
                                                <li class="lang"><a href="https://www.rightplace.es/es/change-language">ES</a></li>
                                                                    <li class="burguer-icon">
                <div id="nav-icon">
                    <span></span>
                    <span></span>
                    <span></span>
                    <span></span>
                </div>
            </li>

        </ul>
    </div>
</nav>

<div class="overlay overlay-slideright">
    <nav>
        <div class="container-fluid">
            <div class="row justify-content-end">
                <div class="display-table">
                    <div class="display-table-cell text-center">
                        <!--<a href=""><img src="img/logos/micenexus-logo.svg" alt="Micenexus" title="Micenexus"></a>-->
                        <ul class="list-unstyled">
													<li class="item">
								<a href="#">Rent</a>
							</li>
																																																												
											<li class="subitem">><a href="https://www.rightplace.es/en/long-term-rental">Rent</a></li>
																																																																									<li class="subitem"><a href="https://www.rightplace.es/en/cities/rent-apartments-barcelona">Barcelona</a></li>
																											<li class="subitem"><a href="https://www.rightplace.es/en/cities/rent-apartments-madrid">Madrid</a></li>
																																																																									
											<li class="subitem">><a href="https://www.rightplace.es/en/how-it-works">How it works</a></li>
																																																																																																																																																															<li class="item">
								<a href="#">Owners</a>
							</li>
																																																																																																															
											<li class="subitem">><a href="https://www.rightplace.es/en/our-services">Our services</a></li>
																																																														
											<li class="subitem">><a href="https://www.rightplace.es/en/owners">Owners</a></li>
																																																														
											<li class="subitem">><a href="https://www.rightplace.es/en/renovation-interior-design">Renovation and decoration</a></li>
																																																																																																
											<li class="subitem">><a href="https://www.rightplace.es/en/property-valuation">Property valuation</a></li>
																																																		                            								                                <li class="item">><a href="https://www.rightplace.es/en/buy-apartments">Sale</a></li>
								                            								                            								                            								                            								                            								                            								                            								                                <li class="item">><a href="https://www.rightplace.es/en/about-us">About us</a></li>
								                            								                                <li class="item">><a href="https://www.rightplace.es/en/equipo">Our team</a></li>
								                            								                            								                                <li class="item">><a href="https://www.rightplace.es/en/press">News</a></li>
								                                                    </ul>
                        <div class="block-info text-center">
                            <<p>
                                                                <a class="mx-1" href="https://www.facebook.com/Rightplace-103179138424863" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/facebook.svg" alt="Facebook" title="Facebook" height="30"></a>
                                                                                                <a class="mx-1" href="https://instagram.com/rightplace.es" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/instagram.svg" alt="Instagram" title="Instagram" height="30"></a>
                                                                																	<a class="mx-1" href="https://www.linkedin.com/company/rightplace-apartments/" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/linkedin.svg" alt="Linkedin" title="Linkedin" height="30"></a>
																									<a class="mx-1" href="https://g.page/Rightplace-apartm" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/google.svg" alt="Google My Business" title="Google My Business" height="30"></a>
								                            </p>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </nav>
</div>
</header>
    <section class="section-ficha-piso">
    <div class="container-fluid">
        <div class="row justify-content-end">
            <div class="col-lg-6 col-xl-8 block-info-piso">
				<!-- GALLERY -->
			
				<div class="row">
					<div class="col-12 p-0">
						<div id="carouselAprt" class="carousel slide">
							<div class="carousel-inner">
								                                								<div class="carousel-item active">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/0.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/0.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/0.jpg"
												alt="Imagen slide 1" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/1.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/1.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1.jpg"
												alt="Imagen slide 2" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/2.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/2.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/2.jpg"
												alt="Imagen slide 3" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/3.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/3.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/3.jpg"
												alt="Imagen slide 4" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/4.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/4.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/4.jpg"
												alt="Imagen slide 5" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/5.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/5.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/5.jpg"
												alt="Imagen slide 6" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/6.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/6.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/6.jpg"
												alt="Imagen slide 7" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/7.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/7.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/7.jpg"
												alt="Imagen slide 8" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/8.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/8.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/8.jpg"
												alt="Imagen slide 9" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/9.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/9.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/9.jpg"
												alt="Imagen slide 10" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/10.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/10.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/10.jpg"
												alt="Imagen slide 11" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/11.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/11.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/11.jpg"
												alt="Imagen slide 12" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/12.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/12.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/12.jpg"
												alt="Imagen slide 13" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/13.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/13.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/13.jpg"
												alt="Imagen slide 14" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/14.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/14.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/14.jpg"
												alt="Imagen slide 15" loading="lazy">
									</picture>
								</div>
                                								<div class="carousel-item">
									<picture class="img-fluid" height="600" width="1800">
																				<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/15.webp" type="image/webp">
										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11246419/1500/15.jpg" type="image/jpeg">
																				<img
												src="/assets/themes/www.rightplace.es/img/product_images/image_11246419/15.jpg"
												alt="Imagen slide 16" loading="lazy">
									</picture>
								</div>
                                							</div>
						</div>
						<a class="carousel-control-prev" href="#carouselAprt" role="button" data-slide="prev">
							<span class="carousel-control-prev-icon" aria-hidden="true"></span>
							<span class="sr-only">Previous</span>
						</a>
						<a class="carousel-control-next" href="#carouselAprt" role="button" data-slide="next">
							<span class="carousel-control-next-icon" aria-hidden="true"></span>
							<span class="sr-only">Next</span>
						</a>
					</div>
				</div>
				<script>
				$('#carouselAprt').on('slide.bs.carousel', function (event) {
					$('#imCarCurrent').html ((event.to+1).toString().padStart(2, "0"));
				})
				</script>
                <!-- INTRO PISO -->
                <div class="row block-intro-piso">
                    <div class="col-12 col-md-7 order-2 order-md-1">
                        <h2 class="title">Putxet Calm</h2>
                        <!--<p class="subtitle"></p>-->
						

                        <address>						Calle Monegal</address>
                        <p class="caracteristicas">
                            								80m<sup>2</sup> · 
                                                                                        2 bedrooms ·
                                                                                                                                                1 bathroom                                                    </p>
                        					</div>
                    <div class="col-12 order-3">
                        <div class="block-text" style="width: 100%">
                            <p>Unique opportunity: 80 m² apartment to renovate in El Putxet i el Farró

With a unique style and in one of the quietest areas of Barcelona, this apartment in El Putxet i el Farró is ideal for those seeking tranquility, nature and excellent connection in an exclusive environment. Located in a semi-pedestrian street, it offers the serenity of a residential neighborhood without giving up urban amenities.<span class="click-leer-mas">more</span></p>
                            <div class="text-2">
                                <p>Main features
With an area of 80 m², this apartment has two double bedrooms, a spacious living-dining room with natural light, and a separate kitchen that connects to a practical patio. It has a complete bathroom with bathtub and bidet, as well as gas radiator heating for greater comfort. 

Extras
The building has an elevator and doorman, guaranteeing comfort and security. In addition, you have the option of acquiring a parking space for 28,000 €, ideal to complete this fantastic opportunity.

Privileged location
With excellent connectivity, Putxet station (Line 7 of Ferrocarrils de la Generalitat) and several bus lines nearby allow easy access to the entire city.</p>
                            </div>
                                                    </div>
                    </div>
					<div class="col-md-5 b-num-slider order-1 order-md-2">
						<div>
							<a class="carousel-control-prev" href="#carouselAprt" role="button" data-slide="prev">
								<span class="carousel-control-prev-icon" aria-hidden="true"></span>
								<span class="sr-only">Previous</span>
							</a>
							<a class="carousel-control-next" href="#carouselAprt" role="button" data-slide="next">
								<span class="carousel-control-next-icon" aria-hidden="true"></span>
								<span class="sr-only">Next</span>
							</a>
							<p><span id="imCarCurrent">01</span> <strong>·</strong> 16</p>
						</div>
					</div>
                </div>
								                <!-- MODAL GENERAL-->
                <!-- Modal -->
                                    <div class="modal fade" id="ModalCondition1" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">How to book?</h3>
                                    <p>Contact us with the reference name of the apartment you like, tell us the reason for your stay and the check-in and out dates.</p>

<p>We will contact you as soon as possible to confirm the availability and to give you all the details for the booking.</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition3" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Documents</h3>
                                    <p><u><strong>Documents needed</strong></u></p>

<p>- Tenant passport / NIE / ID copy</p>

<p>- Permanent address different to the one of the flat you want to book</p>

<p>- SEPA bank account (EEC)</p>

<p>- Reason for temporary stay</p>

<p><u><strong>According to your situation, please send us in addition:</strong></u></p>

<p><strong>University student or </strong><strong>specialised</strong><strong> school</strong></p>

<p>- University or school registration letter or receipt</p>

<p>- Proof of sufficient financial means to support his stay in the country and payment of rent.</p>

<p><strong>Company employees</strong></p>

<p>- Copy of the work contract</p>

<p>- Copy of the last three payrolls</p>

<p><strong>Company</strong></p>

<p>- Constitution deeds and TIN of the company</p>

<p>- Company&rsquo;s representative full power deeds and DNI /ID / NIE or passport</p>

<p>- Last tax statement</p>

<p><strong>Freelance</strong></p>

<p>- Last income tax return.</p>

<p>&nbsp;</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition2" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Estado de la solicitud</h3>
                                    <p>The acceptance of the application will be decided by the owner.</p>

<p>Aspasion Short Rentals SL will notify the result of the application to rent within a maximum of 48 hours.</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition4" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Cleaning</h3>
                                    <p>The final cleaning of the apartment is mandatory and will be the responsibility of the tenant.</p>

<p>The price is established based on the total area (m2) of the apartment and the amount will be indicated in the economic conditions of each apartment.</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition7" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Utilities<br> (water,electricity,gas,)</h3>
                                    <p>Utilities are not included in the monthly rental price. A monthly provision will be charged depending on the apartment, it can oscillate between 150 - 250 euros per month, it will be indicated in the economic conditions of each apartment.</p>

<p>These payments will be regularized at the end of the contract with the actual consumption made in the home.</p>

<p>* Please note that some apartments have a fixed amount for utilities, in which case it will be indicated in the contract.</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition6" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Check-in</h3>
                                    <p>To arrange the check-in, you must agree with your agent. The entrance to our apartments is coordinated during office hours, from 9:30 a.m. to 6:30 p.m. Monday to Friday.</p>

<p>Outside the office hours (9:30 am to 6:30 pm), during the weekend or bank holiday, 30&euro; extra will be charged.</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition8" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Contract</h3>
                                    <p>The acceptance of the application will be decided by the owner. If the contract is not formalized by the tenant, he/she will lose the amount delivered as a reservation.</p>

<p>If the contract is not formalized by the owner and/or does not accept the application to rent, the agency will return the amount paid.</p>

<p>&nbsp;</p>

<p>&nbsp;</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                    <div class="modal fade" id="ModalCondition5" tabindex="-1" role="dialog"
                         aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
                        <div class="modal-dialog modal-dialog-centered" role="document">
                            <div class="modal-content">
                                <div class="modal-body">
                                    <button type="button" class="close-modal" data-dismiss="modal"><img
                                                src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/cancel.svg"
                                                alt="cerrar"></button>
                                    <h3 class="modal-title">Payment</h3>
                                    <p>Economic conditions, the tenant needs to pay the following amounts;</p>

<p>- The proportional part of the month from the check-in date</p>

<p>- The security deposit: 2 months rent</p>

<p>- Final cleaning: according to the total area (m2) of the apartment</p>

<p>- The agency fee: depending of the contract duration</p>

<p>- Taxes related to the contract: ITP</p>

<p><strong>Booking Confirmation</strong>: to confirm the reservation, the tenant must make a prepayment corresponding to the agency fees</p>

<p><em>*Please send the bank transfer receipt by email to your contact in charge of your booking, showing the tenant name and the flat reference name</em></p>

<p><strong>Balance</strong>: the tenant must make the full payment with a minimum of 15 days before arrival at the apartment</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                <!-- SERVICIOS -->
                <div class="row block-servicios fadeIn wow" data-wow-duration="4s">
                    <hr>
                    <div class="col-12 section">Services</div>
                                                                                                                                                                                    <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Heater</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Lift</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Storage room</li>
                                </ul>
                            </div>
                                                                                                                                                                                                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Exterior</li>
                                </ul>
                            </div>
                                                                                                                                                                                                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Gas cooker</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Oven</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Microwave</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Washing machine</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Dryer</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Washer/dryer</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Fridge</li>
                                </ul>
                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Pets allowed</li>
                                </ul>
                            </div>
                                                                                                        </div>

                                    <!-- SITUACION -->
                    <div class="row block-situacion fadeIn wow" data-wow-duration="4s">
                        <hr>
                        <div class="col-12 section">Location</div>
                        <div class="col-12">
                            <div id="map-piso"></div>
                        </div>
                    </div>
                            </div>
			            <div class="col-lg-5 col-xl-3 block-fixed">
                <div class="scroll-fixed"></div>
                <div class="block-info fadeIn wow" data-wow-duration="4s">
                    <p class="precio">Sale price                        <span>458.000€</span>
                    </p>
					<div class="row">
						<div class="col-12">
							<button onclick="contactar(815,'BARCELONA')"
									type="button"
									class="btn btn-blue hvr-ripple-out">Info request</button>
														<p class="share">Share it! <a class="ml-2"
																								href="https://www.facebook.com/sharer/sharer.php?u=https://www.rightplace.es/en/apartments/putxet-calm"
																								target="_blank"><img
											src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/facebook.svg"
											alt="Facebook" title="Facebook" height="9"></a>
								<!--<a class="ml-2" href="" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/instagram.svg" alt="Instagram" title="Instagram" height="9"></a>-->
								<a class="ml-2" href="http://twitter.com/intent/tweet/?url=https://www.rightplace.es/en/apartments/putxet-calm"
								   target="_blank"><img
											src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/twitter.svg"
											alt="Twitter" title="Twitter" height="9"></a></p>
						</div>
					</div>
					<div class="row back">
						<p><a href="javascript:history.back()"><img
										src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/back.svg" width="8"
										class="mr-1">Back to your search results							</a></p>
					</div>
                </div>
            </div>
									        </div>
    </div>
</section>
<script>
    function contactar(id_apartamento, ciudad) {
        location = 'https://www.rightplace.es/en/contact?id_apartamento=' + id_apartamento + '&ciudad=' + ciudad + '&fini=' + $('#fini').val() + '&fout=' + $('#fout').val() + '#contact-form';
        return false;
    }

    function initMap() {
                var icon_map = 'https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/icon-map.svg';
        var center = {
            lat: 41.4070249,
            lng: 2.1432699        };
        var d = new google.maps.Map(document.getElementById("map-piso"), {
            zoom: 15,
            center: center,
            styles: [
                {
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#f5f5f5"
                        }
                    ]
                },
                {
                    "elementType": "labels.icon",
                    "stylers": [
                        {
                            "visibility": "off"
                        }
                    ]
                },
                {
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#616161"
                        }
                    ]
                },
                {
                    "elementType": "labels.text.stroke",
                    "stylers": [
                        {
                            "color": "#f5f5f5"
                        }
                    ]
                },
                {
                    "featureType": "administrative.land_parcel",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#bdbdbd"
                        }
                    ]
                },
                {
                    "featureType": "poi",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#eeeeee"
                        }
                    ]
                },
                {
                    "featureType": "poi",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#757575"
                        }
                    ]
                },
                {
                    "featureType": "poi.park",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#e5e5e5"
                        }
                    ]
                },
                {
                    "featureType": "poi.park",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#9e9e9e"
                        }
                    ]
                },
                {
                    "featureType": "road",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#ffffff"
                        }
                    ]
                },
                {
                    "featureType": "road.arterial",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#757575"
                        }
                    ]
                },
                {
                    "featureType": "road.highway",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#dadada"
                        }
                    ]
                },
                {
                    "featureType": "road.highway",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#616161"
                        }
                    ]
                },
                {
                    "featureType": "road.local",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#9e9e9e"
                        }
                    ]
                },
                {
                    "featureType": "transit.line",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#e5e5e5"
                        }
                    ]
                },
                {
                    "featureType": "transit.station",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#eeeeee"
                        }
                    ]
                },
                {
                    "featureType": "water",
                    "elementType": "geometry",
                    "stylers": [
                        {
                            "color": "#c9c9c9"
                        }
                    ]
                },
                {
                    "featureType": "water",
                    "elementType": "labels.text.fill",
                    "stylers": [
                        {
                            "color": "#9e9e9e"
                        }
                    ]
                }
            ]
        });
        var c = "";
        var a = new google.maps.Marker({
            position: center,
            map: d,
            icon: icon_map
        })
            }
</script>
<script>
    var waitForJQuery_cabecera = setInterval(function () {
        if (typeof $ != 'undefined') {
            $(window).load(function () {

                Date.prototype.formatDDMMYYYY = function () {
                    return this.getDate() + "/" +
                        (this.getMonth() + 1) + "/" +
                        this.getFullYear();
                }
                var nextDate = new Date();

                var checkinDefault = new Date();
                if (!$('#fini').val()) $('#fini').val(checkinDefault.formatDDMMYYYY());

                var checkoutDefault = new Date();
                checkoutDefault.setMonth(checkoutDefault.getMonth() + 1);
                if (!$('#fout').val()) $('#fout').val(checkoutDefault.formatDDMMYYYY());

                var dateFormato = "dd/mm/yy",
                    from = $("#fini")
                        .datepicker({
                            dateFormat: 'dd/mm/yy',
                            defaultDate: +0,
                            minDate: checkinDefault,
                            changeMonth: false,
                            numberOfMonths: 1
                        })
                        .on("change", function () {
                            nextDate = getDateFormat(this);
                            nextDate.setDate(nextDate.getDate() + 1);
                            from.datepicker("setDate", getDateFormat(this));
                            this.blur();
                            var bookElement = $(this);
                            setTimeout(function () {
                                bookElement.parents('.form-book').find('.checkout').datepicker('show');
                            }, 100);
                            $("#fout").datepicker("option", "minDate", getDateFormat(this));
                            $("#fout").datepicker("setDate", nextDate);
                        }),
                    to = $("#fout")
                        .datepicker({
                            dateFormat: 'dd/mm/yy',
                            defaultDate: +2,
                            changeMonth: false,
                            numberOfMonths: 1
                        })
                        .on("change", function () {
                            to.datepicker("setDate", getDateFormat(this));
                            this.blur();
                        });

                function getDateFormat(element) {
                    var date;
                    try {
                        date = $.datepicker.parseDate(dateFormato, element.value);
                    } catch (error) {
                        date = null;
                    }

                    return date;
                }
            });
            clearInterval(waitForJQuery_cabecera);
        }
    }, 100);
</script>

<script>
    $(document).ready(function () {

        $(window).scroll(scroll);
        $(window).resize(scroll);
        $(window).ready(scroll);
        scroll();

    });

    function scroll() {
        var windowHeight = $(window).scrollTop();
        var contenido = $(".scroll-fixed").offset();
        contenido = contenido.top;
        if (windowHeight > contenido) {
            $('.block-fixed .block-info').addClass('scroll');
            $('#map-resultados').addClass('scroll');
        }
        if (windowHeight <= contenido) {
            $('.block-fixed .block-info').removeClass('scroll');
            $('#map-resultados').removeClass('scroll');
        }
    }
</script>
<section class="section-otros">
    <div class="container-fluid">
        <div class="row justify-content-center">
            <div class="col-md-10 fadeIn wow" data-wow-duration="4s">
                <div class="row">
                    <div class="col-12">
                        <h2 class="title">Other apartments</h2>
                    </div>
                </div>
                <div class="row justify-content-center">
                    <div class="col-10 col-md-12">
                        <div class="carousel" data-flickity='{ "groupCells": true,"draggable": true,"pageDots": false, "wrapAround": true }'>
                                                        <!-- PISO -->
                            <div class="carousel-cell">
                                <div id="carouselpiso-1" class="carousel slide" data-ride="carousel">
								                                                                                                                                                                    <div class="carousel-item active">
                                                <a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/canet-house/">
												<picture>
																										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11245246/1500/0.webp" type="image/webp">
													<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_11245246/1500/0.jpg" type="image/jpeg">
																										<img class="d-block img-fluid w-100"
															src="/assets/themes/www.rightplace.es/img/product_images/image_11245246/0.jpg"
															alt="Imagen slide 1" loading="lazy">
												</picture>
												</a>
                                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	
									                                </div>

																	<div class="b-disponible">
										<p class="disponiblidad">
											<img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/disponible.svg" width="20" alt="disponible" title="disponible">
											Available										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/canet-house/">Canet House</a></p>
									<p class="precio"><span>425.000€</span>/month</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/canet-house/" class="btn btn-blue hvr-ripple-out">Details</a>
									</div>
								</div>
                            </div>
                                                        <!-- PISO -->
                            <div class="carousel-cell">
                                <div id="carouselpiso-1" class="carousel slide" data-ride="carousel">
								                                                                                                                                                                    <div class="carousel-item active">
                                                <a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/muntaner-style-venta/">
												<picture>
																										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242513/1500/0.webp" type="image/webp">
													<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242513/1500/0.jpg" type="image/jpeg">
																										<img class="d-block img-fluid w-100"
															src="/assets/themes/www.rightplace.es/img/product_images/image_242513/0.jpg"
															alt="Imagen slide 1" loading="lazy">
												</picture>
												</a>
                                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	
									                                </div>

																	<div class="b-disponible">
										<p class="disponiblidad">
											<img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/disponible.svg" width="20" alt="disponible" title="disponible">
											Available										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/muntaner-style-venta/">Muntaner Style Venta</a></p>
									<p class="precio"><span>790.000€</span>/month</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/muntaner-style-venta/" class="btn btn-blue hvr-ripple-out">Details</a>
									</div>
								</div>
                            </div>
                                                        <!-- PISO -->
                            <div class="carousel-cell">
                                <div id="carouselpiso-1" class="carousel slide" data-ride="carousel">
								                                                                                                                                                                    <div class="carousel-item active">
                                                <a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/casp-luxury-b-venta/">
												<picture>
																										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242385/1500/0.webp" type="image/webp">
													<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242385/1500/0.jpg" type="image/jpeg">
																										<img class="d-block img-fluid w-100"
															src="/assets/themes/www.rightplace.es/img/product_images/image_242385/0.jpg"
															alt="Imagen slide 1" loading="lazy">
												</picture>
												</a>
                                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	
									                                </div>

																	<div class="b-disponible">
										<p class="disponiblidad">
											<img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/disponible.svg" width="20" alt="disponible" title="disponible">
											Available										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/casp-luxury-b-venta/">Casp Luxury B Venta</a></p>
									<p class="precio"><span>1.175.000€</span>/month</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/casp-luxury-b-venta/" class="btn btn-blue hvr-ripple-out">Details</a>
									</div>
								</div>
                            </div>
                                                        <!-- PISO -->
                            <div class="carousel-cell">
                                <div id="carouselpiso-1" class="carousel slide" data-ride="carousel">
								                                                                                                                                                                    <div class="carousel-item active">
                                                <a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/santa-caterina-venta/">
												<picture>
																										<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242430/1500/0.webp" type="image/webp">
													<source srcset="/assets/themes/www.rightplace.es/img/product_images/image_242430/1500/0.jpg" type="image/jpeg">
																										<img class="d-block img-fluid w-100"
															src="/assets/themes/www.rightplace.es/img/product_images/image_242430/0.jpg"
															alt="Imagen slide 1" loading="lazy">
												</picture>
												</a>
                                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                	
									                                </div>

																	<div class="b-disponible">
										<p class="disponiblidad">
											<img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/disponible.svg" width="20" alt="disponible" title="disponible">
											Available										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/santa-caterina-venta/">Santa Caterina Venta</a></p>
									<p class="precio"><span>250.000€</span>/month</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/en/apartments/santa-caterina-venta/" class="btn btn-blue hvr-ripple-out">Details</a>
									</div>
								</div>
                            </div>
                                                    </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</section>
<script>
    function verDetalles (link) {
        if ($('#fini').val()) {
            location = link+'?fini='+$('#fini').val();
        } else if ($('#fini-header').val()) {
            location = link+'?fini='+$('#fini-header').val();
        } else {
            location = link+'?fini=18/01/2025';
        }
        return false;
    }
</script>
<section class="section-text-btn" style="position: relative;">
    <div id="form" style="position: absolute;top:50px;"></div>
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-12 text-center fadeIn wow" data-wow-duration="4s">
                <p>Need help?<br> Delighted to help you.</p>
				                <a href="https://www.rightplace.es/en/contact" class="btn btn-gray hvr-ripple-out">Contact us</a>
				            </div>
			        </div>
    </div>
</section>
<footer>
  <div class="container">
	<div class="row justify-content-center">
	  <div class="col-sm-12 col-md-6 icologo">
		<p class="logo-text">We are members of:</p>
		            
<picture>
			<source data-srcset="medium://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_cluster_inmobiliario.webp" type="image/webp">
		<img data-src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_cluster_inmobiliario.webp"
		 class=""  		 loading="lazy"
		 src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_cluster_inmobiliario.webp"
		 alt="rightplace-es-miembro-de-cluster-inmobiliario"
		 title="rightplace-colabora-con-csimrightplace-es-miembro-de-cluster-inmobiliarioa">
</picture>
		            
<picture>
			<source data-srcset="medium://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_api_cat.webp" type="image/webp">
		<img data-src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_api_cat.webp"
		 class=""  		 loading="lazy"
		 src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/en/rightplace_es_miembro_de_api_cat.webp"
		 alt="rightplace-es-miembro-de-api-catrightplace-es-miembro-de-api-cat"
		 title="rightplace-es-miembro-de-api-cat">
</picture>
			  </div>
	</div>
  </div>
</footer>
<footer>
    <div class="container">
        <div class="row justify-content-center">
            <div class="col-sm-6 col-md-2">
                <p class="title-text">Language</p>
                <select onchange="location='https://www.rightplace.es/' + this.value + '/change-language'" id="lang-footer" class="form-control rounded-0" name="lang-footer">
                                            <option value="es">Español</option>
                                            <option value="en" selected="">English</option>
                                    </select>
                            </div>
            <div class="col-sm-6 col-md-2">
                <p class="title-text">Rightplace</p>
                <ul class="list-unstyled">
                    <li><a href="https://www.rightplace.es/en/long-term-rental">Rent</a></li>
                    <li><a href="https://www.rightplace.es/en/how-it-works">How it works</a></li>
                    <li><a href="https://www.rightplace.es/en/owners">Owners</a></li>
                    <li><a href="https://www.rightplace.es/en/buy-apartments">Sale</a></li>
                    <li><a href="/apartamentos?economy=1">Basic Apartments</a></li>
                    <li><a href="https://www.rightplace.es/en/our-services">Our services</a></li>
                    <li><a href="https://www.rightplace.es/en/about-us">About us</a></li>
                    <li><a href="https://www.rightplace.es/en/contact">Contact</a></li>
                    <li><a href="https://www.rightplace.es/blog" target="_blank">Blog</a></li>
                </ul>
            </div>
            <div class="col-sm-6 col-md-2">
                <p class="title-text">Aspasios leisure</p>
                <ul class="list-unstyled">
                                        <li><a href="https://www.aspasios.com/apartments-barcelona/">Barcelona</a></li>
                    <li><a href="https://www.aspasios.com/apartments-madrid/">Madrid</a></li>

                </ul>
            </div>
            <div class="col-sm-6 col-md-2">
                <p class="title-text">General info</p>
                <ul class="list-unstyled">
                    <li><a href="https://www.rightplace.es/en/cookies-policy">Cookies policy</a></li>
                    <li><a href="https://www.rightplace.es/en/terms-and-conditions">Terms & conditions</a></li>
                    <li><a href="https://www.rightplace.es/en/faqs">FAQs</a></li>
                    <li><a href="https://www.rightplace.es/en/privacy-policy">Privacy policy</a></li>
                    <li><a href="https://www.rightplace.es/en/legal-warning">Legal warning</a></li>
                </ul>
            </div>
            <div class="col-sm-6 col-md-2">
                <p class="title-text">Contact</p>
                                    <p>Barcelona: <a href="tel:+34 93 304 18 60 ">+34 93 304 18 60 </a><br>
                        Carrer Aragó 312, bajos<br>
                        08009 Barcelona</p>
                    <hr />
                                    <p>Madrid: <a href="tel:+34 91 048 19 02">+34 91 048 19 02</a><br>
                        Calle Gran Vía, 6<br>
                        28004</p>
                    <hr />
                            </div>
            <div class="col-sm-6 icons-social">
                                <a class="mr-2" href="https://www.facebook.com/Rightplace-103179138424863" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/facebook.svg" alt="Facebook" title="Facebook" height="30"></a>
                                                    <a class="mr-2" href="https://instagram.com/rightplace.es" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/instagram.svg" alt="Instagram" title="Instagram" height="30"></a>
                                                                    <a class="mr-2" href="https://www.linkedin.com/company/rightplace-apartments/" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/linkedin.svg" alt="Linkedin" title="Linkedin" height="30"></a>
                                                    <a class="mr-2" href="https://g.page/Rightplace-apartm" target="_blank"><img src="https://www.rightplace.es/assets/themes/www.rightplace.es/img/icons/google.svg" alt="Google My Business" title="Google My Business" height="30"></a>
                            </div>
        </div>
    </div>
</footer>
    </body>
    <!-- CSS -->
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/bootstrap.min.css">
	<link rel="stylesheet" type="text/css" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/custom.min.css?v=5" />
	
    <link href="https://fonts.googleapis.com/css?family=Montserrat:300,400,500,700,900" rel="stylesheet" media="none" onload="if(media!=='all')media='all'">
    <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.min.css" media="none" onload="if(media!=='all')media='all'">
    <link rel="stylesheet" href="https://unpkg.com/flickity@2/dist/flickity.min.css" media="none" onload="if(media!=='all')media='all'">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/animate.min.css"  media="none" onload="if(media!=='all')media='all'">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/hover-min.css"  media="none" onload="if(media!=='all')media='all'">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/twentytwenty.css"  media="none" onload="if(media!=='all')media='all'">
	<link rel="stylesheet" type="text/css" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/custom2.min.css?v=4"  media="none" onload="if(media!=='all')media='all'" />
	<noscript>
    <link href="https://fonts.googleapis.com/css?family=Montserrat:300,400,500,700,900" rel="stylesheet">
    <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
    <link rel="stylesheet" href="https://unpkg.com/flickity@2/dist/flickity.min.css">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/animate.min.css">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/hover-min.css">
    <link rel="stylesheet" href="https://www.rightplace.es/assets/themes/www.rightplace.es/css/twentytwenty.css">
	</noscript>
    
    <!-- JS -->
    <script src="https://unpkg.com/flickity@2/dist/flickity.pkgd.min.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.11.0/umd/popper.min.js" integrity="sha384-b/U6ypiBEHpOf/4+1nzFpr53nxSS+GLCkfwBdFNTxtclqqenISfwAzpKaMNFNmj4" crossorigin="anonymous"></script>
	<script src="https://www.rightplace.es/assets/themes/www.rightplace.es/js/bootstrap.min.js"></script>
    <script src="https://www.rightplace.es/assets/themes/www.rightplace.es/js/wow.min.js"></script>
    <script src="https://www.rightplace.es/assets/themes/www.rightplace.es/js/jquery.event.move.js"></script>
    <script src="https://www.rightplace.es/assets/themes/www.rightplace.es/js/jquery.twentytwenty.js"></script>
        <script src="https://www.rightplace.es/assets/themes/www.rightplace.es/js/custom.min.js?v=1"></script>

    
			<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCPU5QAadPvVSsOONtokYcyoWvP0_ABq24&callback=initMap" async defer></script>
			
	<script>new WOW().init();</script>


</html>