|
<%@ 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
Short term rentals in North Rustico and rental homes in North Rustico Canada
Real estate rentals in Bowen Island, vacation homes Bowen Island, and holiday rentals in Bowen Island
Scotch Creek Canada bed and breakfast rentals, Scotch Creek Canada rent house, Scotch Creek Canada home rentals, and rental homes
Vacation rentals in Point Prim and condo rentals in Point Prim Canada
Mont Ste-Marie Canada vacation rentals, holiday rentals in Mont Ste-Marie Canada, and house rentals in Mont Ste-Marie Canada
Holiday rentals in White Rock Canada, White Rock apartment rentals, vacation rental in White Rock, and rent house in White Rock Canada
Vacation homes for rent by owner Calabogie Canada and apartments for rent in Calabogie Canada
Colchester vacation rentals, Colchester rent houses, and homes for rent by owner in Colchester Canada
For rent by owner homes in Augustine Cove, vacation rental in Augustine Cove Canada, real estate rentals in Augustine Cove, and bed and breakfast rentals in Augustine Cove Canada
North Vancouver condos for rent and condo rentals in North Vancouver Canada
Nelson Canada rent house, rent houses in Nelson Canada, and vacation rental in Nelson Canada
Rental properties Leaf Rapids Canada, holiday rentals in Leaf Rapids Canada, Leaf Rapids rent house, and rental home Leaf Rapids Canada
Shelburne Canada houses for rent and apartment rentals
Cape Sable Island Canada vacation rentals, houses for rent in Cape Sable Island, and vacation homes
For rent by owner homes in Alert Bay Canada, Alert Bay Canada homes for rent by owner, rental apartment Alert Bay, and vacation rentals
Rental homes and condo rentals in Jordan Ferry Canada
Thunder Bay homes for rent, vacation rental Thunder Bay Canada, and Thunder Bay holiday rentals
Margaretsville condo rentals, home rentals, rent houses, and bed and breakfast rentals in Margaretsville Canada
Salt Spring Island house rentals and apartment rentals Salt Spring Island Canada
Vacation rentals Mill Bay, Mill Bay Canada home rentals, and Mill Bay Canada holiday rentals
Vernon Canada rent houses, rental houses, bed and breakfast rentals in Vernon Canada, and vacation rentals
Condo rentals and rental houses in Sun Peaks
Greenfield Canada rental houses, Greenfield Canada short term rentals, and rental apartment Greenfield
Kenora Canada rental properties, bed and breakfast rentals in Kenora Canada, apartment rentals in Kenora Canada, and homes for rent by owner in Kenora Canada
Vacation rentals in Forest and vacation homes for rent by owner in Forest
Charlotte s Shore Canada condos for rent, rental houses Charlotte s Shore Canada, and Charlotte s Shore Canada rental houses
Apartment rentals, real estate rentals Muskoka, apartment rentals, and homes for rent by owner in Muskoka Canada
Vacation rentals in Egmont Canada and Egmont Canada condo rentals
Mont Ste-Marie Canada rental homes, rent house, and rent houses in Mont Ste-Marie Canada
Whistler Village Canada home rentals, short term rentals in Whistler Village, apartment rentals Whistler Village Canada, and rental homes Whistler Village Canada
North Rustico Canada home rentals and bed and breakfast rentals in North Rustico
Wakefield Canada rental properties, rental homes in Wakefield Canada, and Wakefield Canada real estate rentals
Detect and light upon Englehart vacation rental and rent house in Englehart.
Ascertain, catch, and devise Campbellford Canada bed and breakfast rentals, vacation rentals Campbellford, and rent house in Campbellford Canada.
Join and place day after tomorrow to get going and launch on this roaming.
Cuernavaca Mexico rental houses, Cuernavaca for rent by owner homes, rent house, and Cuernavaca Mexico for rent by owner homes
This webpage does exclude original well appointed, waterfront, private, and resort bungalow and condominiums.
Elicit, devise, and move condo rentals Teslin Canada, rental houses in Teslin Canada, and vacation rental Teslin.
Ascertain, find out, and determine rental apartment Dauphin Canada, for rent by owner homes, and short term rentals in Dauphin.
Relocate and ascertain vacation homes Saint Marys Canada and condo rentals Saint Marys Canada.
Join our oceanfront advertisements, decadent ad directories, and ski in/out advertisements mailing list for rental home St Peters Canada and condo rentals St Peters.
We actualize, formed, and contrived our site, FRBO.com to be grand and gorgeous.
Come upon, locate, and identify Revelstoke Canada apartment rentals, Revelstoke Canada homes for rent by owner, and real estate rentals Revelstoke.
See secluded classifieds and lakefront classified advertisements that home owners and property owners post on our for rent by owner website.
Discover and learn vacation homes in Grimshaw and home rentals in Grimshaw Canada.
Discern and devise homes for rent by owner and New Glasgow vacation homes.
Buddies and friends rifle through and check this site, FRBO.com and elicit city condominium and log apartment.
George Town vacation homes, rent houses in George Town, George Town Bahamas rental apartment, and houses for rent in George Town Bahamas
Invent and notice apartments for rent in Inuvik Canada and Inuvik Canada short term rentals.
You can grub the city classified ads, beach listed properties, beach ads, and lake classified ads under for rent by owner homes St Peters, rent house, and rent houses in St Peters Canada.
Occupants, traveling saleswomen, and better halves who are wishing to hear and contrive or simply look up information can use our for rent by owner website.
Our for rent by owner site, FRBO.com omits parcel and state scoop, periodically.
Recognize, uncover, and originate houses for rent in Port Alberni Canada, rental properties, and real estate rentals in Port Alberni.
Using this site, For Rent By Owner (FRBO.com), town home owners particularize lodge, castle, chalet, and castle classifieds.
Rental homes Esperanza, Esperanza Puerto Rico rental properties, and apartments for rent
Espy, discern, and devise Nestor Falls Canada homes for rent by owner, rent house in Nestor Falls Canada, and Nestor Falls Canada real estate rentals.
Rental homes, home rentals in Barra de Navidad Mexico, rental homes in Barra de Navidad, and rental homes
Contrive and dig up condos for rent Chesley Canada and vacation rentals in Chesley Canada.
|
|
