Take an advantage of featured property listings and get 40% of more views of property seekers. Pay little on top of membership and advertise your property citywide, regionwide or countrywide. Your property would be displayed above the general listing.
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.
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.
Beautiful 2 story house, original owner. Rare 2 master bedr...
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1 | 1 | 1 | 1 | |
| 2 | SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1 | 1 | 1 | 1 | |
| 3 | SELECT `Sitesetting`.`value` FROM `prod_propertyclustercom`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `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 ('') | 0 | 0 | 1 | |
| 5 | SELECT `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 ('') | 0 | 0 | 1 | |
| 6 | SELECT `Propertytype`.`id`, `Propertytype`.`name` FROM `prod_propertyclustercom`.`propertytypes` AS `Propertytype` WHERE `Propertytype`.`parent_id` = '0' | 2 | 2 | 1 | |
| 7 | SELECT `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` ASC | 14 | 14 | 1 | |
| 8 | SELECT `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` ASC | 10 | 10 | 1 | |
| 9 | SELECT `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` | 62 | 62 | 1 | |
| 10 | SELECT `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) | 87 | 87 | 1 | |
| 11 | SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_propertyclustercom`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 12 | SELECT `Propertyowner`.`id`, `Propertyowner`.*, `Usersimage`.`namemedium`, `Country`.`name`, `Region`.`name`, `City`.`name` FROM `prod_propertyclustercom`.`propertyowners` AS `Propertyowner` LEFT JOIN `prod_propertyclustercom`.`cities` AS `City` ON (`Propertyowner`.`city_id` = `City`.`id`) LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`Propertyowner`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`Propertyowner`.`country_id` = `Country`.`id`) LEFT JOIN `prod_propertyclustercom`.`usersimages` AS `Usersimage` ON (`Usersimage`.`user_id` = `Propertyowner`.`id`) WHERE `Propertyowner`.`id` = '5915cbff-6168-4dc8-a15a-0f1c0a14812a' LIMIT 1 | 1 | 1 | 1 | |
| 13 | SELECT `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` FROM `prod_propertyclustercom`.`properties` AS `Property` WHERE `Property`.`propertyowner_id` = ('5915cbff-6168-4dc8-a15a-0f1c0a14812a') ORDER BY `Property`.`created` DESC | 1 | 1 | 1 | |
| 14 | SELECT `Testimonial`.`id`, `Testimonial`.`propertyowner_id`, `Testimonial`.`description`, `Testimonial`.`status`, `Testimonial`.`created`, `Testimonial`.`modified` FROM `prod_propertyclustercom`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`propertyowner_id` = ('5915cbff-6168-4dc8-a15a-0f1c0a14812a') | 0 | 0 | 1 | |
| 15 | SELECT `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`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `Region`.`description`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long` FROM `prod_propertyclustercom`.`cities` AS `City` LEFT JOIN `prod_propertyclustercom`.`regions` AS `Region` ON (`City`.`region_id` = `Region`.`id`) LEFT JOIN `prod_propertyclustercom`.`countries` AS `Country` ON (`City`.`country_id` = `Country`.`id`) WHERE `City`.`id` = 2752243 AND `City`.`region_id` = 4098 AND `City`.`country_id` = 226 LIMIT 1 | 1 | 1 | 1 | |
| 16 | SELECT `Propertyimage`.`id`, `Propertyimage`.`property_id`, `Propertyimage`.`name`, `Propertyimage`.`namemedium`, `Propertyimage`.`is_default`, `Propertyimage`.`created`, `Propertyimage`.`modified` FROM `prod_propertyclustercom`.`propertyimages` AS `Propertyimage` WHERE `Propertyimage`.`property_id` = '5915cf56-3508-4f11-bf6b-0f1c0a14812a' AND `Propertyimage`.`is_default` = 1 LIMIT 1 | 1 | 1 | 1 | |
| 17 | SELECT `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`)>'1618264162' ORDER BY `Vasorder`.`modified` desc | 0 | 0 | 1 |