Browse Listings

No listings found for this search
Warning (512): JsHelper does not implement a link() method, it is incompatible with PaginatorHelper [CORE/cake/libs/view/helpers/paginator.php, line 98]Code$classname = $ajaxProvider . 'Helper';if (!is_callable(array($classname, 'link'))) {trigger_error(sprintf(__('%s does not implement a link() method, it is incompatible with PaginatorHelper', true), $classname), E_USER_WARNING);PaginatorHelper::__construct() - CORE/cake/libs/view/helpers/paginator.php, line 98 View::_loadHelpers() - CORE/cake/libs/view/view.php, line 800 View::_render() - CORE/cake/libs/view/view.php, line 702 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 913 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 95

Oooops, that category is not among the 4000 categories that are available. Please select the most relevant category from this list
| Company Information | |
| About FocusedBuyer.com | Privacy Policy |
| News & Press Releases | Contact Us |
| Career Opportunities | Blog |
| Help & Support | |
| User Guide | Hints & Tips |
| FAQs | Terms of Service |
| Resolution Center | Site Map |
| Security Center | Help |
| FocusedBuyer.com | |
| Start Buying! | Advertise with Us |
| Start Selling! | Precious® Gateway |
| Log In / Register | Corporate Services |
| Group Buy | Invest in Us |
| Feedback | |
| [BETA] | |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `cake_sessions` AS `Session` WHERE `id` = '518387dd29db5950c456b8d1cb6a2a77' LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT DISTINCT `Category`.`id`, `Category`.`category`, `Listing`.`id` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`expire_date_listing` >= '2026-03-13' AND `Listing`.`under_contract` = 0 AND `Listing`.`deleted` = 0 ORDER BY `Category`.`category` ASC | 0 | 0 | 3 | |
| 3 | SELECT COUNT(*) AS `count` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`under_contract` = 0 AND `Listing`.`active` = 1 AND `Listing`.`send_to` = 0 AND `Listing`.`expire_date_listing` >= '2026-03-13' AND `Listing`.`deleted` = 0 | 1 | 1 | 2 | |
| 4 | SELECT `Listing`.`id`, `Listing`.`created`, `Listing`.`desc`, `Listing`.`user_id`, `Listing`.`add_picture1`, `Listing`.`title`, `Listing`.`category_id`, `Listing`.`expire_date_listing`, `Listing`.`more_than_one`, `Listing`.`shipping_country`, `Listing`.`shipping_state`, `Listing`.`state_other` FROM `listings` AS `Listing` LEFT JOIN `users` AS `User` ON (`Listing`.`user_id` = `User`.`id`) LEFT JOIN `categories` AS `Category` ON (`Listing`.`category_id` = `Category`.`id`) LEFT JOIN `contracts` AS `Contract` ON (`Contract`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`published` = 1 AND `Listing`.`under_contract` = 0 AND `Listing`.`active` = 1 AND `Listing`.`send_to` = 0 AND `Listing`.`expire_date_listing` >= '2026-03-13' AND `Listing`.`deleted` = 0 ORDER BY `Listing`.`id` desc LIMIT 100 | 0 | 0 | 3 | |
| 5 | SELECT `Link`.`id`, `Link`.`nav_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`controller`, `Link`.`action`, `Link`.`params`, `Link`.`restricted`, `Link`.`new_window`, `Link`.`editable`, `Link`.`created`, `Link`.`modified`, `Link`.`position` FROM `links` AS `Link` WHERE `Link`.`nav_id` = 2 ORDER BY `Link`.`position` ASC | 14 | 14 | 0 | |
| 6 | SELECT `Link`.`id`, `Link`.`nav_id`, `Link`.`parent_id`, `Link`.`title`, `Link`.`controller`, `Link`.`action`, `Link`.`params`, `Link`.`restricted`, `Link`.`new_window`, `Link`.`editable`, `Link`.`created`, `Link`.`modified`, `Link`.`position` FROM `links` AS `Link` WHERE `Link`.`nav_id` = 1 ORDER BY `Link`.`position` ASC | 28 | 28 | 0 |
