<%@LANGUAGE="VBSCRIPT"%> <% set rsListings = Server.CreateObject("ADODB.Recordset") rsListings.ActiveConnection = MM_connListings_STRING rsListings.Source = "SELECT * FROM Listings ORDER BY Price DESC" rsListings.CursorType = 0 rsListings.CursorLocation = 2 rsListings.LockType = 3 rsListings.Open() rsListings_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 rsListings_numRows = rsListings_numRows + Repeat1__numRows %> <% Dim Repeat2__numRows Repeat2__numRows = -1 Dim Repeat2__index Repeat2__index = 0 rsListings_numRows = rsListings_numRows + Repeat2__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables ' set the record count rsListings_total = rsListings.RecordCount ' set the number of rows displayed on this page If (rsListings_numRows < 0) Then rsListings_numRows = rsListings_total Elseif (rsListings_numRows = 0) Then rsListings_numRows = 1 End If ' set the first and last displayed record rsListings_first = 1 rsListings_last = rsListings_first + rsListings_numRows - 1 ' if we have the correct record count, check the other stats If (rsListings_total <> -1) Then If (rsListings_first > rsListings_total) Then rsListings_first = rsListings_total If (rsListings_last > rsListings_total) Then rsListings_last = rsListings_total If (rsListings_numRows > rsListings_total) Then rsListings_numRows = rsListings_total End If %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rsListings_total = -1) Then ' count the total records by iterating through the recordset rsListings_total=0 While (Not rsListings.EOF) rsListings_total = rsListings_total + 1 rsListings.MoveNext Wend ' reset the cursor to the beginning If (rsListings.CursorType > 0) Then rsListings.MoveFirst Else rsListings.Requery End If ' set the number of rows displayed on this page If (rsListings_numRows < 0 Or rsListings_numRows > rsListings_total) Then rsListings_numRows = rsListings_total End If ' set the first and last displayed record rsListings_first = 1 rsListings_last = rsListings_first + rsListings_numRows - 1 If (rsListings_first > rsListings_total) Then rsListings_first = rsListings_total If (rsListings_last > rsListings_total) Then rsListings_last = rsListings_total End If %> <% ' *** Move To Record and Go To Record: declare variables Set MM_rs = rsListings MM_rsCount = rsListings_total MM_size = rsListings_numRows MM_uniqueCol = "PrudentialID" MM_paramName = "id" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Specific Record: handle detail parameter If (MM_paramIsDefined And MM_rsCount <> 0) Then ' get the value of the parameter param = Request.QueryString(MM_paramName) ' find the record with the unique column value equal to the parameter value MM_offset = 0 Do While (Not MM_rs.EOF) If (Cstr(MM_rs.Fields.Item(MM_uniqueCol).Value) = param) Then Exit Do End If MM_offset = MM_offset + 1 MM_rs.MoveNext Loop ' if not found, set the number of records and reset the cursor If (MM_rs.EOF) Then If (MM_rsCount < 0) Then MM_rsCount = MM_offset If (MM_size < 0 Or MM_size > MM_offset) Then MM_size = MM_offset MM_offset = 0 ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Close MM_rs.Open End If End If 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 rsListings_first = MM_offset + 1 rsListings_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (rsListings_first > MM_rsCount) Then rsListings_first = MM_rsCount If (rsListings_last > MM_rsCount) Then rsListings_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 %> Prudential Hallmark Realty - All Listings


Prudential Hallmark Realty - Paso Robles Real Estate


800 11th Street
Paso Robles, CA 93446
(805) 237-4700
(800) 747-6075
DRE #00479529

Web Design by PasoRoblesTech.com




800 11th St., Paso Robles, CA 93446 / 800-747-6075 / 805-237-4700 sold@prudentialhallmark.com

Contact Prudential Hallmark to arrange for a viewing at (805) 237-4700 or e-mail sold@prudentialhallmark.com.


PASO ROBLES

Views, Views, Views Custom Built Home on 8+ acres.

This gorgeous Country Style 2700 sqft home offers 3 spacious bedrooms, 3 baths and a large bonus room/office.  There is an oversized 3 car garage, two wonderful arbor style patios, stone planters, stamped concrete walkways and driveway.  Panoramic views from nearly every window in the house.  There are many desired features with this home including a spacious great room w/two sided stone fireplace, a sitting room and sunny breakfast room, crown  moulding, vaulted ceilings.  The large kitchen is open and features white painted pine cabinets, tile countertops with full tile back splash, pantry and a bay window to enjoy the view. Priced at $545,000 (8580W).

 

8

Prudential Hallmark Realty
Tel: (805) 237.4700
Toll-Free: (800) 747.6075
Fax: (805) 237.4711
Email: sold@prudentialhallmark.com


Live chat by AliveChat
© 2005 Prudential Hallmark Realty. All rights reserved. 2005, An Independently Owned and Operated Member of The Prudential Real Estate Affiliates, Inc. PRUDENTIAL and [Rock] Prudential are service marks of The Prudential Insurance Company of America. Equal Housing Opportunity.
  
<% rsListings.Close() %>