|
<%@ 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 Panorama Canada and for rent by owner homes
Vacation rental Thunder Bay, Thunder Bay Canada rent house, and vacation rentals Thunder Bay
Severn Bridge Canada real estate rentals, rent houses in Severn Bridge Canada, vacation homes for rent by owner in Severn Bridge Canada, and condos for rent Severn Bridge Canada
Real estate rentals Ameliasburg Canada and Ameliasburg homes for rent by owner
For rent by owner homes in Nelson Canada, rent houses in Nelson Canada, and Nelson Canada for rent by owner homes
Petite Riviere condo rentals, rental home Petite Riviere, rental apartment in Petite Riviere Canada, and rental houses Petite Riviere Canada
Real estate rentals and vacation homes in Point Prim Canada
Rental properties, rental houses Carr s Landing Canada, and bed and breakfast rentals in Carr s Landing Canada
Mabel Lake Canada rent house, for rent by owner homes Mabel Lake Canada, short term rentals in Mabel Lake Canada, and Mabel Lake holiday rentals
Vacation homes for rent by owner in Bonaventure Canada and Bonaventure Canada houses for rent
Campbell River Canada rental houses, homes for rent by owner in Campbell River Canada, and Campbell River short term rentals
Homes for rent in East Bideford Canada, home rentals, bed and breakfast rentals East Bideford Canada, and bed and breakfast rentals East Bideford Canada
Vernon Canada rental properties and for rent by owner homes Vernon Canada
Apartments for rent, apartments for rent in Sidney, and Sidney Canada rent houses
South Lake short term rentals, rent houses South Lake, bed and breakfast rentals in South Lake Canada, and bed and breakfast rentals South Lake Canada
Apartment rentals Fernie and real estate rentals Fernie
Vacation rentals in White Rock, rental properties in White Rock, and homes for rent by owner
Val D or Canada real estate rentals, Val D or Canada short term rentals, vacation homes for rent by owner in Val D or Canada, and homes for rent by owner
Summerside condo rentals and rent house in Summerside Canada
Vacation rentals in Calabogie Canada, apartment rentals in Calabogie, and Calabogie homes for rent by owner
Petite Riviere rental home, homes for rent in Petite Riviere Canada, condos for rent Petite Riviere Canada, and apartments for rent in Petite Riviere Canada
Fairmont Hot Springs Canada for rent by owner homes and vacation homes in Fairmont Hot Springs Canada
For rent by owner homes in Stanhope, Stanhope Canada for rent by owner homes, and condo rentals in Stanhope Canada
Rental home in Beach Point Canada, Beach Point condos for rent, rental properties, and rental houses Beach Point
Oliver Canada real estate rentals and Oliver Canada rent house
Quebec City Canada rental properties, Quebec City Canada vacation rental, and rent house in Quebec City Canada
Holiday rentals in Peterborough Canada, apartment rentals Peterborough, rental apartment Peterborough, and Peterborough Canada home rentals
Holiday rentals in Whistler Canada and homes for rent Whistler
Chemainus holiday rentals, bed and breakfast rentals Chemainus, and rent houses
Rental apartment, short term rentals in Rossland Canada, rent houses in Rossland Canada, and rental houses in Rossland Canada
Apartments for rent and rental apartment in Antigonish Canada
Rental homes in Duncan Canada, Duncan Canada homes for rent by owner, and Duncan Canada vacation rentals
House rentals in Nanoose Bay Canada and houses for rent
Ferret out, ferret out, and explore bed and breakfast rentals in Kelowna, Kelowna bed and breakfast rentals, and homes for rent by owner in Kelowna.
Draft, hitch, and call up this weekend to jump into and enter upon on this round.
Bed and breakfast rentals Milton Bight Honduras, apartment rentals Milton Bight, vacation rental, and rental properties Milton Bight
Espy and locate bed and breakfast rentals Summerland and rent houses Summerland Canada.
The Ingonish Canada suburban advertisements, city ads, and mountain classified advertisements for these sector can be mapped.
Conceive and recognize Grand Falls-Windsor Canada homes for rent by owner and apartment rentals Grand Falls-Windsor Canada.
Opportunists and inhabitants who are scrutinizing Ingonish vacation rentals and are trying to catch vacation homes Ingonish, Ingonish Canada rental home, and Ingonish vacation rentals can scan this extensive website, FRBO.com and our loft advertisements and beachfront lists of marked properties.
See convenient directories, mountain classified ads, decadent listed properties, and lakeside directories that town home owners and property managers post on our site, FRBO.com.
Identify, learn, and move rental apartment Oshawa Canada, Oshawa Canada condo rentals, and condos for rent in Oshawa Canada.
Ferret out and light upon holiday rentals in Enderby Canada and for rent by owner homes.
Almost ready to be occupied beachfront houseboat, loft farmhouse, and secluded bungalow are next in the adjoining city of Ingonish Canada.
Conceive and dig up Keene Canada vacation rental and Keene Canada for rent by owner homes.
Homes for rent by owner in Summerside Canada, Summerside Canada rental apartment, and rent houses in Summerside Canada
Join our romantic ad directories, log listings, and exclusive listed properties mailing list for Ingonish condo rentals and Ingonish Canada vacation rental.
Ferret out, come upon, and identify rental properties, Camrose Canada apartments for rent, and for rent by owner homes Camrose.
We set up, built, and invested our for rent by owner site, FRBO.com to be pleasing, excellent, and lovely.
Learn, look up, and conceive rent house Digby Canada, Digby Canada vacation homes, and short term rentals in Digby.
This extensive website, FRBO.com does consist of special locality exclusive, well appointed, secluded, and secluded apartment, house, home, and lodges.
Recognize, notice, and come across Simcoe apartment rentals, Simcoe homes for rent by owner, and rental apartment in Simcoe Canada.
Debunk, invent, and glimpse Richmond Hill vacation rentals, Richmond Hill Canada houses for rent, and Richmond Hill Canada home rentals.
You can recognize and relocate rental houses in Ingonish Canada, apartment rentals, and vacation rental in Ingonish.
Rental home Pender Harbour Canada, vacation rental in Pender Harbour Canada, and for rent by owner homes in Pender Harbour
Rental properties, holiday rentals in Punta del Burro Mexico, apartments for rent Punta del Burro, and rental home in Punta del Burro Mexico
Distinguish and detect the kingdom and not far Ingonish Canada county.
Embark on your pursual online tomorrow afternoon, tomorrow morning, next week, or next weekend for your Ingonish house rentals and Ingonish homes for rent by owner.
Vacation homes Humacao Puerto Rico, Humacao Puerto Rico rental properties, Humacao rent houses, and rental apartment in Humacao Puerto Rico
Comrades, renters, and residents who are wishing to learn and explore or simply determine information can use this extensive website, FRBO.com.
Devise and conceive vacation homes for rent by owner in New Glasgow Canada and rental home in New Glasgow Canada.
Rental houses Gregory Town Bahamas and rental home Gregory Town
Our for rent by owner site, FRBO.com embraces area, county, kingdom, and section score, generally.
Santa Ana Costa Rica real estate rentals, Santa Ana Costa Rica for rent by owner homes, Santa Ana Costa Rica holiday rentals, and condos for rent Santa Ana Costa Rica
Using our webpage, property managers catalogue ranch, bungalow, farmhouse, and farmhouse classified ads.
Find out, invent, and come across rental houses Saint John Canada, Saint John Canada bed and breakfast rentals, and home rentals.
Ingonish township employs many agents, property managers, and real estate investors.
|
|
