|
<%@ 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
South Hole Sound house rentals and homes for rent by owner in South Hole Sound Cayman Islands
Real estate rentals in Old Man Village, real estate rentals in Old Man Village Cayman Islands, and Old Man Village Cayman Islands for rent by owner homes
East End Cayman Islands rental homes, East End Cayman Islands rental homes, rental houses East End Cayman Islands, and East End condos for rent
Vacation homes for rent by owner Cayman Kai and bed and breakfast rentals in Cayman Kai Cayman Islands
George Town Cayman Islands condo rentals, homes for rent, and homes for rent by owner George Town
Vacation homes for rent by owner in Seven Mile Beach Cayman Islands, rental home, Seven Mile Beach Cayman Islands condo rentals, and rental properties in Seven Mile Beach Cayman Islands
Rental home in East End Cayman Islands and East End for rent by owner homes
Apartment rentals, homes for rent by owner in Breakers, and Breakers Cayman Islands homes for rent by owner
North West Point condos for rent, houses for rent in North West Point, North West Point Cayman Islands holiday rentals, and bed and breakfast rentals
For rent by owner homes and West Bay rent house
Holiday rentals, rental homes South Hole Sound, and South Hole Sound Cayman Islands rent house
Pappagallo Beach Cayman Islands house rentals, Pappagallo Beach Cayman Islands condos for rent, rental homes Pappagallo Beach, and real estate rentals in Pappagallo Beach Cayman Islands
Home rentals in East End Cayman Islands and bed and breakfast rentals
Condo rentals in George Town, short term rentals in George Town Cayman Islands, and George Town Cayman Islands rental properties
Rental homes in North West Point Cayman Islands, North West Point Cayman Islands rental apartment, holiday rentals North West Point Cayman Islands, and houses for rent North West Point
Real estate rentals in East End Cayman Islands and vacation homes for rent by owner
Rent house in Bamboo Bay, rental home Bamboo Bay Cayman Islands, and Bamboo Bay Cayman Islands rent house
Stake Bay Cayman Islands home rentals, rent house Stake Bay Cayman Islands, condo rentals, and Stake Bay Cayman Islands vacation rental
Condos for rent in East End Cayman Islands and East End vacation rentals
South Hole Sound Cayman Islands condo rentals, for rent by owner homes South Hole Sound, and South Hole Sound Cayman Islands apartments for rent
Vacation rental George Town, vacation homes for rent by owner George Town, rental home in George Town Cayman Islands, and homes for rent by owner in George Town
East End Cayman Islands house rentals and East End Cayman Islands rental home
Determine and espy apartments for rent George Town and George Town house rentals.
Conceive, discover, and discern George Town Cayman Islands homes for rent, vacation homes George Town Cayman Islands, and real estate rentals George Town.
For Rent By Owner can enroll, obtain, serve, and sign on hillside listed properties, hidden listings, and mountain advertisements beach classified ads, lakefront listed properties, and beach lists of marked properties to thump your Breakers Cayman Islands peregrination.
We shaped, occasioned, and invented this extensive website, FRBO.com to be delicate, cute, and sightly.
Glimpse and discern rental houses in George Town Cayman Islands and apartments for rent George Town Cayman Islands.
The Breakers Cayman Islands beach indexes, ski in/out directories, log advertisements, and lakefront classified advertisements for these turf can be mapped.
Devise and invent condo rentals and homes for rent by owner George Town Cayman Islands.
Distinguish and discern George Town Cayman Islands rental properties and vacation rentals in George Town Cayman Islands.
Discern and perceive homes for rent by owner George Town Cayman Islands and apartment rentals.
Disclose and glimpse real estate rentals George Town Cayman Islands and George Town Cayman Islands home rentals.
Using this site, FRBO.com, town home owners itemize home, cabin, castle, and lodge listed properties.
Our webpage encloses vicinity and state experiments, oftentimes.
Breakers Cayman Islands is a magnificent and superb county with exquisite and stunning villa, cabin, home, and chalets.
Breakers Cayman Islands knowledge could sustain, open doors, stump, and help your inspection.
|
|
