<%@LANGUAGE="VBSCRIPT"%> <% Dim Recordset1__MMColParam Recordset1__MMColParam = "1" If (Request.Form("index-Query") <> "") Then Recordset1__MMColParam = Request.Form("index-Query") End If %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_ConResidential_STRING Recordset1.Source = "SELECT Area, Bedrooms, Cost, Development, Image, Link, PropertyName, Ref FROM Details WHERE Bedrooms = '" + Replace(Recordset1__MMColParam, "'", "''") + "'" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <% PriceType=Request.Form("index-currency") %> <% Dim MyChar If PriceType = "GBP" THEN MyChar = "£" If PriceType = "AED" THEN MyChar = "Dh." IF PriceType = "USD" THEN MyChar = "$" IF PriceType = "EURO" THEN MyChar = "€" %> <% Dim GBPrate If PriceType = "GBP" THEN GBPrate = "6.59057" If PriceType = "AED" THEN GBPrate = "1" IF PriceType = "USD" THEN GBPrate = "3.67280" IF PriceType = "EURO" THEN GBPrate = "4.47389" %> <% Dim Recordset2 Dim Recordset2_numRows Set Recordset2 = Server.CreateObject("ADODB.Recordset") Recordset2.ActiveConnection = MM_ConResidential_STRING Recordset2.Source = "SELECT DISTINCT Development FROM Details ORDER BY Development ASC" Recordset2.CursorType = 0 Recordset2.CursorLocation = 2 Recordset2.LockType = 1 Recordset2.Open() Recordset2_numRows = 0 %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables Dim Recordset1_total Dim Recordset1_first Dim Recordset1_last ' set the record count Recordset1_total = Recordset1.RecordCount ' set the number of rows displayed on this page If (Recordset1_numRows < 0) Then Recordset1_numRows = Recordset1_total Elseif (Recordset1_numRows = 0) Then Recordset1_numRows = 1 End If ' set the first and last displayed record Recordset1_first = 1 Recordset1_last = Recordset1_first + Recordset1_numRows - 1 ' if we have the correct record count, check the other stats If (Recordset1_total <> -1) Then If (Recordset1_first > Recordset1_total) Then Recordset1_first = Recordset1_total End If If (Recordset1_last > Recordset1_total) Then Recordset1_last = Recordset1_total End If If (Recordset1_numRows > Recordset1_total) Then Recordset1_numRows = Recordset1_total End If End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables Dim MM_rs Dim MM_rsCount Dim MM_size Dim MM_uniqueCol Dim MM_offset Dim MM_atTotal Dim MM_paramIsDefined Dim MM_param Dim MM_index Set MM_rs = Recordset1 MM_rsCount = Recordset1_total MM_size = Recordset1_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 MM_param = Request.QueryString("index") If (MM_param = "") Then MM_param = Request.QueryString("offset") End If If (MM_param <> "") Then MM_offset = Int(MM_param) End If ' 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 MM_index = 0 While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1)) MM_rs.MoveNext MM_index = MM_index + 1 Wend If (MM_rs.EOF) Then MM_offset = MM_index ' set MM_offset to the last possible record 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 MM_index = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size)) MM_rs.MoveNext MM_index = MM_index + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = MM_index If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If 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 MM_index = 0 While (Not MM_rs.EOF And MM_index < MM_offset) MM_rs.MoveNext MM_index = MM_index + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record Recordset1_first = MM_offset + 1 Recordset1_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (Recordset1_first > MM_rsCount) Then Recordset1_first = MM_rsCount End If If (Recordset1_last > MM_rsCount) Then Recordset1_last = MM_rsCount End If 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 Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth Dim MM_removeList Dim MM_item Dim MM_nextItem ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next ' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_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) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If ' 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 Dim MM_keepMove Dim MM_moveParam Dim MM_moveFirst Dim MM_moveLast Dim MM_moveNext Dim MM_movePrev Dim MM_urlStr Dim MM_paramList Dim MM_paramIndex Dim MM_nextParam MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 1) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then MM_paramList = Split(MM_keepMove, "&") MM_keepMove = "" For MM_paramIndex = 0 To UBound(MM_paramList) MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1) If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex) 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 = Server.HTMLEncode(MM_keepMove) & "&" End If MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = MM_urlStr & "0" MM_moveLast = MM_urlStr & "-1" MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size) If (MM_offset - MM_size < 0) Then MM_movePrev = MM_urlStr & "0" Else MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size) End If %> <% Dim Repeat2__numRows Dim Repeat2__index Repeat2__numRows = 1 Repeat2__index = 0 Recordset1_numRows = Recordset1_numRows + Repeat2__numRows %> Dubai Living - Luxury Dubai Property & Real Estate Sales and Services
     
DUBAI PROPERTY
Dubai Property
Residential Dubai Property and Real Estate for sale. Apartments, Villa's, Waterfront or Marina. New builds, Off-plan or re-sale property. more>>
DUBAI REAL ESTATE
Dubai Commercial Properties
Dubai Commercial Property for sale. Retail Units, Offices, Land Plots and various other commercial opportunties. more>>
DUBAI LIVING SERVICES
Dubai Living Services
Our Comprehensive range of additional services, including Property Management, Mortgage assistance, Legal assistance... more>>
INTERACTIVE
Dubai Living Forum
Dubai Living Interactive Discussion Forum. Why not chat, discuss or ask questions about all things dubai. more>>
DUBAI LIFESTYLE
Dubai Lifestyle
Lifestyle Information. Shopping, Hotels, Bars, Clubs, Theme parks, Standards of Living, Safety, Weather. All the information you will need. more>>
MEDIA PRESENTATIONS
Media Presentations
Video Presenations about Dubai, its history, the furture plans, and various development projects in Dubai. more>>
FINANCIAL
Financial
Information on taxes, growth rates, rental potentials, legal, quality control and foreign exchange details. more>>
FREQUENTLY ASKED QUESTIONS
FAQ
Your most frequently asked questions answered. Our simple A to Z guide to Dubai. more>>
CONTACT DUBAI LIVING
Contact Dubai Living
Why not send us your requirements and a member of our sales team can assist you in finding your dream property. more>>
FEATURE PROPERTIES  
PARK TOWERS
Park Towers
Location:
DIFC
Bedrooms:
1 - 3
Price From:
1,935,000+
OCEAN HEIGHTS
Ocean Heights
Location:
Dubai Marina
Bedrooms:
1 - 3
Price From:
1,195,000+
PROPERTY SEARCH
Bedrooms
Price Range (AED)
Development
Currency
 
23 MARINA
23 Marina
Location:
Dubai Marina
Bedrooms:
2 - 4
Price From:
1,408,778+
ARABIAN CROWNE
Arabian Crowne
Location:
City of Arabia
Bedrooms:
Studio - 4
Price From:
490,200+
EXCLUSIVES
Dubai Living Exclusives
Guaranteed Rent
Guaranteed Rental Income
Hotel Leaseback
Hotel Leaseback Deals
Furniture Offers
Furniture Package Offers
Reduced Prices
Discounted Prices
Shared Leasing
Shared and Fractional Ownership
   
 
EMIRATES CROWN
Emirates Crown
Location:
Dubai Marina
Bedrooms:
2 - 3
Price From:
2,239,170+
GOLDCREST VIEWS 2
Gold Crest Views 2
Location:
Jumeirah Lake
Bedrooms:
Studio - 2
Price From:
619,000+

10 REASONS WHY DUBAI REAL ESTATE

1. Rents are high >>
2. Prices are low >>
3. Mortgage falling >>
4. New federal law >>
5. Supply shortage >>
6. Demand is high >>
7. Slow supply >>
8. Economy boom >>
9. On the Up >>
10. Many skeptics >>
 
Property Management
Things to Do..

Looking for a professional property management service? Why not give our services team a call for full information on how we can help you manage your property.

We look forward to bringing you our fantastic guides to dubai on:
Places to go..
Things to do..
Attractions to see..
and much much more..

     
Dubai Residential
   
 
dubailiving.co.uk Copyright © 2005. Dubai Living. All Rights Reserved.