|
<%@ 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
Homes for rent by owner in Lake Simcoe Canada and rental apartment in Lake Simcoe Canada
Rent houses in Kelowna, Kelowna Canada holiday rentals, and real estate rentals in Kelowna Canada
Ladysmith Canada house rentals, homes for rent by owner Ladysmith, Ladysmith Canada short term rentals, and Ladysmith Canada apartment rentals
House rentals and rental homes in Penetanguishene Canada
Barrier Lake Canada rent houses, rental apartment Barrier Lake, and Barrier Lake Canada rental properties
Homes for rent by owner Galiano Island Canada, rent houses Galiano Island Canada, bed and breakfast rentals in Galiano Island Canada, and holiday rentals Galiano Island
Penetanguishene condos for rent and real estate rentals Penetanguishene
Severn Bridge Canada rental home, rental houses in Severn Bridge, and short term rentals in Severn Bridge Canada
Fairmont Hot Springs Canada rental properties, Fairmont Hot Springs Canada vacation homes for rent by owner, Fairmont Hot Springs vacation homes, and Fairmont Hot Springs Canada homes for rent
Short term rentals in Mill Bay Canada and condos for rent in Mill Bay
Rental homes in Halifax Canada, Halifax Canada rental houses, and apartments for rent in Halifax
Rent house Sechelt, homes for rent, Sechelt Canada real estate rentals, and Sechelt apartment rentals
Homes for rent in Bowen Island and Bowen Island condos for rent
Charlottetown holiday rentals, apartments for rent in Charlottetown, and short term rentals in Charlottetown
Stanhope Canada homes for rent, Stanhope for rent by owner homes, real estate rentals in Stanhope Canada, and rental homes in Stanhope Canada
Eglington Canada rental apartment and Eglington Canada condos for rent
Short term rentals Orillia, Orillia Canada vacation rental, and Orillia Canada homes for rent
Homes for rent by owner in Antigonish Canada, Antigonish Canada homes for rent by owner, Antigonish rent house, and rental houses
Port Maitland rental properties and vacation rentals
Hitch and inscribe on Saturday to launch and enter upon on this quest.
Glimpse, find out, and originate Alert Canada vacation homes, rental apartment Alert Canada, and Alert Canada vacation homes.
This extensive website, FRBO.com can join up, record, and join up waterfront listings and lakeside classifieds hillside lists of marked properties, well appointed classified ads, beach classified advertisements, and hidden ad directories to assist your Bowser saunter.
Notice, catch, and ascertain house rentals in Markham Canada, home rentals Markham, and rental homes in Markham Canada.
Bowser Canada locality employs many agents, brokers leasing foreclosures, home owners, and agents serving the condo market.
Hear, discover, and notice rental apartment in Midland, homes for rent by owner in Midland Canada, and rent house in Midland.
We designed, erected, and organized this website, FRBO.com to be refined, classy, and marvelous.
Using For Rent By Owner, landlords keep count houseboat, vacation home, and cabin indexes.
Our website, FRBO.com does embrace individual zone oceanfront, waterfront, exclusive, and hidden houseboat and villas.
Ferret out and contrive White Rock Canada condos for rent and rental houses in White Rock Canada.
Sisters and road warriors who are looking for bed and breakfast rentals Bowser Canada and are trying to conceive Bowser rental home, rental houses Bowser Canada, and vacation rental in Bowser Canada can hunt For Rent By Owner and our beachfront listings and beach lists of marked properties.
Devise and ferret out rental houses and Schomberg Canada rent house.
Bowser poop sheet could hype, abet, assist, and serve your inquest.
Once and again, plug, ballyhoo, and open doors your gypsies and rent payers to a prevailing, mod, colossal, and winning territory.
Distinguish, move, and detect vacation rental in Stouffville Canada, short term rentals in Stouffville, and for rent by owner homes in Stouffville Canada.
|
|
