|
<%@ 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
Jasper Canada rental home and vacation rental
Homes for rent by owner in Chandos Lake Canada, for rent by owner homes, and houses for rent in Chandos Lake Canada
Mabel Lake homes for rent by owner, apartment rentals in Mabel Lake Canada, Mabel Lake bed and breakfast rentals, and vacation rental
Invermere Canada rent house and vacation rental Invermere Canada
Condos for rent, vacation homes Anglemont Canada, and Anglemont bed and breakfast rentals
Home rentals in Pictou Island, bed and breakfast rentals Pictou Island Canada, homes for rent Pictou Island Canada, and homes for rent by owner in Pictou Island
Apartment rentals in Sutton Canada and Sutton bed and breakfast rentals
Vacation homes in Mont Sainte-Anne, Mont Sainte-Anne rental apartment, and rental apartment in Mont Sainte-Anne Canada
Houses for rent, real estate rentals in Ottawa Canada, Ottawa Canada rent house, and Ottawa Canada house rentals
Houses for rent Naramata Canada and vacation homes for rent by owner Naramata
Toronto rental houses, rental properties in Toronto Canada, and for rent by owner homes Toronto Canada
Houses for rent in Barrier Lake Canada, rental properties in Barrier Lake Canada, rent house in Barrier Lake, and Barrier Lake Canada rental homes
Rental apartment in Golden Canada and Golden Canada house rentals
Invermere Canada real estate rentals, Invermere Canada holiday rentals, and Invermere Canada vacation homes for rent by owner
Gabriola Island Canada vacation homes for rent by owner, Gabriola Island Canada condos for rent, vacation homes for rent by owner in Gabriola Island Canada, and Gabriola Island Canada holiday rentals
Rent houses Souris Canada and Souris Canada home rentals
Campbell River real estate rentals, houses for rent Campbell River Canada, and bed and breakfast rentals
Mont Sainte-Anne Canada apartment rentals, rental properties, rent house in Mont Sainte-Anne Canada, and Mont Sainte-Anne Canada rent house
Homes for rent by owner in Nanaimo Canada and apartment rentals Nanaimo Canada
Mayne Island Canada home rentals, Mayne Island homes for rent, and home rentals in Mayne Island
Apartment rentals, condo rentals in Edmonton Canada, Edmonton Canada rent house, and apartment rentals Edmonton Canada
Ste Adele rental houses and vacation homes for rent by owner Ste Adele
Collingwood Canada vacation rental, Collingwood condo rentals, and Collingwood Canada rent houses
Halfmoon Bay condo rentals, condo rentals, rental houses Halfmoon Bay, and rent houses
Vacation rental and vacation homes in Yarmouth Canada
Holiday rentals in Peggy s Cove, house rentals in Peggy s Cove Canada, and vacation homes in Peggy s Cove Canada
Kelowna home rentals, Kelowna Canada holiday rentals, vacation rentals in Kelowna, and houses for rent in Kelowna Canada
Rental properties and vacation rentals in Sechelt Canada
Apartment rentals, St Peters vacation homes, and rent houses in St Peters Canada
Homes for rent by owner, homes for rent in Darnley, homes for rent in Darnley Canada, and for rent by owner homes in Darnley Canada
Rent house Coquitlam and apartment rentals in Coquitlam Canada
Rent house in Naramata Canada, vacation rentals Naramata, and Naramata Canada rental apartment
Rental properties and Toronto vacation homes for rent by owner
Rent houses Apex Mountain Canada, rental houses Apex Mountain, and vacation homes in Apex Mountain Canada
Houses for rent, homes for rent, Olveston Montserrat house rentals, and homes for rent in Olveston Montserrat
Learn and ascertain Surrey Canada apartment rentals and house rentals Surrey.
Paraiso Costa Rica home rentals, Paraiso real estate rentals, and Paraiso Costa Rica real estate rentals
Observe and uncover condos for rent and home rentals in Brockville Canada.
Identify and observe real estate rentals and bed and breakfast rentals.
Dig up, catch, and move vacation rentals in Maple Ridge Canada, condo rentals Maple Ridge Canada, and rental houses in Maple Ridge Canada.
Discover, discover, and ferret out rental houses in Seven Sister Falls Canada, rental home Seven Sister Falls Canada, and for rent by owner homes in Seven Sister Falls Canada.
Tear into your inspection online next weekend, tomorrow evening, on Wednesday, or in the morning for your Roberts Creek Canada apartment rentals and condos for rent Roberts Creek Canada.
Infrequently, puff and bail out your brothers-in-law, sisters, and travelers to a societal, crowd-pleaser, and fashionable vicinity.
Devise and hear condo rentals Sauble Beach Canada and holiday rentals in Sauble Beach Canada.
Catch, disclose, and discover rental homes Parkhill Canada, apartments for rent in Parkhill, and rental home in Parkhill Canada.
Homes for rent in Puerto Real Puerto Rico, Puerto Real rental properties, Puerto Real Puerto Rico bed and breakfast rentals, and real estate rentals Puerto Real Puerto Rico
Vacation homes for rent by owner in Gran Roque and rental properties in Gran Roque Venezuela
Recognize and invent for rent by owner homes Lac-Mégantic Canada and for rent by owner homes Lac-Mégantic.
Find some, another story, and extraordinary materials in Roberts Creek Canada and classify Roberts Creek vacation rental.
Rental apartment in Las Tablas Panama and bed and breakfast rentals Las Tablas
Locate and identify rent houses in Fort Saskatchewan Canada and homes for rent Fort Saskatchewan.
This extensive website, FRBO.com seats dominion, tract, stretch, and area evidence, recurrently.
Join our log listings, exclusive classified advertisements, and exclusive ad directories mailing list for holiday rentals Roberts Creek and Roberts Creek Canada condo rentals.
Rental homes and Denman Island Canada homes for rent
Discover and locate house rentals in Crofton and real estate rentals in Crofton Canada.
Rental properties West Bay Cayman Islands, West Bay Cayman Islands homes for rent by owner, and house rentals West Bay
You can debunk, originate, and determine Roberts Creek short term rentals and apartment rentals in Roberts Creek.
Identify and disclose Snag homes for rent and bed and breakfast rentals in Snag Canada.
Conscribe, embody, secure, and take on this evening to enter upon, take up, and open on this voyage.
Truro Canada rent houses, for rent by owner homes Truro Canada, rental properties Truro Canada, and condo rentals Truro
Invent, explore, and hear rental apartment, holiday rentals in Saint Jean sur Richelieu, and Saint Jean sur Richelieu rental homes.
See exotic lists of marked properties, lakefront ad directories, beachfront indexes, and city lists of marked properties that third party listing companies and condo owners post on our site, FRBO.com.
Lodgers, citizens, and boarders who are wishing to move, look up, and identify or simply catch information can use our for rent by owner website.
Homes for rent by owner and Richmond Canada real estate rentals
|
|
