|
<%@ 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
Rent house Fernie and vacation rental in Fernie Canada
Houses for rent, home rentals, and Parksville rental apartment
Vacation homes for rent by owner in Johnstown Canada, rent houses in Johnstown Canada, bed and breakfast rentals in Johnstown Canada, and vacation homes for rent by owner in Johnstown Canada
Mont Tremblant Canada rental apartment and Mont Tremblant vacation homes
Coquitlam homes for rent by owner, Coquitlam Canada condos for rent, and rent house in Coquitlam Canada
Rental homes Peterborough Canada, Peterborough rental home, holiday rentals in Peterborough, and Peterborough bed and breakfast rentals
Niagara Falls home rentals and condo rentals in Niagara Falls Canada
Vacation rentals West Bay Canada, vacation rental in West Bay, and vacation rental
Apartments for rent, rental apartment in Port Stanton Canada, bed and breakfast rentals Port Stanton, and Port Stanton Canada for rent by owner homes
Real estate rentals in Tyne Valley Canada and Tyne Valley vacation homes
Rental homes in Beach Point, vacation rental, and rental home Beach Point
Homes for rent by owner in Stanhope, apartment rentals in Stanhope Canada, real estate rentals in Stanhope Canada, and apartment rentals Stanhope Canada
Vacation homes in Creekside Canada and vacation rentals in Creekside
House rentals, homes for rent in Anglemont, and Anglemont homes for rent
Maple Ridge Canada rent house, Maple Ridge bed and breakfast rentals, house rentals Maple Ridge Canada, and apartment rentals Maple Ridge
Rental houses Balm Beach and Balm Beach Canada homes for rent
Rent house in Blooming Point, Blooming Point Canada condos for rent, and apartments for rent Blooming Point
Oliver Canada vacation homes for rent by owner, vacation rental in Oliver, Oliver for rent by owner homes, and Oliver home rentals
Alert Bay Canada house rentals and vacation rental in Alert Bay Canada
Join our lakeside lists of marked properties, exotic ad directories, studio advertisements, and well appointed classified ads mailing list for Nanaimo Canada short term rentals and rental apartment Nanaimo.
Nanaimo Canada dope could collaborate, root for, facilitate, and further your pursuit.
Dig up, design, and notice vacation homes for rent by owner Dorchester, Dorchester Canada condo rentals, and homes for rent by owner in Dorchester Canada.
Nanaimo Canada is a pretty, delightful, and comely sector with classy and graceful townhouse and farmhouses.
Disclose and discern rental homes in Saanichton and bed and breakfast rentals.
Look up, elicit, and ferret out rental houses Valleyfield, houses for rent, and rental apartment.
Discern and determine Kitimat Canada condo rentals and Kitimat Canada rental home.
Uncover small number and unusual reports in Nanaimo and particularize house rentals in Nanaimo Canada.
Nanaimo town home owners and third party listing companies list vacation homes in Nanaimo, holiday rentals Nanaimo, and rent houses in Nanaimo.
You can explore the loft indexes, romantic classifieds, and lakeside ads under for rent by owner homes in Nanaimo Canada and rental home Nanaimo.
Get and record now to enter upon, launch, launch, and get going on this survey.
Inaugurate your investigation online on Monday, on Monday, on Thursday, or tomorrow morning for your rental homes in Nanaimo Canada, vacation homes in Nanaimo, and for rent by owner homes.
Find out, disclose, and uncover rent houses Standard, vacation homes for rent by owner, and rental homes.
We concocted and instituted FRBO.Com, For Rent By Owner, to be dazzling, marvelous, and stunning.
Learn and discern Uxbridge real estate rentals and Uxbridge apartment rentals.
|
|
