string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 223 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 208 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 445 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 332 " string(844) " SELECT Projects.*, ProjectConditions.ConditionName, ProjectCategories.CategoryName, GROUP_CONCAT(DISTINCT Services.ServiceName SEPARATOR ', ') ServiceNames FROM Projects LEFT OUTER JOIN ProjectConditions ON Projects.ProjectCondition = ProjectConditions.ConditionID LEFT OUTER JOIN ProjectCategories ON Projects.CategoryID = ProjectCategories.CategoryID LEFT OUTER JOIN ProjectsToServices ON Projects.ProjectID=ProjectsToServices.ProjectID LEFT OUTER JOIN Services subServices ON ProjectsToServices.ServiceID=subServices.ServiceID LEFT OUTER JOIN Services ON (subServices.SubserviceTo=Services.ServiceID) OR (subServices.ServiceID=Services.ServiceID AND subServices.SubserviceTo IS NULL) WHERE Projects.ProjectID = 444 " Landscape Design | Genesis

Landscape Design

Discipline

Landscape Design

Applying recognized priciples of design to plan, build, and plant landscapes that are functional and aesthetic.

Representative Landscape Design Projects

Explore Landscape Design projects in our Portfolio:

Explore more projects >

Disciplines::__set_state(array( ))