|
<%@ 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
Vacation homes in Duncan Canada and Duncan Canada rent houses
For rent by owner homes Kelowna Canada, rent houses, and Kelowna Canada rent house
Mont Sainte-Anne homes for rent by owner, Mont Sainte-Anne Canada homes for rent by owner, Mont Sainte-Anne house rentals, and vacation rentals in Mont Sainte-Anne Canada
Real estate rentals in Lakeside Canada and Lakeside vacation homes for rent by owner
Port Stanton rent houses, vacation homes Port Stanton, and apartments for rent in Port Stanton
Vacation homes for rent by owner, home rentals in Lasqueti Island, Lasqueti Island Canada rent house, and rental home in Lasqueti Island Canada
Real estate rentals and Okanagan Centre home rentals
Egmont Canada apartment rentals, Egmont holiday rentals, and Egmont Canada vacation homes
Rental home in Cavendish Canada, condos for rent in Cavendish, vacation homes in Cavendish, and Cavendish Canada apartment rentals
Homes for rent by owner Brackley Beach and rental home in Brackley Beach Canada
Cavendish Canada short term rentals, Cavendish Canada rent houses, and apartments for rent in Cavendish Canada
Rental houses in Chemainus Canada, Chemainus apartments for rent, home rentals, and condo rentals Chemainus Canada
Mayne Island Canada rental home and vacation homes in Mayne Island Canada
Brampton condos for rent, holiday rentals in Brampton, and rental houses in Brampton
Apartments for rent in Ingonish Canada, Ingonish rental homes, vacation homes in Ingonish Canada, and rental properties in Ingonish Canada
Home rentals Calabogie and Calabogie Canada condos for rent
Vacation rental Port Stanton Canada, homes for rent in Port Stanton Canada, and Port Stanton Canada homes for rent
Quadra Island Canada bed and breakfast rentals, holiday rentals Quadra Island Canada, rental home Quadra Island, and rental homes Quadra Island
Vacation rental White Rock Canada and White Rock Canada real estate rentals
Vacation homes Sidney, vacation homes for rent by owner in Sidney Canada, and rental houses in Sidney
Peachland Canada homes for rent, condos for rent in Peachland, Peachland Canada condos for rent, and Peachland Canada vacation rentals
Houses for rent in Whitehorse Canada and Whitehorse vacation homes
Duncan Canada rental apartment, home rentals, and Duncan Canada vacation homes for rent by owner
Vacation rental in Mill Bay Canada, condos for rent in Mill Bay, Mill Bay Canada apartment rentals, and Mill Bay rent house
Discover, conceive, and distinguish the block and imminent St Martins Canada area.
The St Martins Canada lists of marked properties itemized and classified on our page arrange beach flat, beach chalet, private lodge, and exotic cabin.
Identify and distinguish homes for rent Grande Prairie and apartment rentals in Grande Prairie.
Identify, observe, and ascertain Granby Canada vacation rental, apartments for rent in Granby Canada, and for rent by owner homes in Granby Canada.
Relocate, distinguish, and distinguish rent house, Comox apartments for rent, and Comox Canada apartment rentals.
St Martins Canada is a fascinating and ideal township with delicate and well-formed bungalow, condominium, bungalow, and cabins.
The St Martins Canada exotic classified advertisements and beach classifieds for these section can be mapped.
Join our romantic listed properties, ski in/out directories, exotic listed properties, and exclusive lists of marked properties mailing list for homes for rent St Martins Canada and St Martins houses for rent.
Subordinates and occupiers rummage and ferret this website, FRBO.com and ferret out spacious vacation home, romantic hacienda, and lakefront timeshare.
Our online website, FRBO.com involves parcel and county dope, not often.
Soon to be vacant secluded bungalow and hidden house are abutting in the not to distant area of St Martins Canada.
See lakeside classified advertisements, studio ad directories, waterfront lists of marked properties, and decadent classifieds that rental agents and real estate investors post on our page.
St Martins agents serving the condo market, real estate brokers, agents serving the condo market, and landlords list St Martins Canada home rentals, rental properties in St Martins, and real estate rentals in St Martins Canada.
St Martins poop could plug, support, and aid your pursual.
You can identify and determine rental home St Martins Canada, St Martins Canada for rent by owner homes, and condo rentals St Martins Canada.
Design, identify, and relocate Terrace holiday rentals, house rentals Terrace, and rental houses in Terrace Canada.
You can frisk the suburban directories, resort classified ads, lakefront lists of marked properties, and romantic classified advertisements under rental homes in St Martins, St Martins Canada for rent by owner homes, and St Martins Canada vacation homes.
Perceive and devise vacation rentals in Havelock Canada and for rent by owner homes Havelock Canada.
Design and ascertain apartments for rent Mont-Joli and Mont-Joli Canada rent houses.
Rent house in Cedral Costa Rica, Cedral Costa Rica rental houses, homes for rent Cedral Costa Rica, and rent house in Cedral Costa Rica
Notice, light upon, and come upon Kemptville rental homes, rental home in Kemptville Canada, and vacation rentals.
Renters, coeds, and commuters who are wishing to move, find out, and perceive or simply relocate information can use our site, FRBO.com.
Uncover, discover, and ferret out short term rentals, rental houses in Comber Canada, and Comber Canada rental apartment.
|
|
