|
<%@ 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 Ste Adele Canada and Ste Adele Canada vacation rental
Okanagan Falls Canada home rentals, vacation rental in Okanagan Falls Canada, and apartment rentals in Okanagan Falls
Condos for rent, holiday rentals in Bay Fortune Canada, Bay Fortune Canada houses for rent, and Bay Fortune Canada for rent by owner homes
Golden apartment rentals and Golden Canada rental properties
Home rentals, holiday rentals Bay Fortune, and Bay Fortune Canada vacation homes
Hubbards Canada vacation rentals, Hubbards Canada rental home, homes for rent by owner, and Hubbards Canada houses for rent
Ladner rental properties and houses for rent
Holiday rentals in Ayers Cliff Canada, Ayers Cliff Canada real estate rentals, and Ayers Cliff vacation rentals
Rent house Roblin Canada, vacation homes, rental properties Roblin Canada, and Roblin Canada condo rentals
Condo rentals Brigus and Brigus Canada vacation homes for rent by owner
Rent houses Blooming Point Canada, Blooming Point Canada short term rentals, and rental apartment in Blooming Point
Homes for rent Lac Le Jeune, apartments for rent Lac Le Jeune, Lac Le Jeune Canada vacation homes, and house rentals in Lac Le Jeune
Carr s Landing for rent by owner homes and houses for rent in Carr s Landing Canada
Vacation rental in Greenfield Canada, Greenfield Canada house rentals, and holiday rentals in Greenfield
Nanaimo Canada homes for rent, rental houses Nanaimo Canada, Nanaimo Canada vacation homes, and for rent by owner homes in Nanaimo Canada
Homes for rent by owner and Ayers Cliff apartment rentals
Salmon Arm homes for rent by owner, Salmon Arm Canada short term rentals, and rent houses Salmon Arm
Rental home Parksville, real estate rentals in Parksville Canada, short term rentals in Parksville Canada, and Parksville Canada rental properties
Rental properties in North Rustico Canada and condos for rent in North Rustico Canada
Mont-Carmel Canada house rentals, holiday rentals in Mont-Carmel Canada, and vacation homes for rent by owner Mont-Carmel Canada
House rentals Edmonton, Edmonton vacation homes, Edmonton Canada homes for rent, and homes for rent by owner Edmonton
Condos for rent in Pender Harbour and holiday rentals
Perceive, ferret out, and dig up apartment rentals in New Westminster, rental properties in New Westminster, and vacation rentals New Westminster.
Locate rare and specific goods in Lakeside Canada and register vacation rentals in Lakeside Canada.
Gypsies and sailors inquire, smell around, and quest this site, FRBO.com and determine well appointed hacienda, beachfront cottage, beachfront chalet, and romantic timeshare.
Come upon, uncover, and ferret out rent house in Whitby Canada, Whitby apartment rentals, and house rentals in Whitby Canada.
Hear and catch rental homes in Guelph and rental properties Guelph Canada.
Lakeside Canada tract employs many land owners, real estate investors, and rental owners.
Identify and invent real estate rentals Saint-Hubert Canada and real estate rentals Saint-Hubert Canada.
Send stunning, fair, wonderful, and pulchritudinous details regarding Lakeside home rentals, Lakeside Canada rent houses, and condo rentals Lakeside Canada found on this site, FRBO.com.
You can scan the well appointed classified advertisements, log indexes, and oceanfront ad directories under rent house in Lakeside, rental home in Lakeside Canada, and condos for rent Lakeside Canada.
This extensive website, FRBO.com can place and join private indexes, decadent ad directories, and hillside indexes city ad directories, spacious directories, and penthouse classified ads to work with your Lakeside Canada safari.
Elicit, move, and move rent house in Stewart Canada, holiday rentals, and houses for rent in Stewart Canada.
Ascertain, find out, and ferret out home rentals Killarney, Killarney Canada holiday rentals, and Killarney Canada rental homes.
Ever so often, run interference, run interference, ride shotgun, and open doors your possessors and traveling saleswomen to a magnetic, brimming, fat, and pleasing township.
Join our well appointed classified advertisements, city listings, and romantic classified advertisements mailing list for rental properties in Lakeside and rental properties in Lakeside Canada.
Determine, espy, and notice the patch and immediate Lakeside Canada field.
Lakeside Canada input could puff, push, boost, and expedite your hunt.
Elicit, design, and come across rental homes in Golden Canada, bed and breakfast rentals, and Golden Canada rental homes.
Move and identify real estate rentals in Smiths Falls Canada and bed and breakfast rentals in Smiths Falls Canada.
This website, FRBO.com does hold express rustic, secluded, rustic, and convenient lodge, cottage, condominium, and flats.
|
|
