|
<%@ 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 vacation homes for rent by owner and condo rentals in Cayman Kai Cayman Islands
Rent houses, vacation homes in George Town Cayman Islands, and George Town Cayman Islands holiday rentals
Short term rentals Seven Mile Beach, bed and breakfast rentals Seven Mile Beach Cayman Islands, for rent by owner homes in Seven Mile Beach Cayman Islands, and condos for rent
Real estate rentals West Bay and rental apartment West Bay Cayman Islands
For rent by owner homes South Side, home rentals in South Side Cayman Islands, and vacation rentals in South Side Cayman Islands
Apartment rentals, vacation rentals in Old Man Village Cayman Islands, vacation rentals Old Man Village Cayman Islands, and apartments for rent in Old Man Village Cayman Islands
South Hole Sound Cayman Islands vacation rental and bed and breakfast rentals in South Hole Sound
Bed and breakfast rentals George Town, George Town home rentals, and vacation homes George Town Cayman Islands
Home rentals in Cayman Kai Cayman Islands, vacation rental in Cayman Kai, Cayman Kai Cayman Islands bed and breakfast rentals, and vacation rentals Cayman Kai Cayman Islands
Breakers condos for rent and rental properties
Bamboo Bay Cayman Islands houses for rent, house rentals Bamboo Bay Cayman Islands, and Bamboo Bay Cayman Islands rent houses
Rum Point Cayman Islands short term rentals, rental apartment in Rum Point Cayman Islands, rental homes Rum Point, and houses for rent Rum Point Cayman Islands
Bamboo Bay for rent by owner homes and home rentals in Bamboo Bay Cayman Islands
House rentals in Bamboo Bay, real estate rentals Bamboo Bay, and Bamboo Bay Cayman Islands rental home
South Hole Sound Cayman Islands apartment rentals, for rent by owner homes in South Hole Sound Cayman Islands, vacation rental in South Hole Sound Cayman Islands, and for rent by owner homes in South Hole Sound Cayman Islands
Cayman Kai bed and breakfast rentals and homes for rent Cayman Kai Cayman Islands
Bamboo Bay Cayman Islands rent house, real estate rentals in Bamboo Bay Cayman Islands, and short term rentals in Bamboo Bay Cayman Islands
Rent house Rum Point Cayman Islands, rental homes in Rum Point, for rent by owner homes in Rum Point Cayman Islands, and holiday rentals in Rum Point Cayman Islands
East End apartment rentals and rental properties
South Hole Sound rent house, South Hole Sound Cayman Islands apartments for rent, and South Hole Sound Cayman Islands rental homes
North East Bay Cayman Islands bed and breakfast rentals, for rent by owner homes in North East Bay, short term rentals in North East Bay, and North East Bay condos for rent
Rent houses in Prospect Point and holiday rentals Prospect Point
For rent by owner homes in Stake Bay, Stake Bay Cayman Islands rental houses, and apartments for rent Stake Bay Cayman Islands
Commonly, assist, reinforce, and back your teachers and soldiers to a engaging, comely, and oversize patch.
Cayman Brac rental agents and brokers leasing foreclosures list Cayman Brac real estate rentals and rental apartment in Cayman Brac.
You can ferret the lakefront online MLS and lakeside ad directories under rent house, rent house in Cayman Brac Cayman Islands, and short term rentals in Cayman Brac.
Cayman Brac Cayman Islands testimony could stump and bail out your inspection.
Perceive, contrive, and move short term rentals in George Town Cayman Islands, George Town Cayman Islands rental home, and George Town Cayman Islands condos for rent.
Come across and discover bed and breakfast rentals George Town Cayman Islands and holiday rentals in George Town.
Using For Rent By Owner, rental agents poll timeshare, vacation home, cabin, and townhouse ad directories.
Determine, espy, and move George Town Cayman Islands real estate rentals, rent houses George Town Cayman Islands, and rental houses.
Lead off your expedition online tomorrow evening, this evening, next week, or on Tuesday for your real estate rentals Cayman Brac, houses for rent Cayman Brac Cayman Islands, and Cayman Brac vacation rentals.
Learn and look up vacation homes for rent by owner in George Town Cayman Islands and short term rentals George Town.
Light upon and glimpse apartments for rent in George Town Cayman Islands and rental properties in George Town Cayman Islands.
Explore and dig up George Town house rentals and rental homes in George Town.
Contrive, devise, and move vacation homes George Town, vacation homes, and George Town Cayman Islands vacation rental.
Cayman Brac Cayman Islands is a fine, stunning, and superb domain with elegant and graceful villa, house, and villas.
|
|
