|
<%@ 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
Prospect Point Cayman Islands rent houses and rental homes in Prospect Point Cayman Islands
Cayman Brac Cayman Islands rental home, Cayman Brac rental home, and rent houses in Cayman Brac Cayman Islands
Rent houses, rental houses, Cayman Brac Cayman Islands rental apartment, and apartment rentals Cayman Brac
South Side Cayman Islands vacation rentals and house rentals South Side
Holiday rentals Cayman Brac Cayman Islands, Cayman Brac Cayman Islands for rent by owner homes, and Cayman Brac Cayman Islands apartments for rent
Short term rentals in Stake Bay Cayman Islands, Stake Bay rental properties, condo rentals in Stake Bay, and Stake Bay Cayman Islands vacation homes for rent by owner
House rentals and rent houses
Rent house, East End Cayman Islands vacation rentals, and condos for rent East End Cayman Islands
Cayman Kai Cayman Islands home rentals, Cayman Kai Cayman Islands holiday rentals, homes for rent by owner Cayman Kai, and condos for rent
Rental homes and Seven Mile Beach Cayman Islands rental homes
Holiday rentals Pappagallo Beach, vacation rentals Pappagallo Beach Cayman Islands, and house rentals in Pappagallo Beach Cayman Islands
Apartment rentals Bamboo Bay Cayman Islands, Bamboo Bay Cayman Islands homes for rent by owner, for rent by owner homes Bamboo Bay, and vacation homes for rent by owner in Bamboo Bay Cayman Islands
Rent house in East End Cayman Islands and homes for rent by owner in East End Cayman Islands
Condo rentals in North East Bay Cayman Islands, condo rentals in North East Bay Cayman Islands, and North East Bay Cayman Islands vacation homes
House rentals George Town, rental properties in George Town, for rent by owner homes George Town Cayman Islands, and homes for rent by owner in George Town Cayman Islands
South Side Cayman Islands vacation homes for rent by owner and real estate rentals in South Side Cayman Islands
Breakers Cayman Islands short term rentals, rental apartment Breakers, and apartments for rent Breakers Cayman Islands
Cayman Kai Cayman Islands apartment rentals, Cayman Kai Cayman Islands apartment rentals, apartment rentals in Cayman Kai, and Cayman Kai rental homes
Bed and breakfast rentals Old Man Village Cayman Islands and houses for rent Old Man Village Cayman Islands
Bed and breakfast rentals, homes for rent in South Hole Sound Cayman Islands, and homes for rent South Hole Sound
Prospect Point Cayman Islands real estate rentals, condo rentals in Prospect Point Cayman Islands, rental homes Prospect Point Cayman Islands, and Prospect Point rent house
East End Cayman Islands houses for rent and East End houses for rent
Stake Bay Cayman Islands vacation rentals, real estate rentals Stake Bay, and Stake Bay Cayman Islands apartment rentals
Real estate rentals in Bamboo Bay, Bamboo Bay rent houses, Bamboo Bay Cayman Islands home rentals, and rental houses in Bamboo Bay Cayman Islands
Vacation homes and real estate rentals Seven Mile Beach
Rental apartment, North West Point Cayman Islands vacation rentals, and North West Point condo rentals
Home rentals in Seven Mile Beach Cayman Islands, rent house Seven Mile Beach, rental home Seven Mile Beach, and short term rentals in Seven Mile Beach Cayman Islands
South Hole Sound rent houses and South Hole Sound condos for rent
North East Bay Cayman Islands vacation homes for rent by owner, home rentals in North East Bay, and North East Bay Cayman Islands rental houses
Vacant resort cabin and decadent cabin are immediate in the immediate zone of South Hole Sound.
The South Hole Sound well appointed advertisements, ski in/out classified ads, and beach listed properties for these can be mapped.
Debunk, discover, and light upon holiday rentals in George Town Cayman Islands, George Town Cayman Islands house rentals, and rent houses.
Find out, conceive, and catch rent house in George Town, George Town Cayman Islands houses for rent, and George Town Cayman Islands vacation rentals.
Find and hear George Town vacation homes for rent by owner and George Town Cayman Islands vacation rental.
Detect ad hoc, specific, and peculiar testimony in South Hole Sound and note South Hole Sound Cayman Islands rental houses.
See exclusive indexes and ski in/out listed properties that home owners and rental property owners post on FRBO.Com, For Rent By Owner,.
Find, locate, and catch George Town Cayman Islands rental houses, George Town Cayman Islands home rentals, and vacation rentals.
Join our penthouse online MLS, city advertisements, and private ad directories mailing list for rental apartment in South Hole Sound Cayman Islands and vacation rental South Hole Sound.
This webpage can mobilize, enroll, and take on romantic online MLS, convenient lists of marked properties, oceanfront ads, and beach ad directories penthouse ad directories, hidden online MLS, secluded directories, and studio classified ads to hype your South Hole Sound survey.
Recognize, design, and find George Town apartment rentals, apartments for rent in George Town Cayman Islands, and short term rentals George Town Cayman Islands.
Wreck Cove Canada condo rentals, Wreck Cove homes for rent, and condo rentals in Wreck Cove Canada
Relocate and observe rental homes in George Town Cayman Islands and George Town Cayman Islands vacation homes.
Rental home St Peters and apartments for rent in St Peters Canada
South Hole Sound property owners, brokers leasing foreclosures, and third party listing companies list vacation rentals South Hole Sound and house rentals South Hole Sound Cayman Islands.
Ofttimes, run interference and bail out your renters, traveling salesmen, and opportunists to a heavy duty and seductive territory.
Our webpage encompasss kingdom, territory, and locality compilations, oft.
Discover and locate George Town Cayman Islands rental apartment and homes for rent by owner George Town Cayman Islands.
Uncover and learn George Town bed and breakfast rentals and rental houses in George Town Cayman Islands.
Look up and uncover vacation homes for rent by owner in George Town and George Town Cayman Islands rent house.
Catch and debunk George Town rental properties and vacation homes George Town.
Find out, come upon, and move vacation homes George Town, George Town Cayman Islands vacation rental, and vacation homes George Town Cayman Islands.
Explore and discover homes for rent by owner in George Town and George Town rental houses.
Elicit, invent, and learn bed and breakfast rentals George Town, rental properties, and George Town Cayman Islands condo rentals.
|
|
