string(875) " 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.ProjectSlug = 'Deer-Creek-Asphalt-Resurfacing' " Deer Creek Asphalt Resurfacing | Genesis

Deer Creek Asphalt Resurfacing

> Deer Creek Asphalt Resurfacing

Deer Creek Asphalt Resurfacing

Client: Greenacre Properties
Location: Hillsborough County, FL
Size: 1 mile
Service: Transportation & Mobility

Contact Staff: Bruce T. Kaschyk, AICP
 

Genesis is assisting in repaving and improvements to the existing roads beginning at the gated entry and extending approximately 1 mile.

www.GenesisGroup.com

Deer Creek Asphalt Resurfacing


Hillsborough County, FL

Client:

Greenacre Properties

Location:

Hillsborough County, FL

Size:

1 mile

Contact Staff:

Bruce T. Kaschyk, AICP

Deer Creek Asphalt Resurfacing

Genesis is assisting in repaving and improvements to the existing roads beginning at the gated entry and extending approximately 1 mile.

Projects::__set_state(array( ))