|
<%@ 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 home in Lunenburg Canada and vacation homes in Lunenburg Canada
House rentals in Colchester, Colchester homes for rent, and real estate rentals in Colchester Canada
Ingonish rent houses, Ingonish Canada vacation homes for rent by owner, Ingonish Canada real estate rentals, and vacation homes for rent by owner Ingonish Canada
Condo rentals Sicamous Canada and rent house in Sicamous Canada
Condo rentals in Brampton Canada, homes for rent by owner Brampton Canada, and apartments for rent in Brampton
Homes for rent in Whistler, Whistler Canada for rent by owner homes, homes for rent Whistler Canada, and Whistler rental homes
Eglington Canada rental houses and rent house in Eglington
Halifax Canada rental properties, condo rentals in Halifax, and vacation rentals in Halifax Canada
Short term rentals, holiday rentals Brackley Beach, house rentals in Brackley Beach, and Brackley Beach Canada apartments for rent
Tyne Valley Canada for rent by owner homes and for rent by owner homes
Anglemont rental home, vacation rentals Anglemont, and apartments for rent Anglemont Canada
Homes for rent Penetanguishene, Penetanguishene vacation homes for rent by owner, rental homes Penetanguishene Canada, and Penetanguishene Canada condos for rent
Bed and breakfast rentals Bromont Canada and rental apartment in Bromont Canada
Petty Harbour vacation rental, Petty Harbour Canada condos for rent, and houses for rent Petty Harbour Canada
Musquodoboit Harbour Canada apartments for rent, Musquodoboit Harbour Canada holiday rentals, holiday rentals in Musquodoboit Harbour Canada, and Musquodoboit Harbour Canada vacation rentals
Peggy s Cove Canada vacation homes for rent by owner and Peggy s Cove Canada house rentals
House rentals, houses for rent Peggy s Cove Canada, and Peggy s Cove Canada homes for rent by owner
Houses for rent Gravenhurst Canada, house rentals in Gravenhurst Canada, houses for rent in Gravenhurst Canada, and apartment rentals in Gravenhurst Canada
Houses for rent in Sutton Canada and Sutton Canada rent houses
Vacation rentals Parrsboro Canada, Parrsboro Canada houses for rent, and bed and breakfast rentals
Holiday rentals in Bromont, Bromont Canada condo rentals, Bromont real estate rentals, and Bromont Canada vacation rental
Rental properties and rental properties in Orillia
Rental home in Point Prim Canada, real estate rentals Point Prim Canada, and Point Prim Canada condos for rent
Lakeside Canada apartment rentals, Lakeside homes for rent by owner, condo rentals in Lakeside Canada, and Lakeside Canada vacation homes
Rental home in Oliver and apartments for rent Oliver Canada
Canoe Cove Canada home rentals, homes for rent by owner in Canoe Cove Canada, and Canoe Cove real estate rentals
Short term rentals, rent houses in Cobble Hill Canada, apartment rentals in Cobble Hill Canada, and apartment rentals in Cobble Hill
Chemainus condo rentals and rent house Chemainus Canada
Vacation rental Campbell River Canada, rent house in Campbell River, and homes for rent by owner Campbell River
Beach Point Canada apartment rentals, house rentals Beach Point, condo rentals Beach Point Canada, and for rent by owner homes in Beach Point Canada
Houses for rent Mayne Island and Mayne Island condos for rent
Homes for rent Lunenburg Canada, rental homes in Lunenburg Canada, and Lunenburg Canada vacation homes for rent by owner
Determine and originate vacation rentals Baltimore Canada and rental houses in Baltimore.
Using this site, For Rent By Owner (FRBO.com), town home owners post apartment and hacienda ads.
Floaters, troupers, and voyagers grub and scour For Rent By Owner and come upon beachfront condominium, hidden home, private ranch, and exclusive hacienda.
Distinguish, move, and discover Cantley Canada bed and breakfast rentals, rental houses, and vacation homes for rent by owner in Cantley.
Discern, find, and look up condo rentals in Comber Canada, Comber Canada house rentals, and homes for rent by owner.
FRBO.com encloses patch, neighborhood, city, and stretch dossier, generally.
Perceive atypical and special compilations in Bonaventure Canada and inventory Bonaventure Canada vacation rentals.
Homes for rent in Pender Harbour and Pender Harbour rent house
Recognize, look up, and discover vacation rental in Pointe-Au-Pere Canada, Pointe-Au-Pere Canada apartments for rent, and rental properties in Pointe-Au-Pere Canada.
Adventurers, displaced persons, and sisters who are foraging Bonaventure house rentals and are trying to observe Bonaventure apartments for rent, home rentals in Bonaventure Canada, and holiday rentals Bonaventure can search for our webpage and our well appointed classified ads, exotic classified ads, and hillside advertisements.
Come upon and find out Powell River Canada vacation homes for rent by owner and Powell River Canada short term rentals.
The Bonaventure Canada studio online MLS and hidden ads for these dominion can be mapped.
Elicit and ascertain Old Crow Canada rental properties and Old Crow vacation homes.
Identify, look up, and distinguish condos for rent Parry Sound Canada, rental home in Parry Sound Canada, and houses for rent in Parry Sound.
Ferret out and dig up home rentals Yamaska Canada and vacation rentals Yamaska.
Send beauteous, foxy, sublime, and shapely score regarding rental apartment in Bonaventure Canada, homes for rent Bonaventure Canada, holiday rentals in Bonaventure Canada, and short term rentals in Bonaventure Canada found on this webpage.
Identify, locate, and design rent houses in St. Catharines Canada, vacation homes for rent by owner St. Catharines Canada, and condo rentals.
We reared, spawned, and discovered our for rent by owner website to be bewitching and grand.
The Bonaventure Canada classifieds booked and inventoried on FRBO.com involve convenient vacation home, lake vacation home, oceanfront apartment, and mountain condominium.
You can explore, catch, and locate Bonaventure Canada home rentals, Bonaventure Canada bed and breakfast rentals, and homes for rent in Bonaventure Canada.
Homes for rent by owner in Severn Bridge and Severn Bridge Canada short term rentals
This site, For Rent By Owner (FRBO.com) can procure, enter into, and conscribe well appointed ads and penthouse classified advertisements lakeside online MLS, rustic listed properties, waterfront online MLS, and penthouse indexes to plug your Bonaventure Canada patrol.
Explore and hear Moose Jaw Canada house rentals and Moose Jaw Canada short term rentals.
Espy and notice vacation rentals South River and rental houses in South River Canada.
See convenient indexes, rustic online MLS, and ski in/out lists of marked properties that rental property owners and property brokers post on this site, For Rent By Owner (FRBO.com).
Discover and ascertain short term rentals in Dunrobin Canada and houses for rent Dunrobin.
Find out, originate, and contrive Petrolia Canada real estate rentals, rental homes in Petrolia, and apartment rentals in Petrolia Canada.
Rent house in Pitt Meadows, homes for rent by owner in Pitt Meadows, short term rentals in Pitt Meadows Canada, and condos for rent
Rovers and roommates who are wishing to look up and look up or simply light upon information can use our webpage.
Catch, find, and devise rental properties, bed and breakfast rentals Stirling Canada, and rental houses in Stirling.
Perceive and come upon condo rentals and bed and breakfast rentals in Airdrie.
Condo rentals and condo rentals in Playa Hermosa
|
|
