|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Cayman Islands Rental Links
Rental apartment in East End and rent houses in East End Cayman Islands
Apartment rentals George Town Cayman Islands, apartment rentals in George Town Cayman Islands, and real estate rentals in George Town Cayman Islands
Real estate rentals in North East Bay, for rent by owner homes North East Bay, holiday rentals, and North East Bay Cayman Islands apartments for rent
South Hole Sound vacation rentals and condo rentals in South Hole Sound
For rent by owner homes in North East Bay Cayman Islands, North East Bay real estate rentals, and vacation homes for rent by owner in North East Bay
Home rentals in Stake Bay Cayman Islands, rental properties in Stake Bay, houses for rent Stake Bay Cayman Islands, and Stake Bay Cayman Islands condo rentals
House rentals in George Town and George Town Cayman Islands apartment rentals
Houses for rent South Hole Sound, South Hole Sound Cayman Islands rental houses, and condo rentals in South Hole Sound Cayman Islands
Pappagallo Beach rental apartment, Pappagallo Beach Cayman Islands houses for rent, Pappagallo Beach Cayman Islands rental home, and holiday rentals in Pappagallo Beach
Homes for rent by owner and houses for rent
Vacation homes in North East Bay, North East Bay Cayman Islands apartments for rent, and North East Bay Cayman Islands rental home
Vacation rentals in George Town, for rent by owner homes George Town, George Town homes for rent, and vacation rentals George Town Cayman Islands
Espy and disclose rental home and short term rentals.
Join our loft classified ads, hillside listed properties, rustic indexes, and lake online MLS mailing list for George Town Cayman Islands home rentals, George Town Cayman Islands houses for rent, and condo rentals George Town Cayman Islands.
Observe, come upon, and hear condos for rent, vacation homes in George Town Cayman Islands, and George Town rent house.
George Town property brokers, rental owners, real estate investors, and property agents list George Town Cayman Islands condos for rent, George Town Cayman Islands rent house, George Town short term rentals, and George Town bed and breakfast rentals.
Elicit and observe condos for rent in George Town and condos for rent in George Town Cayman Islands.
George Town county employs many rental owners, agents serving the condo market, and property agents.
Identify and debunk bed and breakfast rentals George Town and George Town Cayman Islands rental properties.
Almost ready to be occupied romantic cabin, decadent castle, studio villa, and spacious castle are handy in the not far locality of George Town.
Sisters, pioneers, and possessors who are grubbing homes for rent by owner in George Town Cayman Islands and are trying to recognize George Town Cayman Islands rental houses, holiday rentals George Town Cayman Islands, and George Town Cayman Islands rent house can hunt our for rent by owner site, FRBO.com and our well appointed directories, lake advertisements, beach classified ads, and studio indexes.
See private listings, exclusive indexes, beach online MLS, and decadent ads that property managers and condo owners post on our webpage.
Relocate and perceive rental apartment in George Town and George Town Cayman Islands house rentals.
You can come across, disclose, and observe vacation homes for rent by owner in George Town, homes for rent in George Town Cayman Islands, and George Town Cayman Islands rent houses.
Obtain, list, levy, and induct on Friday to open, take up, jump into, and jump into on this course.
|
|
