<%@ 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: Real_Estate_Consultants_Real_Estate.asp '------------------------------- ' Real_Estate_Consultants_Real_Estate Custom Includes begin Dim page Dim pageName Dim Cities Dim Counties page = "Real_Estate_Consultants_Real_Estate" pageName = "Real_Estate_Consultants_Real_Estate" Session("expired") = "No" %> <% ' Real_Estate_Consultants_Real_Estate CustomIncludes end '------------------------------- '*** TOOLS *** '** FROM FILE ** root=Replace(server.MapPath("AdminOwnerXML.html"),"AdminOwnerXML.html","") 'Set fso = 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 '** REMOTE XML ** '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 '** REMOTE DATABASE ** 'Set Conn = Server.CreateObject("ADODB.Connection") 'Set Rs = Server.CreateObject("ADODB.Recordset") 'Conn.Open "Provider=sqloledb;" & _ ' "Data Source=216.127.88.120,2433;" & _ ' "Network Library=dbmssocn;" & _ ' "Initial Catalog=Accounting;" & _ ' "User ID=sa;" & _ ' "Password=buckler;" 'rs.Open SQL,conn,1,1 'rs.Close 'conn.Close 'set rs=Nothing 'set conn=Nothing ' Set conn = CreateObject("ADODB.Connection") ' Set rs = Server.CreateObject("ADODB.Recordset") ' filePath = Server.MapPath("AdminMyStuff.html") ' conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & filePath ' strSQL = "SELECT * FROM MyListings ORDER BY ID Desc" ' Set rs = conn.Execute(strSQL) ' rs.Movefirst 'rs.Close 'conn.Close 'set rs=Nothing 'set conn=Nothing '=============================== ' Save Page and File Name available into variables '------------------------------- sFileName = "Real_Estate_Consultants_Real_Estate.html" sTemplateFileName = "Skin/Real_Estate_Consultants_Real_Estate.html" '=============================== '=============================== 'Save the name of the form and type of action into the variables '------------------------------- sAction = GetParam("FormAction") sForm = GetParam("FormName") '=============================== ' Real_Estate_Consultants_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")) ' Real_Estate_Consultants_Real_Estate Show end '------------------------------- ' Destroy all object variables '------------------------------- ' Real_Estate_Consultants_Real_Estate Close Event begin ' Real_Estate_Consultants_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() %> <% If LoadedPage <> "" Then SetScript "PutYourContentHere",LoadedPage Else If Request("Real_Estate_Consultants_Real_EstateMessage") <> "" Then SetScript "PutYourContentHere","

" & Request("Real_Estate_Consultants_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 '=============================== %>

Wilmington Real Estate -

1031 Exchange - TIC A leading 1031 tenants in common (TIC) exchange services that helps to learn exchange rules and to find 1031 replacement properties. Guide on Tenants in Common and Property exchanges.	Austin Apartment Finder We are a full service, free apartment locating and relocation company, specializing in apartments in Austin, Texas and the surrounding area.	Charlotte NC Real Estate Welcome to Charlotte Life and Home.com is designed to give you all the information you about North Carolina Homes, NC Home for Sale in the Charlotte area.	Charlotte North Carolina Real Estate Sunny Yates, your Charlotte North Carolina Real Estate and Lake Norman Real Estate expert.

Colorado Mountain Homes ExitExcalibur.com is a team of professionals who believe that by combining the best local agents with the power of the Internet.	Colorado Springs Realtors Colorado Springs Real Estate & Relocation, FREE RELOCATION CD, Elegant Homes, resale homes, relocation, Black Forest, Monument	Edmonton Real Estate Board Edmonton-Home.com, your number 1 source in Edmonton for Re Max Real Estate Investments, Commercial Agents, Property Listings, Remax Realty, and Edmonton Real Estate Board.	Golf Sponsor Sign RockSigns.ca are a Lacombe, Alberta Canada company that makes rock signs by placing words and pictures into stone, products include golf signs for sale, golf course tee sign.

Homes For Sale In New Jersey Get the best real estate listings & homes for sale, expert advice, local info, and much more from a proven Fort Lee, Tenafly and Edgewater, New Jersey NUMBER1EXPERT" Top Selling real estate agents.	Las Vegas Nevada Real Estate Welcome to the Las Vegas Homes MLS Search this will be the only tool you will need to find the best value that meets your criteria .We provide free listings of Las Vegas Homes MLS Search For Sale.	Legal Jobs In San Francisco Levin & Associates specializes in the permanent placement of attorneys at law firms and corporations in Los Angeles, San Francisco, Silicon Valley, Orange County and San Diego.	Longboat Key Realtor Welcome to the best source for Sarasota MLS and Bradenton MLS for searching for homes in Sarasota Florida and Bradenton Florida, as well as terrific Sarasota Information, Sarasota County property se

Mountain Lodge At Telluride Telluride Real Estate: Homes, Land, and Ranches in the Telluride Region for sale.	New Home Las Vegas NV Gavish Real Estate.com here for you in Las Vegas for - New Luxury Home For Sale, North Las Vegas Nevada Real Estate Agent, Las Vegas Nevada Realtor & more	Real Estate Agent Utah Relocatetosunnystgeorge.com provides you with a wealth of knowledge for your journey through the world of Real Estate in Southern Utah, Luxury Homes St George Utah.	Real Estate In Miami Beach We specialize in representing our clients in the purchase and sale of Condominiums, single-family residences and income property within the cities of Miami real estate, South florida real estate, Mi

Real Estate Investment lane yates real estate investments and developments.	Sacramento California Real Estate Search for homes in Sacramento,Elk Grove counties CA California Real Estate mls listings Homes for sale By Wesellsacramento.com	Slovak Property SK-Properties s.r.o. is a Slovakia based estate agency with a UK Support Office which offers a more individual approach to its UK clients	Vacation Boothbay Harbor Beach Cove Hotel & Resort, the only sandy beachfront hotel and resort in the Boothbay Harbor Region.

Water Garden Design Denton Backyardconcept.com is specialized for operating years with lots of experiences in selling pond waterfalls, backyard waterfalls, KOI ponds in the country like Denton, Argyle, McKinney, Frisco, Allen	West Redding Homes We offer a wide range of Real Estate services like Redding Homes for Sale in Northern California.	Woming Property Welcome to Leisure-Propertiesinc.com, here you will find information about Land For Sale In Wyoming and Real Estate Wyoming Land.

Home Search

Newsletter

Reports

Home Valuation

Financing

Tools

Blog

Contact

About

Login