Feedback

Search Properties

Sponsored Properties

Sponsored properties are viewed by most of the property seekers. You can tag your property citywide, regionwide or countrywide and attract the audience. Your property would be displayed above the featured listing.

Store your search

Just fill the search form only once. Select the set of search criteria and give it a name. Use "Save & Search" button to store permanently this set of search criteria so when you come next time, you get the pre defined list of searches. Have a freedom from filling search forms every time for the same criteria.

Senior Housing Properties for Lease

For Sale (9) |  For Lease (0) 

Senior Housing type has not yet received any property.

(default) 26 queries took 22 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1111
2SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1110
3SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1110
4SELECT `Property`.`id`, `Property`.`propertytype_id`, `Property`.`othertype`, `Property`.`propertyowner_id`, `Property`.`package_id`, `Property`.`order_id`, `Property`.`looking_for`, `Property`.`name`, `Property`.`url`, `Property`.`email`, `Property`.`address1`, `Property`.`address2`, `Property`.`country_id`, `Property`.`region_id`, `Property`.`city_id`, `Property`.`zipcode`, `Property`.`lon`, `Property`.`lat`, `Property`.`phone`, `Property`.`fax`, `Property`.`min_price`, `Property`.`max_price`, `Property`.`min_deposit`, `Property`.`max_deposit`, `Property`.`isnegotiable`, `Property`.`icon`, `Property`.`description`, `Property`.`currency`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`garage`, `Property`.`livesquare`, `Property`.`landsquare`, `Property`.`totalsquare`, `Property`.`area_unit`, `Property`.`floorno`, `Property`.`floortotal`, `Property`.`subway_min`, `Property`.`construction_year`, `Property`.`is_furnished`, `Property`.`is_new`, `Property`.`keywords_generated`, `Property`.`status`, `Property`.`is_disclaimer`, `Property`.`is_sold`, `Property`.`created`, `Property`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `Region`.`description`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country`, `City`.`description`, `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name`, `Propertytype`.`status`, `Propertytype`.`operation`, `Propertytype`.`created`, `Propertytype`.`modified`, `Propertyowner`.`id`, `Propertyowner`.`firstname`, `Propertyowner`.`lastname`, `Propertyowner`.`email`, `Propertyowner`.`password`, `Propertyowner`.`companyname`, `Propertyowner`.`confirm`, `Propertyowner`.`status`, `Propertyowner`.`address1`, `Propertyowner`.`address2`, `Propertyowner`.`country_id`, `Propertyowner`.`region_id`, `Propertyowner`.`city_id`, `Propertyowner`.`zipcode`, `Propertyowner`.`phone`, `Propertyowner`.`fax`, `Propertyowner`.`skype`, `Propertyowner`.`logo`, `Propertyowner`.`aboutme`, `Propertyowner`.`type`, `Propertyowner`.`notification`, `Propertyowner`.`iagreed`, `Propertyowner`.`lastlogin`, `Propertyowner`.`lastlogin2`, `Propertyowner`.`ipaddress`, `Propertyowner`.`created`, `Propertyowner`.`modified`, `Package`.`id`, `Package`.`name`, `Package`.`shortdescription`, `Package`.`property`, `Package`.`photo`, `Package`.`video`, `Package`.`free_lead`, `Package`.`display_contact`, `Package`.`trial_term`, `Package`.`validity`, `Package`.`term_unit`, `Package`.`amount`, `Package`.`status`, `Package`.`is_free`, `Package`.`created`, `Package`.`modified` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` ON (`Property`.`propertyowner_id` = `Propertyowner`.`id`) LEFT JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Property`.`package_id` = `Package`.`id`) WHERE `Property`.`id` in ('')001
5SELECT `Property`.`id`, `Property`.`propertytype_id`, `Property`.`othertype`, `Property`.`propertyowner_id`, `Property`.`package_id`, `Property`.`order_id`, `Property`.`looking_for`, `Property`.`name`, `Property`.`url`, `Property`.`email`, `Property`.`address1`, `Property`.`address2`, `Property`.`country_id`, `Property`.`region_id`, `Property`.`city_id`, `Property`.`zipcode`, `Property`.`lon`, `Property`.`lat`, `Property`.`phone`, `Property`.`fax`, `Property`.`min_price`, `Property`.`max_price`, `Property`.`min_deposit`, `Property`.`max_deposit`, `Property`.`isnegotiable`, `Property`.`icon`, `Property`.`description`, `Property`.`currency`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`garage`, `Property`.`livesquare`, `Property`.`landsquare`, `Property`.`totalsquare`, `Property`.`area_unit`, `Property`.`floorno`, `Property`.`floortotal`, `Property`.`subway_min`, `Property`.`construction_year`, `Property`.`is_furnished`, `Property`.`is_new`, `Property`.`keywords_generated`, `Property`.`status`, `Property`.`is_disclaimer`, `Property`.`is_sold`, `Property`.`created`, `Property`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `Region`.`description`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country`, `City`.`description`, `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name`, `Propertytype`.`status`, `Propertytype`.`operation`, `Propertytype`.`created`, `Propertytype`.`modified`, `Propertyowner`.`id`, `Propertyowner`.`firstname`, `Propertyowner`.`lastname`, `Propertyowner`.`email`, `Propertyowner`.`password`, `Propertyowner`.`companyname`, `Propertyowner`.`confirm`, `Propertyowner`.`status`, `Propertyowner`.`address1`, `Propertyowner`.`address2`, `Propertyowner`.`country_id`, `Propertyowner`.`region_id`, `Propertyowner`.`city_id`, `Propertyowner`.`zipcode`, `Propertyowner`.`phone`, `Propertyowner`.`fax`, `Propertyowner`.`skype`, `Propertyowner`.`logo`, `Propertyowner`.`aboutme`, `Propertyowner`.`type`, `Propertyowner`.`notification`, `Propertyowner`.`iagreed`, `Propertyowner`.`lastlogin`, `Propertyowner`.`lastlogin2`, `Propertyowner`.`ipaddress`, `Propertyowner`.`created`, `Propertyowner`.`modified`, `Package`.`id`, `Package`.`name`, `Package`.`shortdescription`, `Package`.`property`, `Package`.`photo`, `Package`.`video`, `Package`.`free_lead`, `Package`.`display_contact`, `Package`.`trial_term`, `Package`.`validity`, `Package`.`term_unit`, `Package`.`amount`, `Package`.`status`, `Package`.`is_free`, `Package`.`created`, `Package`.`modified` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` ON (`Property`.`propertyowner_id` = `Propertyowner`.`id`) LEFT JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Property`.`package_id` = `Package`.`id`) WHERE `Property`.`id` in ('')001
6SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
7SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
8SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10101
9SELECT `Region`.`id`, `Region`.`name`, `Region`.`country_id`, `Country`.`id`, `Country`.`name` FROM `prod_propertyclustercom`.`regions` AS `Region` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Region`.`country_id` = `Country`.`id`) WHERE `Region`.`country_id` = '226' GROUP BY `Region`.`id`62621
10SELECT `Property`.`id`, `Property`.`status`, `Property`.`looking_for`, `Property`.`region_id` FROM `prod_propertyclustercom`.`properties` AS `Property` WHERE `Property`.`status` = 1 AND `Property`.`region_id` IN (4085, 4086, 4087, 4088, 4089, 4090, 4091, 4092, 4093, 4094, 4095, 4096, 4097, 4098, 4099, 4100, 4101, 4102, 4103, 4104, 4105, 4106, 4107, 4108, 4109, 4110, 4111, 4112, 4113, 4114, 4115, 4116, 4117, 4118, 4119, 4120, 4121, 4122, 4123, 4124, 4125, 4126, 4127, 4128, 4129, 4130, 4131, 4132, 4133, 4134, 4135, 4136, 4137, 4138, 4139, 4140, 4141, 4142, 4143, 4144, 4145, 4146)87871
11SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_propertyclustercom`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1111
12SELECT `Propertytype`.`id`, `Propertytype`.`parent_id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`name` = 'senior housing' AND `Propertytype`.`status` = 1 LIMIT 1111
13SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'220
14SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
15SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10100
16SELECT `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Zone`.`id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prod_propertyclustercom`.`countries` AS `Country` LEFT JOIN `prod_propertyclustercom`.`zones` AS `Zone` ON (`Country`.`zone_id` = `Zone`.`id`) WHERE 1 = 1 ORDER BY `Country`.`name` ASC2252251
17SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
18SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
19SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10101
20SELECT `Region`.`name`, `Country`.`name`, `Property`.`id` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) WHERE `Property`.`country_id` = 226 AND `Property`.`propertytype_id` = '5350afe1-6b5c-4a34-bf61-07ec6281e16b' AND `Property`.`looking_for` = 'To Lease' AND `Property`.`status` = 1 GROUP BY `Region`.`id` ORDER BY rand() ASC LIMIT 10001
21SELECT `Vasorder`.`id`, `Vasorder`.`order_number`, `Vasorder`.`propertyowner_id`, `Vasorder`.`valueaddedservice_id`, `Vasorder`.`discount`, `Vasorder`.`coupon_discount`, `Vasorder`.`coupon_code`, `Vasorder`.`taxe`, `Vasorder`.`subtotal`, `Vasorder`.`grandtotal`, `Vasorder`.`first_name`, `Vasorder`.`last_name`, `Vasorder`.`card_holder_name`, `Vasorder`.`street_address`, `Vasorder`.`email`, `Vasorder`.`street_address2`, `Vasorder`.`city`, `Vasorder`.`state`, `Vasorder`.`country`, `Vasorder`.`ip_country`, `Vasorder`.`zip`, `Vasorder`.`phone`, `Vasorder`.`status`, `Vasorder`.`response`, `Vasorder`.`expiry_date`, `Vasorder`.`created`, `Vasorder`.`modified` FROM `prod_propertyclustercom`.`vasorders` AS `Vasorder` WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618264616' ORDER BY `Vasorder`.`modified` desc001
22SELECT `Property`.*, `Country`.`name`, `Region`.`name`, `City`.`name`, `Propertytype`.*, `Package`.`amount`, `Package`.`name`, `Property`.`id` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) left JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Package`.`id` = `Property`.`package_id`) left JOIN (SELECT Vasorderdetail.property_id AS vpid, Vasorder.id AS vid FROM `vasorders` AS `Vasorder` LEFT JOIN `vasorderdetails` AS `Vasorderdetail` ON (`Vasorder`.`id` = `Vasorderdetail`.`vasorder_id`) WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618264616' GROUP BY `Vasorderdetail`.`property_id`) AS `Vas` ON (`Vas`.`vpid` = `Property`.`id`) WHERE `Property`.`propertytype_id` in ('5350af55-20d8-4554-ae43-07ec6281e16b', '5350af0a-7030-444a-83fa-07ec6281e16b', '5350af81-a3a0-4984-92af-07ec6281e16b', '5350af2c-d248-446c-af3b-07ec6281e16b', '5350af17-d000-4aa0-bd85-07ec6281e16b', '5350af46-24ac-4d3c-b9b8-07ec6281e16b', '5350abe4-5550-42cb-a392-07ec6281e16b', '5350aef8-a244-42e2-871e-07ec6281e16b', '5350b01a-a96c-49c3-b337-07ec6281e16b', '5350aee9-d304-4911-bb7a-07ec6281e16b', '5350afe1-6b5c-4a34-bf61-07ec6281e16b', '5350afd5-b274-4363-b53c-07ec6281e16b', '5350afa2-6fac-464f-914d-07ec6281e16b', '5350af39-0398-4732-8f5a-07ec6281e16b', 'commercialother') AND `Property`.`status` = 1 AND `Property`.`looking_for` = 'To Lease' AND `Property`.`propertytype_id` = '5350afe1-6b5c-4a34-bf61-07ec6281e16b' GROUP BY `Property`.`id` ORDER BY `Package`.`amount` Desc, `Property`.`min_price` Desc LIMIT 10001
23SELECT COUNT(*) AS `count` FROM `prod_propertyclustercom`.`properties` AS `Property` LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Property`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Property`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Property`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`propertytypes` AS `Propertytype` ON (`Property`.`propertytype_id` = `Propertytype`.`id`) left JOIN `prod_propertyclustercom`.`packages` AS `Package` ON (`Package`.`id` = `Property`.`package_id`) left JOIN (SELECT Vasorderdetail.property_id AS vpid, Vasorder.id AS vid FROM `vasorders` AS `Vasorder` LEFT JOIN `vasorderdetails` AS `Vasorderdetail` ON (`Vasorder`.`id` = `Vasorderdetail`.`vasorder_id`) WHERE UNIX_TIMESTAMP(`Vasorder`.`expiry_date`)>'1618264616' GROUP BY `Vasorderdetail`.`property_id`) AS `Vas` ON (`Vas`.`vpid` = `Property`.`id`) WHERE `Property`.`propertytype_id` in ('5350af55-20d8-4554-ae43-07ec6281e16b', '5350af0a-7030-444a-83fa-07ec6281e16b', '5350af81-a3a0-4984-92af-07ec6281e16b', '5350af2c-d248-446c-af3b-07ec6281e16b', '5350af17-d000-4aa0-bd85-07ec6281e16b', '5350af46-24ac-4d3c-b9b8-07ec6281e16b', '5350abe4-5550-42cb-a392-07ec6281e16b', '5350aef8-a244-42e2-871e-07ec6281e16b', '5350b01a-a96c-49c3-b337-07ec6281e16b', '5350aee9-d304-4911-bb7a-07ec6281e16b', '5350afe1-6b5c-4a34-bf61-07ec6281e16b', '5350afd5-b274-4363-b53c-07ec6281e16b', '5350afa2-6fac-464f-914d-07ec6281e16b', '5350af39-0398-4732-8f5a-07ec6281e16b', 'commercialother') AND `Property`.`status` = 1 AND `Property`.`looking_for` = 'To Sale' AND `Property`.`propertytype_id` = '5350afe1-6b5c-4a34-bf61-07ec6281e16b' GROUP BY `Property`.`id`991
24SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0'221
25SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa65f-8328-48f0-9334-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC14141
26SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '534fa8c1-7dc8-4258-b249-07ec6281e16b' AND `Propertytype`.`status` = 1 ORDER BY `Propertytype`.`name` ASC10101