<!--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` = 'es'
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="es-ES">

    <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 | Rightplace Barcelona</title>

    <meta name="robots" content="">
            <meta name="keywords" content="Apartamento, venta, Barcelona, Putxet Calm">
        <meta name="description" content="Caracter&iacute;sticas principales
Con una superficie de 80 m&sup2;, esta vivienda cuenta con dos habitaciones dobles, un sal&oacute;n-comedor espacioso y con luz natural, y una cocina independiente que conecta con un pr&aacute;ctico patio. Dispone de un ba&ntilde;o completo con ba&ntilde;era y bidet, adem&aacute;s de calefacci&oacute;n mediante radiadores de gas para mayor confort. 

Extras
El edificio dispone de ascensor y portero, garantizando comodidad y seguridad. Adem&aacute;s, tienes la opci&oacute;n de adquirir una plaza de parking por 28.000 &euro;, ideal para completar esta fant&aacute;stica oportunidad.

Ubicaci&oacute;n privilegiada
Con excelente conectividad, la estaci&oacute;n de Putxet (L&iacute;nea 7 de los Ferrocarrils de la Generalitat) y varias l&iacute;neas de autob&uacute;s cercanas permiten un f&aacute;cil acceso a toda la ciudad.


Para cualquier informaci&oacute;n adicional, &iexcl;no dudes en contactar con nosotros!">

    <!-- OpenGraph -->
    <meta property="og:type" content="website" />
    <meta property="og:site_name" content="">
    <meta property="og:title" content="Putxet Calm | Rightplace Barcelona" />
            <meta property="og:url" content="https://www.rightplace.es/apartamentos/putxet-calm" />
    
      
        <meta property="og:image" content="" />
        <meta property="og:description" content="Caracter&iacute;sticas principales
Con una superficie de 80 m&sup2;, esta vivienda cuenta con dos habitaciones dobles, un sal&oacute;n-comedor espacioso y con luz natural, y una cocina independiente que conecta con un pr&aacute;ctico patio. Dispone de un ba&ntilde;o completo con ba&ntilde;era y bidet, adem&aacute;s de calefacci&oacute;n mediante radiadores de gas para mayor confort. 

Extras
El edificio dispone de ascensor y portero, garantizando comodidad y seguridad. Adem&aacute;s, tienes la opci&oacute;n de adquirir una plaza de parking por 28.000 &euro;, ideal para completar esta fant&aacute;stica oportunidad.

Ubicaci&oacute;n privilegiada
Con excelente conectividad, la estaci&oacute;n de Putxet (L&iacute;nea 7 de los Ferrocarrils de la Generalitat) y varias l&iacute;neas de autob&uacute;s cercanas permiten un f&aacute;cil acceso a toda la ciudad.


Para cualquier informaci&oacute;n adicional, &iexcl;no dudes en contactar con nosotros!">

    <!-- TwitterCard -->
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:url" content="https://www.rightplace.es/apartamentos/putxet-calm">    <meta name="twitter:title" content="Putxet Calm | Rightplace Barcelona">
    <meta name="twitter:text:description" content="Caracter&iacute;sticas principales
Con una superficie de 80 m&sup2;, esta vivienda cuenta con dos habitaciones dobles, un sal&oacute;n-comedor espacioso y con luz natural, y una cocina independiente que conecta con un pr&aacute;ctico patio. Dispone de un ba&ntilde;o completo con ba&ntilde;era y bidet, adem&aacute;s de calefacci&oacute;n mediante radiadores de gas para mayor confort. 

Extras
El edificio dispone de ascensor y portero, garantizando comodidad y seguridad. Adem&aacute;s, tienes la opci&oacute;n de adquirir una plaza de parking por 28.000 &euro;, ideal para completar esta fant&aacute;stica oportunidad.

Ubicaci&oacute;n privilegiada
Con excelente conectividad, la estaci&oacute;n de Putxet (L&iacute;nea 7 de los Ferrocarrils de la Generalitat) y varias l&iacute;neas de autob&uacute;s cercanas permiten un f&aacute;cil acceso a toda la ciudad.


Para cualquier informaci&oacute;n adicional, &iexcl;no dudes en contactar con nosotros!" />
            <meta name="twitter:image:src" content="https://www.rightplace.es/">
    
    <!-- Alternates y Hreflang -->
            <link href="https://www.rightplace.es/apartamentos/putxet-calm" rel="canonical" />
        <link href="https://www.rightplace.es/apartamentos/putxet-calm" hreflang="x-default" rel="alternate" />

                    <link href="https://www.rightplace.es/en/apartments/putxet-calm" hreflang="en" rel="alternate" />
        
        <link href="https://www.rightplace.es/apartamentos/putxet-calm" hreflang="es" 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/">
                    <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="#">Alquiler</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/alquiler-pisos-meses"><span class="menu-title">Tu segunda casa</span></a></li>
																																																																		<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/ciudades/alquiler-pisos-barcelona"><span class="menu-title">Apartamentos en  Barcelona</span></a></li>
																					<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/ciudades/alquiler-pisos-madrid"><span class="menu-title">Apartamentos en  Madrid</span></a></li>
																<li class="nav-item"><a class="nav-link" href="/apartamentos?premium=1"><span class="menu-title">Apartamentos Premium</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/alquiler"><span class="menu-title">Cómo funciona</span></a></li>
																																																																																																				
												</ul>
											</div>
										</div>
									</div>
								</div>
							</div>
									</li>
            				<li class="dropdown">
					<a href="#">Propietarios</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/servicios"><span class="menu-title">Nuestros Servicios</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/propietarios"><span class="menu-title">Alquiler por temporada</span></a></li>
																																																										<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/interiorismo-reformas"><span class="menu-title">Interiorismo y reformas</span></a></li>
																																																																																<li class="nav-item"><a class="nav-link" href="https://www.rightplace.es/tasacion-pisos"><span class="menu-title">Valoramos tu piso</span></a></li>
																																		
												</ul>
											</div>
										</div>
									</div>
								</div>
							</div>
									</li>
            											<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/venta-pisos"><span class="menu-title">Compraventa</span></a>
				</li>
																																																									<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/nosotros"><span class="menu-title">Nosotros</span></a>
				</li>
															<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/equipo"><span class="menu-title">Equipo</span></a>
				</li>
																						<li class="dropdown">
					<a class="nav-link" href="https://www.rightplace.es/prensa"><span class="menu-title">Prensa</span></a>
				</li>
							
            <li><a href="https://www.rightplace.es/blog/" 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/en/change-language">EN</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/en/change-language">EN</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="#">Alquiler</a>
							</li>
																																																												
											<li class="subitem">><a href="https://www.rightplace.es/alquiler-pisos-meses">Tu segunda casa</a></li>
																																																																									<li class="subitem"><a href="https://www.rightplace.es/ciudades/alquiler-pisos-barcelona">Barcelona</a></li>
																											<li class="subitem"><a href="https://www.rightplace.es/ciudades/alquiler-pisos-madrid">Madrid</a></li>
																																																																									
											<li class="subitem">><a href="https://www.rightplace.es/alquiler">Cómo funciona</a></li>
																																																																																																																																																															<li class="item">
								<a href="#">Propietarios</a>
							</li>
																																																																																																															
											<li class="subitem">><a href="https://www.rightplace.es/servicios">Nuestros Servicios</a></li>
																																																														
											<li class="subitem">><a href="https://www.rightplace.es/propietarios">Alquiler por temporada</a></li>
																																																														
											<li class="subitem">><a href="https://www.rightplace.es/interiorismo-reformas">Interiorismo y reformas</a></li>
																																																																																																
											<li class="subitem">><a href="https://www.rightplace.es/tasacion-pisos">Valoramos tu piso</a></li>
																																																		                            								                                <li class="item">><a href="https://www.rightplace.es/venta-pisos">Compraventa</a></li>
								                            								                            								                            								                            								                            								                            								                            								                                <li class="item">><a href="https://www.rightplace.es/nosotros">Nosotros</a></li>
								                            								                                <li class="item">><a href="https://www.rightplace.es/equipo">Equipo</a></li>
								                            								                            								                                <li class="item">><a href="https://www.rightplace.es/prensa">Prensa</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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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="Slide image 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 dormitorios ·
                                                                                                                                                1 baño                                                    </p>
                        					</div>
                    <div class="col-12 order-3">
                        <div class="block-text" style="width: 100%">
                            <p>Oportunidad única: piso a reformar de 80 m² en El Putxet i el Farró

Con un estilo único y en una de las zonas más tranquilas de Barcelona, este piso en El Putxet i el Farró es ideal para quienes buscan tranquilidad, naturaleza y excelente conexión en un entorno exclusivo. Ubicado en una calle semipeatonal, ofrece la serenidad de un barrio residencial sin renunciar a las comodidades urbanas.<span class="click-leer-mas">Leer más</span></p>
                            <div class="text-2">
                                <p>Características principales
Con una superficie de 80 m², esta vivienda cuenta con dos habitaciones dobles, un salón-comedor espacioso y con luz natural, y una cocina independiente que conecta con un práctico patio. Dispone de un baño completo con bañera y bidet, además de calefacción mediante radiadores de gas para mayor confort. 

Extras
El edificio dispone de ascensor y portero, garantizando comodidad y seguridad. Además, tienes la opción de adquirir una plaza de parking por 28.000 €, ideal para completar esta fantástica oportunidad.

Ubicación privilegiada
Con excelente conectividad, la estación de Putxet (Línea 7 de los Ferrocarrils de la Generalitat) y varias líneas de autobús cercanas permiten un fácil acceso a toda la ciudad.


Para cualquier información adicional, ¡no dudes en contactar con nosotros!</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">Cómo reservar</h3>
                                    <p>Contacta con nosotros indicando la referencia del apartamento que le interesa, el motivo y las fechas de su estancia.</p>

<p>Le responderemos lo antes posible para darle todos los detalles de disponibilidad y condiciones de reserva.</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>La formalizaci&oacute;n definitiva del contrato de arrendamiento est&aacute; sujeto a la aceptaci&oacute;n del propietario.</p>

<p>Rightplace&nbsp;comunicar&aacute; al interesado en un plazo m&aacute;ximo de 48h el resultado de la solicitud de alquiler.</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">Documentación</h3>
                                    <p><strong><u>Documentaci&oacute;n general</u>:</strong></p>

<p>- Fotocopia del pasaporte / DNI / NIE de la persona que ocupar&aacute; el inmueble</p>

<p>- Direcci&oacute;n de vivienda habitual (origen)</p>

<p>- Cuenta bancaria europea (SEPA)</p>

<p>- Motivo de estancia</p>

<p><u><strong>Documentaci&oacute;n adicional necesaria en funci&oacute;n de su situaci&oacute;n</strong></u></p>

<p><strong>Estudiante o escuela especializada</strong>:</p>

<p>- Matr&iacute;cula de la universidad o certificado de pago</p>

<p>- Acreditaci&oacute;n de medios econ&oacute;micos para hacer frente a la estancia y los gastos mensuales del contrato</p>

<p><strong>Empleado por cuenta ajena</strong></p>

<p>- Copia del contrato de trabajo</p>

<p>- Copia de las tres &uacute;ltimas n&oacute;minas</p>

<p><strong>Empresa</strong></p>

<p>- Escritura de constituci&oacute;n y CIF de la empresa</p>

<p>- Representante legal de la empresa y DNI / ID / NIE o pasaporte</p>

<p>- &Uacute;ltima declaraci&oacute;n de impuestos</p>

<p><strong>Aut&oacute;nomos / Freelance</strong></p>

<p>- Copia del informe de la &uacute;ltima declaraci&oacute;n de renta de la persona f&iacute;sica</p>

<p>&nbsp;</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">Limpieza</h3>
                                    <p>La limpieza final del apartamento es obligatoria y ser&aacute; a cargo del inquilino.</p>

<p>El precio se establece en funci&oacute;n de la superficie total (m2) del apartamento y el importe ser&aacute; indicado en las condiciones economicas de cada apartamento.</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">Pagos</h3>
                                    <p><strong>Condiciones econ&oacute;micas, para reservas un apartamento;</strong></p>

<p>- Pago de primer mes o parte proporcional desde el d&iacute;a del check-in.</p>

<p>- Fianza: 2 mensualidades.</p>

<p>- Limpieza final: depender&aacute; del tama&ntilde;o del apartamento, se indicar&aacute; en la ficha del apartamento.</p>

<p>- Honorarios de agencia: depender&aacute; de la duraci&oacute;n del contrato, importe indicado en la ficha econ&oacute;mica del apartamento.</p>

<p>- Impuestos relacionadas con el contrato: ITP</p>

<p><strong>Confirmaci&oacute;n de reserva</strong>: Para confirmar la reserva, el cliente deber&aacute; efectuar un prepago correspondiente a los honorarios de agencia.</p>

<p><em>* Rogamos env&iacute;en el comprobante de transferencia v&iacute;a email a su agente, debidamente identificada con el nombre del inquilino y referencia del apartamento.</em><strong> </strong></p>

<p><strong>Saldo pendiente:</strong> El cliente deber&aacute; completar el pago con una antelaci&oacute;n m&iacute;nima de 15 d&iacute;as a su llegada al apartamento.</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>El check in se debe coordinar con uno de nuestros agentes. La entrada a nuestros apartamentos se efectuar&aacute; en horario de oficina de 9:30h a 18.30h de lunes a viernes.</p>

<p>Fuera del horario de atenci&oacute;n, durante el fin de semana o festivo, se cobrar&aacute;n 30 &euro; adicionales</p>

<p>&nbsp;</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">Suministros<br> (agua, gas, electricidad)</h3>
                                    <p>Los suministros no est&aacute;n incluidos en el precio de alquiler mensual. Se cobrar&aacute; una provisi&oacute;n mensual en funci&oacute;n del apartmento, cuyo importe ser&aacute; indicado en la informaci&oacute;n economica de cada apartamento. Pudiendo oscilar entre los 150 - 250 euros al mes.</p>

<p>Estos pagos se regularizar&aacute;n al finalizar el contrato contrast&aacute;ndolo con el consumo real efectuado en la vivienda.</p>

<p>* Tener en cuenta que algunos apartamentos tendr&aacute;n asignado un importefijo por esteconcepto ,en cuyo caso aparecer&aacute; indicado en el contrato.</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">Contrato</h3>
                                    <p>La formalizaci&oacute;n definitiva del contrato de arrendamiento est&aacute; sujeto a la decisi&oacute;n final del propietario.</p>

<p>En caso de no formalizarse el contrato por causa imputable al inquilino antes de la fecha indicada, &eacute;ste perder&aacute; la cantidad entregada en concepto de reserva.</p>

<p>En caso de no formalizarse el contrato de arrendamiento por causa imputable al arrendador, Rightplace&nbsp;devolver&aacute; la cantidad entregada exenta de penalizaci&oacute;n alguna.</p>

<p>&nbsp;</p>
                                </div>
                            </div>
                        </div>
                    </div>
                                <!-- SERVICIOS -->
                <div class="row block-servicios fadeIn wow" data-wow-duration="4s">
                    <hr>
                    <div class="col-12 section">Servicios</div>
                                                                                                                                                                                    <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Calefacción</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Ascensor</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Trastero</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>Cocina de gas</li>
                                </ul>
                            </div>
                                                                                                                                            <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Horno</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Microondas</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Lavadora</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Secadora</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Lavadora-secadora</li>
                                </ul>
                            </div>
                                                                                                <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Nevera</li>
                                </ul>
                            </div>
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        <div class="col-6 col-sm-4 col-md-3">
                                <ul>
                                    <li>Admite mascotas</li>
                                </ul>
                            </div>
                                                                                                        </div>

                                    <!-- SITUACION -->
                    <div class="row block-situacion fadeIn wow" data-wow-duration="4s">
                        <hr>
                        <div class="col-12 section">Ubicación</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">Precio de venta                        <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">Solicitar info</button>
														<p class="share">¡Compártelo! <a class="ml-2"
																								href="https://www.facebook.com/sharer/sharer.php?u=https://www.rightplace.es/apartamentos/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/apartamentos/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">Volver a los resultados de tu búsqueda							</a></p>
					</div>
                </div>
            </div>
									        </div>
    </div>
</section>
<script>
    function contactar(id_apartamento, ciudad) {
        location = 'https://www.rightplace.es/contacto?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">Otros apartamentos</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/apartamentos/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="Slide image 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">
											Disponible										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/canet-house/">Canet House</a></p>
									<p class="precio"><span>425.000€</span>/mes</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/canet-house/" class="btn btn-blue hvr-ripple-out">Ver detalles</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/apartamentos/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="Slide image 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">
											Disponible										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/muntaner-style-venta/">Muntaner Style Venta</a></p>
									<p class="precio"><span>790.000€</span>/mes</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/muntaner-style-venta/" class="btn btn-blue hvr-ripple-out">Ver detalles</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/apartamentos/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="Slide image 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">
											Disponible										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/casp-luxury-b-venta/">Casp Luxury B Venta</a></p>
									<p class="precio"><span>1.175.000€</span>/mes</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/casp-luxury-b-venta/" class="btn btn-blue hvr-ripple-out">Ver detalles</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/apartamentos/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="Slide image 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">
											Disponible										</p>
									</div>
								
								<div class="b-info">
									<p class="title-piso"><a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/santa-caterina-venta/">Santa Caterina Venta</a></p>
									<p class="precio"><span>250.000€</span>/mes</p>

									<div class="block-btn">
										<a onclick="return verDetalles(this)" href="https://www.rightplace.es/apartamentos/santa-caterina-venta/" class="btn btn-blue hvr-ripple-out">Ver detalles</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>¿Necesitas ayuda?<br> Estaremos encantados de ayudarte.</p>
				                <a href="https://www.rightplace.es/contacto" class="btn btn-gray hvr-ripple-out">Contactar</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">Somos miembros de:</p>
		            
<picture>
			<source data-srcset="medium://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/es/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/es/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/es/rightplace_es_miembro_de_cluster_inmobiliario.webp"
		 alt="rightplace-es-miembro-de-cluster-inmobiliario"
		 title="rightplace-es-miembro-de-cluster-inmobiliario">
</picture>
		            
<picture>
			<source data-srcset="medium://www.rightplace.es/assets/themes/www.rightplace.es/img/gallery/logos_footer_1/es/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/es/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/es/rightplace_es_miembro_de_api_cat.webp"
		 alt="rightplace-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">Idioma</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" selected="">Español</option>
                                            <option value="en">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/alquiler-pisos-meses">Tu segunda casa</a></li>
                    <li><a href="https://www.rightplace.es/alquiler">Cómo funciona</a></li>
                    <li><a href="https://www.rightplace.es/propietarios">Alquiler por temporada</a></li>
                    <li><a href="https://www.rightplace.es/venta-pisos">Compraventa</a></li>
                    <li><a href="/apartamentos?economy=1">Pisos Basic</a></li>
                    <li><a href="https://www.rightplace.es/servicios">Nuestros Servicios</a></li>
                    <li><a href="https://www.rightplace.es/nosotros">Nosotros</a></li>
                    <li><a href="https://www.rightplace.es/contacto">Contacto</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">Información general</p>
                <ul class="list-unstyled">
                    <li><a href="https://www.rightplace.es/poltica-de-cookies">Política de Cookies</a></li>
                    <li><a href="https://www.rightplace.es/terminos-y-condiciones">Términos y condiciones</a></li>
                    <li><a href="https://www.rightplace.es/faqs">FAQs</a></li>
                    <li><a href="https://www.rightplace.es/politica-de-privacidad">Política de privacidad</a></li>
                    <li><a href="https://www.rightplace.es/aviso-legal">Aviso legal</a></li>
                </ul>
            </div>
            <div class="col-sm-6 col-md-2">
                <p class="title-text">Contacto</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,  Madrid</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/datepicker-es.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>