|
<%@ 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" %>
|
Canada Rental Links
Banff home rentals and rent houses in Banff Canada
Holiday rentals, Fernie Canada homes for rent, and Fernie for rent by owner homes
Rent house, Osoyoos Canada condo rentals, for rent by owner homes Osoyoos Canada, and for rent by owner homes in Osoyoos Canada
Holiday rentals in Tofino Canada and Tofino Canada rent house
House rentals in North Rustico Canada, homes for rent by owner in North Rustico, and vacation rentals North Rustico Canada
Bed and breakfast rentals in Ile Verte-Green Island, Ile Verte-Green Island Canada holiday rentals, Ile Verte-Green Island Canada home rentals, and house rentals in Ile Verte-Green Island Canada
Home rentals in Lac Castor Canada and apartments for rent Lac Castor Canada
Rental properties in Rossland Canada, Rossland Canada rental properties, and rental homes Rossland Canada
Homes for rent by owner in Petite Riviere, home rentals Petite Riviere, rent house Petite Riviere Canada, and homes for rent
Real estate rentals and vacation rentals Carr s Landing Canada
Houses for rent in Mont Tremblant Canada, Mont Tremblant Canada real estate rentals, and home rentals in Mont Tremblant
Alert Bay bed and breakfast rentals, short term rentals in Alert Bay Canada, apartments for rent Alert Bay, and vacation homes for rent by owner
Rental apartment Port Alberni and Port Alberni Canada rental homes
For rent by owner homes Montague Canada, vacation rentals, and vacation homes in Montague Canada
Stanhope vacation rental, Stanhope Canada vacation homes, Stanhope Canada real estate rentals, and Stanhope Canada vacation rental
Rental home Chester and rental homes in Chester
Rental houses in Cobble Hill Canada, Cobble Hill Canada vacation homes for rent by owner, and Cobble Hill rental homes
Houses for rent, rental houses in Fairmont Hot Springs Canada, homes for rent Fairmont Hot Springs, and homes for rent Fairmont Hot Springs
Vacation rental and holiday rentals in Canoe Cove Canada
The Pictou Island Canada classified advertisements written down and census on this website, FRBO.com seat decadent houseboat, lake ranch, lake farmhouse, and beach hacienda.
FRBO.com encloses county, patch, and township input, periodically.
Our webpage can oblige, record, serve, and recruit decadent classifieds, exotic ads, lakeside lists of marked properties, and lake listings loft listed properties, oceanfront online MLS, and lake indexes to further your Pictou Island Canada crossing.
Vacated exotic cabin and log castle are convenient in the not faraway city of Pictou Island Canada.
Glimpse, observe, and identify home rentals in Oshawa Canada, vacation homes in Oshawa, and Oshawa Canada homes for rent by owner.
Brothers-in-law, seafarers, and transmigrants who are wishing to uncover, glimpse, and relocate or simply dig up information can use our site, FRBO.com.
Companions and better halves who are rooting bed and breakfast rentals and are trying to design home rentals Pictou Island Canada, Pictou Island rental houses, and houses for rent Pictou Island can run down For Rent By Owner and our beachfront listed properties, decadent online MLS, oceanfront advertisements, and exotic classifieds.
Relocate, observe, and locate holiday rentals in Dawson Creek Canada, bed and breakfast rentals Dawson Creek, and Dawson Creek Canada rent houses.
Join our lakefront indexes, lakefront directories, well appointed directories, and beach ads mailing list for Pictou Island Canada house rentals and condo rentals in Pictou Island Canada.
Discover and recognize rental properties and Lachine Canada rent house.
Elicit and uncover holiday rentals in Chesley Canada and Chesley Canada vacation homes for rent by owner.
Identify, discover, and look up vacation rentals, apartment rentals in Rouyn-Noranda, and apartments for rent in Rouyn-Noranda Canada.
Pictou Island property owners and condo owners list rent house in Pictou Island and Pictou Island Canada condos for rent.
Send charming and well-formed materials regarding homes for rent Pictou Island, house rentals in Pictou Island, for rent by owner homes in Pictou Island Canada, and Pictou Island Canada bed and breakfast rentals found on this extensive website, FRBO.com.
Light upon and dig up condo rentals in Ethel Canada and rental home in Ethel Canada.
|
|
