Montreal Furnished Apartments Rentals


Welcome to MyStudioMontreal.com, the leader in furnished apartments and studios ren..
tal in Montreal.
We offer hundreds of furnished studios, serviced suites, equipped lofts, student housing, corporate and executive serviced accommodations downtown and old port Montreal. If you are looking for a short term apartment rental, temporary housing or vacation rentals in Montreal, our site is by far the place to look at. All our temporary flats and holiday apartments are ideal for relocations, internships, off campus student housing and short term rentals in Montreal.We offer a wide range of accommodations types such as all inclusive flats, businness suites, temporary condos, vacation home rentals, furnished studios, executive rentals etc.All our temporary accommodations are all inclusive, fully equipped, and includes a wide range of services such as gym access, jacuzzi, sauna, concierge, airport shuttle, and much more!

Welcome to Montreal!



You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.number_adults= order by priority' at line 2
Select distinct a.id, name, text_en as text,number_stars,number_bathrooms,number_sleeps,number_adults,number_childsto4,number_childsfrom4,square,price1,price2,price3,price4,estimated_price,discount,basic_monthly_price,page_title_en,daily, page_title_fr, page_title_es from rentals a left join search b on a.id=b.id left join alternatives c on c.id2=a.id where 1 and region_id=1 and a.number_stars= AND a.number_adults= order by priority
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.number_adults= order by priority' at line 2 [Select distinct a.id, name, text_en as text,number_stars,number_bathrooms,number_sleeps,number_adults,number_childsto4,number_childsfrom4,square,price1,price2,price3,price4,estimated_price,discount,basic_monthly_price,page_title_en,daily, page_title_fr, page_title_es from rentals a left join search b on a.id=b.id left join alternatives c on c.id2=a.id where 1 and region_id=1 and a.number_stars= AND a.number_adults= order by priority]