Store Locations & Hours

West Store - Lakewood
8640 West Colfax Avenue Lakewood, Co. 80215 Phone: 303-205-0350 888-510-0350 Toll-Free (Out of area only PLEASE) Click for Map	Open 7 Days! Regular Hours: (MT) Mon - Fri 10am-6pm Sat 10am-5pm Sun 12pm-4pm Call for holiday hours
South Store - Englewood
5050 South Federal Boulevard #31 Englewood, Co. 80110 Phone: 303-738-0202 Click for Map	Regular Hours: (MT) Mon - Fri 11am-6pm Sat 11am-4pm Closed Sunday Call for holiday hours
New Showroom opening April 1st! Largest in the Rockies, with an enclosed garden grow-room in the store!

<% Set menurs = Server.CreateObject("ADODB.Recordset") menurs.ActiveConnection = MM_growstore_STRING menurs.Source = "SELECT * FROM grostor.menu WHERE parentid = '0' ORDER BY sortorder" menurs.CursorType = 0 menurs.CursorLocation = 2 menurs.LockType = 1 menurs.Open() Set subrs = Server.CreateObject("ADODB.Recordset") subrs.ActiveConnection = MM_growstore_STRING subrs.Source = "SELECT * FROM grostor.menu WHERE parentid = '" + Request.QueryString("parentid") + "' ORDER BY sortorder" subrs.CursorType = 0 subrs.CursorLocation = 2 subrs.LockType = 1 subrs.Open() Set parentrs = Server.CreateObject("ADODB.Recordset") parentrs.ActiveConnection = MM_growstore_STRING parentrs.Source = "SELECT * FROM grostor.menu WHERE id = '" + Request.QueryString("parentid") + "' ORDER BY sortorder" parentrs.CursorType = 0 parentrs.CursorLocation = 2 parentrs.LockType = 1 parentrs.Open() if not parentrs.eof then if parentrs.fields.item("parentid").value <> "0" then subsparentid = parentrs.fields.item("parentid") end if end if Set subsparentrs = Server.CreateObject("ADODB.Recordset") subsparentrs.ActiveConnection = MM_growstore_STRING subsparentrs.Source = "SELECT * FROM grostor.menu WHERE parentid = '" + subsparentid + "' ORDER BY sortorder" subsparentrs.CursorType = 0 subsparentrs.CursorLocation = 2 subsparentrs.LockType = 1 subsparentrs.Open() Set haschildren = Server.CreateObject("ADODB.Recordset") haschildren.ActiveConnection = MM_growstore_STRING haschildren.Source = "SELECT * FROM grostor.menu WHERE id = '" + Request.QueryString("parentid") + "' ORDER BY sortorder" haschildren.CursorType = 0 haschildren.CursorLocation = 2 haschildren.LockType = 1 haschildren.Open() %> <% while (not menurs.eof) %> <%if cstr(menurs.fields.item("id").value)=request.QueryString("parentid") or cstr(menurs.fields.item("id").value)=subsparentid then response.write(" <% if not parentrs.eof then if cstr(menurs.fields.item("id").value)=request.QueryString("parentid") AND parentrs.fields.item("parentid").value = "0" then while (not subrs.eof) %> <% if cstr(subrs.fields.item("id").value)=request.QueryString("parentid") then response.write(" <% subrs.movenext wend else if NOT subsparentrs.eof and cstr(menurs.fields.item("id").value)=subsparentid then while (not subsparentrs.eof) %> <% if cstr(subsparentrs.fields.item("id").value)=request.QueryString("parentid") then response.write(" <% if cstr(subsparentrs.fields.item("id").value) = request.querystring("parentid") then while (not subrs.eof) %> <% if cstr(subrs.fields.item("id").value)=request.QueryString("parentid") then response.write(" <% subrs.movenext wend end if subsparentrs.movenext wend end if end if end if%> <% menurs.movenext wend %>

" + menurs.fields.item("itemdescript").value + "") else response.write("	" + menurs.fields.item("itemdescript").value + "") end if %>
" + subrs.fields.item("itemdescript").value + "") else response.write("	" + subrs.fields.item("itemdescript").value + "") end if %>
" + subsparentrs.fields.item("itemdescript").value + "") else response.write("	" + subsparentrs.fields.item("itemdescript").value + "") end if %>
" + subrs.fields.item("itemdescript").value + "") else response.write("	" + subrs.fields.item("itemdescript").value + "") end if %>
Search The Grow Store

House & Garden Nutrients Humboldt Nutrients

Sponsored By: