<% Response.Buffer = true %> <% 'Database Connection String; 'Server.MapPath = the location of the database on the server 'please change the path to the correct path on your server Set objADO = Server.CreateObject("ADODB.Connection") sDSN = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db\fsboREplus.mdb") & ";" objADO.Open sDSN 'Contact Variables; Used in contact.asp and other pages that contain the contact info. 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. ' Create a recordset object to store specific table information Set objConfig = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblConfig" 'Set the recordset object equal to the SQL query string objConfig.Open SQL, objADO, 1, 3 strVarCompany = objConfig("Company") strVarAddress = objConfig("CompanyAddress") strVarCity = objConfig("CompanyCity") strVarState = objConfig("CompanyState") strVarZip = objConfig("CompanyZip") strVarCountry = objConfig("CompanyCountry") strVarEmail = objConfig("CompanyEmail") strVarPhone = objConfig("CompanyPhone") strVarFax = objConfig("CompanyFax") strVarMainContact = objConfig("CompanyContact") strVarWebsite = objConfig("CompanyWebsite") strVarBGColor = objConfig("BGColor") strSlogan = objConfig("Slogan") strOfferAdvertising = objConfig("OfferAdvertising") str1000ImpressionsAdCost = objConfig("1000ImpressionsCost") str5000ImpressionsAdCost = objConfig("5000ImpressionsCost") str10000ImpressionsAdCost = objConfig("10000ImpressionsCost") str50000ImpressionsAdCost = objConfig("50000ImpressionsCost") str100000ImpressionsAdCost = objConfig("100000ImpressionsCost") strServiceType = objConfig("ServiceType") strServiceAdCost = objConfig("ServiceAdCost") strAgentList = objConfig("AgentList") strLogo = objConfig("logo") strKeywords = objConfig("Keywords") strMetaDescription = objConfig("MetaDescription") 'PAYPAL VARIABLES - See PaypalCode.doc located in the documentation folder 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. 'Email address the payment should be sent to strPayPalEmail = objConfig("PayPalEmail") strAgentFeatured1MonthCost = objConfig("AgentFeatured1MonthCost") strAgentFeatured3MonthCost = objConfig("AgentFeatured3MonthCost") strAgentFeatured6MonthCost = objConfig("AgentFeatured6MonthCost") strAgentFeatured12MonthCost = objConfig("AgentFeatured12MonthCost") strAgentStandard1MonthCost = objConfig("AgentStandard1MonthCost") strAgentStandard3MonthCost = objConfig("AgentStandard3MonthCost") strAgentStandard6MonthCost = objConfig("AgentStandard6MonthCost") strAgentStandard12MonthCost = objConfig("AgentStandard12MonthCost") strUserFeatured1MonthCost = objConfig("UserFeatured1MonthCost") strUserFeatured3MonthCost = objConfig("UserFeatured3MonthCost") strUserFeatured6MonthCost = objConfig("UserFeatured6MonthCost") strUserFeatured12MonthCost = objConfig("UserFeatured12MonthCost") strUserStandard1MonthCost = objConfig("UserStandard1MonthCost") strUserStandard3MonthCost = objConfig("UserStandard3MonthCost") strUserStandard6MonthCost = objConfig("UserStandard6MonthCost") strUserStandard12MonthCost = objConfig("UserStandard12MonthCost") 'Description of the service to appear on the Featured Listing receipt strFeaturedAdDescription = "Featured Listing on " & strVarWebsite 'Description of the service to appear on the Regular Listing receipt strStandardAdDescription = "Standard Listing on " & strVarWebsite 'Description of the service to appear on the Upgrade Listing receipt strUpgradeAdDescription = "Upgrade Listing on " & strVarWebsite 'Cost you want to charge for the listing strUpgradeAdCost = objConfig("UpgradeAdCost") 'whether ads are paid or free strListingType = objConfig("ListingType") 'Page that the user should return to after making payment for featured ad; 'They should return to page step1F.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1F.asp strPayPalReturnPageFeatured = strVarWebsite + "/featuredsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageRegular = strVarWebsite + "/standardsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageUpgrade = strVarWebsite + "/upgradesuccess.asp" 'Page that the user should return to if cancelling before completing PayPal payment; 'They should return to page cancel.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/cancel.asp strPayPalCancel = strVarWebsite + "/cancel.asp" %> <% Sub CreateRoomCombo(iCount)%> <% End Sub Sub CreateFlooringCombo(iCount)%> <% End Sub ' Formats a given 10 digit number into a nice looking phone number ' Example: given strNumber of 8005551212 you get (800) 555-1212 Function FormatPhoneNumber(strNumber) Dim strInput ' String to hold our entered number Dim strTemp ' Temporary string to hold our working text Dim strCurrentChar ' Var for storing each character for eval. Dim I ' Looping var ' Uppercase all characters for consistency strInput = UCase(strNumber) ' To be able to handle some pretty bad formatting, strip out ' all characters except for chars A to Z and digits 0 to 9 ' before proceeding. I left in the chars for slogan ' numbers like 1-800-GET-CASH etc... For I = 1 To Len(strInput) strCurrentChar = Mid(strInput, I, 1) ' Numbers (0 to 9) If Asc("0") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("9") Then strTemp = strTemp & strCurrentChar End If ' Upper Case Chars (A to Z) If Asc("A") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("Z") Then strTemp = strTemp & strCurrentChar End If Next 'I ' Swap strTemp back to strInput for next set of validation strInput = strTemp strTemp = "" ' Remove leading 1 if applicable If Len(strInput) = 11 And Left(strInput, 1) = "1" Then strInput = Right(strInput, 10) End If ' Error catch to make sure strInput is proper length now that ' we've finished manipulating it. If Not Len(strInput) = 10 Then ' Handle errors. Err.Raise 1, "FormatPhoneNumber function", _ "The phone number to be formatted must be a valid 10 digit US phone number!" End If ' If an error occurred then the rest of this won't get processed. ' Build the output formatted string ' (xxx) xxx-xxxx strTemp = "(" ' "(" strTemp = strTemp & Left(strInput, 3) ' Area code strTemp = strTemp & ") " ' ") " strTemp = strTemp & Mid(strInput, 4, 3) ' Exchange strTemp = strTemp & "-" ' "-" strTemp = strTemp & Right(strInput, 4) ' 4 digit part ' Set return value FormatPhoneNumber = strTemp End Function sub openrs(rs, sql) Set rs = Server.CreateObject("ADODB.Recordset") rs.CursorLocation = adUseServer rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText end sub function ToHTML(strValue) if IsNull(strValue) then ToHTML = "" else ToHTML = Server.HTMLEncode(strValue) end if end function function ToURL(strValue) if IsNull(strValue) then strValue = "" ToURL = Server.URLEncode(strValue) end function function GetValueHTML(rs, strFieldName) GetValueHTML = ToHTML(GetValue(rs, strFieldName)) end function function GetValue(rs, strFieldName) on error resume next if rs is nothing then GetValue = "" elseif (not rs.EOF) and (strFieldName <> "") then res = rs(strFieldName) if isnull(res) then res = "" end if GetValue = res else GetValue = "" end if if bDebug then response.write err.Description end function function GetParam(ParamName) if Request.QueryString(ParamName).Count > 0 then Param = Request.QueryString(ParamName) elseif Request.Form(ParamName).Count > 0 then Param = Request.Form(ParamName) else Param = "" end if if Param = "" then GetParam = Empty else GetParam = Param end if end function Function ToSQL(Value, sType) Param = Value if Param = "" then ToSQL = "Null" else if sType = "Number" then ToSQL = CDbl(Param) else ToSQL = "'" & Replace(Param, "'", "''") & "'" end if end if end function function DLookUp(Table, fName, sWhere) on error resume next Res = cn.execute("select " & fName & " from " & Table & " where " & sWhere).Fields(0).Value if IsNull(Res) then Res = "" DLookUp = Res end function function getCheckBoxValue(sVal, CheckedValue, UnCheckedValue, sType) if isempty(sVal) then if UnCheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = UnCheckedValue else getCheckBoxValue = "'" & Replace(UnCheckedValue, "'", "''") & "'" end if end if else if CheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = CheckedValue else getCheckBoxValue = "'" & Replace(CheckedValue, "'", "''") & "'" end if end if end if end function function getValFromLOV(sVal, aArr) sRes = "" if (ubound(aArr) mod 2) = 1 then for i = 0 to ubound(aArr) step 2 if cstr(sVal) = cstr(aArr(i)) then sRes = aArr(i+1) next end if getValFromLOV = sRes end function function get_options(sql,is_search,is_required,selected_value) options_str="" if is_search then options_str=options_str&"" else if is_required then options_str=options_str&"" end if openrs tmprs,sql while not tmprs.EOF id=GetValue(tmprs, 0) value=GetValue(tmprs, 1) selected="" if CStr(id) = CStr(selected_value) then selected = "SELECTED" end if options_str = options_str & "" tmprs.MoveNext wend get_options = options_str end function Function ProceedError() if cn.Errors.Count > 0 then ProceedError = cn.Errors(0).Description & " (" & cn.Errors(0).Source & ")" elseif not (Err.Description = "") then ProceedError = Err.Description else ProceedError = "" end if end Function function CheckSecurity(iLevel) if Session("UserID") = "" then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) else if CLng(Session("UserRights")) < CLng(iLevel) then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) End if end function %> <% 'Set all form variable values equal to NULL strUserName = "" strPassword = "" 'Retrieving form input and assigning to a variable 'txtUserName is the name of a text box on the form strUserName = Request.Form ("txtUserName") strPassword = Request.Form("txtPassword") strAction = request("cmdAction") strSubmit = request("cmdSubmit") strSearch = request("cmdSearch") strEmail = request("txtEmail") strSiteId = request("txtSiteId") 'This code only runs if the submit button is clicked if Request.Form <> "" and strSearch <> "" then if strSiteId = "" then msg = "You must enter a site id to search." end if if msg = "" then ' Create a recordset object to store specific table information Set objSearch = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From REListing where REListingId=" & strSiteId 'Set the recordset object equal to the SQL query string objSearch.Open SQL, objADO, 1, 3 if objSearch.EOF then msg = "Site Id " & strSiteId & " does not exist in our database. Please try again." else Response.Redirect "detail.asp?Id=" & strSiteId end if end if end if if Request.Form <> "" and strAction <> "" then 'Sets an error message if any required fields are left blank if strUserName = "" or strPassword = "" then WarningErrMsg = "
All fields are required." end if 'If error message was not set, then all error checks were passed; Connect to the database if WarningErrMsg = "" then ' Create a recordset object to store specific table information Set objRS = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblLogin where (UserName = '" + strUserName + "') AND (Password = '" + strPassword + "')" 'Set the recordset object equal to the SQL query string objRS.Open SQL, objADO, 1, 3 'Checks to see if the recordset is empty - record not found. EOF = End Of File. If empty: Login Denied if objRS.EOF then WarningErrMsg = "
Member information not found. ACCESS DENIED!
You must be registered to be able to login." else 'If login is present - set session variables and login. session("AccessLevel") = objRs("AccessLevel") session("UserName") = strUserName session.Timeout = 120 Response.Redirect "menu.asp" end if end if end if if Request.Form <> "" and strSubmit <> "" then if strEmail = "" then strWarning = "You must type an email address to join our mailing list." end if 'Make sure a valid email address if strEmail <> "" and (instr( strEmail, "@") = 0 or instr( strEmail, ".") = 0) then strWarning = "
Email Address must be in the form account@server.com." end if if strWarning = "" then ' Create a recordset object to store specific table information Set objEmail = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblEmail where (EmailAddress = '" + strEmail + "')" 'Set the recordset object equal to the SQL query string objEmail.Open SQL, objADO, 1, 3 if objEmail.EOF then objEmail.addnew objEmail("EmailAddress") = strEmail objEmail("DateAdded") = Date() objEmail.update strWarning ="
Your email address has been sucessfully added to our mailing list." 'Mail STATING you hate to see them go and link if they want to subscribe again. ' Create a recordset object to store specific table information strSubject = strVarCompany & " Mail Subscription Request" strBody = strBody + "Your email address has been successfully added to our mailing list." &vbcrlf strBody = strBody + "Thank you for being a subscriber." & vbcrlf strBody = strBody + "To unsubscribe, use the url " & strVarWebsite & "." & vbcrlf strBody = strBody + "Again thank you for being a subscriber." Set objNewMail = Server.CreateObject("CDONTS.NewMail") objNewMail.From = strVarEmail objNewMail.To = strEmail objNewMail.Subject = strSubject objNewMail.BodyFormat = 1 'objNewMail.MailFormat = 1 objNewMail.Body = strBody objNewMail.Send() else strWarning = "
That Email Address already joined our mailing list." end if end if end if %> <% 'Database Connection String; 'Server.MapPath = the location of the database on the server 'please change the path to the correct path on your server Set objADO = Server.CreateObject("ADODB.Connection") sDSN = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db\fsboREplus.mdb") & ";" objADO.Open sDSN 'Contact Variables; Used in contact.asp and other pages that contain the contact info. 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. ' Create a recordset object to store specific table information Set objConfig = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblConfig" 'Set the recordset object equal to the SQL query string objConfig.Open SQL, objADO, 1, 3 strVarCompany = objConfig("Company") strVarAddress = objConfig("CompanyAddress") strVarCity = objConfig("CompanyCity") strVarState = objConfig("CompanyState") strVarZip = objConfig("CompanyZip") strVarCountry = objConfig("CompanyCountry") strVarEmail = objConfig("CompanyEmail") strVarPhone = objConfig("CompanyPhone") strVarFax = objConfig("CompanyFax") strVarMainContact = objConfig("CompanyContact") strVarWebsite = objConfig("CompanyWebsite") strVarBGColor = objConfig("BGColor") strSlogan = objConfig("Slogan") strOfferAdvertising = objConfig("OfferAdvertising") str1000ImpressionsAdCost = objConfig("1000ImpressionsCost") str5000ImpressionsAdCost = objConfig("5000ImpressionsCost") str10000ImpressionsAdCost = objConfig("10000ImpressionsCost") str50000ImpressionsAdCost = objConfig("50000ImpressionsCost") str100000ImpressionsAdCost = objConfig("100000ImpressionsCost") strServiceType = objConfig("ServiceType") strServiceAdCost = objConfig("ServiceAdCost") strAgentList = objConfig("AgentList") strLogo = objConfig("logo") strKeywords = objConfig("Keywords") strMetaDescription = objConfig("MetaDescription") 'PAYPAL VARIABLES - See PaypalCode.doc located in the documentation folder 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. 'Email address the payment should be sent to strPayPalEmail = objConfig("PayPalEmail") strAgentFeatured1MonthCost = objConfig("AgentFeatured1MonthCost") strAgentFeatured3MonthCost = objConfig("AgentFeatured3MonthCost") strAgentFeatured6MonthCost = objConfig("AgentFeatured6MonthCost") strAgentFeatured12MonthCost = objConfig("AgentFeatured12MonthCost") strAgentStandard1MonthCost = objConfig("AgentStandard1MonthCost") strAgentStandard3MonthCost = objConfig("AgentStandard3MonthCost") strAgentStandard6MonthCost = objConfig("AgentStandard6MonthCost") strAgentStandard12MonthCost = objConfig("AgentStandard12MonthCost") strUserFeatured1MonthCost = objConfig("UserFeatured1MonthCost") strUserFeatured3MonthCost = objConfig("UserFeatured3MonthCost") strUserFeatured6MonthCost = objConfig("UserFeatured6MonthCost") strUserFeatured12MonthCost = objConfig("UserFeatured12MonthCost") strUserStandard1MonthCost = objConfig("UserStandard1MonthCost") strUserStandard3MonthCost = objConfig("UserStandard3MonthCost") strUserStandard6MonthCost = objConfig("UserStandard6MonthCost") strUserStandard12MonthCost = objConfig("UserStandard12MonthCost") 'Description of the service to appear on the Featured Listing receipt strFeaturedAdDescription = "Featured Listing on " & strVarWebsite 'Description of the service to appear on the Regular Listing receipt strStandardAdDescription = "Standard Listing on " & strVarWebsite 'Description of the service to appear on the Upgrade Listing receipt strUpgradeAdDescription = "Upgrade Listing on " & strVarWebsite 'Cost you want to charge for the listing strUpgradeAdCost = objConfig("UpgradeAdCost") 'whether ads are paid or free strListingType = objConfig("ListingType") 'Page that the user should return to after making payment for featured ad; 'They should return to page step1F.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1F.asp strPayPalReturnPageFeatured = strVarWebsite + "/featuredsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageRegular = strVarWebsite + "/standardsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageUpgrade = strVarWebsite + "/upgradesuccess.asp" 'Page that the user should return to if cancelling before completing PayPal payment; 'They should return to page cancel.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/cancel.asp strPayPalCancel = strVarWebsite + "/cancel.asp" %> <% Sub CreateRoomCombo(iCount)%> <% End Sub Sub CreateFlooringCombo(iCount)%> <% End Sub ' Formats a given 10 digit number into a nice looking phone number ' Example: given strNumber of 8005551212 you get (800) 555-1212 Function FormatPhoneNumber(strNumber) Dim strInput ' String to hold our entered number Dim strTemp ' Temporary string to hold our working text Dim strCurrentChar ' Var for storing each character for eval. Dim I ' Looping var ' Uppercase all characters for consistency strInput = UCase(strNumber) ' To be able to handle some pretty bad formatting, strip out ' all characters except for chars A to Z and digits 0 to 9 ' before proceeding. I left in the chars for slogan ' numbers like 1-800-GET-CASH etc... For I = 1 To Len(strInput) strCurrentChar = Mid(strInput, I, 1) ' Numbers (0 to 9) If Asc("0") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("9") Then strTemp = strTemp & strCurrentChar End If ' Upper Case Chars (A to Z) If Asc("A") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("Z") Then strTemp = strTemp & strCurrentChar End If Next 'I ' Swap strTemp back to strInput for next set of validation strInput = strTemp strTemp = "" ' Remove leading 1 if applicable If Len(strInput) = 11 And Left(strInput, 1) = "1" Then strInput = Right(strInput, 10) End If ' Error catch to make sure strInput is proper length now that ' we've finished manipulating it. If Not Len(strInput) = 10 Then ' Handle errors. Err.Raise 1, "FormatPhoneNumber function", _ "The phone number to be formatted must be a valid 10 digit US phone number!" End If ' If an error occurred then the rest of this won't get processed. ' Build the output formatted string ' (xxx) xxx-xxxx strTemp = "(" ' "(" strTemp = strTemp & Left(strInput, 3) ' Area code strTemp = strTemp & ") " ' ") " strTemp = strTemp & Mid(strInput, 4, 3) ' Exchange strTemp = strTemp & "-" ' "-" strTemp = strTemp & Right(strInput, 4) ' 4 digit part ' Set return value FormatPhoneNumber = strTemp End Function sub openrs(rs, sql) Set rs = Server.CreateObject("ADODB.Recordset") rs.CursorLocation = adUseServer rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText end sub function ToHTML(strValue) if IsNull(strValue) then ToHTML = "" else ToHTML = Server.HTMLEncode(strValue) end if end function function ToURL(strValue) if IsNull(strValue) then strValue = "" ToURL = Server.URLEncode(strValue) end function function GetValueHTML(rs, strFieldName) GetValueHTML = ToHTML(GetValue(rs, strFieldName)) end function function GetValue(rs, strFieldName) on error resume next if rs is nothing then GetValue = "" elseif (not rs.EOF) and (strFieldName <> "") then res = rs(strFieldName) if isnull(res) then res = "" end if GetValue = res else GetValue = "" end if if bDebug then response.write err.Description end function function GetParam(ParamName) if Request.QueryString(ParamName).Count > 0 then Param = Request.QueryString(ParamName) elseif Request.Form(ParamName).Count > 0 then Param = Request.Form(ParamName) else Param = "" end if if Param = "" then GetParam = Empty else GetParam = Param end if end function Function ToSQL(Value, sType) Param = Value if Param = "" then ToSQL = "Null" else if sType = "Number" then ToSQL = CDbl(Param) else ToSQL = "'" & Replace(Param, "'", "''") & "'" end if end if end function function DLookUp(Table, fName, sWhere) on error resume next Res = cn.execute("select " & fName & " from " & Table & " where " & sWhere).Fields(0).Value if IsNull(Res) then Res = "" DLookUp = Res end function function getCheckBoxValue(sVal, CheckedValue, UnCheckedValue, sType) if isempty(sVal) then if UnCheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = UnCheckedValue else getCheckBoxValue = "'" & Replace(UnCheckedValue, "'", "''") & "'" end if end if else if CheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = CheckedValue else getCheckBoxValue = "'" & Replace(CheckedValue, "'", "''") & "'" end if end if end if end function function getValFromLOV(sVal, aArr) sRes = "" if (ubound(aArr) mod 2) = 1 then for i = 0 to ubound(aArr) step 2 if cstr(sVal) = cstr(aArr(i)) then sRes = aArr(i+1) next end if getValFromLOV = sRes end function function get_options(sql,is_search,is_required,selected_value) options_str="" if is_search then options_str=options_str&"" else if is_required then options_str=options_str&"" end if openrs tmprs,sql while not tmprs.EOF id=GetValue(tmprs, 0) value=GetValue(tmprs, 1) selected="" if CStr(id) = CStr(selected_value) then selected = "SELECTED" end if options_str = options_str & "" tmprs.MoveNext wend get_options = options_str end function Function ProceedError() if cn.Errors.Count > 0 then ProceedError = cn.Errors(0).Description & " (" & cn.Errors(0).Source & ")" elseif not (Err.Description = "") then ProceedError = Err.Description else ProceedError = "" end if end Function function CheckSecurity(iLevel) if Session("UserID") = "" then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) else if CLng(Session("UserRights")) < CLng(iLevel) then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) End if end function %> <%= strVarCompany %> - <%= objConfig("Keywords") %> <% strUserName = session("UserName") %>
<% 'Database Connection String; 'Server.MapPath = the location of the database on the server 'please change the path to the correct path on your server Set objADO = Server.CreateObject("ADODB.Connection") sDSN = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db\fsboREplus.mdb") & ";" objADO.Open sDSN 'Contact Variables; Used in contact.asp and other pages that contain the contact info. 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. ' Create a recordset object to store specific table information Set objConfig = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblConfig" 'Set the recordset object equal to the SQL query string objConfig.Open SQL, objADO, 1, 3 strVarCompany = objConfig("Company") strVarAddress = objConfig("CompanyAddress") strVarCity = objConfig("CompanyCity") strVarState = objConfig("CompanyState") strVarZip = objConfig("CompanyZip") strVarCountry = objConfig("CompanyCountry") strVarEmail = objConfig("CompanyEmail") strVarPhone = objConfig("CompanyPhone") strVarFax = objConfig("CompanyFax") strVarMainContact = objConfig("CompanyContact") strVarWebsite = objConfig("CompanyWebsite") strVarBGColor = objConfig("BGColor") strSlogan = objConfig("Slogan") strOfferAdvertising = objConfig("OfferAdvertising") str1000ImpressionsAdCost = objConfig("1000ImpressionsCost") str5000ImpressionsAdCost = objConfig("5000ImpressionsCost") str10000ImpressionsAdCost = objConfig("10000ImpressionsCost") str50000ImpressionsAdCost = objConfig("50000ImpressionsCost") str100000ImpressionsAdCost = objConfig("100000ImpressionsCost") strServiceType = objConfig("ServiceType") strServiceAdCost = objConfig("ServiceAdCost") strAgentList = objConfig("AgentList") strLogo = objConfig("logo") strKeywords = objConfig("Keywords") strMetaDescription = objConfig("MetaDescription") 'PAYPAL VARIABLES - See PaypalCode.doc located in the documentation folder 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. 'Email address the payment should be sent to strPayPalEmail = objConfig("PayPalEmail") strAgentFeatured1MonthCost = objConfig("AgentFeatured1MonthCost") strAgentFeatured3MonthCost = objConfig("AgentFeatured3MonthCost") strAgentFeatured6MonthCost = objConfig("AgentFeatured6MonthCost") strAgentFeatured12MonthCost = objConfig("AgentFeatured12MonthCost") strAgentStandard1MonthCost = objConfig("AgentStandard1MonthCost") strAgentStandard3MonthCost = objConfig("AgentStandard3MonthCost") strAgentStandard6MonthCost = objConfig("AgentStandard6MonthCost") strAgentStandard12MonthCost = objConfig("AgentStandard12MonthCost") strUserFeatured1MonthCost = objConfig("UserFeatured1MonthCost") strUserFeatured3MonthCost = objConfig("UserFeatured3MonthCost") strUserFeatured6MonthCost = objConfig("UserFeatured6MonthCost") strUserFeatured12MonthCost = objConfig("UserFeatured12MonthCost") strUserStandard1MonthCost = objConfig("UserStandard1MonthCost") strUserStandard3MonthCost = objConfig("UserStandard3MonthCost") strUserStandard6MonthCost = objConfig("UserStandard6MonthCost") strUserStandard12MonthCost = objConfig("UserStandard12MonthCost") 'Description of the service to appear on the Featured Listing receipt strFeaturedAdDescription = "Featured Listing on " & strVarWebsite 'Description of the service to appear on the Regular Listing receipt strStandardAdDescription = "Standard Listing on " & strVarWebsite 'Description of the service to appear on the Upgrade Listing receipt strUpgradeAdDescription = "Upgrade Listing on " & strVarWebsite 'Cost you want to charge for the listing strUpgradeAdCost = objConfig("UpgradeAdCost") 'whether ads are paid or free strListingType = objConfig("ListingType") 'Page that the user should return to after making payment for featured ad; 'They should return to page step1F.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1F.asp strPayPalReturnPageFeatured = strVarWebsite + "/featuredsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageRegular = strVarWebsite + "/standardsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageUpgrade = strVarWebsite + "/upgradesuccess.asp" 'Page that the user should return to if cancelling before completing PayPal payment; 'They should return to page cancel.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/cancel.asp strPayPalCancel = strVarWebsite + "/cancel.asp" %> <% Sub CreateRoomCombo(iCount)%> <% End Sub Sub CreateFlooringCombo(iCount)%> <% End Sub ' Formats a given 10 digit number into a nice looking phone number ' Example: given strNumber of 8005551212 you get (800) 555-1212 Function FormatPhoneNumber(strNumber) Dim strInput ' String to hold our entered number Dim strTemp ' Temporary string to hold our working text Dim strCurrentChar ' Var for storing each character for eval. Dim I ' Looping var ' Uppercase all characters for consistency strInput = UCase(strNumber) ' To be able to handle some pretty bad formatting, strip out ' all characters except for chars A to Z and digits 0 to 9 ' before proceeding. I left in the chars for slogan ' numbers like 1-800-GET-CASH etc... For I = 1 To Len(strInput) strCurrentChar = Mid(strInput, I, 1) ' Numbers (0 to 9) If Asc("0") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("9") Then strTemp = strTemp & strCurrentChar End If ' Upper Case Chars (A to Z) If Asc("A") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("Z") Then strTemp = strTemp & strCurrentChar End If Next 'I ' Swap strTemp back to strInput for next set of validation strInput = strTemp strTemp = "" ' Remove leading 1 if applicable If Len(strInput) = 11 And Left(strInput, 1) = "1" Then strInput = Right(strInput, 10) End If ' Error catch to make sure strInput is proper length now that ' we've finished manipulating it. If Not Len(strInput) = 10 Then ' Handle errors. Err.Raise 1, "FormatPhoneNumber function", _ "The phone number to be formatted must be a valid 10 digit US phone number!" End If ' If an error occurred then the rest of this won't get processed. ' Build the output formatted string ' (xxx) xxx-xxxx strTemp = "(" ' "(" strTemp = strTemp & Left(strInput, 3) ' Area code strTemp = strTemp & ") " ' ") " strTemp = strTemp & Mid(strInput, 4, 3) ' Exchange strTemp = strTemp & "-" ' "-" strTemp = strTemp & Right(strInput, 4) ' 4 digit part ' Set return value FormatPhoneNumber = strTemp End Function sub openrs(rs, sql) Set rs = Server.CreateObject("ADODB.Recordset") rs.CursorLocation = adUseServer rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText end sub function ToHTML(strValue) if IsNull(strValue) then ToHTML = "" else ToHTML = Server.HTMLEncode(strValue) end if end function function ToURL(strValue) if IsNull(strValue) then strValue = "" ToURL = Server.URLEncode(strValue) end function function GetValueHTML(rs, strFieldName) GetValueHTML = ToHTML(GetValue(rs, strFieldName)) end function function GetValue(rs, strFieldName) on error resume next if rs is nothing then GetValue = "" elseif (not rs.EOF) and (strFieldName <> "") then res = rs(strFieldName) if isnull(res) then res = "" end if GetValue = res else GetValue = "" end if if bDebug then response.write err.Description end function function GetParam(ParamName) if Request.QueryString(ParamName).Count > 0 then Param = Request.QueryString(ParamName) elseif Request.Form(ParamName).Count > 0 then Param = Request.Form(ParamName) else Param = "" end if if Param = "" then GetParam = Empty else GetParam = Param end if end function Function ToSQL(Value, sType) Param = Value if Param = "" then ToSQL = "Null" else if sType = "Number" then ToSQL = CDbl(Param) else ToSQL = "'" & Replace(Param, "'", "''") & "'" end if end if end function function DLookUp(Table, fName, sWhere) on error resume next Res = cn.execute("select " & fName & " from " & Table & " where " & sWhere).Fields(0).Value if IsNull(Res) then Res = "" DLookUp = Res end function function getCheckBoxValue(sVal, CheckedValue, UnCheckedValue, sType) if isempty(sVal) then if UnCheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = UnCheckedValue else getCheckBoxValue = "'" & Replace(UnCheckedValue, "'", "''") & "'" end if end if else if CheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = CheckedValue else getCheckBoxValue = "'" & Replace(CheckedValue, "'", "''") & "'" end if end if end if end function function getValFromLOV(sVal, aArr) sRes = "" if (ubound(aArr) mod 2) = 1 then for i = 0 to ubound(aArr) step 2 if cstr(sVal) = cstr(aArr(i)) then sRes = aArr(i+1) next end if getValFromLOV = sRes end function function get_options(sql,is_search,is_required,selected_value) options_str="" if is_search then options_str=options_str&"" else if is_required then options_str=options_str&"" end if openrs tmprs,sql while not tmprs.EOF id=GetValue(tmprs, 0) value=GetValue(tmprs, 1) selected="" if CStr(id) = CStr(selected_value) then selected = "SELECTED" end if options_str = options_str & "" tmprs.MoveNext wend get_options = options_str end function Function ProceedError() if cn.Errors.Count > 0 then ProceedError = cn.Errors(0).Description & " (" & cn.Errors(0).Source & ")" elseif not (Err.Description = "") then ProceedError = Err.Description else ProceedError = "" end if end Function function CheckSecurity(iLevel) if Session("UserID") = "" then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) else if CLng(Session("UserRights")) < CLng(iLevel) then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) End if end function %> <% TodayDate = Now() TodayDate = FormatDateTime(TodayDate, VBShortDate) Set RS=Server.CreateObject("ADODB.RecordSet") SQL = vbNullString SQL = SQL & "UPDATE Clients " SQL = SQL & "SET Status='DontShow' WHERE ImpPur < ImpNow" objADO.execute(SQL) Set RS = Nothing Set RS=Server.CreateObject("ADODB.RecordSet") Query = "SELECT * FROM Clients WHERE Status='Show' AND StartDate <= #" & TodayDate & "#" RS.Open Query, objADO, 3, 3 IF (RS.EOF) THEN ShowBanner = "default" %> <% Else rndMax = CInt(RS.RecordCount) RS.MoveFirst Do While Not RS.EOF RS.MoveNext Loop RS.MoveFirst Randomize Timer rndNumber = Int(RND * rndMax) RS.Move rndNumber Id = RS("AdID") UrlTo = RS("LinkTo") GetImg = RS("ImgUrl") WriteSize1 = RS("SizeOf1") WriteSize2 = RS("SizeOf2") DisText = RS("TextUnder") ImpNow = RS("ImpNow") ImpNewNow = ImpNow + 1 Set RS = Nothing Set RS=Server.CreateObject("ADODB.RecordSet") SQL = vbNullString SQL = SQL & "UPDATE Clients " SQL = SQL & "SET ImpNow="&ImpNewNow&" WHERE AdID="&Id&"" objADO.execute(SQL) Set RS = Nothing End If %> <%=DisText%>
Home | Get Listed! | <% if strUserName = "" then %> Create An Account | <% end if %> <% if strUserName = "" then %> Member Login <% end if %> <% if strUserName <> "" then %> Logout <% end if %> | <% if strUserName <> "" then %> Control Panel | <% end if %> Search Listings | View Featured | Newest Properties | Testimonials
Seller Tools | Buyer Tools | Find An Agent | Services Directory | Mortgage Center <% if strOfferAdvertising = "Yes" then %> | Advertising <% end if %> | News | About Us | Contact
Register To List
Register with us and sell your property faster. Registration is simple and better yet FREE. You have to be registered to begin listing.
List Your Property
List your property on our site and SELL FAST! Sellers can place a 1, 3, 6, or 12 month featured or standard listing. Click here to find out more!
Search Real Estate
Search our current listings by type of home, price range, number of bedrooms, number of baths, and total square footage.
FEATURED LISTING

Feature your property!
Maximize it's exposure!

<% 'Database Connection String; 'Server.MapPath = the location of the database on the server 'please change the path to the correct path on your server Set objADO = Server.CreateObject("ADODB.Connection") sDSN = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db\fsboREplus.mdb") & ";" objADO.Open sDSN 'Contact Variables; Used in contact.asp and other pages that contain the contact info. 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. ' Create a recordset object to store specific table information Set objConfig = Server.CreateObject("ADODB.Recordset") 'Establish what records you want selected for the SQL query string SQL = "Select * From TblConfig" 'Set the recordset object equal to the SQL query string objConfig.Open SQL, objADO, 1, 3 strVarCompany = objConfig("Company") strVarAddress = objConfig("CompanyAddress") strVarCity = objConfig("CompanyCity") strVarState = objConfig("CompanyState") strVarZip = objConfig("CompanyZip") strVarCountry = objConfig("CompanyCountry") strVarEmail = objConfig("CompanyEmail") strVarPhone = objConfig("CompanyPhone") strVarFax = objConfig("CompanyFax") strVarMainContact = objConfig("CompanyContact") strVarWebsite = objConfig("CompanyWebsite") strVarBGColor = objConfig("BGColor") strSlogan = objConfig("Slogan") strOfferAdvertising = objConfig("OfferAdvertising") str1000ImpressionsAdCost = objConfig("1000ImpressionsCost") str5000ImpressionsAdCost = objConfig("5000ImpressionsCost") str10000ImpressionsAdCost = objConfig("10000ImpressionsCost") str50000ImpressionsAdCost = objConfig("50000ImpressionsCost") str100000ImpressionsAdCost = objConfig("100000ImpressionsCost") strServiceType = objConfig("ServiceType") strServiceAdCost = objConfig("ServiceAdCost") strAgentList = objConfig("AgentList") strLogo = objConfig("logo") strKeywords = objConfig("Keywords") strMetaDescription = objConfig("MetaDescription") 'PAYPAL VARIABLES - See PaypalCode.doc located in the documentation folder 'These variables are pulled from the table TblConfig and these values can 'be edited through the site admin control panel. Do not edit the values in this page. 'Email address the payment should be sent to strPayPalEmail = objConfig("PayPalEmail") strAgentFeatured1MonthCost = objConfig("AgentFeatured1MonthCost") strAgentFeatured3MonthCost = objConfig("AgentFeatured3MonthCost") strAgentFeatured6MonthCost = objConfig("AgentFeatured6MonthCost") strAgentFeatured12MonthCost = objConfig("AgentFeatured12MonthCost") strAgentStandard1MonthCost = objConfig("AgentStandard1MonthCost") strAgentStandard3MonthCost = objConfig("AgentStandard3MonthCost") strAgentStandard6MonthCost = objConfig("AgentStandard6MonthCost") strAgentStandard12MonthCost = objConfig("AgentStandard12MonthCost") strUserFeatured1MonthCost = objConfig("UserFeatured1MonthCost") strUserFeatured3MonthCost = objConfig("UserFeatured3MonthCost") strUserFeatured6MonthCost = objConfig("UserFeatured6MonthCost") strUserFeatured12MonthCost = objConfig("UserFeatured12MonthCost") strUserStandard1MonthCost = objConfig("UserStandard1MonthCost") strUserStandard3MonthCost = objConfig("UserStandard3MonthCost") strUserStandard6MonthCost = objConfig("UserStandard6MonthCost") strUserStandard12MonthCost = objConfig("UserStandard12MonthCost") 'Description of the service to appear on the Featured Listing receipt strFeaturedAdDescription = "Featured Listing on " & strVarWebsite 'Description of the service to appear on the Regular Listing receipt strStandardAdDescription = "Standard Listing on " & strVarWebsite 'Description of the service to appear on the Upgrade Listing receipt strUpgradeAdDescription = "Upgrade Listing on " & strVarWebsite 'Cost you want to charge for the listing strUpgradeAdCost = objConfig("UpgradeAdCost") 'whether ads are paid or free strListingType = objConfig("ListingType") 'Page that the user should return to after making payment for featured ad; 'They should return to page step1F.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1F.asp strPayPalReturnPageFeatured = strVarWebsite + "/featuredsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageRegular = strVarWebsite + "/standardsuccess.asp" 'Page that the user should return to after making payment for regular ad; 'They should return to page step1.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/step1.asp strPayPalReturnPageUpgrade = strVarWebsite + "/upgradesuccess.asp" 'Page that the user should return to if cancelling before completing PayPal payment; 'They should return to page cancel.asp under your domain; 'http://www.yourdomain.com/FSBO Auto Folder/cancel.asp strPayPalCancel = strVarWebsite + "/cancel.asp" %> <% Sub CreateRoomCombo(iCount)%> <% End Sub Sub CreateFlooringCombo(iCount)%> <% End Sub ' Formats a given 10 digit number into a nice looking phone number ' Example: given strNumber of 8005551212 you get (800) 555-1212 Function FormatPhoneNumber(strNumber) Dim strInput ' String to hold our entered number Dim strTemp ' Temporary string to hold our working text Dim strCurrentChar ' Var for storing each character for eval. Dim I ' Looping var ' Uppercase all characters for consistency strInput = UCase(strNumber) ' To be able to handle some pretty bad formatting, strip out ' all characters except for chars A to Z and digits 0 to 9 ' before proceeding. I left in the chars for slogan ' numbers like 1-800-GET-CASH etc... For I = 1 To Len(strInput) strCurrentChar = Mid(strInput, I, 1) ' Numbers (0 to 9) If Asc("0") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("9") Then strTemp = strTemp & strCurrentChar End If ' Upper Case Chars (A to Z) If Asc("A") <= Asc(strCurrentChar) And Asc(strCurrentChar) <= Asc("Z") Then strTemp = strTemp & strCurrentChar End If Next 'I ' Swap strTemp back to strInput for next set of validation strInput = strTemp strTemp = "" ' Remove leading 1 if applicable If Len(strInput) = 11 And Left(strInput, 1) = "1" Then strInput = Right(strInput, 10) End If ' Error catch to make sure strInput is proper length now that ' we've finished manipulating it. If Not Len(strInput) = 10 Then ' Handle errors. Err.Raise 1, "FormatPhoneNumber function", _ "The phone number to be formatted must be a valid 10 digit US phone number!" End If ' If an error occurred then the rest of this won't get processed. ' Build the output formatted string ' (xxx) xxx-xxxx strTemp = "(" ' "(" strTemp = strTemp & Left(strInput, 3) ' Area code strTemp = strTemp & ") " ' ") " strTemp = strTemp & Mid(strInput, 4, 3) ' Exchange strTemp = strTemp & "-" ' "-" strTemp = strTemp & Right(strInput, 4) ' 4 digit part ' Set return value FormatPhoneNumber = strTemp End Function sub openrs(rs, sql) Set rs = Server.CreateObject("ADODB.Recordset") rs.CursorLocation = adUseServer rs.Open sql, cn, adOpenForwardOnly, adLockReadOnly, adCmdText end sub function ToHTML(strValue) if IsNull(strValue) then ToHTML = "" else ToHTML = Server.HTMLEncode(strValue) end if end function function ToURL(strValue) if IsNull(strValue) then strValue = "" ToURL = Server.URLEncode(strValue) end function function GetValueHTML(rs, strFieldName) GetValueHTML = ToHTML(GetValue(rs, strFieldName)) end function function GetValue(rs, strFieldName) on error resume next if rs is nothing then GetValue = "" elseif (not rs.EOF) and (strFieldName <> "") then res = rs(strFieldName) if isnull(res) then res = "" end if GetValue = res else GetValue = "" end if if bDebug then response.write err.Description end function function GetParam(ParamName) if Request.QueryString(ParamName).Count > 0 then Param = Request.QueryString(ParamName) elseif Request.Form(ParamName).Count > 0 then Param = Request.Form(ParamName) else Param = "" end if if Param = "" then GetParam = Empty else GetParam = Param end if end function Function ToSQL(Value, sType) Param = Value if Param = "" then ToSQL = "Null" else if sType = "Number" then ToSQL = CDbl(Param) else ToSQL = "'" & Replace(Param, "'", "''") & "'" end if end if end function function DLookUp(Table, fName, sWhere) on error resume next Res = cn.execute("select " & fName & " from " & Table & " where " & sWhere).Fields(0).Value if IsNull(Res) then Res = "" DLookUp = Res end function function getCheckBoxValue(sVal, CheckedValue, UnCheckedValue, sType) if isempty(sVal) then if UnCheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = UnCheckedValue else getCheckBoxValue = "'" & Replace(UnCheckedValue, "'", "''") & "'" end if end if else if CheckedValue = "" then getCheckBoxValue = "Null" else if sType = "Number" then getCheckBoxValue = CheckedValue else getCheckBoxValue = "'" & Replace(CheckedValue, "'", "''") & "'" end if end if end if end function function getValFromLOV(sVal, aArr) sRes = "" if (ubound(aArr) mod 2) = 1 then for i = 0 to ubound(aArr) step 2 if cstr(sVal) = cstr(aArr(i)) then sRes = aArr(i+1) next end if getValFromLOV = sRes end function function get_options(sql,is_search,is_required,selected_value) options_str="" if is_search then options_str=options_str&"" else if is_required then options_str=options_str&"" end if openrs tmprs,sql while not tmprs.EOF id=GetValue(tmprs, 0) value=GetValue(tmprs, 1) selected="" if CStr(id) = CStr(selected_value) then selected = "SELECTED" end if options_str = options_str & "" tmprs.MoveNext wend get_options = options_str end function Function ProceedError() if cn.Errors.Count > 0 then ProceedError = cn.Errors(0).Description & " (" & cn.Errors(0).Source & ")" elseif not (Err.Description = "") then ProceedError = Err.Description else ProceedError = "" end if end Function function CheckSecurity(iLevel) if Session("UserID") = "" then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) else if CLng(Session("UserRights")) < CLng(iLevel) then response.redirect("Login.asp?QueryString=" & toURL(request.serverVariables("QUERY_STRING")) & "&ret_page=" & toURL(request.serverVariables("SCRIPT_NAME"))) End if end function %> <% sSQL = "SELECT * FROM REListing where (AdType = '1')" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sSQL, objADO, 1, 3 IF (RS.EOF) THEN %> There are not any featured properties. <% Else rndMax = CInt(RS.RecordCount) RS.MoveFirst Do While Not RS.EOF RS.MoveNext Loop RS.MoveFirst Randomize Timer rndNumber = Int(RND * rndMax) RS.Move rndNumber id = rs("REListingId") imgsrc = rs("REListingImage") 'UrlTo = RS("LinkTo") 'GetImg = RS("ImgUrl") 'WriteSize1 = RS("SizeOf1") 'WriteSize2 = RS("SizeOf2") 'DisText = RS("TextUnder") 'ImpNow = RS("ImpNow") 'ImpNewNow = ImpNow + 1 End If %> <% if not rs.EOF then %> "> <%If Len(rs("REListingImage")) > 0 Then %> " border="0" width="160" height="120"> <% Else%> <%End If %>
<%=rs("REListingAddress1")%>
<%=rs("REListingCity")%>, <%=rs("REListingState")%>   <%=rs("REListingZip")%>
<% if rs("REListingPrice") > "0" then %> <%= formatcurrency(rs("REListingPrice"))%> <% else %> Call For Price <% end if %> <% else %> No Featured Listings To Display At This Time <% end if %>

Click here to view other featured listings.

<% if Msg <> "" then %>
Message(s): <%= Msg %>
<% end if %>
Site Id Search:

MEMBER LOGIN <% if WarningErrMsg <> "" then %>
Message(s):<%= warningErrMsg %>
<% end if %>


User Name:
Password:

Not yet a member? Click here to register.
You must register to place listings.

Want to receive the latest news and promotions from our web site? It is simple! Just join our mailing list and we'll send you the hottest news from time to time!

<% if strWarning <> "" then %>

Message(s):
<%= strwarning %>
<% end if %>

Join Our Mailing List
Your email:

Click here to unsubscribe.

(c) <%= year(date) %> <%= strVarCompany %>
Read our Terms & Conditions, and Privacy Policy
Website Development Provided By: Development Solutions