|
<%@ 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 apartment Seven Mile Beach and bed and breakfast rentals Seven Mile Beach Cayman Islands
Stake Bay Cayman Islands condo rentals, Stake Bay rent house, and Stake Bay vacation rentals
Seven Mile Beach Cayman Islands bed and breakfast rentals, home rentals Seven Mile Beach, Seven Mile Beach vacation rentals, and Seven Mile Beach Cayman Islands apartments for rent
Prospect Point Cayman Islands vacation rental and Prospect Point condos for rent
Vacation homes in South Side Cayman Islands, vacation homes for rent by owner South Side, and South Side Cayman Islands rental home
Apartment rentals in North West Point Cayman Islands, North West Point condo rentals, home rentals in North West Point Cayman Islands, and vacation rental in North West Point Cayman Islands
Rental apartment Bamboo Bay and apartment rentals
North West Point Cayman Islands rental houses, short term rentals, and North West Point rental properties
For rent by owner homes, rental apartment Old Man Village Cayman Islands, rental houses in Old Man Village Cayman Islands, and homes for rent by owner Old Man Village Cayman Islands
Pappagallo Beach Cayman Islands rent house and rental houses in Pappagallo Beach Cayman Islands
Rental home in Pappagallo Beach Cayman Islands, homes for rent in Pappagallo Beach Cayman Islands, and home rentals Pappagallo Beach
Breakers Cayman Islands rental houses, real estate rentals, rental apartment in Breakers Cayman Islands, and Breakers rent house
Rent houses in North East Bay Cayman Islands and apartment rentals
Vacation rental, short term rentals in Bamboo Bay Cayman Islands, and houses for rent in Bamboo Bay Cayman Islands
Home rentals Rum Point, vacation rentals in Rum Point, vacation rentals, and rent houses
Home rentals in Old Man Village Cayman Islands and Old Man Village homes for rent by owner
Apartment rentals Rum Point, house rentals in Rum Point Cayman Islands, and rent house in Rum Point Cayman Islands
Vacation homes in North West Point, North West Point Cayman Islands condos for rent, North West Point rental homes, and home rentals North West Point
Vacation homes for rent by owner and East End Cayman Islands home rentals
Vacation rentals, homes for rent in Stake Bay Cayman Islands, and Stake Bay Cayman Islands rental home
Rent houses North East Bay, bed and breakfast rentals, rental home in North East Bay, and vacation rental North East Bay Cayman Islands
Condo rentals South Side and apartments for rent in South Side Cayman Islands
George Town Cayman Islands apartments for rent, rent houses in George Town Cayman Islands, and short term rentals
Condo rentals, rent house in Old Man Village, short term rentals in Old Man Village, and rental apartment
Rental properties and Cayman Brac Cayman Islands rental apartment
Short term rentals, rental home in Bamboo Bay Cayman Islands, and short term rentals in Bamboo Bay Cayman Islands
Rent house in Stake Bay, rental home in Stake Bay, bed and breakfast rentals in Stake Bay, and rental houses
Vacation homes in Seven Mile Beach Cayman Islands and homes for rent by owner in Seven Mile Beach Cayman Islands
Holiday rentals in Pappagallo Beach Cayman Islands, rental properties in Pappagallo Beach, and Pappagallo Beach Cayman Islands home rentals
South Side Cayman Islands apartments for rent, rent houses South Side, vacation homes in South Side Cayman Islands, and real estate rentals in South Side Cayman Islands
Vacation homes in Cayman Kai and for rent by owner homes in Cayman Kai
Pappagallo Beach Cayman Islands house rentals, apartments for rent Pappagallo Beach Cayman Islands, and homes for rent in Pappagallo Beach Cayman Islands
Condos for rent in East End Cayman Islands and rent houses in East End
Rental apartment in Prospect Point, holiday rentals in Prospect Point, and Prospect Point for rent by owner homes
We imagined and planned FRBO.com to be sightly, excellent, and refined.
Notice, debunk, and find apartments for rent in George Town, house rentals in George Town Cayman Islands, and rental homes in George Town.
The North East Bay Cayman Islands mountain classified advertisements, spacious listings, lakefront lists of marked properties, and studio listings for these turf can be mapped.
Join our beach lists of marked properties, lake lists of marked properties, romantic classified advertisements, and romantic directories mailing list for rental houses in North East Bay Cayman Islands, rental houses North East Bay Cayman Islands, and real estate rentals in North East Bay.
North East Bay rental property owners and property managers list North East Bay rental properties, vacation rentals North East Bay, North East Bay Cayman Islands rental home, and home rentals in North East Bay Cayman Islands.
You can find, catch, and move short term rentals in North East Bay and apartments for rent North East Bay Cayman Islands.
Identify and observe vacation rental in George Town and George Town for rent by owner homes.
Ordinarily, facilitate and cooperate your ramblers, dwellers, and pilgrims to a likable, super colossal, super colossal, and celebrated kingdom.
Contrive, light upon, and espy rent houses in George Town Cayman Islands, rental houses in George Town Cayman Islands, and house rentals George Town Cayman Islands.
North East Bay goods could cooperate and plug your quest.
This site, FRBO.com does incorporate rare area lakefront, lakeside, and exotic lodge, condominium, and lodges.
Move another story and various poop in North East Bay Cayman Islands and manifest North East Bay condos for rent.
Chapala Mexico vacation homes, vacation homes for rent by owner, and holiday rentals
Ferret out and locate rent house in George Town and rent houses in George Town Cayman Islands.
Almost ready to be occupied beach timeshare, lakeside lodge, studio apartment, and city duplex are not remote in the abutting state of North East Bay.
Using our for rent by owner site, FRBO.com, agents bill cottage, cottage, duplex, and cabin classifieds.
Ferret out, light upon, and determine condos for rent in George Town Cayman Islands, vacation homes for rent by owner, and rental apartment in George Town.
Recognize and conceive George Town Cayman Islands vacation rental and condo rentals in George Town Cayman Islands.
See well appointed listings, romantic listed properties, and convenient ads that property agents and agents post on our website, FRBO.com.
North East Bay Cayman Islands turf employs many rental owners and property brokers.
Come upon, identify, and uncover George Town Cayman Islands rental properties, houses for rent in George Town Cayman Islands, and George Town Cayman Islands houses for rent.
Distinguish and observe George Town apartments for rent and bed and breakfast rentals George Town.
Find out and identify rental homes and rent houses in George Town.
You can study the lakeside directories, well appointed directories, beachfront lists of marked properties, and beach classifieds under North East Bay rental homes and homes for rent North East Bay.
Homes for rent in Okanagan Falls Canada, condos for rent, and Okanagan Falls Canada apartment rentals
Marsh Harbour Bahamas rent houses and Marsh Harbour rental apartment
Observe and come across George Town Cayman Islands condos for rent and George Town short term rentals.
Catch and come upon the dominion and not far away North East Bay Cayman Islands neighborhood.
Roamers, traveling saleswomen, and trekkers who are rifling through real estate rentals in North East Bay Cayman Islands and are trying to contrive apartment rentals in North East Bay Cayman Islands and real estate rentals North East Bay can rummage our for rent by owner website and our loft directories, oceanfront online MLS, suburban listed properties, and spacious advertisements.
For Rent By Owner seats parcel, neighborhood, tract, and vicinity evidence, once and again.
Vacation homes El Placer Mexico and apartment rentals El Placer Mexico
Uncover, ascertain, and glimpse rental homes George Town, homes for rent by owner George Town, and homes for rent George Town Cayman Islands.
For Rent By Owner can hitch, conscribe, employ, and obtain loft lists of marked properties, decadent listings, exclusive listings, and beachfront indexes studio lists of marked properties, beach ads, romantic ads, and city classified ads to abet your North East Bay Cayman Islands tour.
Learn, hear, and dig up rent house in George Town Cayman Islands, vacation rentals George Town Cayman Islands, and George Town Cayman Islands rental homes.
Devise, determine, and discover homes for rent by owner George Town, George Town Cayman Islands vacation rentals, and George Town Cayman Islands home rentals.
For rent by owner homes Sayulita Mexico, rent house in Sayulita, and Sayulita Mexico rental apartment
|
|
