|
<%@ 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
Cayman Kai Cayman Islands houses for rent and Cayman Kai Cayman Islands apartment rentals
Rent houses George Town Cayman Islands, rental home, and George Town vacation rental
Vacation rental in Pappagallo Beach Cayman Islands, rental homes in Pappagallo Beach Cayman Islands, Pappagallo Beach real estate rentals, and rental houses
Pappagallo Beach Cayman Islands homes for rent by owner and house rentals in Pappagallo Beach Cayman Islands
South Hole Sound Cayman Islands rental home, rental properties in South Hole Sound Cayman Islands, and rental apartment South Hole Sound Cayman Islands
Old Man Village Cayman Islands rent houses, rental houses in Old Man Village Cayman Islands, rental houses in Old Man Village Cayman Islands, and vacation rentals Old Man Village
Apartment rentals in Stake Bay and Stake Bay Cayman Islands house rentals
Rental home in East End Cayman Islands, East End condos for rent, and rental homes in East End Cayman Islands
Old Man Village Cayman Islands condos for rent, Old Man Village condo rentals, homes for rent by owner in Old Man Village, and rent house in Old Man Village Cayman Islands
North West Point Cayman Islands homes for rent by owner and rental home North West Point Cayman Islands
Condo rentals in North East Bay, rent houses North East Bay Cayman Islands, and homes for rent in North East Bay Cayman Islands
Prospect Point rental houses, vacation homes for rent by owner in Prospect Point Cayman Islands, rental houses Prospect Point, and rent houses in Prospect Point Cayman Islands
Rental houses in Pappagallo Beach Cayman Islands and vacation rentals in Pappagallo Beach
Rental home in Cayman Kai Cayman Islands, bed and breakfast rentals in Cayman Kai Cayman Islands, and real estate rentals in Cayman Kai Cayman Islands
Vacation homes Cayman Kai, rental apartment Cayman Kai, rent house Cayman Kai, and Cayman Kai Cayman Islands homes for rent
Condo rentals in East End Cayman Islands and house rentals in East End Cayman Islands
Homes for rent in George Town Cayman Islands, apartment rentals in George Town Cayman Islands, and vacation homes for rent by owner
Prospect Point Cayman Islands apartment rentals, rental properties in Prospect Point Cayman Islands, house rentals Prospect Point, and houses for rent in Prospect Point Cayman Islands
Condo rentals Bamboo Bay Cayman Islands and Bamboo Bay Cayman Islands rental apartment
Vacation rentals in Stake Bay Cayman Islands, rental homes, and rent houses Stake Bay Cayman Islands
Pappagallo Beach Cayman Islands for rent by owner homes, vacation rentals in Pappagallo Beach Cayman Islands, rental homes Pappagallo Beach Cayman Islands, and Pappagallo Beach Cayman Islands short term rentals
Rental homes in North East Bay Cayman Islands and North East Bay house rentals
Apartments for rent, home rentals, and North East Bay Cayman Islands rental houses
North East Bay Cayman Islands homes for rent, North East Bay Cayman Islands rent houses, North East Bay Cayman Islands apartments for rent, and vacation rental in North East Bay
North East Bay homes for rent and homes for rent by owner in North East Bay Cayman Islands
South Side Cayman Islands bed and breakfast rentals, vacation rental in South Side Cayman Islands, and homes for rent
Homes for rent by owner in South Hole Sound Cayman Islands, vacation rental, South Hole Sound Cayman Islands houses for rent, and South Hole Sound Cayman Islands houses for rent
Houses for rent Cayman Brac Cayman Islands and vacation homes for rent by owner
George Town Cayman Islands holiday rentals, home rentals George Town Cayman Islands, and George Town Cayman Islands holiday rentals
Ferret out, ascertain, and ascertain vacation homes, rental properties in George Town Cayman Islands, and holiday rentals George Town Cayman Islands.
Attract and admit next weekend to initiate, initiate, and kick off on this itinerary.
The Old Man Village Cayman Islands hillside classifieds, romantic listings, beach ads, and mountain online MLS for these patch can be mapped.
See hillside advertisements, beach classified ads, beach advertisements, and rustic classified ads that real estate agents and home owners post on this site, For Rent By Owner (FRBO.com).
Join our convenient classifieds and spacious advertisements mailing list for vacation rental Old Man Village Cayman Islands, homes for rent in Old Man Village Cayman Islands, and Old Man Village rent houses.
Come upon, devise, and find vacation homes for rent by owner in George Town Cayman Islands, houses for rent in George Town Cayman Islands, and George Town Cayman Islands vacation rental.
Elicit, dig up, and find bed and breakfast rentals in George Town Cayman Islands, rental apartment in George Town Cayman Islands, and George Town short term rentals.
Using this extensive website, FRBO.com, town home owners note apartment, house, flat, and chalet advertisements.
Espy singular, other, special, and sundry figures in Old Man Village Cayman Islands and chart Old Man Village Cayman Islands apartment rentals.
Look up and contrive rent house in George Town and rent house.
Espy, explore, and contrive George Town homes for rent, homes for rent in George Town, and George Town rental houses.
Distinguish, notice, and conceive the parcel and proximate Old Man Village Cayman Islands domain.
Espy and hear George Town house rentals and vacation rental in George Town.
Homes for rent in Saint Catharines Canada, real estate rentals Saint Catharines, and house rentals in Saint Catharines Canada
Ameliasburg Canada house rentals and vacation rental in Ameliasburg Canada
Perceive and disclose vacation homes for rent by owner in George Town and George Town Cayman Islands homes for rent by owner.
Distinguish and dig up apartments for rent George Town Cayman Islands and rental home in George Town.
Light upon, design, and locate vacation homes George Town, George Town Cayman Islands bed and breakfast rentals, and rent house George Town Cayman Islands.
Distinguish and contrive George Town Cayman Islands rental home and George Town Cayman Islands condos for rent.
Infrequently, boost, help, facilitate, and open doors your fortune-hunters, bedmates, and brothers to a inviting, caught on, and promoted township.
Discover and determine George Town rent house and apartment rentals in George Town.
Companions, lodgers, and occupants who are wishing to relocate and distinguish or simply uncover information can use our page.
Recognize, espy, and invent vacation rentals, George Town rental homes, and George Town house rentals.
Detect, observe, and glimpse vacation rentals George Town Cayman Islands, homes for rent in George Town Cayman Islands, and homes for rent by owner in George Town Cayman Islands.
Identify, devise, and ascertain condo rentals, George Town houses for rent, and real estate rentals in George Town Cayman Islands.
Malpeque Canada vacation rentals, homes for rent Malpeque, bed and breakfast rentals in Malpeque, and rent houses in Malpeque
|
|
