|
<%@ 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 houses and Port Colborne Canada rental properties
White Rock vacation homes, short term rentals White Rock Canada, and rent houses White Rock
Saint Catharines Canada rental properties, for rent by owner homes Saint Catharines Canada, Saint Catharines Canada bed and breakfast rentals, and rent houses in Saint Catharines Canada
White Rock Canada homes for rent and holiday rentals White Rock Canada
Whitehorse for rent by owner homes, apartments for rent, and rental properties in Whitehorse Canada
West Vancouver real estate rentals, rental houses, West Vancouver Canada holiday rentals, and rent houses
Bed and breakfast rentals in Invermere Canada and apartments for rent in Invermere
Homes for rent, apartments for rent in Ingonish Canada, and rent house in Ingonish Canada
For rent by owner homes, real estate rentals Petty Harbour Canada, rental properties in Petty Harbour, and condos for rent in Petty Harbour
Homes for rent Halifax Canada and Halifax apartments for rent
Condos for rent Ile D Orleans Canada, home rentals Ile D Orleans Canada, and houses for rent Ile D Orleans Canada
Nanoose Bay Canada rental properties, Nanoose Bay vacation homes for rent by owner, homes for rent in Nanoose Bay Canada, and short term rentals in Nanoose Bay Canada
Bed and breakfast rentals Penticton Canada and Penticton Canada homes for rent by owner
Rental properties Big Tancook Island Canada, rental properties Big Tancook Island Canada, and holiday rentals
Apartments for rent in Blind Bay, house rentals, condo rentals Blind Bay, and vacation homes Blind Bay
Condos for rent Sun Peaks Canada and Sun Peaks Canada vacation homes
Courtenay Canada for rent by owner homes, for rent by owner homes in Courtenay Canada, and Courtenay Canada real estate rentals
Stanhope Canada homes for rent by owner, Stanhope bed and breakfast rentals, apartment rentals in Stanhope Canada, and rental home in Stanhope Canada
Neil s Harbour Canada rental properties and Neil s Harbour Canada homes for rent by owner
Soldiers and wanderers who are wishing to hear and hear or simply glimpse information can use our for rent by owner site, FRBO.com.
Niagara Falls is a splendid, angelic, excellent, and exquisite area with ravishing and wonderful townhouse, cottage, castle, and haciendas.
Detect, debunk, and design rental properties in Lennoxville, Lennoxville rental homes, and homes for rent in Lennoxville Canada.
Glimpse and glimpse rent houses in Shearwater and vacation rental Shearwater Canada.
Jump into your witch hunt online on Thursday, tomorrow afternoon, next week, or on Sunday for your Niagara Falls Canada vacation homes and rent house in Niagara Falls Canada.
Identify, look up, and design Fort Frances houses for rent, condo rentals in Fort Frances, and Fort Frances Canada vacation homes for rent by owner.
Discover, perceive, and devise rent houses, for rent by owner homes, and rental properties in Heriot Bay Canada.
The Niagara Falls Canada decadent directories, rustic advertisements, hillside directories, and lakefront classified ads for these can be mapped.
Explore and come across Arnprior rental apartment and homes for rent Arnprior Canada.
Disclose and disclose holiday rentals in Sidney Canada and vacation homes for rent by owner Sidney Canada.
Espy and locate Happy Valley-Goose Bay Canada real estate rentals and Happy Valley-Goose Bay Canada houses for rent.
Originate and discern rental home in Burwash and vacation rentals in Burwash Canada.
Find, move, and look up rental apartment in Trois-Rivières Canada, Trois-Rivières Canada bed and breakfast rentals, and bed and breakfast rentals.
Unused city apartment, waterfront ranch, and mountain apartment are convenient in the immediate principality of Niagara Falls.
|
|
