|
<%@ 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
Houses for rent in Eglington and vacation rental in Eglington Canada
Rental home Buckhorn, rental houses Buckhorn Canada, and Buckhorn Canada house rentals
Greenfield Canada vacation rental, homes for rent by owner in Greenfield Canada, home rentals, and Greenfield Canada home rentals
Houses for rent in Radium Hot Springs Canada and home rentals in Radium Hot Springs Canada
Apartment rentals, Chemainus apartments for rent, and rental properties
Holiday rentals in West Vancouver Canada, West Vancouver apartments for rent, rental homes, and West Vancouver rental properties
Short term rentals in Bowen Island Canada and vacation rental
For rent by owner homes in Saint Catharines, apartment rentals Saint Catharines Canada, and Saint Catharines Canada vacation rentals
Sidney Canada rental home, rental properties in Sidney Canada, rent houses, and Sidney Canada real estate rentals
Gibsons vacation homes and homes for rent by owner in Gibsons Canada
Rent house Point Prim, short term rentals in Point Prim Canada, and Point Prim holiday rentals
Vacation homes Beach Point, houses for rent Beach Point Canada, Beach Point Canada bed and breakfast rentals, and Beach Point for rent by owner homes
Kimberley Canada rent house and bed and breakfast rentals Kimberley
Homes for rent by owner in Cavendish, Cavendish condos for rent, and Cavendish Canada for rent by owner homes
Houses for rent in Mabel Lake, vacation rentals in Mabel Lake Canada, vacation homes for rent by owner in Mabel Lake Canada, and rental apartment in Mabel Lake
Kenora Canada houses for rent and rental properties in Kenora
Denman Island Canada condos for rent, Denman Island Canada condos for rent, and rental properties Denman Island Canada
Vacation homes Osoyoos Canada, rental apartment in Osoyoos Canada, rental properties in Osoyoos, and vacation homes for rent by owner Osoyoos
Homes for rent by owner and holiday rentals Cortes Island
Holiday rentals in Thunder Bay Canada, holiday rentals Thunder Bay, and vacation rentals
Vacation homes in Red Mountain Canada, homes for rent Red Mountain, Red Mountain Canada apartments for rent, and Red Mountain Canada rental apartment
Port Carling Canada condo rentals and houses for rent Port Carling Canada
Home rentals in White Dummer Lake Canada, rent houses White Dummer Lake Canada, and homes for rent by owner
Vacation homes in Charlottetown, Charlottetown Canada for rent by owner homes, rental houses in Charlottetown Canada, and real estate rentals in Charlottetown
Rental homes in St Martins and rental homes St Martins Canada
Penetanguishene house rentals, Penetanguishene rental houses, and bed and breakfast rentals
Lac-Des-Plages Canada condo rentals, apartment rentals Lac-Des-Plages, holiday rentals Lac-Des-Plages Canada, and house rentals Lac-Des-Plages
Picton house rentals and houses for rent in Picton
Rental apartment Savage Harbour, Savage Harbour Canada homes for rent, and holiday rentals in Savage Harbour
Houses for rent in Diamond Canada, Diamond Canada rental home, Diamond Canada vacation rentals, and for rent by owner homes Diamond Canada
Niagara-on-the-Lake Canada apartments for rent and Niagara-on-the-Lake Canada vacation rentals
Homes for rent, apartments for rent in Cobble Hill Canada, and rental properties
Ameliasburg Canada for rent by owner homes and house rentals in Ameliasburg
Vacation rental Port Alberni, holiday rentals in Port Alberni Canada, and rental home Port Alberni Canada
Uncover and learn Saint-Lambert rental properties and Saint-Lambert Canada houses for rent.
Locate, light upon, and look up Acton Vale Canada homes for rent by owner, Acton Vale Canada rental houses, and rent house.
Find out, elicit, and come upon vacation rental in Terrace, rental apartment in Terrace Canada, and vacation homes in Terrace Canada.
This webpage does eliminate peculiar dominion exotic, resort, beachfront, and city lodge, apartment, apartment, and duplexs.
Glimpse and disclose Abbotsford rental home and Abbotsford Canada house rentals.
Notice, glimpse, and come across rental properties Shawnigan Lake Canada, Shawnigan Lake Canada vacation homes for rent by owner, and vacation homes Shawnigan Lake Canada.
Conceive and find out Comber Canada rental properties and short term rentals Comber Canada.
San Francisco-San Pancho rental properties and San Francisco-San Pancho Mexico real estate rentals
Discern, dig up, and explore real estate rentals Lennoxville Canada, Lennoxville Canada real estate rentals, and Lennoxville Canada holiday rentals.
Morelia Mexico rent house and homes for rent in Morelia Mexico
Invermere brokers leasing foreclosures, third party listing companies, real estate brokers, and third party listing companies list rental apartment in Invermere Canada, vacation rental in Invermere, Invermere apartment rentals, and Invermere Canada for rent by owner homes.
Oftentimes, aid, bail out, and help your hikers, confreres, and road warriors to a packed and jumbo county.
You can search for the beachfront lists of marked properties, suburban advertisements, and oceanfront online MLS under Invermere Canada homes for rent, for rent by owner homes in Invermere, and Invermere Canada short term rentals.
Rent house in Courland Trinidad and Tobago, vacation homes, and rental homes Courland
Home rentals in Fortuna US Virgin Islands, houses for rent in Fortuna, rental homes in Fortuna US Virgin Islands, and homes for rent by owner
Locate and recognize holiday rentals in Yorkton Canada and rental properties Yorkton.
Determine, originate, and design real estate rentals in Calgary Canada, for rent by owner homes in Calgary Canada, and rental houses Calgary.
Rental apartment in Los Chivos, Los Chivos rental homes, Los Chivos Puerto Rico rental homes, and Los Chivos Puerto Rico home rentals
Our for rent by owner website omits territory and stretch poop sheet, successively.
Determine and explore Golden Canada house rentals and house rentals Golden.
Ferret out, detect, and come across Lancaster rental homes, rental houses Lancaster Canada, and vacation rental in Lancaster Canada.
Cohorts, soldiers, and travelers quest, rake, and search for this website, FRBO.com and light upon private villa, beachfront home, and secluded villa.
Determine and originate Cowansville Canada apartment rentals and real estate rentals Cowansville Canada.
You can learn, originate, and elicit Invermere Canada vacation homes for rent by owner, short term rentals, and homes for rent by owner Invermere.
Espy and ascertain La Baie Canada bed and breakfast rentals and vacation homes La Baie Canada.
Join our mountain indexes and oceanfront ads mailing list for Invermere Canada condos for rent and apartment rentals in Invermere Canada.
Rental properties Little Bay Jamaica, bed and breakfast rentals in Little Bay, Little Bay Jamaica holiday rentals, and home rentals in Little Bay
Look up, distinguish, and come across Saanichton Canada rental home, for rent by owner homes in Saanichton Canada, and rent houses Saanichton.
Interest, procure, register, and sign on in the morning to lead off, begin, kick off, and kick off on this transit.
|
|
