// text/x-generic db.php ( PHP script, UTF-8 Unicode text ) string(1628) "SELECT p.id_product, p.brand, p.folder_name, p.item_number, p.article_number, p.groupnumber, ((cost * pakg * (1 + 0.32) * 100 / 45) * 1) AS price, (discount * pakg * (1 + 0.32) * 100 / 45) * 1 AS discount, (warehouse + gateway + stock_brand + stock) AS product_stock, ROUND(((((cost * pakg * (1 + 0.32) * 100 / 45) * 1) - (((cost * pakg * (1 + 0.32) * 100 / 45) * 1) * discount)) / ((cost * pakg * (1 + 0.32) * 100 / 45) * 1)) * 100) AS porcent, pakg AS qty_per_box, p.collectionname, p.stylename, p.roomname, p.subname, p.piecename, p.item_size, p.tvsize, p.versionphoto, p.simplified_color, p.mattress_firmness, p.table_shape, p.mattress_pillowtop, p.mattress_type, p.bodega_mx, p.cdmx, p.warehouse, p.milenium, p.gateway, p.brand_divece, p.stock_brand, p.stock, (bodega_mx + cdmx + warehouse + milenium + gateway) AS store_stock, ((bodega_mx + cdmx + warehouse + milenium + gateway) + stock_brand) AS total_stock, p.fbrclr, p.finishcolor, p.material, countryoforigin, last_modified, p.set_qty, p.item_name, COUNT(p.id_product) AS hits, !ISNULL(s.id_entry) AS saved, IFNULL(c.quantity, 0) AS cart_qty FROM tb_products_test p LEFT JOIN tb_saved_items s ON p.groupnumber = s.groupnumber AND s.session_id = 't4jslhc9mfd099j7b82d4m56lq' LEFT JOIN tb_cart c ON c.id_product = p.id_product AND c.session_id = 't4jslhc9mfd099j7b82d4m56lq' WHERE p.item_number != '' AND p.active = 'Y' AND cost > 0 AND pakg > 0 AND box_number > 0 AND has3d = 1 GROUP BY p.id_product ORDER BY hits ASC,price ASC LIMIT 10000" array(12) { [0]=> array(2) { ["en"]=> string(7) "Ceramic" ["es"]=> string(9) "Cerámica" } [1]=> array(2) { ["en"]=> string(8) "Concrete" ["es"]=> string(8) "Concreto" } [2]=> array(2) { ["en"]=> string(6) "Fabric" ["es"]=> string(4) "Tela" } [3]=> array(2) { ["en"]=> string(5) "Glass" ["es"]=> string(6) "Vidrio" } [4]=> array(2) { ["en"]=> string(7) "Leather" ["es"]=> string(4) "Piel" } [5]=> array(2) { ["en"]=> string(5) "Stone" ["es"]=> string(4) "Roca" } [6]=> array(2) { ["en"]=> string(5) "Metal" ["es"]=> string(5) "Metal" } [7]=> array(2) { ["en"]=> string(6) "Mirror" ["es"]=> string(6) "Espejo" } [8]=> array(2) { ["en"]=> string(7) "Plastic" ["es"]=> string(9) "Plástico" } [9]=> array(2) { ["en"]=> string(6) "Rattan" ["es"]=> string(6) "Tejido" } [10]=> array(2) { ["en"]=> string(4) "Wood" ["es"]=> string(6) "Madera" } [11]=> array(2) { ["en"]=> string(6) "Marble" ["es"]=> string(6) "Marmol" } } OSGO HOME | 3D Catalog

osgo properties

osgo properties

Fast Delivery Showrooms

Augmented Reality

{{title_filters}}

{{clearer}}

{{ translate(filter,`${key}s`).firstUpperCase() }} Pillow Top Non Pillow Top

Rooms

Pieces

Price

Tradicional

Styles

Colors

materials

Finish

Sort by

{{label3d}}

{{ trans('rooms') }}

Bar & Recreational

Bar & Recreational

Bedroom

Decor

appliances

Kitchen

mattresses

Art

Dining Room

Kids & Youth

Lighting

Living Room

Mattresses

Office

Outdoor

Pets

Rugs

Rugs

3D and Augmented Reality

3D and Augmented Reality

3D and Augmented Reality

3D and Augmented Reality

{{ trans('pieces') }}

Sofas & Loveseats

Sofas & Loveseats

Sectionals

Chairs & Recliners

Chairs & Recliners

Futons & Sofa Beds

Futons & Sofa Beds

Accent Chairs

Accent Tables

Tv Stands & Media Storage

Tv Stands & Media Storage

Bookcases

Cabinets & Chests

Cabinets & Chests

Living Room Sets

Living Room Sets

Fireplaces

Dining Chairs & Benches

Dining Chairs & Benches

Counter Height Tables

Counter Height Tables

Counter Height Chairs & Stools

Counter Height Chairs & Stools

Buffets & Sideboards

Buffets & Sideboards

Dining Room Sets

Dining Room Sets

Beds & Daybeds

Headboards

Beauty

Dressers & Mirrors

Dressers & Mirrors

Chests

Nightstands

Vanities

Bedroom Benches & Chairs

Bedroom Benches & Chairs

Bedding & Pillows

Bedding & Pillows

Bed Frames

Closet & Armoires

Closet & Armoires

Bedroom Sets

Toilets

Utensiles

Desks

Office Chairs

Hutches

Office Storage

Office Accessories

Office Accessories

Office Sets

Kids Beds

Bunk & Loft Beds

Bunk & Loft Beds

Bedding & Pillows

Bedding & Pillows

Cribs

Playroom Sets

Kids Vanities

Kids Seatings

Kids Storage

Student Desk

Pet Beds

Litter Boxes & Enclosures

Litter Boxes & Enclosures

Bar Stools & Chairs

Bar Stools & Chairs

Carts & Trays

Bar & Storage

Bar & Bar Sets

Bar & Wine Tools

Bar & Wine Tools

Outdoor Sofas & Sectionals

Outdoor Sofas & Sectionals

Outdoor Stool & Benches

Outdoor Stool & Benches

Heating & Firepits

Heating & Firepits

Sunbeds & Hammocks

Sunbeds & Hammocks

Shades & Umbrellas

Shades & Umbrellas

Outdoor Furniture Sets

Outdoor Furniture Sets

Outdoor Accessories

Outdoor Accessories

Painting

Photography

Drawings

Televisions

Microwaves

Coffeemakers

Twin

Full

Queen

King

BunkieBoard

Pillows

Twin

Full

Queen

California King

California King

King

Twin

Full

Queen

California King

California King

King

Bed Frames

Pillows

Bed Frames

Pillows

Rectangle Rugs

Round Rugs

Outdoor Rugs

Outdoor Rugs

Chandeliers

WallLights

TableLamps

Floor Lamps

Ceiling Lights & Fans

Ceiling Lights & Fans

Clocks

Mirrors

Candles & Holders

Candles & Holders

Accent Pillows

Planters & Terrariums

Planters & Terrariums

Home Accents

Coat Racks

{{ trans('prices') }}

{{ trans('styles') }}

Bohemian

Bohemian

Country

Country

Glam

Glam

Industrial

Industrial

Modern

Modern

Novelty

Novelty

Traditional

Traditional

Transitional

Transitional

Vintage

Vintage

{{ trans('colors') }}

Beige

Beige

Black

Black

Blue

Blue

Brown

Brown

Copper

Copper

Gold

Gold

Gray

Gray

Green

Green

Multi Color

Multi Color

Orange

Orange

Pink

Pink

Purple

Purple

Red

Red

Silver

Silver

Translucent

Translucent

White

White

Yellow

Yellow

Navy

Navy

Ivory

Ivory

Saddle

Saddle

Camel

Camel

{{ trans('materials') }}

Ceramic

Ceramic

Concrete

Concrete

Fabric

Fabric

Glass

Glass

Leather

Leather

Stone

Stone

Metal

Metal

Mirror

Mirror

Plastic

Plastic

Rattan

Rattan

Wood

Wood

Marble

Marble

Size

Twin

Twin

Twin XL

Twin XL

Full

Full

Queen

Queen

King

King

California King

California King

California King

Delivery

Fast Delivery

Fast Delivery

Open Box Deal

Open Box Deal

{{ trans('mfirms') }}

Ultra Firm

Ultra Firm

Firm

Firm

Cushionn Firm

Cushionn Firm

Medium

Medium

Plush

Plush

Ultra Plush

Ultra Plush

{{ trans('mpillowtops') }}

Pillow Top

Pillow Top

Non Pillow Top

Non Pillow Top

{{ trans('mbrands') }}

American Star

American Star

Serta

Serta

Sealy

Sealy

Wellsville

Wellsville

Tempurpedic

Tempurpedic

Other

Other

{{ trans('mtypes') }}

Innerspring Mattress

Innerspring Mattress

Innerspring Mattress

Memory Foam Mattress

Memory Foam Mattress

Memory Foam Mattress

Hybrid Mattress

Hybrid Mattress

Hybrid Mattress

{{ trans('mtypes') }}

Twin

Twin

Twin XL

Twin XL

Full

Full

Queen

Queen

King

King

California King

California King

California King

{{ trans('tableshape') }}

Round

Round

Square

Square

Rectangle

Rectangle

Oval

Oval

{{ trans('orders') }}

Featured

New Arrivals

On sale

Price Low to High

Price Low to High

Price High to Low

Price High to Low

{{lang == 'mx' ? 'Fitros activos:' : 'Active Filters:'}}

{{clearer}}

Fast delivery product

Open box deal product

{{size.tvsize}}"

{{item.product_stock}} {{lang == 'mx' ? 'Disponibles' : 'Available'}}

{{lang == 'mx' ? 'Recíbelo del ' : 'Receive it from '}} April 05 {{lang == 'mx' ? 'al ' : 'to '}} April 20

{{lang == 'mx' ? 'Recíbelo de 1 a 3 semanas' : 'Receive it from 1 to 3 weeks'}}

{{translate(item.item_name)}}{{ item.set_qty > 1 ? ' ('+trans('per')+item.set_qty+')' : '' }}

{{translate(item.subname)}}{{ item.set_qty > 1 ? ' ('+trans('per')+item.set_qty+')' : '' }}

{{ format(item.discount) }} {{currency}} Sale

{{format(item.price)}} {{currency}} {{ format(item.price) }} {{currency}}

{{ lang == 'mx' ? 'Por favor contáctanos para mas información.' : 'Please contact us to check availability..' }} {{ lang == 'mx' ? 'Preguntar por WhatsApp' : 'Ask on WhatsApp' }}

{{ trans('totalPages') }} {{totalPages}}

{{ trans('waiting') }}

{{ trans('nofounds') }}

Safe Shipping Across the U.S. We ship with the main parcels in the country.

Secure Payments Pay with Card, PayPal, Deposits or transfer.

Secure Delivery Guaranteed and insured products to reach your destination.

Share in your social networks

hola

hola

hola

hola

hola

{{item.item_name}} | {{ translate(item.simplified_color,'colors') }}

{{ price }} {{currency}}

{{ discount }} {{currency}} {{ price }} {{currency}}

{{ translate(item.simplified_color,'colors') }}

{{ translate(item.item_size,'pieces') }}

{{ translate(item.stylename,'styles') }}

{{ translate(item.finishcolor,'materials') }}

{{ item.shippingweight }} {{ trans('weight') }}

{{trans('colors')}}

{{trans('sizes')}}

{{size.size}}

{{trans('quantity')}}

{{ trans('incart') }}

{{ trans('view') }}

contact us

(213) 674-5018

payment

AMEX

AMEX

AMEX

AMEX

AMEX