select CompanyProdID ,a.CompanyID,a.ProductID,producttitle,ProductDesc,ProdName, productimagefilepath, price, pricecurrency,a.brandid,productcondition, placeoforigin, minorderqty, supplyability, packagingdetails, deliverydetails, specifications,productvideolink, ProductName,CompanyName,Add1,Add2,Add3,TelStdCode,TelNo,contactperson,Activities,lattitude,longitude,mapzoom,city,productrating,brandname,brandimage from trncompanyprod a inner join mstcompany c on a.CompanyID=c.CompanyID left join mstproduct b on a.productid=b.ProductID left join mstbrands d on a.brandid=d.brandid WHERE companyprodid = '' LIMIT 0,1
Here at Hernandez Concrete we focus on our customers satisfaction and our quality work for both big and small projects. We do driveway, retaining wall, patio, foundations, stamped concrete, colored concrete and more
Location
Year Established
Business Type
-
Turn over
US$
Employees
Main Markets