|
<%@ 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 home North West Point and rental homes North West Point
Prospect Point Cayman Islands vacation rentals, Prospect Point Cayman Islands rental apartment, and rental home in Prospect Point
Homes for rent by owner Seven Mile Beach, apartments for rent, rent houses in Seven Mile Beach Cayman Islands, and homes for rent by owner
Bed and breakfast rentals and rental homes in Old Man Village Cayman Islands
South Side Cayman Islands apartment rentals, rent house, and South Side Cayman Islands rental home
Pappagallo Beach houses for rent, rental houses in Pappagallo Beach Cayman Islands, Pappagallo Beach Cayman Islands rental houses, and rental home in Pappagallo Beach
Stake Bay Cayman Islands holiday rentals and Stake Bay homes for rent by owner
Bamboo Bay Cayman Islands rental home, bed and breakfast rentals Bamboo Bay Cayman Islands, and Bamboo Bay Cayman Islands rental apartment
Rental home in Stake Bay, Stake Bay Cayman Islands houses for rent, condo rentals in Stake Bay Cayman Islands, and Stake Bay Cayman Islands homes for rent by owner
Rental houses and apartments for rent in George Town
Cayman Kai Cayman Islands condos for rent, home rentals, and bed and breakfast rentals in Cayman Kai Cayman Islands
Contrive and devise George Town Cayman Islands apartments for rent and for rent by owner homes in George Town.
Generally, run interference and root for your drifters, boarders, and excursionists to a handsome, enticing, copious, and seductive neighborhood.
Find, explore, and detect George Town bed and breakfast rentals, George Town Cayman Islands vacation rentals, and homes for rent by owner.
This site, For Rent By Owner (FRBO.com) does accommodate novel zone ski in/out, exotic, hidden, and mountain townhouse, castle, condominium, and castles.
Transmigrants and students who are wishing to identify and devise or simply learn information can use our for rent by owner site, FRBO.com.
Ferret out and debunk rental home in George Town Cayman Islands and apartment rentals.
You can cast about the waterfront classified ads, lakeside classified advertisements, mountain listed properties, and beach online MLS under Rum Point Cayman Islands apartments for rent and Rum Point Cayman Islands homes for rent.
Relocate and devise vacation rentals and condos for rent in George Town Cayman Islands.
The Rum Point ski in/out ad directories and private ad directories for these county can be mapped.
Rum Point Cayman Islands proof could abet, relieve, and ballyhoo your pursuing.
Conceive and glimpse rent house George Town Cayman Islands and bed and breakfast rentals in George Town Cayman Islands.
Design and dig up for rent by owner homes George Town Cayman Islands and homes for rent by owner in George Town.
Light upon and distinguish apartment rentals in George Town Cayman Islands and George Town rental apartment.
Conceive other, special, and rare notes in Rum Point and tick off short term rentals in Rum Point.
|
|
