<%@LANGUAGE="VBSCRIPT"%> <% Dim rsCompareList__MM_ColParam rsCompareList__MM_ColParam = "1" if (Request.QueryString("PriceRangeID") <> "") then rsCompareList__MM_ColParam = Request.QueryString("PriceRangeID") %> <% set rsCompareList = Server.CreateObject("ADODB.Recordset") rsCompareList.ActiveConnection = MM_QCFSBO_FLYER_STRING rsCompareList.Source = "SELECT tb_Listings.ListingNumber, tb_Status.Status, tb_Listings.Street, tb_City.City, tb_Listings.ZipCode, tb_Listings.PropertyTypeID, tb_PropertyType.PropertyType, tb_Listings.BedRoom, tb_Listings.BathRoom, tb_Listings.SFMain,tb_Listings.SFTotal, tb_Listings.Price, tb_Listings.PriceRangeID, tb_Listings.URL,tb_PriceRange.PriceRange FROM (((tb_Listings INNER JOIN tb_City ON tb_Listings.CityID = tb_City.CityID) INNER JOIN tb_Status ON tb_Listings.StatusID = tb_Status.StatusID) INNER JOIN tb_PropertyType ON tb_Listings.PropertyTypeID = tb_PropertyType.PropertyTypeID) INNER JOIN tb_PriceRange ON tb_Listings.PriceRangeID = tb_PriceRange.PriceRangeID WHERE (((tb_Status.Status)='Active') AND ((tb_Listings.PropertyTypeID)<>11) AND ((tb_Listings.PriceRangeID)=" + Replace(rsCompareList__MM_ColParam, "'", "''") + ")) ORDER BY tb_Listings.Price DESC;" rsCompareList.CursorType = 0 rsCompareList.CursorLocation = 2 rsCompareList.LockType = 3 rsCompareList.Open() rsCompareList_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = 5 Dim Repeat1__index Repeat1__index = 0 rsCompareList_numRows = rsCompareList_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables ' set the record count rsCompareList_total = rsCompareList.RecordCount ' set the number of rows displayed on this page If (rsCompareList_numRows < 0) Then rsCompareList_numRows = rsCompareList_total Elseif (rsCompareList_numRows = 0) Then rsCompareList_numRows = 1 End If ' set the first and last displayed record rsCompareList_first = 1 rsCompareList_last = rsCompareList_first + rsCompareList_numRows - 1 ' if we have the correct record count, check the other stats If (rsCompareList_total <> -1) Then If (rsCompareList_first > rsCompareList_total) Then rsCompareList_first = rsCompareList_total If (rsCompareList_last > rsCompareList_total) Then rsCompareList_last = rsCompareList_total If (rsCompareList_numRows > rsCompareList_total) Then rsCompareList_numRows = rsCompareList_total End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rsCompareList_total = -1) Then ' count the total records by iterating through the recordset rsCompareList_total=0 While (Not rsCompareList.EOF) rsCompareList_total = rsCompareList_total + 1 rsCompareList.MoveNext Wend ' reset the cursor to the beginning If (rsCompareList.CursorType > 0) Then rsCompareList.MoveFirst Else rsCompareList.Requery End If ' set the number of rows displayed on this page If (rsCompareList_numRows < 0 Or rsCompareList_numRows > rsCompareList_total) Then rsCompareList_numRows = rsCompareList_total End If ' set the first and last displayed record rsCompareList_first = 1 rsCompareList_last = rsCompareList_first + rsCompareList_numRows - 1 If (rsCompareList_first > rsCompareList_total) Then rsCompareList_first = rsCompareList_total If (rsCompareList_last > rsCompareList_total) Then rsCompareList_last = rsCompareList_total End If %> <% ' *** Move To Record and Go To Record: declare variables Set MM_rs = rsCompareList MM_rsCount = rsCompareList_total MM_size = rsCompareList_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter r = Request.QueryString("index") If r = "" Then r = Request.QueryString("offset") If r <> "" Then MM_offset = Int(r) ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record i = 0 While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1)) MM_rs.MoveNext i = i + 1 Wend If (MM_rs.EOF) Then MM_offset = i ' set MM_offset to the last possible record End If %> <% ' *** Move To Record: if we dont know the record count, check the display range If (MM_rsCount = -1) Then ' walk to the end of the display range for this page i = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size)) MM_rs.MoveNext i = i + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = i If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If ' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If ' move the cursor to the selected record i = 0 While (Not MM_rs.EOF And i < MM_offset) MM_rs.MoveNext i = i + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record rsCompareList_first = MM_offset + 1 rsCompareList_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (rsCompareList_first > MM_rsCount) Then rsCompareList_first = MM_rsCount If (rsCompareList_last > MM_rsCount) Then rsCompareList_last = MM_rsCount End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 0) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then params = Split(MM_keepMove, "&") MM_keepMove = "" For i = 0 To UBound(params) nextItem = Left(params(i), InStr(params(i),"=") - 1) If (StrComp(nextItem,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & params(i) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&" urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = urlStr & "0" MM_moveLast = urlStr & "-1" MM_moveNext = urlStr & Cstr(MM_offset + MM_size) prev = MM_offset - MM_size If (prev < 0) Then prev = 0 MM_movePrev = urlStr & Cstr(prev) %> QCFSBO®.com - Listing Comparison Tool
index35 index36 index35
index38
An OH Guide
 index37
index35 index36 index35
index38

If you wish to post an Open House announcement with your listing please note the following:

Open House is updated on Wednesday late afternoon/early evening. Call-in deadline with your Open House info is Wednesdays 3 PM every week. Should a holiday fall on a Wednesday the Open House announcements will be updated on next business day.

You can notify us of your Open House in several ways:

• E-mail us         • Send a feedback         • Call us at (563) 355-1310         • Send a Fax to: (563) 355-1509

Please be sure to include the following information:

• Your Name         • Address of Property         • Date & Time of Open House

Some Sellers like to call in every week with their varying Open House times. However, there are many that have set aside a fixed time once a week during which they hold their Open House. These Sellers have a standing order with us (e.g. Open Sundays 1-3) and don’t need to call that in again unless they wish to cancel the Open House or change the time. The standing order eliminates one more thing they have to remember to do every week on time.

Our recommendation: If possible stay with Sundays for your Open House and avoid Open House sessions that take longer than 1½ - 2 hours. The best time on Sundays? Anytime between 1:00 PM and 4:00 PM
______________________________________

[Close this window]
index37
Copyright © 1999-2008 Quad City Virtual, Inc. All rights reserved.

<% rsCompareList.Close() %>