Beyond Construction

Register now

Forgot username?

Forgot password?

Remember Me

Find Your BUILDING PRODUCTS & TOOLS

Advance Search

Search Assist

Save Time & Money On Your Next Project

Building Products & Tools

arrowImg
SELECT phpsd_listing_products.product_id AS product_id, product_name, member_id, product_price, product_photo, product_desc FROM phpsd_listing_products ,phpsd_listings WHERE product_id IN (54,52,42,18) AND product_status IN ('featured','approved') AND phpsd_listing_products.listing_id = phpsd_listings.listing_id AND ( (listing_expiry_date = '0000-00-00') OR (listing_expiry_date <> '0000-00-00' AND listing_expiry_date >= now()) ) AND listing_status IN ('approved','featured') AND ( (product_expiry_date = '0000-00-00') OR (product_expiry_date <> '0000-00-00' AND product_expiry_date >= now()) ) GROUP BY (phpsd_listing_products.product_id) ORDER BY FIELD(phpsd_listing_products.product_id,54,52,42,18) LIMIT 0,9

Hot Deals

    There are no Hot Deals available.
SELECT phpsd_listing_products.product_id AS product_id, product_name, member_id, product_price, product_photo, product_desc FROM phpsd_listing_products ,phpsd_listings WHERE product_status IN ('featured') AND phpsd_listing_products.listing_id = phpsd_listings.listing_id AND ( (listing_expiry_date = '0000-00-00') OR (listing_expiry_date <> '0000-00-00' AND listing_expiry_date >= now()) ) AND listing_status IN ('approved','featured') AND ( (product_expiry_date = '0000-00-00') OR (product_expiry_date <> '0000-00-00' AND product_expiry_date >= now()) ) GROUP BY (phpsd_listing_products.product_id) ORDER BY product_date_time DESC LIMIT 0,6

Featured Products

There are no Featured Products available.
SELECT phpsd_listing_products.product_id AS product_id, product_name, member_id, product_price, product_photo, product_desc, listing_phone FROM phpsd_listing_products ,phpsd_listings WHERE product_id IN (41,37,51) AND product_status IN ('featured','approved') AND phpsd_listing_products.listing_id = phpsd_listings.listing_id AND ( (listing_expiry_date = '0000-00-00') OR (listing_expiry_date <> '0000-00-00' AND listing_expiry_date >= now()) ) AND listing_status IN ('approved','featured') AND ( (product_expiry_date = '0000-00-00') OR (product_expiry_date <> '0000-00-00' AND product_expiry_date >= now()) ) GROUP BY (phpsd_listing_products.product_id) ORDER BY FIELD(phpsd_listing_products.product_id,41,37,51) LIMIT 0,9

Sponsor Products

    There are no Sponsor Products available.