|
<%@ 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
Muskoka Canada vacation homes and rental houses Muskoka Canada
Balm Beach rental properties, rent house Balm Beach, and Balm Beach Canada vacation rentals
Honey Harbour Canada condos for rent, condo rentals Honey Harbour Canada, house rentals in Honey Harbour, and short term rentals
Salt Spring Island Canada rental homes and rental houses Salt Spring Island
Rental houses, Thunder Bay Canada short term rentals, and Thunder Bay Canada homes for rent
Naramata Canada rental apartment, house rentals in Naramata Canada, Naramata home rentals, and apartments for rent Naramata
For rent by owner homes in Cortes Island and Cortes Island Canada rental home
Bracebridge Canada rental properties, homes for rent by owner Bracebridge Canada, and Bracebridge bed and breakfast rentals
Short term rentals Petite Riviere Canada, apartment rentals in Petite Riviere Canada, Petite Riviere Canada rent houses, and houses for rent
For rent by owner homes in North Lake Canada and houses for rent in North Lake Canada
Homes for rent by owner in Yarmouth Canada, home rentals in Yarmouth Canada, and Yarmouth Canada homes for rent by owner
House rentals in Lac Castor Canada, Lac Castor Canada real estate rentals, for rent by owner homes in Lac Castor Canada, and Lac Castor Canada for rent by owner homes
Celista Canada bed and breakfast rentals and holiday rentals in Celista Canada
Rent house in Mont Ste-Marie, Mont Ste-Marie home rentals, and rental apartment Mont Ste-Marie
You can rake the loft advertisements and beach advertisements under apartments for rent Quebec City and holiday rentals in Quebec City Canada.
Identify, ascertain, and come upon rental apartment, Wakefield apartment rentals, and Wakefield Canada rental properties.
Debunk ad hoc and special reports in Quebec City Canada and index Quebec City Canada rental apartment.
The Quebec City classifieds kept counted and polled on our online website, FRBO.com arrange city farmhouse, city houseboat, and penthouse home.
Send lovely, stunning, and magnificent scoop regarding house rentals Quebec City and rental homes Quebec City found on this site, FRBO.com.
Launch your inspection online tomorrow, tonight, or on Wednesday for your Quebec City Canada rental houses, rental houses, and Quebec City home rentals.
Perceive and glimpse house rentals in Coquitlam Canada and home rentals in Coquitlam Canada.
Traveling agents, commuters, and sorority sisters scour, rake, and investigate our page and come upon beachfront duplex and waterfront ranch.
Espy, observe, and elicit vacation rentals Sault Ste. Marie, apartment rentals Sault Ste. Marie Canada, and rental properties in Sault Ste. Marie Canada.
Catch, discover, and explore real estate rentals La Pocatiere Canada, La Pocatiere Canada vacation rentals, and La Pocatiere Canada for rent by owner homes.
Ferret out and come across the locality and convenient Quebec City zone.
Espy and move Inuvik Canada rental homes and home rentals Inuvik.
Honeymooners and renters who are searching homes for rent by owner Quebec City Canada and are trying to uncover Quebec City condos for rent and bed and breakfast rentals in Quebec City Canada can scour FRBO.com and our rustic directories and penthouse ads.
|
|
