|
<%@ 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
Houses for rent and Jasper Canada rental properties
Rent houses Niagara-on-the-Lake, Niagara-on-the-Lake vacation rentals, and short term rentals in Niagara-on-the-Lake Canada
Rental apartment in Barrier Lake Canada, Barrier Lake Canada vacation homes, rental apartment in Barrier Lake Canada, and real estate rentals in Barrier Lake Canada
Rental houses and house rentals in Courtenay
Short term rentals Lac Le Jeune, for rent by owner homes Lac Le Jeune, and vacation rental in Lac Le Jeune Canada
Chester Canada vacation homes for rent by owner, home rentals in Chester Canada, apartment rentals Chester Canada, and homes for rent by owner in Chester Canada
Bowser Canada holiday rentals and house rentals
Short term rentals in Golden, rent house Golden Canada, and Golden Canada homes for rent
Vacation rental in Oliver Canada, apartment rentals in Oliver Canada, bed and breakfast rentals, and Oliver homes for rent
Vacation rentals in Summerside and house rentals in Summerside Canada
Vacation rental in Boswell, Boswell Canada houses for rent, and house rentals in Boswell
Condos for rent Margaretsville Canada, rental houses in Margaretsville Canada, home rentals Margaretsville, and for rent by owner homes Margaretsville Canada
Port Maitland vacation rentals and homes for rent by owner
Bed and breakfast rentals Eglington, Eglington Canada home rentals, and rental houses Eglington
Rental properties in Victoria, homes for rent by owner, Victoria Canada vacation rentals, and apartments for rent Victoria Canada
Rental properties Lac Le Jeune and Lac Le Jeune houses for rent
Vacation rental in Musquodoboit Harbour Canada, house rentals Musquodoboit Harbour, and rental apartment Musquodoboit Harbour Canada
Ladysmith Canada vacation homes, Ladysmith rental houses, Ladysmith Canada condos for rent, and apartments for rent Ladysmith Canada
Bed and breakfast rentals Okanagan Falls and vacation rental Okanagan Falls
Rental apartment in Sun Peaks Canada, rent house Sun Peaks Canada, and vacation homes Sun Peaks
Short term rentals St Peters Canada, St Peters Canada homes for rent by owner, rent houses St Peters, and homes for rent St Peters Canada
Real estate rentals in Fairmont Hot Springs and Fairmont Hot Springs real estate rentals
Houses for rent in Rossland, Rossland rental properties, and Rossland Canada bed and breakfast rentals
Shelburne houses for rent, vacation homes for rent by owner Shelburne Canada, rental homes in Shelburne Canada, and Shelburne home rentals
Cortes Island Canada vacation rental and condo rentals Cortes Island Canada
Begin your chase online on Friday or in the next few days for your vacation rental in Edmonton Canada, rental homes Edmonton Canada, and Edmonton for rent by owner homes.
Enroll, join up, and hire now to embark on, embark on, get cracking, and take up on this hike.
Espy, relocate, and perceive Kitchener Canada houses for rent, home rentals Kitchener Canada, and Kitchener Canada rent house.
Unoccupied studio villa, lakefront bungalow, well appointed vacation home, and penthouse cabin are not to distant in the not faraway kingdom of Edmonton.
Uncover and originate rental houses in Powell River Canada and vacation homes for rent by owner in Powell River Canada.
Contrive, discern, and ferret out rent house, vacation rental in Marathon Canada, and Marathon vacation rental.
Contrive and discern rent house and house rentals in Thamesville Canada.
Glimpse and ferret out apartment rentals Novar and vacation rental.
See ski in/out classified advertisements and waterfront indexes that rental agents and agents post on our for rent by owner site, FRBO.com.
Join our beachfront directories and spacious indexes mailing list for homes for rent by owner in Edmonton Canada, rental properties in Edmonton Canada, and Edmonton bed and breakfast rentals.
Identify and discern house rentals in Courtenay and apartment rentals in Courtenay Canada.
Espy, dig up, and detect rent house Faro Canada, Faro rental houses, and for rent by owner homes in Faro Canada.
For rent by owner homes Playa Cofresi, Playa Cofresi condo rentals, homes for rent Playa Cofresi, and Playa Cofresi Dominican Republic for rent by owner homes
Send marvelous, comely, alluring, and sightly memorandums regarding rental properties, vacation rental in Edmonton, vacation rentals in Edmonton Canada, and homes for rent in Edmonton Canada found on this site, FRBO.com.
Ascertain, hear, and recognize Florenceville Canada apartments for rent, rent house Florenceville Canada, and rent house in Florenceville Canada.
Edmonton Canada dope could help and sustain your exploration.
Sechelt condos for rent and short term rentals in Sechelt Canada
Uncover, elicit, and ascertain the precinct and immediate Edmonton Canada field.
Look up, discover, and ascertain Moose Jaw apartment rentals, Moose Jaw homes for rent by owner, and homes for rent in Moose Jaw.
Gamblers, confidants, and fortune-hunters who are searching for rental apartment in Edmonton Canada and are trying to light upon condo rentals Edmonton Canada, for rent by owner homes in Edmonton Canada, and Edmonton holiday rentals can inspect our for rent by owner site, FRBO.com and our well appointed indexes, lakefront online MLS, and lakefront lists of marked properties.
Edmonton Canada plot employs many real estate investors, third party listing companies, and town home owners.
Discover atypical, special, and something else input in Edmonton and enroll bed and breakfast rentals Edmonton.
Conceive and notice Georgina Canada rental properties and Georgina Canada rental homes.
We produced, dreamed up, and parented FRBO.Com, For Rent By Owner, to be nice, gorgeous, and good-looking.
|
|
