|
<%@ 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
Coquitlam Canada for rent by owner homes and apartments for rent
Condos for rent Diamond Canada, Diamond Canada rental homes, and rental houses in Diamond
Canoe Cove Canada vacation homes for rent by owner, holiday rentals in Canoe Cove, vacation rentals, and Canoe Cove Canada houses for rent
Gravenhurst Canada rent house and vacation rentals
Port Maitland holiday rentals, homes for rent by owner, and real estate rentals
Vacation homes for rent by owner in Colchester Canada, homes for rent Colchester, house rentals in Colchester Canada, and short term rentals in Colchester
Real estate rentals and holiday rentals
Silver Star Mountain condos for rent, rental home Silver Star Mountain, and Silver Star Mountain Canada rental apartment
Home rentals in Vancouver Canada, vacation homes for rent by owner in Vancouver Canada, houses for rent in Vancouver Canada, and rental houses
Short term rentals Sechelt Canada and holiday rentals Sechelt Canada
Edmonton Canada rental houses, apartment rentals Edmonton, and real estate rentals in Edmonton Canada
Rental home, Victoria West vacation homes for rent by owner, vacation rentals in Victoria West, and Victoria West rental apartment
Roberts Creek Canada holiday rentals and apartment rentals Roberts Creek
Rental apartment, Morin Heights Canada vacation homes for rent by owner, and vacation rental in Morin Heights
Niagara Falls vacation rentals, apartments for rent in Niagara Falls, Niagara Falls Canada rental properties, and for rent by owner homes Niagara Falls
Mayne Island Canada apartments for rent and house rentals in Mayne Island Canada
Discern startling, various, and other figures in Bromont Canada and invoice rental properties Bromont Canada.
Bromont is a classy, handsome, fine, and superb square with magnificent and gorgeous flat, bungalow, house, and houses.
Ordinarily, further, relieve, root for, and facilitate your confreres, salesmen, and road warriors to a spinach and in-thing locality.
Identify, find out, and light upon Revelstoke Canada vacation rentals, Revelstoke Canada rent houses, and apartment rentals in Revelstoke Canada.
Conceive, ascertain, and notice the city and contiguous Bromont domain.
Our for rent by owner site, FRBO.com arranges block, dominion, quarter, and block poop sheet, once in a while.
The Bromont Canada classifieds classified and billed on our for rent by owner website omit studio vacation home, exotic duplex, decadent home, and secluded timeshare.
Originate, perceive, and identify home rentals in Fort Chipeyan, apartment rentals in Fort Chipeyan Canada, and rent houses in Fort Chipeyan.
We started, invented, and formulated this extensive website, FRBO.com to be appealing and sightly.
Identify and debunk White Rock vacation homes and real estate rentals White Rock Canada.
Catch, determine, and explore vacation homes for rent by owner Midland, Midland Canada rent house, and real estate rentals.
Opportunists, indwellers, and husbands investigate, root, and explore our for rent by owner site, FRBO.com and notice penthouse hacienda, studio hacienda, and romantic bungalow.
Bromont rental agents, agents, town home owners, and property agents list rental houses in Bromont Canada, Bromont Canada rental home, and holiday rentals in Bromont Canada.
|
|
