|
<%@ 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 Cayman Brac Cayman Islands and Cayman Brac vacation homes
Homes for rent by owner in Seven Mile Beach, real estate rentals Seven Mile Beach, and apartments for rent
Real estate rentals in North East Bay, rent houses, holiday rentals in North East Bay, and real estate rentals North East Bay Cayman Islands
Rental apartment in George Town Cayman Islands and George Town house rentals
Vacation homes for rent by owner in Rum Point, rental apartment Rum Point Cayman Islands, and Rum Point holiday rentals
Rental home in Rum Point Cayman Islands, vacation rental in Rum Point, condo rentals in Rum Point Cayman Islands, and Rum Point home rentals
Rent house Cayman Kai Cayman Islands and Cayman Kai Cayman Islands vacation rental
Vacation rental Old Man Village Cayman Islands, apartment rentals in Old Man Village Cayman Islands, and rental properties
Holiday rentals in North East Bay Cayman Islands, home rentals, North East Bay homes for rent, and North East Bay Cayman Islands vacation homes for rent by owner
Apartments for rent Pappagallo Beach and rent house Pappagallo Beach
Rental houses, vacation rental in North West Point Cayman Islands, and rental home in North West Point Cayman Islands
Prospect Point Cayman Islands rental properties, Prospect Point Cayman Islands rental houses, real estate rentals Prospect Point, and house rentals in Prospect Point Cayman Islands
Rental homes in Rum Point Cayman Islands and Rum Point Cayman Islands vacation rental
Bed and breakfast rentals Prospect Point Cayman Islands, holiday rentals Prospect Point Cayman Islands, and condos for rent Prospect Point Cayman Islands
Condo rentals Bamboo Bay Cayman Islands, condo rentals Bamboo Bay Cayman Islands, houses for rent, and Bamboo Bay holiday rentals
Condos for rent and apartment rentals
South Side condos for rent, vacation homes in South Side, and South Side Cayman Islands real estate rentals
Vacation rental in George Town Cayman Islands, George Town Cayman Islands short term rentals, vacation rental, and rental apartment George Town
Apartments for rent and Pappagallo Beach apartments for rent
Vacation homes for rent by owner in South Hole Sound Cayman Islands, rent house in South Hole Sound Cayman Islands, and for rent by owner homes South Hole Sound Cayman Islands
Seven Mile Beach Cayman Islands condos for rent, vacation rental, apartment rentals in Seven Mile Beach, and Seven Mile Beach Cayman Islands rental apartment
North East Bay Cayman Islands home rentals and rental homes in North East Bay
Rental properties in South Side Cayman Islands, homes for rent, and houses for rent South Side
Bamboo Bay Cayman Islands home rentals, vacation rentals Bamboo Bay Cayman Islands, Bamboo Bay Cayman Islands houses for rent, and holiday rentals
Rent house and homes for rent North East Bay Cayman Islands
Seven Mile Beach holiday rentals, homes for rent in Seven Mile Beach, and Seven Mile Beach rental properties
Breakers Cayman Islands rental apartment, real estate rentals in Breakers, house rentals Breakers, and Breakers Cayman Islands house rentals
North West Point Cayman Islands for rent by owner homes and rent house in North West Point
Breakers Cayman Islands vacation rentals, Breakers Cayman Islands for rent by owner homes, and vacation rentals in Breakers Cayman Islands
Send grand, dazzling, classy, and good-looking input regarding short term rentals in West Bay Cayman Islands and house rentals found on For Rent By Owner.
Ferret out, dig up, and come upon apartment rentals in George Town Cayman Islands, vacation rentals, and rental properties George Town Cayman Islands.
Discern and espy George Town Cayman Islands homes for rent and rent house in George Town Cayman Islands.
Light upon, detect, and contrive George Town real estate rentals, bed and breakfast rentals in George Town Cayman Islands, and rental apartment George Town Cayman Islands.
West Bay notes could bail out and push your inquest.
Rovers and acquaintances who are smelling around vacation rentals West Bay Cayman Islands and are trying to recognize home rentals in West Bay, vacation rental in West Bay Cayman Islands, and West Bay Cayman Islands real estate rentals can scrutinize this site, For Rent By Owner (FRBO.com) and our hidden classified ads, lakeside indexes, spacious ads, and lake ad directories.
Catch and discover for rent by owner homes George Town Cayman Islands and George Town houses for rent.
Relocate, perceive, and dig up houses for rent in George Town, homes for rent by owner George Town Cayman Islands, and apartment rentals.
Relocate, uncover, and relocate vacation rental George Town, rental apartment in George Town Cayman Islands, and George Town Cayman Islands for rent by owner homes.
Rent houses, rental homes, and Mullet Bay St Maarten rental houses
West Bay home owners, property agents, and property agents list West Bay Cayman Islands vacation homes and homes for rent West Bay.
The West Bay private lists of marked properties, studio ad directories, beachfront classifieds, and well appointed listed properties for these square can be mapped.
Invent, detect, and espy house rentals in George Town Cayman Islands, rental properties in George Town Cayman Islands, and bed and breakfast rentals George Town.
Lead off your inquiry online on Thursday, on Sunday, on Monday, or on Wednesday for your West Bay Cayman Islands houses for rent, apartments for rent in West Bay Cayman Islands, and rent house in West Bay Cayman Islands.
You can investigate the city listed properties and lakeside advertisements under rental apartment in West Bay Cayman Islands and apartments for rent in West Bay Cayman Islands.
Our online website, FRBO.com subsumes vicinity, territory, domain, and neighborhood abstracts, ordinarily.
Light upon and recognize vacation rental in George Town Cayman Islands and for rent by owner homes in George Town Cayman Islands.
Look up and devise rental homes in George Town and George Town for rent by owner homes.
Explore bizarre, discrete, particular, and extraordinary scoop in West Bay Cayman Islands and docket West Bay vacation rental.
Hikers and wanderers who are wishing to contrive, glimpse, and detect or simply learn information can use our online website, FRBO.com.
Join our beach ads and resort lists of marked properties mailing list for West Bay Cayman Islands rental houses, West Bay houses for rent, and condos for rent in West Bay Cayman Islands.
West Bay precinct employs many real estate agents and real estate brokers.
Learn and learn George Town apartment rentals and vacation rentals in George Town Cayman Islands.
Determine and come across George Town houses for rent and rental home in George Town.
Perceive and design rental homes in George Town and vacation homes George Town Cayman Islands.
|
|
