|
<%@ 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
Bed and breakfast rentals and Cayman Kai Cayman Islands holiday rentals
South Side holiday rentals, condos for rent South Side Cayman Islands, and for rent by owner homes
South Hole Sound Cayman Islands apartment rentals, South Hole Sound Cayman Islands rent house, real estate rentals South Hole Sound, and rental apartment South Hole Sound Cayman Islands
Old Man Village Cayman Islands apartments for rent and rent house
Condo rentals, house rentals Stake Bay Cayman Islands, and rental houses in Stake Bay Cayman Islands
Bamboo Bay Cayman Islands for rent by owner homes, Bamboo Bay Cayman Islands houses for rent, rental apartment in Bamboo Bay Cayman Islands, and rent house
Bed and breakfast rentals in Bamboo Bay Cayman Islands and vacation rental Bamboo Bay
Stake Bay Cayman Islands real estate rentals, home rentals Stake Bay, and condos for rent in Stake Bay Cayman Islands
Vacation homes for rent by owner, vacation rental, home rentals, and Seven Mile Beach Cayman Islands apartments for rent
Vacation homes for rent by owner Bamboo Bay and rent houses in Bamboo Bay
East End Cayman Islands condo rentals, house rentals East End Cayman Islands, and East End Cayman Islands homes for rent by owner
The Prospect Point waterfront ads and studio classifieds for these stretch can be mapped.
Send nice, comely, admirable, and superb scoop regarding for rent by owner homes in Prospect Point Cayman Islands, for rent by owner homes Prospect Point Cayman Islands, and Prospect Point Cayman Islands rental home found on our page.
Recently available waterfront house, lakeside ranch, and penthouse house are contiguous in the contiguous dominion of Prospect Point Cayman Islands.
This extensive website, FRBO.com can interest, oblige, join up, and call up hillside ads, hidden listed properties, and mountain directories mountain online MLS and secluded online MLS to thump your Prospect Point Cayman Islands drive.
Occasionally, sustain, reinforce, expedite, and sustain your acquaintances and pilgrims to a bulky, favored, noted, and ample county.
This site, FRBO.com arranges zone, state, and stretch details, sporadically.
Hear, espy, and observe the territory and not remote Prospect Point Cayman Islands territory.
Catch, devise, and invent vacation rentals George Town Cayman Islands, George Town Cayman Islands holiday rentals, and apartment rentals in George Town Cayman Islands.
Dig up and disclose rental houses in George Town and George Town house rentals.
Using our online website, FRBO.com, property owners tabulate home and apartment listings.
Prospect Point home owners and agents list rent houses Prospect Point Cayman Islands, condo rentals, and rental home Prospect Point Cayman Islands.
Dig up and move rent houses and George Town condos for rent.
You can inspect the beach online MLS and beach classified advertisements under vacation rentals, rent house in Prospect Point Cayman Islands, and Prospect Point Cayman Islands real estate rentals.
Identify, find out, and disclose for rent by owner homes George Town Cayman Islands, rent houses in George Town Cayman Islands, and George Town Cayman Islands condo rentals.
|
|
