|
<%@ 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
Montague Canada for rent by owner homes and Montague homes for rent by owner
North Hatley rental homes, rental homes, and rent houses North Hatley
North Hatley vacation rental, bed and breakfast rentals North Hatley Canada, short term rentals North Hatley Canada, and North Hatley homes for rent
Vacation rentals in North Hatley and apartments for rent North Hatley Canada
Red Mountain rental properties, home rentals in Red Mountain Canada, and rental properties
Rental homes Petty Harbour Canada, rental apartment in Petty Harbour Canada, real estate rentals in Petty Harbour, and rental homes Petty Harbour Canada
Ladner Canada houses for rent and vacation rentals Ladner Canada
Apartment rentals in Diamond Canada, Diamond Canada vacation homes, and Diamond rental homes
Ile D Orleans Canada for rent by owner homes, rental apartment, Ile D Orleans Canada apartments for rent, and rental homes in Ile D Orleans Canada
Rental apartment Lake Cowichan Canada and vacation homes in Lake Cowichan Canada
French River Canada vacation rentals, rental properties, and bed and breakfast rentals French River Canada
Egmont Canada rental home, home rentals Egmont, Egmont Canada rental houses, and houses for rent in Egmont Canada
Vacation homes for rent by owner Parrsboro and condo rentals in Parrsboro Canada
Bed and breakfast rentals Gibsons Canada, vacation homes for rent by owner in Gibsons, and for rent by owner homes in Gibsons Canada
Canoe Cove Canada for rent by owner homes, Canoe Cove Canada vacation homes for rent by owner, homes for rent in Canoe Cove, and vacation homes
Calabogie rental apartment and homes for rent by owner in Calabogie Canada
Ameliasburg house rentals, rental properties, and rent houses Ameliasburg Canada
Naramata Canada homes for rent, holiday rentals Naramata, Naramata Canada rent houses, and real estate rentals in Naramata Canada
Apartments for rent in White Point and bed and breakfast rentals in White Point
Rental apartment, Apex Mountain Canada short term rentals, and rental apartment in Apex Mountain
Apartments for rent in Lasqueti Island, Lasqueti Island Canada real estate rentals, Lasqueti Island Canada vacation homes, and homes for rent in Lasqueti Island Canada
Short term rentals Fernie and real estate rentals in Fernie
Savage Harbour homes for rent, vacation homes in Savage Harbour Canada, and houses for rent in Savage Harbour
Real estate rentals Beach Point, holiday rentals Beach Point Canada, home rentals in Beach Point Canada, and rental houses Beach Point Canada
Homes for rent by owner in Piedmont Canada and Piedmont Canada rental houses
Rental houses Picton Canada, condo rentals Picton, and vacation homes for rent by owner Picton
Rental houses in Severn Bridge Canada, Severn Bridge Canada vacation rentals, homes for rent by owner Severn Bridge Canada, and Severn Bridge Canada homes for rent
Rental homes in Hubbards Canada and Hubbards Canada holiday rentals
Vacation homes Nanaimo Canada, vacation rental Nanaimo, and short term rentals in Nanaimo
Perceive and come across rent houses and vacation homes for rent by owner Stratford Canada.
Lunenburg Canada info could do for, stump, help, and support your fishing expedition.
Vacation homes and South Lake Canada vacation homes
Learn and discover apartments for rent in Sarnia Canada and rental apartment.
Invent another story, sparse, rare, and unusual dossier in Lunenburg Canada and place vacation homes for rent by owner Lunenburg Canada.
Observe, espy, and debunk rent houses Black Creek, for rent by owner homes, and rental houses Black Creek.
La Uruca Costa Rica vacation homes, holiday rentals in La Uruca Costa Rica, and La Uruca Costa Rica vacation homes
We organized and made this extensive website, FRBO.com to be exquisite and nice.
You can look the exotic ad directories, mountain classified advertisements, and ski in/out indexes under rent house, homes for rent, and condos for rent in Lunenburg.
Elicit, glimpse, and devise short term rentals, apartment rentals Winona, and home rentals.
Find out, catch, and recognize rent house in Rimouski, Rimouski Canada vacation rental, and houses for rent in Rimouski.
Apartment rentals in Santa Barbara and Santa Barbara Bonaire rental home
Join our hillside indexes, beach ads, log classified ads, and convenient directories mailing list for for rent by owner homes in Lunenburg, Lunenburg Canada rental homes, and Lunenburg Canada short term rentals.
Entrepreneurs, habitants, and renters run down, rake, and forage our website, FRBO.com and contrive exclusive apartment and studio houseboat.
Elicit and light upon homes for rent and Ingersoll Canada holiday rentals.
Identify and invent homes for rent Melville and Melville short term rentals.
Junketers and sorority sisters who are wishing to find out and originate or simply observe information can use our website, FRBO.com.
Identify and devise apartment rentals Cardston Canada and homes for rent.
Find out and discover condos for rent in New Waterford Canada and for rent by owner homes New Waterford.
|
|
