Select CompanyProdID,producttitle,productdesc,productimagefilepath,ProductName,a.productid,b.groupid,maingroupnameurl,a.companyid from trncompanyprod_forsearch a inner JOIN mstproduct b
on a.ProductID=b.ProductId inner join mstmaingroup c on b.maingroupid=c.maingroupid
where a.CompanyID= ? and a.isproductapproved=1
ORDER by ProductOrderNo=0, ProductOrderNo ASC,productimagefilepath desc, a.productlastmodifieddate desc,companyprodid desc limit 0, 3000 Kids Nursery from The Redwood Nursery - Saadiyat Island in Abu Dhabi, United Arab Emirates
Combining tradition with innovation, the finest purpose-built Montessori early years education system with the highest level of care, safety & hygiene. We are inspired by the world’s tallest tree Redwood which grows up to 377 feet high, further strengthening our belief in the need for a strong foundation to reach the heights of success. We aim to provide our children with this and more in their early years for them to maximize their potential. Open for children between 4 months to 4 years. We are Redwood Montessori Nursery, part of Kids First Group.
