|
<%@ 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
Ingonish Canada rental properties and Ingonish Canada rent house
Condo rentals Balm Beach Canada, house rentals in Balm Beach, and Balm Beach Canada vacation rental
Real estate rentals Boswell Canada, bed and breakfast rentals in Boswell, houses for rent, and Boswell homes for rent
Rental home Mont Ste-Marie and condo rentals in Mont Ste-Marie
Kenora Canada holiday rentals, condo rentals in Kenora, and holiday rentals
Thetis Island Canada rental houses, Thetis Island Canada rental properties, Thetis Island Canada bed and breakfast rentals, and Thetis Island Canada real estate rentals
Peggy s Cove Canada condo rentals and real estate rentals Peggy s Cove
North Vancouver Canada vacation rental, rental home in North Vancouver Canada, and rent house in North Vancouver
Homes for rent by owner Red Mountain Canada, house rentals Red Mountain, Red Mountain Canada rental home, and for rent by owner homes Red Mountain
Rental homes Souris Canada and home rentals Souris Canada
Rent house in Wakefield Canada, real estate rentals Wakefield Canada, and rental homes
Celista bed and breakfast rentals, for rent by owner homes Celista, Celista Canada vacation rental, and apartments for rent in Celista Canada
Apartment rentals in Okanagan Falls and Okanagan Falls rent house
Rental properties in Mont Sainte-Anne Canada, real estate rentals Mont Sainte-Anne Canada, and rental homes in Mont Sainte-Anne
Whitehorse Canada condo rentals, Whitehorse Canada house rentals, Whitehorse Canada home rentals, and condo rentals
Vacation rentals Kelowna Canada and vacation rental Kelowna Canada
Vacation rental Charlotte s Shore Canada, holiday rentals Charlotte s Shore Canada, and rental apartment Charlotte s Shore
Rent houses Boswell Canada, house rentals Boswell, vacation rental in Boswell Canada, and vacation homes in Boswell
Apartments for rent and rental properties Cape Sable Island
Holiday rentals Musquodoboit Harbour Canada, bed and breakfast rentals, and rental apartment in Musquodoboit Harbour
Sooke Canada apartment rentals, real estate rentals Sooke Canada, Sooke Canada rental properties, and Sooke vacation rentals
Real estate rentals Piedmont Canada and rental homes Piedmont Canada
Rental houses Augustine Cove Canada, homes for rent by owner Augustine Cove, and Augustine Cove condos for rent
Roblin Canada real estate rentals, vacation rentals in Roblin Canada, Roblin rental houses, and home rentals Roblin Canada
Petite Riviere Canada short term rentals and bed and breakfast rentals Petite Riviere Canada
Rent houses in Chemong Lake Canada, rental home in Chemong Lake, and Chemong Lake vacation homes
Roblin Canada holiday rentals, bed and breakfast rentals Roblin Canada, rent houses Roblin Canada, and vacation homes in Roblin Canada
Niagara Falls Canada homes for rent by owner and holiday rentals in Niagara Falls Canada
White Point Canada bed and breakfast rentals, homes for rent White Point Canada, and real estate rentals in White Point
Gabriola Island Canada houses for rent, vacation homes in Gabriola Island Canada, rent house Gabriola Island, and Gabriola Island rental home
Rental properties Lake Simcoe Canada and short term rentals
Rental properties, condos for rent in Victoria West, and condo rentals in Victoria West
For rent by owner homes in Hubbards Canada and apartments for rent in Hubbards Canada
See well appointed listings, lakeside ads, and beach ads that property brokers and real estate investors post on this webpage.
Observe and discover vacation homes for rent by owner Pilot Mound and Pilot Mound Canada home rentals.
Rent houses Troncones and Troncones Mexico holiday rentals
Light upon, devise, and identify rental properties Medicine Hat, apartment rentals in Medicine Hat Canada, and home rentals in Medicine Hat Canada.
Discover, debunk, and ascertain Rexdale rental home, Rexdale Canada rental apartment, and Rexdale Canada rental houses.
Perceive, uncover, and detect bed and breakfast rentals in Wolfville Canada, houses for rent in Wolfville Canada, and Wolfville Canada vacation rentals.
Explore and originate vacation homes Miramichi and apartment rentals Miramichi.
Jordan Ferry Canada is a foxy, resplendent, ideal, and enticing section with grand, admirable, and handsome bungalow and flats.
Disclose, come upon, and originate home rentals Orleans, apartments for rent Orleans Canada, and vacation homes for rent by owner in Orleans Canada.
Jordan Ferry dossier could collaborate, help, and work with your quest.
Look up and discern real estate rentals and Sussex Canada vacation rental.
Not often, thump and work with your fellow workers, occupants, and acquaintances to a well-liked and teasing precinct.
Glimpse, come across, and identify rental houses Parkhill Canada, Parkhill Canada vacation homes, and Parkhill for rent by owner homes.
Ferret out, detect, and contrive Espanola Canada condos for rent, Espanola Canada bed and breakfast rentals, and Espanola Canada rental properties.
Light upon and observe Amherst rental apartment and homes for rent in Amherst Canada.
Look up and originate rent house and vacation homes for rent by owner in Sarnia Canada.
You can relocate, relocate, and find out Jordan Ferry homes for rent by owner, homes for rent by owner in Jordan Ferry, and condo rentals Jordan Ferry Canada.
Find and detect Novar real estate rentals and rent house in Novar Canada.
Rental houses La Guardia Venezuela, La Guardia Venezuela rental homes, and houses for rent in La Guardia Venezuela
Originate and identify rental properties in Burlington Canada and rent house Burlington.
Home rentals in Grote Berg Curacao and Grote Berg condos for rent
You can look the beach lists of marked properties, city advertisements, beach online MLS, and city advertisements under Jordan Ferry Canada rental homes and condo rentals in Jordan Ferry Canada.
Unused penthouse apartment, lakefront cottage, and convenient villa are near-at-hand in the not to distant sector of Jordan Ferry.
|
|
