<% if request.querystring("plan") = "" then plan = request.form("plan") else plan = request.querystring("plan") end if set conn = Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open "C:\Inetpub\vhosts\designconnection.com\cgi-bin\dcdata.mdb" set rs = Server.CreateObject("ADODB.Recordset") rs.Open "PLANS WHERE plannumber = '" & plan & "'", conn if rs.eof then response.redirect "/index.htm" end if slab = rs("slab") basement = rs("basement") crawlspace = rs("crawlspace") daylight = rs("daylight") pole = rs("pole") if rs.eof then rs.Close conn.Close response.redirect "/index.htm" end if dnumber = rs("dnumber") set conn3 = Server.CreateObject("ADODB.Connection") conn3.Provider="Microsoft.Jet.OLEDB.4.0" conn3.Open "C:\Inetpub\vhosts\designconnection.com\cgi-bin\dcdata.mdb" set rs4 = Server.CreateObject("ADODB.Recordset") rs4.Open "OPTIONS WHERE dnumber = '" & dnumber & "'", conn3 extrablueprint = rs4("extrablueprint") reverseplan = rs4("reverseplan") artwork = rs4("artwork") correctreading = rs4("correctreading") mlist = rs4("mlist") ex2 = rs4("b2") ex3 = rs4("b3") ex4 = rs4("b4") ex5 = rs4("b5") ex6 = rs4("b6") set conn2 = Server.CreateObject("ADODB.Connection") conn2.Provider="Microsoft.Jet.OLEDB.4.0" conn2.Open "C:\Inetpub\vhosts\designconnection.com\cgi-bin\dcdata.mdb" set dn = Server.CreateObject("ADODB.Recordset") if rs("price") = "A" then dn.Open "A WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "B" then dn.Open "B WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "C" then dn.Open "C WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "D" then dn.Open "D WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "E" then dn.Open "E WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "F" then dn.Open "F WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "G" then dn.Open "G WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "H" then dn.Open "H WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "I" then dn.Open "I WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "J" then dn.Open "J WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "K" then dn.Open "K WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "L" then dn.Open "L WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "M" then dn.Open "M WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "N" then dn.Open "N WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if if rs("price") = "Z" then dn.Open "Z WHERE dnumber = '" & dnumber & "'", conn2 study = dn("study") set1 = dn("set1") set3 = dn("set3") set4 = dn("set4") set5 = dn("set5") set6 = dn("set6") builder = dn("set8") vellum = dn("vellum") cad = dn("cad") pdf = dn("pdf") end if %> <% if NOT rs("notes") ="" then %>

Please Note: <%=rs("notes")%>
<% else end if %>
<% if NOT rs("notes2") ="" then %>

Also Note: <%=rs("notes2")%>
<% else end if %>


<%if NOT rs("fp2") = "" then %> <% end if %> <%if NOT rs("fp3") = "" then %> <% end if %>
Plan Number:  <%=rs("plannumber")%>
Plan Information:
<% if NOT rs("biglogo") = "" then %> Click image for larger version: <% else end if %>
<% if NOT rs("biglogo") = "" then %> " rel="lightbox">" border="0"> <% else %> " border="0"> <% end if %>

Square Feet : <%=rs("TotalSqftbonus")%>
Bedrooms:  <%=rs("bedrooms")%>
Baths:  <%=rs("baths")%>
Garage:  <%=rs("garagenum")%>
Exact Width:  <%=rs("exactWidth")%>
Exact Depth: <%=rs("exactDepth")%>
Style:  <%=rs("primarystyle")%>
Foundation Type: <%=rs("foundation")%>
<% if NOT rs("rear") ="" then %>

" rel="lightbox">Click here for rear elevation pictures.

<% else %> <% end if %> " target="_blank">Click here for more detailed plan information.

Floor Plans:
<% if NOT rs("fpbig1") = "" then %>
Click image for larger version:
<% else end if %>
<% if NOT rs("fpbig1") = "" then %> " rel="lightbox">" border="0"> <% else %> " border="0"> <% end if %>

Floor Plans:
<% if NOT rs("fpbig2") = "" then %>
Click image for larger version:
<% else end if %>
<% if NOT rs("fpbig2") = "" then %> <% else%>
" border="0">
<% end if %>
Additional Image / Floor Plans:
<% if NOT rs("fpbig3") = "" then %>
Click image for larger version:
<% else end if %>
<% if NOT rs("fpbig3") = "" then %> " rel="lightbox">" border="0"> <% else %> " border="0"> <% end if %>


Plan Sets:

To Order Call 1-860-485-4188, or use our secure ordering form below:

Plan: <%=rs("plannumber")%> - What do these plans include?
">"> <% if NOT rs4("extrablueprint") = "" then%> <%end if%> <% if NOT rs4("reverseplan") = "" then%> <%end if%> <% if NOT rs4("artwork") = "" then%> <%end if%> <% if NOT rs4("correctreading") = "" then%> <%end if%> <% if NOT rs4("mlist") = "" then%> <%end if%>
Plan sets:

Please select package:  


You must select a foundation: 

Extra's:

Extra Blueprints:  



Mirror Reversed Plan:  
Plan Artwork:  
Correct Reading Reversed Plan: 
Materials List: 

If you have any questions about this plan, options, or any general questions, please check our FAQ section by clicking here.
Please check your selections before processing your final order. All sales are final.


<% if NOT dn("study") = "" then%>
Study Sets:

To Order Call 1-860-485-4188, or use our simple ordering form below:

Plan: <%=rs("plannumber")%> - Study set rebate offer! - What do these plans include?

">">
*Study Set: 

If you have any questions about this plan, options, or any general questions, please check our FAQ section by clicking here.
Please check your selections before processing your final order. All sales are final.

<% rs.Close conn.Close rs4.Close conn3.Close dn.Close conn2.Close end if %>

Privacy Policy

House Plans | Garage Plans | Ordering Info | About Us
Contact Us | Links | Link To Us | Site Map | Disclaimer

Content is © 1992-2010 Design Connection, LLC