<%@ Language="VBScript" %> <% Dim Conn, Rs, searchID, strSQL, strImgNum, filePath,folderNum ' Create ADO Connection Component to connect with the database Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") ' Filename: Insurance_Real_Estate.asp '------------------------------- ' Insurance_Real_Estate Custom Includes begin Dim page Dim pageName Dim Cities Dim Counties page = "Insurance_Real_Estate" pageName = "Insurance_Real_Estate" Session("expired") = "No" %> <% ' Insurance_Real_Estate CustomIncludes end '------------------------------- '*** TOOLS *** root=Replace(lcase(server.MapPath("AdminOwnerXML.html")),"adminownerxml.html","") 'set fso = Server.CreateObject("Scripting.FileSystemObject") 'If fso.fileexists(Root & "alreadyAsked.txt") then 'set f = fso.OpenTextFile(Root & "alreadyAsked.txt", 1) 'sHTML2 = f.ReadAll() 'set f=nothing 'End If 'sHTML = "" 'url = "http://www.nailsoupmedia.com/PostLinkLetter.html" ''Set xml = Server.CreateObject("MSXML2.ServerXMLHTTP") 'Set xml = Server.CreateObject("Microsoft.XMLHTTP") 'xml.Open "GET", url, False 'xml.Send 'sHTML = xml.responseText 'set xml=nothing '=============================== ' Save Page and File Name available into variables '------------------------------- sFileName = "Insurance_Real_Estate.html" sTemplateFileName = "Skin/Insurance_Real_Estate.html" '=============================== '=============================== 'Save the name of the form and type of action into the variables '------------------------------- sAction = GetParam("FormAction") sForm = GetParam("FormName") '=============================== ' Insurance_Real_Estate Show begin '=============================== ' Display page '------------------------------- ' Load HTML template for this page '------------------------------- 'Dim LoadedPage 'LoadedPage = LoadTemplate2 (sAppPath & "Skin/Objects/AutoBlog.html") LoadTemplate sAppPath & sTemplateFileName, "main" '------------------------------- ' Load HTML template of Header and Footer '------------------------------- '------------------------------- SetVar "FileName", sFileName '------------------------------- ' Step through each form '------------------------------- 'OpenDB 'Load_Cities_Counties Item_Show '------------------------------- Parse "main", True '------------------------------- ' Output the page to the browser '------------------------------- Response.write fixPage(PrintVar("main")) ' Insurance_Real_Estate Show end '------------------------------- ' Destroy all object variables '------------------------------- ' Insurance_Real_Estate Close Event begin ' Insurance_Real_Estate Close Event end UnloadTemplate '=============================== '=============================== ' FUNCTIONS '------------------------------- '=============================== ' Display '=============================== Sub Load_Cities_Counties() Counties = replaceLastComma(Session("counties")) Cities = replaceLastComma(Session("cities")) End Sub Function ShowMyListings Dim con Dim rst Set con = CreateObject("ADODB.Connection") Set rst = Server.CreateObject("ADODB.Recordset") filePath = Server.MapPath("AdminMyStuff.html") con.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=" & filePath strSQL = "SELECT * FROM MyListings ORDER BY ID Desc" Set rst = con.Execute(strSQL) rst.Movefirst Response.Write While not rst.EOF Response.Write "" & rst("mls") & "
" rst.MoveNext Wend con.Close:set rst=Nothing : set con = Nothing End Function '=============================== ' Display Search Form '------------------------------- Sub Item_Show() SetVar "BrokerName1",Session("BrokerName1") SetVar "BrokerPhone1",Session("BrokerPhone1") SetVar "BrokerEmail1",Session("BrokerEmail1") if session("BrokerName1") <> "" then setVar "FullName",session("BrokerName1") if session("BrokerName1") <> "" then setVar "OwnerName",session("BrokerName1") if session("BrokerEmail1") <> "" then setVar "Email",session("BrokerEmail1") if session("BrokerPhone1") <> "" then setVar "Phone",session("BrokerPhone1") %> <% If LoadedPage <> "" Then SetScript "PutYourContentHere",LoadedPage Else If Request("Insurance_Real_EstateMessage") <> "" Then SetScript "PutYourContentHere","


" & Request("Insurance_Real_EstateMessage") & "
" End If End if For totalDynamics = 1 to DynamicVarIndex aDVar = DynamicVarItem(totalDynamics) & ",load" SetScript aDVar , DynamicVar(totalDynamics) Next SetScript "MyListings",ShowMyListings Parse "FormSearch", False End Sub '=============================== %>


 



      Scott Thompson, Your Trusted Advisor  (510) 410-2003
  • Auto Insurance Brampton

    • Ace Financial Group is a Certified Financial Planner and one of the largest, most respected and experienced insurance & financial services firm in the country and deliver Best Investment Solutions l
  • Auto Insurance Quotes

    • Free Online Insurance Quotes - Find and Compare Insurance rates, Get free quotes from Health Insurance, Car insurance, Life & Term Insurance, Homeowners Insurance and more providers.
  • Business car insurance

    • Your one comparison shop for auto, life, health, home, business insurance quotes.
  • Medical Insurance Quote

    • Expert health insurance advice, learn about health insurance. Online health insurance quote. Affordable health insurance.


  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get


  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get


  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • money mastery

    • The Money Mastery provides you with genuine guidance, so that you can work towards achieving your goal of debt relief. We provide 100% legitimate Personal Finance Program and will help you to a get
  • Online Payday Lenders

    • Online Payday Lenders
  • Oregon OR Debt Settlement Portland Eugene Salem Credit Card Debt Settlement

    • Oregon OR Debt Settlement Portland Eugene Salem Credit Card Debt Settlement


  • Quote Car Insurance

    • Get quote car insurance and save up to $600 monthly.
  • Telemarketing Phone Lists

    • The Wholesale Source for Mailing Lists, Telemarketing Lists, Sales Leads, and Database Licensing!
  • VA loans

    • Work directly with a VA Home Loans specialist. Veterans can qualify for up to $417k with $0 down. Pre-qualify online for your VA Loan today.
    Property Spotlight

    1 of 1 photos
    OAKLAND For Sale
    $878,000
    4 Beds / 2 Baths
    Multi-family Property, Area: Oakland Zip Code 94610, County: Alameda, Approximately 0...
    more >>
    View All Our Picks >>

    Oakland Real Estate Agent
    Scott Thompson
    (510) 410-2003
    Let me help you relocate to a new home or property in Oakland, Piedmont, Berkeley, San Leandro and Alameda as well as the Montclair, Crocker Highlands and Alameda County county areas. I can direct you to a church or synagogue, public or private schools, golf courses, recreational facilities, cultural events, or a hotel. I can provide you with local news, maps, city info, city statistics, and more -- everything you need to become familiar with all aspects of the greater Oakland metropolitan area.