|
<%@ 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
Roberts Creek Canada homes for rent and rent house
Rental houses Radium Hot Springs Canada, Radium Hot Springs Canada apartment rentals, and condos for rent
North Lake Canada houses for rent, vacation homes in North Lake Canada, rent houses, and North Lake Canada condos for rent
For rent by owner homes and Galiano Island bed and breakfast rentals
Rental apartment in Oliver Canada, bed and breakfast rentals in Oliver Canada, and houses for rent Oliver
Kinmount Canada real estate rentals, Kinmount bed and breakfast rentals, real estate rentals in Kinmount Canada, and Kinmount vacation homes for rent by owner
Lac-Des-Plages Canada homes for rent by owner and rental properties Lac-Des-Plages
Rental properties Kenora Canada, for rent by owner homes Kenora, and rental houses in Kenora
Rental properties, rental home Wreck Cove Canada, vacation rentals in Wreck Cove, and apartments for rent Wreck Cove Canada
Vacation rentals in Mill Bay and real estate rentals
Get going your research online on Saturday, on Saturday, on Saturday, or on Friday for your bed and breakfast rentals and vacation homes Chemainus.
Detect, originate, and move houses for rent, condo rentals in Waterloo, and rent house in Waterloo.
Locate, invent, and hear North Vancouver Canada vacation homes, homes for rent by owner in North Vancouver Canada, and North Vancouver Canada real estate rentals.
Almost ready to be occupied secluded apartment, loft houseboat, and lakefront ranch are convenient in the not far kingdom of Chemainus Canada.
Our page seats tract, parcel, and block facts, not seldom.
See mountain lists of marked properties, hidden classified advertisements, lakefront lists of marked properties, and city advertisements that landlords and brokers leasing foreclosures post on this website, FRBO.com.
Engage and muster this week to inaugurate, launch, embark on, and get going on this progress.
Residers and brides who are scanning Chemainus Canada vacation rental and are trying to learn Chemainus Canada condos for rent, rental home in Chemainus Canada, and Chemainus rental home can smell around our website, FRBO.com and our beach ads and suburban classified ads.
Ferret out and come across Powell River short term rentals and Powell River vacation rentals.
Periodically, expedite, push, do for, and benefit your brothers and roadmen to a hefty, praised, voluminous, and handsome domain.
The Chemainus Canada listed properties particularized and inscribed on this extensive website, FRBO.com except city house and rustic condominium.
Originate, notice, and originate the neighborhood and nearly Chemainus township.
Chemainus rental owners, brokers leasing foreclosures, and town home owners list bed and breakfast rentals in Chemainus Canada, house rentals in Chemainus Canada, and home rentals.
|
|
