<%@LANGUAGE="VBSCRIPT"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_mitchell_STRING MM_editTable = "freereport" MM_editRedirectUrl = "formaction.asp?action=freereport" MM_fieldsStr = "sell|value|sell1|value|sell2|value|buyer|value|buyer1|value|fname|value|lname|value|email|value|iam|value" MM_columnsStr = "sell|none,'Y','N'|sell1|none,'Y','N'|sell2|none,'Y','N'|buyer|none,'Y','N'|buyer1|none,'Y','N'|fname|',none,''|lname|',none,''|email|',none,''|iam|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) session(MM_fields(MM_i)) = Request.Form(MM_fields(MM_i)) 'this sets the session for a given field name Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> Mitchell Team | Real Estate Newmarket, RealCanada Networks

The Mitchell Team is pleased to offer a Complimentary Home Staging Consultation to each of our clients.

A FREE service valued at $175-$350 depending on the size of your home. The Mitchell Team is committed to getting you Top dollar for your home.

Did you know - Buyers know within the first 30 seconds they are in a house if it is going to be their home. Buying a Home is a very emotional decision.

When you put your home up for sale you should no longer think of it as your home. It’s now a product and your goal is to market it as such. By staging your house we help it appeal to the widest audience possible, therefore sell faster and for more money!

Whether you need to completely transform your living space or simply need help with furniture and accessory placement. One of York Regions finest interior decorators will guide you staging your home to sell for top dollar. She will advise you how to make your home appear bigger and brighter.

Once your home is listed we will determine if your home would benefit from home staging. From there our home stager will visit you and your home to view the exterior and interior and establish what areas could benefit from staging. After conducting a room by room analysis they will return to their office and put together a comprehensive report that will include recommendations for areas of concern and how to highlight each room’s best features. You will receive a copy of the report and you can then decide if you would like to do the work yourself or hire the home stager to do the work for you.

Click here to view a gallery of rooms before and after Staging
10 tips for creating the perfect curb appeal
Psychology of Colour
Staging a Fabulous Kitchen

For more information on FREE Home Staging Consultation please fill out the simple form below.

Required fields are bold. We respect your privacy – your information is never shared or sold to outside entities. See our Privacy Policy.

First Name :
Last Name :
Home Phone:
Email :
Address:
Comments: