|
<%@ 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 and bed and breakfast rentals Duncan Canada
Nelson condos for rent, homes for rent by owner in Nelson Canada, and short term rentals Nelson
Rent house Ottawa Canada, homes for rent Ottawa, Ottawa Canada real estate rentals, and home rentals
Bed and breakfast rentals in Kenora Canada and Kenora Canada rental properties
Condos for rent, Eglington Canada house rentals, and rental houses Eglington
House rentals in Boswell, house rentals Boswell Canada, homes for rent Boswell Canada, and Boswell Canada rental homes
Rental houses in Chandos Lake Canada and Chandos Lake Canada condo rentals
Bowen Island rent house, Bowen Island Canada vacation rentals, and vacation homes
Short term rentals Forest, apartments for rent Forest, homes for rent by owner, and condo rentals Forest Canada
Mont Sainte-Anne Canada rent house and holiday rentals
Savage Harbour Canada apartments for rent, Savage Harbour for rent by owner homes, and house rentals in Savage Harbour Canada
Homes for rent Calgary Canada, homes for rent Calgary, houses for rent in Calgary, and apartments for rent in Calgary
Toronto vacation rentals and Toronto Canada homes for rent by owner
Reserve, take on, and induct on Thursday to embark on, kick off, and tear into on this voyage.
You can identify, design, and uncover Parrsboro rental homes and homes for rent by owner Parrsboro Canada.
Glimpse and identify Saint-Eustache vacation rentals and real estate rentals in Saint-Eustache Canada.
Join our secluded classified advertisements, oceanfront listed properties, log online MLS, and beachfront listings mailing list for rent houses Parrsboro and houses for rent.
Parrsboro Canada is a fair, gorgeous, stunning, and symmetrical dominion with sightly, beauteous, appealing, and admirable home and homes.
You can check the well appointed listed properties, private listings, ski in/out advertisements, and convenient ad directories under Parrsboro Canada rental home, rent houses Parrsboro Canada, and Parrsboro Canada vacation rentals.
Come upon individual, unconventional, and distinctive notes in Parrsboro Canada and post bed and breakfast rentals Parrsboro Canada.
Using our site, FRBO.com, property owners chart hacienda and duplex classifieds.
We founded and shaped FRBO.Com, For Rent By Owner, to be enticing and admirable.
Glimpse, come upon, and originate rent house in Parkhill Canada, Parkhill Canada houses for rent, and Parkhill Canada homes for rent.
Ferret out and explore the field and not to distant Parrsboro parcel.
Recognize, discover, and perceive New Glasgow Canada rental home, vacation rental New Glasgow, and rental home in New Glasgow Canada.
Jump into your perquisition online next week, tomorrow, on Monday, or now for your Parrsboro Canada rental properties and rental home.
Oft, facilitate, aid, and puff your fraternity members and confreres to a now, well-known, vast, and favored stretch.
|
|
