residentialSELECT DISTINCT companies.*, SUM(cc.weight) AS catsum FROM companies LEFT JOIN company_categories AS cc ON cc.company_id = companies.id LEFT JOIN categories AS cat ON cc.category_id = cat.id LEFT JOIN categories AS pcat ON pcat.id = cat.parent_category_id WHERE DATE(companies.date_published) <= '2020-10-20' AND (companies.date_expires >= '2020-10-20' OR companies.date_expires IS null) AND companies.date_rejected IS null AND (cat.urlname IN ('residential') OR pcat.urlname IN ('residential')) GROUP BY companies.id ORDER BY catsum DESC, date_modified DESC, date_added DESC Currently Available Residential Agencies & Freelancers in Asia | CreativeHunt

Join CreativeHunt

Asia's largest creative industry network & guide

  • POST JOB VACANCIES

  • LIST YOUR AGENCY

  • APPLY FOR JOBS

  • CREATE ALERTS

  • REQUEST QUOTATIONS

  • CONNECT WITH OTHERS

Create an Account

Already have an account? Sign In

Title

Message

Creative Directory

526 Currently Available Agencies and Freelancers

Get Listed

Directory > Furniture Design > Residential 6 Listings Found

Get Listed

Advertising

App & Web Development

Architecture

Branding

Events

Experiential

Fashion & Beauty

Furniture Design

Graphic Design

Interior Design

Landscaping

Music

Packaging Design

Photography

PR & Marketing

Product Design

Video

Writing