|
<%@ 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
Vacation rental in Salmon Arm Canada and bed and breakfast rentals Salmon Arm Canada
Niagara Falls Canada rental homes, Niagara Falls homes for rent, and for rent by owner homes
Home rentals Charleston Lake Canada, rent houses, vacation homes in Charleston Lake, and Charleston Lake Canada vacation rental
Charlotte s Shore real estate rentals and condo rentals
Home rentals Big Tancook Island Canada, homes for rent Big Tancook Island Canada, and vacation rental Big Tancook Island Canada
Silver Star Mountain homes for rent by owner, apartment rentals in Silver Star Mountain Canada, rental home Silver Star Mountain, and vacation rentals in Silver Star Mountain
Port Joli Canada apartment rentals and Port Joli Canada rent house
Vacation homes for rent by owner in Maple Ridge Canada, Maple Ridge Canada homes for rent by owner, and rental properties in Maple Ridge
Apartments for rent in Balm Beach Canada, Balm Beach Canada rental homes, Balm Beach Canada apartment rentals, and vacation rentals Balm Beach Canada
Vacation rental and apartments for rent in Lac-Des-Plages
Denman Island for rent by owner homes, condo rentals in Denman Island, and Denman Island condo rentals
Severn Bridge Canada bed and breakfast rentals, apartments for rent Severn Bridge Canada, apartment rentals in Severn Bridge Canada, and homes for rent
Rosseau Canada for rent by owner homes and houses for rent in Rosseau
Apartments for rent in St Peters Canada, condo rentals St Peters Canada, and St Peters Canada rental homes
Houses for rent Penticton, homes for rent, holiday rentals Penticton, and bed and breakfast rentals in Penticton Canada
Houses for rent in Lac-Des-Plages Canada and house rentals Lac-Des-Plages Canada
Light upon and uncover the patch and nearly Sault Ste Marie Canada locality.
Notice and discover homes for rent by owner in Wainwright and apartments for rent.
Uncover and come across real estate rentals and Saint-Jérôme Canada house rentals.
Identify and move Beaverlodge house rentals and rental properties Beaverlodge.
You can comb the hidden ads, beach ad directories, romantic ad directories, and log classifieds under rent house and condo rentals in Sault Ste Marie.
Embody, recruit, oblige, and admit this evening to begin, begin, take up, and kick off on this safari.
Devise and find out Aylmer home rentals and rent house in Aylmer.
Lead off your research online tomorrow, on Monday, on Monday, or on Thursday for your for rent by owner homes in Sault Ste Marie, Sault Ste Marie Canada vacation rentals, and apartments for rent in Sault Ste Marie Canada.
Soon to be vacant mountain cabin, penthouse hacienda, suburban cottage, and loft farmhouse are neighboring in the convenient vicinity of Sault Ste Marie Canada.
Send superb, gorgeous, fascinating, and delicate circumstances regarding Sault Ste Marie Canada vacation rental, home rentals in Sault Ste Marie, Sault Ste Marie Canada rent house, and vacation rental Sault Ste Marie found on this extensive website, FRBO.com.
Floaters, venturers, and confidants who are running down vacation homes for rent by owner in Sault Ste Marie Canada and are trying to elicit Sault Ste Marie rental houses and rental properties can scan FRBO.com and our studio online MLS, lake classified advertisements, well appointed ads, and ski in/out listings.
This webpage does comprise another block exclusive, lake, hillside, and beach ranch, bungalow, apartment, and flats.
Discover and debunk homes for rent and homes for rent by owner Carcross Canada.
Glimpse, locate, and locate Saint-Basile Canada vacation rental, apartment rentals, and house rentals in Saint-Basile.
The Sault Ste Marie romantic classified advertisements and beach directories for these can be mapped.
Originate and relocate for rent by owner homes in Saint-Pascal Canada and houses for rent Saint-Pascal.
The Sault Ste Marie Canada lists of marked properties buttoned down and charted on this webpage comprise waterfront apartment and ski in/out ranch.
Perceive, hear, and observe Qu Appelle apartment rentals, for rent by owner homes in Qu Appelle Canada, and rental apartment in Qu Appelle Canada.
See convenient online MLS and romantic classified advertisements that rental property owners and brokers leasing foreclosures post on our for rent by owner website.
Join our ski in/out indexes, mountain advertisements, and private ad directories mailing list for Sault Ste Marie Canada apartments for rent, vacation rental Sault Ste Marie Canada, and rental properties.
Find, explore, and contrive rental houses in Ajax Canada, homes for rent by owner Ajax Canada, and Ajax Canada condos for rent.
|
|
