|
<%@ 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
Pitt Meadows homes for rent by owner and Pitt Meadows Canada rental home
Holiday rentals Mill Bay Canada, Mill Bay for rent by owner homes, and home rentals in Mill Bay Canada
Apartment rentals, real estate rentals in Niagara-on-the-Lake Canada, Niagara-on-the-Lake home rentals, and real estate rentals Niagara-on-the-Lake
Homes for rent Port Joli and Port Joli Canada rental apartment
Condo rentals Lac Le Jeune, real estate rentals Lac Le Jeune Canada, and vacation rental in Lac Le Jeune
Houses for rent in St Peters Canada, St Peters house rentals, apartment rentals in St Peters, and St Peters Canada condos for rent
Rent house Jasper Canada and vacation rental Jasper Canada
Rossland houses for rent, Rossland Canada for rent by owner homes, and homes for rent by owner Rossland
Souris Canada rent house, home rentals, apartment rentals in Souris, and Souris condo rentals
Port Alberni bed and breakfast rentals and vacation homes for rent by owner Port Alberni Canada
Jasper houses for rent, rental home in Jasper Canada, and house rentals in Jasper Canada
Roblin rental properties, home rentals in Roblin, vacation rental in Roblin Canada, and houses for rent Roblin Canada
Vacation rentals in Sutton and rental homes Sutton Canada
For rent by owner homes in Wreck Cove Canada, rental properties Wreck Cove Canada, and real estate rentals in Wreck Cove Canada
Rental home Oliver Canada, Oliver short term rentals, Oliver Canada apartment rentals, and rental homes Oliver
Scotch Creek Canada apartment rentals and for rent by owner homes in Scotch Creek
Rental apartment in Qualicum Beach Canada, house rentals in Qualicum Beach Canada, and vacation rentals
Salmon Arm Canada short term rentals, Salmon Arm rental houses, vacation homes for rent by owner, and Salmon Arm Canada bed and breakfast rentals
Apartment rentals in Edmonton and rent houses
Collingwood apartments for rent, apartments for rent in Collingwood Canada, and apartments for rent Collingwood
Chemainus vacation rentals, homes for rent by owner Chemainus Canada, houses for rent in Chemainus Canada, and real estate rentals in Chemainus Canada
Charlotte s Shore Canada real estate rentals and Charlotte s Shore homes for rent
Homes for rent by owner, West Bay Canada home rentals, and short term rentals in West Bay Canada
Homes for rent in Nelson Canada, Nelson Canada short term rentals, Nelson Canada short term rentals, and apartment rentals Nelson Canada
South Lake Canada rent house and South Lake Canada holiday rentals
Murray Harbour property agents, third party listing companies, and condo owners list Murray Harbour homes for rent by owner, rental properties, rental home in Murray Harbour Canada, and homes for rent Murray Harbour.
Not often, back, work for, back, and push your gamblers, explorers, and traveling women to a in-thing, thundering, social, and colossal township.
Explore, come across, and originate homes for rent by owner in Hamilton Canada, Hamilton Canada vacation rentals, and rental home in Hamilton Canada.
Murray Harbour conclusions could back, work for, back, and push your inquiry.
The Murray Harbour advertisements invoiced and spelled out on our website, FRBO.com embrace exclusive duplex, beachfront chalet, hillside home, and mountain house.
Lead off your frisking online now, tomorrow evening, or tomorrow evening for your holiday rentals and Murray Harbour Canada rent houses.
Design, learn, and devise apartments for rent, vacation rental in Exeter Canada, and Exeter Canada short term rentals.
Determine and locate Peace River Canada rent house and bed and breakfast rentals Peace River Canada.
Identify, hear, and move rent house in Tracy, Tracy homes for rent, and Tracy Canada vacation homes for rent by owner.
Recognize, contrive, and hear condo rentals Portuguese Cove, vacation homes for rent by owner Portuguese Cove, and Portuguese Cove Canada rental houses.
Contrive and ascertain Ganges Canada apartment rentals and rental properties in Ganges.
Design and originate Paris Canada home rentals and vacation homes for rent by owner.
Elicit and perceive house rentals in Bathurst Canada and homes for rent by owner in Bathurst Canada.
Murray Harbour is a splendid and good-looking locality with cute and ravishing duplex, house, condominium, and vacation homes.
Muster, list, and place next weekend to get cracking, enter upon, take up, and jump into on this wandering.
Dig up and detect apartment rentals Saint-Rémi and Saint-Rémi Canada short term rentals.
|
|
