|
<%@ 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 homes in Penetanguishene and vacation rental Penetanguishene Canada
Greenfield Canada rental home, houses for rent Greenfield, and Greenfield Canada for rent by owner homes
Vacation homes for rent by owner in Lac Castor Canada, Lac Castor Canada home rentals, rent house in Lac Castor Canada, and Lac Castor vacation homes
Osoyoos for rent by owner homes and Osoyoos Canada vacation rental
Okanagan Falls houses for rent, houses for rent Okanagan Falls Canada, and short term rentals
Ste Adele Canada short term rentals, Ste Adele vacation rental, bed and breakfast rentals in Ste Adele Canada, and rent house
Home rentals in Okanagan Centre and Okanagan Centre Canada rent houses
Chemong Lake bed and breakfast rentals, Chemong Lake Canada homes for rent by owner, and Chemong Lake rental houses
Cavendish Canada rental apartment, Cavendish Canada home rentals, Cavendish Canada rent houses, and real estate rentals Cavendish Canada
Short term rentals Quebec City and rental home Quebec City Canada
Rental houses in Park Corner, rent houses, and rental apartment in Park Corner Canada
Condo rentals in Tyne Valley Canada, real estate rentals Tyne Valley Canada, Tyne Valley for rent by owner homes, and Tyne Valley Canada vacation rentals
Okanagan Falls Canada homes for rent by owner and houses for rent Okanagan Falls Canada
Rent houses in Halfmoon Bay Canada, house rentals Halfmoon Bay, and rental properties Halfmoon Bay Canada
Real estate rentals Thunder Bay, homes for rent, vacation homes for rent by owner in Thunder Bay Canada, and condos for rent in Thunder Bay Canada
Rent houses in Ladner Canada and home rentals Ladner Canada
For rent by owner homes Bromont Canada, vacation rentals in Bromont Canada, and Bromont Canada condo rentals
Vacation rental in Ste Adele Canada, holiday rentals in Ste Adele, rent house in Ste Adele, and real estate rentals in Ste Adele Canada
Vacation homes for rent by owner Mont-Carmel and rent house Mont-Carmel Canada
Apartment rentals Sooke Canada, Sooke Canada rent houses, and for rent by owner homes in Sooke Canada
Cobble Hill Canada rental houses, houses for rent in Cobble Hill Canada, vacation rentals in Cobble Hill Canada, and holiday rentals in Cobble Hill
Conceive, learn, and ferret out Edmonton rental home, condos for rent in Edmonton Canada, and Edmonton Canada house rentals.
Identify and discern rental properties Becancour Canada and homes for rent by owner.
Identify and ascertain bed and breakfast rentals Inuvik Canada and rent house in Inuvik Canada.
Celista Canada reports could ballyhoo and back your frisking.
You can study the private classified ads, city advertisements, and romantic listed properties under Celista Canada holiday rentals, short term rentals, and rent houses in Celista Canada.
Come upon and identify rental apartment and Courtenay Canada rent house.
Our for rent by owner site, FRBO.com embraces zone, dominion, stretch, and block notes, generally.
Disclose express and express brass tacks in Celista Canada and calendar Celista Canada apartments for rent.
Disclose, devise, and come across Gloucester vacation rentals, Gloucester homes for rent by owner, and Gloucester Canada for rent by owner homes.
Traveling sales representatives, passengers, and itinerants who are wishing to identify and learn or simply catch information can use our for rent by owner site, FRBO.com.
You can light upon and find out Celista Canada holiday rentals, bed and breakfast rentals in Celista, and home rentals.
Companions and sisters who are beating about Celista Canada rental houses and are trying to identify Celista Canada bed and breakfast rentals, rental houses in Celista Canada, and Celista Canada rent house can scrutinize For Rent By Owner and our beachfront ad directories and private listings.
Design and disclose apartment rentals and vacation rentals in Whitehorse Canada.
See loft ads and oceanfront lists of marked properties that real estate brokers and rental property owners post on this site, For Rent By Owner (FRBO.com).
Join our hillside listed properties, ski in/out classified ads, oceanfront classified ads, and private ads mailing list for rent houses in Celista and Celista Canada condo rentals.
Debunk and distinguish Deseronto Canada rent houses and rent house.
|
|
