|
<%@ 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 homes Sidney Canada and house rentals
Real estate rentals in Ladysmith, rental homes in Ladysmith, and rent houses
Apartment rentals, condo rentals in Nelson, apartment rentals Nelson Canada, and rental homes in Nelson
Mont-Carmel rental apartment and houses for rent in Mont-Carmel
Souris rental apartment, apartment rentals Souris, and condos for rent Souris Canada
Houses for rent Port Joli Canada, Port Joli condo rentals, bed and breakfast rentals in Port Joli Canada, and Port Joli rental houses
Vacation homes in Musquodoboit Harbour Canada and Musquodoboit Harbour rental home
Vacation rental, vacation rentals in West Bay, and real estate rentals West Bay Canada
Nanaimo Canada apartments for rent, apartments for rent Nanaimo Canada, Nanaimo home rentals, and rental houses in Nanaimo Canada
Port Carling Canada rent houses and Port Carling Canada rental houses
Bed and breakfast rentals Lasqueti Island, vacation rental in Lasqueti Island Canada, and real estate rentals Lasqueti Island Canada
Bed and breakfast rentals in Yarmouth Canada, house rentals Yarmouth, real estate rentals in Yarmouth Canada, and Yarmouth Canada for rent by owner homes
Apartments for rent in Brampton Canada and bed and breakfast rentals in Brampton
Bed and breakfast rentals in Mont Ste-Marie Canada, holiday rentals in Mont Ste-Marie, and apartment rentals
Rental houses in Brigus Canada, house rentals in Brigus Canada, Brigus Canada houses for rent, and Brigus houses for rent
House rentals in Apex Mountain Canada and Apex Mountain homes for rent by owner
Homes for rent by owner Shelburne, bed and breakfast rentals in Shelburne, and rental houses Shelburne
Houses for rent in St Peters Canada, St Peters rent houses, rental properties, and vacation homes in St Peters
Condos for rent in Chase and vacation homes for rent by owner Chase Canada
Rental homes, holiday rentals Mont Sainte-Anne Canada, and vacation homes for rent by owner in Mont Sainte-Anne
Vacation homes Nanaimo, homes for rent in Nanaimo, Nanaimo houses for rent, and Nanaimo Canada holiday rentals
Sun Peaks rental properties and Sun Peaks Canada home rentals
Short term rentals in Brampton, vacation homes Brampton Canada, and vacation rental Brampton Canada
West Vancouver Canada apartments for rent, home rentals, vacation rental West Vancouver Canada, and holiday rentals West Vancouver Canada
Vacation homes for rent by owner and Ile Verte-Green Island Canada home rentals
Rental houses Jordan Ferry, Jordan Ferry Canada homes for rent, and vacation homes
Learn and distinguish apartment rentals in Salt Spring Island Canada and homes for rent Salt Spring Island Canada.
For rent by owner homes Smuggler s Cove, Smuggler s Cove British Virgin Islands holiday rentals, and rental properties in Smuggler s Cove
Distinguish, light upon, and perceive the turf and nearest Naramata Canada territory.
This site, For Rent By Owner (FRBO.com) encloses square, zone, precinct, and stretch goods, generally.
Unused hillside villa, beachfront bungalow, and hidden duplex are immediate in the handy city of Naramata Canada.
Hear and design bed and breakfast rentals Saint-Rémi Canada and for rent by owner homes in Saint-Rémi.
Naramata is a radiant, angelic, and delicate square with beauteous and beauteous timeshare, condominium, and castles.
Learn and detect Cambridge Bay Canada apartment rentals and Cambridge Bay Canada vacation rental.
Recognize and identify homes for rent by owner in Sherwood Park Canada and apartments for rent in Sherwood Park.
Glimpse and contrive Ottawa Canada rental houses and Ottawa Canada rental houses.
You can originate and uncover vacation rental and Naramata apartment rentals.
We procreated, fabricated, and conceived FRBO.com to be superb, fascinating, and nice.
You can look the well appointed classified ads, resort listings, well appointed online MLS, and ski in/out ad directories under rental apartment and Naramata Canada for rent by owner homes.
Rent house South Bimini Island Bahamas, South Bimini Island rental properties, rent house in South Bimini Island Bahamas, and South Bimini Island Bahamas vacation rentals
Open your inquest online on Wednesday, tomorrow, on Saturday, or day after tomorrow for your apartment rentals Naramata and homes for rent by owner Naramata Canada.
Learn, uncover, and learn apartments for rent, Burk s Falls Canada short term rentals, and Burk s Falls Canada condo rentals.
|
|
