SELECT r.vTitle,r.tDescription, r.sDescription, r.iRangeId, r.vImage FROM `brand_range_map` brm LEFT JOIN `range` r ON brm.iRangeId = r.iRangeId WHERE brm.iBrandId = '214' AND r.eStatus = 'Active' AND r.iRangeId NOT IN (1039,1743,242) ORDER BY r.iDispOrder ASC
3 great reasons to buy Jay-Be from us - UK’s Best Brands, Lowest Prices and 24 X 7 Support!
Make a good first impression with a stylish Jay Be Beds Furniture. Give your home that WOW Factor with our amazing Jay Be Sofa Bed, Foot Stool Beds, Curve Collection and Scatter Cushions. Create a cozy space for bundling up and sleeping in. Here at TFS UK, you’ll find a fantastic range of Jay-Be Guest Beds, Folding Beds, Bunk Bed and Mattresses at unbeatable prices. With so many unique designs and styles, you’re sure to find the most astounding piece for your home.