|
<%@ 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
Apartment rentals in Nelson Canada and apartments for rent
Penetanguishene Canada rent houses, Penetanguishene Canada rental properties, and Penetanguishene houses for rent
Rental homes Port Maitland, Port Maitland Canada vacation homes for rent by owner, Port Maitland Canada house rentals, and vacation rentals in Port Maitland Canada
Lac-Superior houses for rent and rental homes in Lac-Superior Canada
Short term rentals Roblin, homes for rent by owner Roblin Canada, and Roblin Canada rent house
Lac Le Jeune Canada for rent by owner homes, Lac Le Jeune Canada houses for rent, vacation homes for rent by owner in Lac Le Jeune, and home rentals in Lac Le Jeune
Homes for rent by owner Ayers Cliff and rental homes in Ayers Cliff Canada
West Bay Canada rent house, homes for rent by owner in West Bay Canada, and bed and breakfast rentals in West Bay Canada
Montague rental properties, rental home Montague, Montague Canada homes for rent by owner, and rental apartment in Montague Canada
Homes for rent by owner Port Carling Canada and rental apartment in Port Carling
Rent house, Cobble Hill Canada apartment rentals, and Cobble Hill Canada real estate rentals
Vacation rentals in Alert Bay, Alert Bay Canada home rentals, holiday rentals in Alert Bay Canada, and vacation rentals in Alert Bay Canada
Bed and breakfast rentals Big Tancook Island Canada and rental properties in Big Tancook Island Canada
Real estate rentals in Gravenhurst Canada, Gravenhurst homes for rent, and bed and breakfast rentals in Gravenhurst
Homes for rent by owner in Big Tancook Island Canada, Big Tancook Island Canada vacation homes, house rentals in Big Tancook Island, and Big Tancook Island rental home
Rent house in Golden Canada and Golden Canada real estate rentals
Apartments for rent in Canoe Cove, house rentals Canoe Cove Canada, and Canoe Cove rental properties
Vacation rentals Cortes Island Canada, Cortes Island holiday rentals, rental properties in Cortes Island Canada, and Cortes Island Canada rental apartment
Discover, dig up, and move vacation rentals, rent houses Nanticoke Canada, and rental houses.
You can inspect the hidden classifieds, mountain lists of marked properties, city listings, and waterfront online MLS under holiday rentals, Cortes Island Canada house rentals, and homes for rent by owner in Cortes Island Canada.
Catch, devise, and catch Peterborough Canada short term rentals, Peterborough Canada holiday rentals, and Peterborough bed and breakfast rentals.
Locate and hear rent house in Beaverlodge and Beaverlodge short term rentals.
Detect and detect for rent by owner homes and Moncton Canada condos for rent.
Perceive and light upon Newmarket Canada apartments for rent and houses for rent.
Relocate and ascertain short term rentals in Corner Brook and short term rentals in Corner Brook.
Begin your going-over online on Wednesday, tomorrow morning, or on Thursday for your rental apartment, apartments for rent, and Cortes Island Canada rental apartment.
Our page consist ofs plot, locality, vicinity, and state scoop, successively.
Procure, mobilize, appoint, and inscribe tomorrow morning to begin, enter upon, and lead off on this course.
Cortes Island is a enticing and exquisite city with beauteous and delightful flat, duplex, and cabins.
We authored, procreated, and dreamed up our for rent by owner website to be charming, handsome, delicate, and charming.
Move, uncover, and contrive rental properties Lower Sackville Canada, vacation rental in Lower Sackville, and homes for rent in Lower Sackville.
Using our online website, FRBO.com, property owners index chalet and townhouse classified ads.
Notice and detect Portuguese Cove Canada real estate rentals and condos for rent in Portuguese Cove.
Relocate, espy, and determine apartment rentals Williams Lake, rental properties Williams Lake Canada, and vacation rental in Williams Lake.
Explore, conceive, and come across rental properties in Burk s Falls, homes for rent in Burk s Falls, and Burk s Falls Canada apartment rentals.
|
|
