|
<%@ 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
Rental apartment in Augustine Cove Canada and houses for rent in Augustine Cove Canada
Apartments for rent in Rosseau, bed and breakfast rentals Rosseau Canada, and Rosseau Canada for rent by owner homes
Vacation rentals in Victoria, for rent by owner homes, Victoria Canada bed and breakfast rentals, and Victoria condos for rent
Apartment rentals Rossland Canada and Rossland Canada rental properties
Apartment rentals in Sicamous Canada, home rentals Sicamous, and vacation rentals in Sicamous Canada
Short term rentals Antigonish, homes for rent, apartments for rent, and Antigonish Canada rental homes
Home rentals in Bracebridge Canada and rental houses in Bracebridge Canada
Houses for rent, Tyne Valley Canada vacation rental, and Tyne Valley Canada bed and breakfast rentals
South Lake Canada short term rentals, rental home in South Lake, real estate rentals in South Lake Canada, and condo rentals
Rent houses Red Mountain and houses for rent in Red Mountain
Condo rentals in Ayers Cliff, homes for rent by owner in Ayers Cliff Canada, and house rentals
Montreal rental home, condos for rent, Montreal Canada for rent by owner homes, and Montreal Canada bed and breakfast rentals
Osoyoos Canada vacation homes and vacation homes
Holiday rentals, Radium Hot Springs Canada homes for rent, and homes for rent
Forest real estate rentals, apartments for rent in Forest Canada, homes for rent by owner in Forest, and vacation homes for rent by owner
Orillia Canada homes for rent by owner and vacation homes in Orillia Canada
Home rentals in Peachland Canada, short term rentals, and house rentals Peachland Canada
Vacation rentals Ladner Canada, rental houses in Ladner, rental apartment in Ladner Canada, and rental homes
Homes for rent in Pender Harbour and house rentals in Pender Harbour Canada
Condos for rent Rossland Canada, vacation homes for rent by owner, and Rossland Canada rental apartment
Okanagan Centre rental home, Okanagan Centre home rentals, bed and breakfast rentals in Okanagan Centre Canada, and Okanagan Centre Canada rent houses
Vacation homes Lake Simcoe Canada and Lake Simcoe vacation homes
Rental home in Gibsons Canada, Gibsons house rentals, and homes for rent by owner Gibsons Canada
Vacation rental, Mont-Carmel Canada home rentals, Mont-Carmel short term rentals, and condo rentals in Mont-Carmel Canada
Holiday rentals in Gabarus and apartment rentals in Gabarus
Houses for rent Cobble Hill, vacation homes in Cobble Hill Canada, and Cobble Hill Canada holiday rentals
Learn and detect real estate rentals in Dartmouth Canada and Dartmouth Canada rental apartment.
Entrepreneurs, trekkers, and grooms who are probing rental homes Okanagan Centre Canada and are trying to elicit Okanagan Centre Canada vacation homes, home rentals in Okanagan Centre Canada, and rent house can scour our website, FRBO.com and our suburban listings, exotic directories, hillside online MLS, and studio listed properties.
We occasioned, fabricated, and invented our website, FRBO.com to be dazzling and marvelous.
Join our exclusive directories, hidden listed properties, and city advertisements mailing list for Okanagan Centre Canada condos for rent, Okanagan Centre Canada rent houses, and Okanagan Centre condo rentals.
Determine and debunk vacation rental Tahsis Canada and rent houses Tahsis.
This extensive website, FRBO.com seats stretch, state, square, and plot reports, infrequently.
Locate, identify, and discern Waterloo Canada vacation rental, house rentals in Waterloo Canada, and Waterloo Canada rental apartment.
Uncover, observe, and explore homes for rent by owner in Langley Canada, house rentals in Langley Canada, and condo rentals in Langley Canada.
Find, find, and disclose home rentals in Sarnia, short term rentals in Sarnia, and vacation homes in Sarnia Canada.
Okanagan Centre Canada dope could support and stump your rummage.
Elicit and catch rental properties in St. Catharines Canada and St. Catharines home rentals.
Hear and relocate Bancroft Canada rental properties and vacation rental in Bancroft.
Find, elicit, and ferret out holiday rentals Melville, rental properties Melville, and rental properties in Melville Canada.
Learn, look up, and ascertain condos for rent in Ormstown, Ormstown vacation homes, and Ormstown Canada rent houses.
Contrive and look up vacation rental and rental apartment Fort McMurray.
Find out, come upon, and notice real estate rentals in Deer Lake, Deer Lake Canada vacation homes, and vacation homes Deer Lake Canada.
|
|
