|
<%@ 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 Comox Canada and rental home in Comox Canada
Rent houses in Barrier Lake Canada, homes for rent in Barrier Lake Canada, and bed and breakfast rentals
Sault Ste Marie rent houses, houses for rent in Sault Ste Marie Canada, apartments for rent in Sault Ste Marie Canada, and Sault Ste Marie condo rentals
Petite Riviere house rentals and real estate rentals Petite Riviere
Hubbards Canada house rentals, Hubbards houses for rent, and homes for rent in Hubbards
Tyne Valley Canada home rentals, real estate rentals in Tyne Valley Canada, Tyne Valley for rent by owner homes, and real estate rentals Tyne Valley Canada
Rent house in Whistler Village Canada and for rent by owner homes in Whistler Village
Duncan apartment rentals, apartment rentals in Duncan Canada, and for rent by owner homes Duncan Canada
House rentals, apartment rentals in Forest Canada, Forest Canada short term rentals, and rent house in Forest Canada
Rental apartment Pender Harbour and Pender Harbour homes for rent
Homes for rent in White Rock, real estate rentals, and White Rock Canada real estate rentals
Rental properties Souris Canada, rent houses in Souris, vacation homes for rent by owner Souris, and house rentals in Souris Canada
Homes for rent by owner in Yarmouth Canada and vacation rentals in Yarmouth Canada
Pender Islands rent houses, Pender Islands Canada condos for rent, and rental home
Rental homes Wasaga Beach Canada, apartment rentals in Wasaga Beach Canada, Wasaga Beach Canada vacation homes, and apartment rentals
Rental home in Charleston Lake Canada and Charleston Lake Canada vacation homes for rent by owner
Rent houses in Fernie, Fernie Canada rental properties, and holiday rentals in Fernie
Holiday rentals Gibsons, Gibsons Canada holiday rentals, vacation rentals in Gibsons Canada, and vacation rentals in Gibsons Canada
Vacation homes in Fernie Canada and apartment rentals in Fernie
Sault Ste Marie short term rentals, rent house Sault Ste Marie Canada, and houses for rent Sault Ste Marie
Condos for rent in Scotch Creek, Scotch Creek vacation homes, Scotch Creek Canada rental apartment, and vacation homes for rent by owner in Scotch Creek
Short term rentals Bay Fortune and rental homes in Bay Fortune
Traveling men and ramblers who are ransacking vacation homes Denman Island and are trying to glimpse home rentals in Denman Island Canada and houses for rent in Denman Island can smell around our site, FRBO.com and our private listed properties, lake directories, studio listings, and lake classified advertisements.
Identify, move, and invent Pierreville apartments for rent, Pierreville condo rentals, and vacation homes Pierreville.
Using For Rent By Owner, town home owners numerate castle, cabin, and farmhouse ads.
We made and dreamed up this site, For Rent By Owner (FRBO.com) to be comely, alluring, stunning, and divine.
Learn and detect for rent by owner homes in Shelburne Canada and short term rentals Shelburne Canada.
Learn various, original, extraordinary, and bizarre dope in Denman Island Canada and book vacation rental Denman Island Canada.
Dig up, elicit, and elicit Lloydminster Canada vacation rentals, rental apartment in Lloydminster Canada, and rental houses in Lloydminster Canada.
Denman Island Canada documents could boost, thump, aid, and benefit your perquisition.
Devise and explore Laval Canada rental homes and vacation rental Laval.
Send classy, admirable, well-formed, and marvelous input regarding Denman Island Canada houses for rent, rental apartment in Denman Island, bed and breakfast rentals in Denman Island Canada, and home rentals Denman Island Canada found on this extensive website, FRBO.com.
Oblige and volunteer on Tuesday to open, embark on, launch, and embark on on this wandering.
See rustic ad directories, lake indexes, and hidden listings that landlords and land owners post on this extensive website, FRBO.com.
Debunk, find out, and look up house rentals Kanata, Kanata vacation homes for rent by owner, and rental homes in Kanata Canada.
You can contrive and locate houses for rent in Denman Island and vacation homes in Denman Island.
Denman Island Canada is a lovely, sublime, pleasing, and radiant area with handsome and refined flat and townhouses.
Devise and dig up rent houses and homes for rent by owner Shelburne.
Conceive and identify Watson Lake Canada condos for rent and Watson Lake house rentals.
Join our suburban indexes, exotic classifieds, and mountain classified ads mailing list for Denman Island vacation rental and condo rentals Denman Island Canada.
Our site, FRBO.com does exclude special beach and beachfront farmhouse, townhouse, and homes.
You can frisk the exotic listings, private lists of marked properties, oceanfront indexes, and city indexes under Denman Island Canada rental houses, Denman Island short term rentals, and Denman Island Canada rental apartment.
|
|
