%
'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
%>
<%
'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
%>
<%
'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
%>
<%
strMailSubmit = request("cmdMailSubmit")
strSearchId = request("cmdSearchId")
strEmail = request("txtEmail")
strSiteId = request("txtSiteId")
'This code only runs if the submit button is clicked
if Request.Form <> "" and strSearchId <> "" then
if strSiteId = "" then
SiteIdmsg = "You must enter a site id to search."
end if
if SiteIdmsg = "" 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
SiteIdmsg = "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 strMailSubmit <> "" then
if strEmail = "" then
strMailWarning = "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
strMailWarning = " Email Address must be in the form account@server.com."
end if
if strMailWarning = "" 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
strMailWarning =" 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
strMailWarning = " That Email Address already joined our mailing list."
end if
end if
end if
%>
FEATURED PROPERTY LISTINGS
Feature your property on our site
and sell fast! Click Here to find out how.
<%
'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 %>
Click here to view more featured properties.
<% end if %>
<% if SiteIdMsg <> "" then %>
Message(s): <%= SiteIdMsg %>
<% end if %>
<% if strMailWarning <> "" then %>
Message(s): <%= strMailWarning %>
<% end if %>
LOAN PROGRAMS
"A" PAPER HOME MORTGAGE PROGRAMS
First Time Home Buyer Loan
Program
Whether you're a first time home buyer or simply
starting over, a First Time Home Buyer loan can help. It's a
fast, streamlined way to help new home buyers with the necessary cash at closing
for their down payment and closing costs that they do not have to repay. Fixed
and adjustable rate mortgage products up to 100%
LTV/CLTV.
Conventional Home Mortgage Loan
Program
Conventional conforming home loan, including fixed and
adjustable rate mortgage products, fixed period ARMs, and balloon loans to meet
a lot of borrowers' needs. For larger home mortgage loan amounts, there are
jumbo home loans to $650,000, super jumbo loans to $1,000,000, and mega mortgage
jumbo loan products to $2,000,000.
Fast
& Easy Home Loan Program - Great Price for Great Borrowers!
The
Fast & Easy home loan program offers borrowers with excellent credit a home
loan up to 90% LTV/CLTV without verification of assets or income. This home loan
program offers a great price for borrowers with high quality credit. Just like
its name, it's fast, very easy and there's an 80/10/10
with a Super Streamline HELOC under this home loan program to avoid Mortgage
Insurance. Borrowers can be self employed or salaried, and there are no reserve
requirements with a low down payment loan.
Expanded Criteria Home Mortgage Loan Program
Getting turned down or spending hours finding a loan just because
your finances don't fall within the "cookie cutter" criteria for a traditional
loan program. Expanded Criteria program is the answer. These "A" paper loans are
offered for fixed rates, ARMs and Conforming Fixed 3/1, 5/1, 7/1 & 10/1
ARMs. There are also many no income loan programs such as Reduced Doc, No Ratio
and No Income/No Asset loan programs.
Zero Down
Payment 103% Plan up to $375,000, a loan that allows borrower's to finance up to
100% LTV. They can even include up to 3% closing costs and prepaid fees in the
home loan amount, for a total loan LTV of 103%!*
Zero Down
Payment, 80/20 with a combined mortgage loan amount up to $500,000.The second
mortgage loan can be a HELOC or Fixed Rate and there are no home Mortgage
Insurance loan requirements.
VA IRRRLs
(interest rate reduction refinance home loan)
Teacher Next
Door home loan
Many government
loans allow minimum down payment and/ordown payment
assistance home loan for a true zero no down
payment home buyer loan.
FHLMC Affordable Gold 97 - Low Income Home Loan
Financing
This
program is the "simple" answer for low to moderate income financing. As long as
a borrower's income doesn't exceed 100% of the MSA median income, he or she may
qualify for as little as 3% down. Plus, the down payment can be a grant,
"affordable second" or unsecured mortgage loan (from anon-profit
organization,government
agency or the borrower's employer), or can come from the borrower's own funds or
a gift from a family member. Only one month of reserves is required. Premium
pricing is allowed for closing costs/prepaids, and home buyer education is not
required!
Flex 97 - Ideal First Time Home Buyer Loan
Program
This
program is ideal for the First Time Home
Buyer and move-up borrowers who lack the funds for a down payment and
closing costs but have good credit. Borrowers may qualify for a Flex loan with
as little as 3% down payment plus, the down payment can be agrant,
gift,an "affordable
second" or "unsecured loan". Also, there are no median income restrictions and
no first time home buyer education requirements.
Rural Housing Grant Home Loan Program
The
Rural Housing Service (RHS) loan is an affordable home lending product designed
to get residents in designated rural areas into a home that they would not
otherwise qualify for. Some of the most attractive features for this home loan
include:
100% LTV based
on the appraised value of the home
No down
payment (zero down payment)
No cash
reserves required (great for a first time home buyer)
No MI
requirement (a guarantee fee is required)
Manufactured
home housing permitted
HOME EQUITY MORTGAGE LOAN PROGRAMS
Within Every Home Lies a Wealth of
Opportunity!
Home
equity credit is one of the most popular forms of consumer credit among home
owners. There are lines of credit and second liens on a home loan available to
125%. These home equity loan products offer minimal paperwork, low start rates,
and three different risk grades to help qualify home borrowers to get a great
home equity loan.
Tandem Home Loan Program - One Call, Two Loans, So Many Benefits!
When
borrowers "tandem" a Home Equity Line of Credit (HELOC) or Fixed Rate Second
loan with their first mortgage, they may qualify for a larger total home loan
amount, eliminate MI, or avoid jumbo loan pricing. Tandem Home Loan Programs let
you close two loans at the same time without extra documentation! For example,
you have an 80/20 Tandem package under the Expanded Criteria family, requiring
no down payment, and STILL no MI! There's also have an 80/10/10 with a Fast
& Easy home loan program for borrowers with excellent credit, which allows a
great home loan at a great price, up to 90% CLTV with no mortgage insurance and
no reserves.
Streamline Home Equity Line of Credit!
Streamline Home Equity Line of Credit is a pre-approved home equity
loan for borrowers who are funded with an eligible servicer first mortgage up to
six months ago. There's no documentation requirements and the Super Streamline
HELOC loan can close concurrently with a Fast & Easy home loan for salaried
or self-employed borrowers with excellent credit, a great home loan package at a
great price, up to 90% CLTV, with no reserves and no home mortgage
insurance.
Fixed rate
seconds and home equity loan seconds are not available in all states. Contact
your lender for restrictions on home equity products in your state. Recording or
stamp fees may apply in some states on Tandem mortgage home loans.
HOME MORTGAGE INSURANCE ALTERNATIVES
Tandem Home Mortgage Loan Program
Borrowers can avoid mortgage insurance with a Tandem alternative. By
doing a first and a second mortgage home loan, borrower can avoid mortgage
insurance, increase their tax deductions, or avoid Jumbo pricing and Jumbo
payments. There's little to no extra paperwork and you can save money in most
cases. There are several different Tandem Home Mortgage Loan opportunities,
including:
100% CLTV
loan 80/20
95% CLTV
loan 75/20/05 80/15/05
90% CLTV
loan 75/15/10 80/10/10
Any time your
down payment is less than 20%, a Tandem first and a second home mortgage loan is
a great way to avoid mortgage insurance and/or Jumbo pricing, as well as save
money on your total home monthly payment!
Mortgage
Insurance Alternatives. There are smart alternatives to regular mortgage
insurance. By folding the cost of mortgage insurance into the loan, borrowers
may realize a tax deduction,** plus a lower net monthly home payment that can
help make first time home ownership more affordable. Home mortgage insurance
alternatives are available in several versions, depending on a home borrower's
financial circumstances:
Monthly Tax
Advantage MI features an add-on to the home loan's interest rate to cover
the cost of MI, resulting in a potentially greater tax deduction than with the
traditional mortgage insurance you would pay on your home
loan.
One-Time Tax
Advantage MI features a 3-point increase in the home loan amount, which is
financed over the life of the home loan and typically results in a lower home
monthly payment than with traditional mortgage insurance.
**Borrowers
should consult their tax advisor regarding the deductibility of mortgage
interest. Please contact your local branch for any restrictions on home Mortgage
Insurance and eligible home loan types in your state.
SUBPRIME HOME MORTGAGE LOAN PRODUCTS
Flexible guidelines, aggressive pricing and exceptional service is
available to home borrowers with a wide range of financing solutions. When you
use an automated underwriting system, you can get an underwriting outcome for
your subprime loan in minutes. Home mortgage loan products usually include 15
and 30 year fixed and adjustable rate mortgage products, fixed period ARMs,
reduced pricing options, even a rate-reduction loan for home owners who pay
their mortgage loan on time every month. A through D credit grades fit even the
most demanding home borrowers.
EXPANDED HOME MORTGAGE LOAN APPROVAL
This
is a series of niche products intended for borrowers with just slightly impaired
credit. These are borrowers who fall just below A-paper criteria, but who don't
really belong in a traditional subprime home mortgage loan product. With
Expanded Loan Approval (ELA) loans, borrowers can get better terms and pricing
than they would get with subprime home loans, with LTVs as high as 95%. ELA
loans are available for purchase money, rate-and-term refi's, even cashout
refi's. Allowed property types include second homes, owner-occupied one and
two-unit residences, manufactured home, and approved condos. There's even a
mortgage loan program that allows borrowers to lower their interest rate after
two years based on timely payments.