<% Dim SQL, rs, rs2 set rs = Server.CreateObject("ADODB.Recordset") SQL = "SELECT (daz_listings.listingid*(1+datepart(s,getdate()))*(1+datepart(ms,getdate())))%1000 sortid, daz_listings.title, daz_listings.address, " & _ "daz_listings.city, daz_listings.phone, daz_listings.description, daz_listings.photo, " & _ "daz_listings.logo, daz_listings.email, daz_listings.url, daz_states.state " & _ "FROM daz_listings INNER JOIN daz_states ON daz_listings.stateId = daz_states.stateId " & _ "INNER JOIN daz_displays ON daz_listings.listingId = daz_displays.listingId " & _ "WHERE daz_displays.typeId = 2 " & _ "AND realtorId = 25 " & _ "AND daz_displays.approved = 1 " & _ "ORDER BY sortid " set rs = oConn.execute(SQL) set rs2 = Server.CreateObject("ADODB.Recordset") SQL = "SELECT daz_listings.title, daz_listings.address, " & _ "daz_listings.city, daz_listings.phone, daz_listings.description, daz_listings.photo, " & _ "daz_listings.logo, daz_listings.url, daz_states.state " & _ "FROM daz_listings INNER JOIN daz_states ON daz_listings.stateId = daz_states.stateId " & _ "INNER JOIN daz_displays ON daz_listings.listingId = daz_displays.listingId " & _ "WHERE daz_displays.typeId = 1 " & _ "AND realtorId = 25 " & _ "AND daz_displays.approved = 1 " set rs2 = oConn.execute(SQL) '######################################################################################## %> Dream Arizona | Phoenix Real Estate | Az Agents, Realtors
Home     About Us     Advertising     Listing     Site Directory     Members Login Bringing Dream Homes to Reality  
QUICK REFERENCE
        

Phoenix Real Estate
Agents and Realtors


Finding Dream Homes in Phoenix Arizona

Featured Agents   Feature Your Site Here
<% Dim count count = 0 If Not (rs.BOF And rs.EOF) Then rs.movefirst Do Until rs.EOF '######################################################################################## 'featured ad If count <> 0 then Response.write("
") End If Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
") If trim(rs("photo")) <> "" then Response.write("") Else Response.write("") End If Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
" & rs("title") & "") If trim(rs("email")) <> "" then Response.write("email") End If If (trim(rs("email")) <> "") and (trim(rs("url")) <> "") then Response.write(" | ") End If If trim(rs("url")) <> "" then Response.write("visit website") End If Response.write("
") Response.write("" & rs("phone") & "
") Response.write("" & rs("address") & "
") Response.write("" & rs("city") & ", " & rs("state") & "
") Response.write("
") If trim(rs("logo")) <> "" then Response.write("") Else Response.write("") End If Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
" & rs("description") & "
") Response.write("
") count = count + 1 rs.moveNext Loop Else '######################################################################################## 'default featured Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
") End If set rs = nothing 'standard listing text Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
") Response.write("") Response.write("") Response.write("
Standard ListingsList Your Site
") If Not (rs2.BOF And rs2.EOF) Then rs2.movefirst Do Until rs2.EOF '######################################################################################## 'standard ad Response.write("") Response.write("") If trim(rs2("url")) <> "" then Response.write("") Else Response.write("") End If Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("") Response.write("
" & rs2("title") & "" & rs2("title") & "" & rs2("phone") & "
" & rs2("address") & " " & rs2("city") & ", " & rs2("state") & "
" & rs2("description") & "
") rs2.moveNext Loop End If set rs2 = nothing 'end of table Response.write("
") %>

In the Greater Phoenix area: Ahwatukee, Chandler, Gilbert, Glendale, Mesa, Peoria, Phoenix and Tempe. In Scottsdale visit Paradise Valley, Fountain Hills and Carefree. Other Arizona areas, see Flagstaff, Kingman, Lake Havasu, Page, Payson, Prescott, Sedona, Tucson and Yuma.

Phoenix Arizona Connections

Arizona Department of Education
Find a desirable school district

 Among The Best Places To Live
Phoenix is one of the best
City of Phoenix
Connections to city services

 Statistical Snapshot of Phoenix>
Statistics from Money Magazine
Arizona Motor Vehicle Division
Driving and vehicle laws

Hotels in Phoenix
Accommodations during your visit
Greater Phoenix CVB
Discover where the action is

 Fine Dining Choices
Great restaurant choices




Click here for other Phoenix real estate agents.

 



By Using This Website, You Agree to Our Terms of Website Use
The Az Directory of Real Estate provides information and connections intended to make buying and owning an Arizona home a more rewarding experience. The guide covers homebuyers and home sellers throughout Arizona including Phoenix, Scottsdale, Tucson, Sedona, Flagstaff, Tempe, Glendale, Peoria, Paradise Valley, Payson, Prescott, Yuma and other towns within Arizona.

©2004 Subia Worldwide. Targeted Real Estate Advertising
| Website Design by Subia Creative |

Webmaster