|
<%@ 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
Tyne Valley Canada vacation homes and vacation rentals
Real estate rentals in Truro Canada, Truro apartments for rent, and for rent by owner homes Truro Canada
Houses for rent Colchester, Colchester Canada rental home, Colchester Canada real estate rentals, and Colchester Canada home rentals
Mayne Island bed and breakfast rentals and house rentals Mayne Island Canada
Rent houses, home rentals Collingwood Canada, and Collingwood Canada homes for rent by owner
Stanhope Canada apartments for rent, rental apartment Stanhope Canada, rental homes Stanhope Canada, and holiday rentals
Port Joli Canada vacation homes and rental apartment Port Joli
Homes for rent Bay St Lawrence Canada, vacation rental in Bay St Lawrence Canada, and Bay St Lawrence Canada homes for rent by owner
Antigonish Canada vacation homes, vacation rental, houses for rent Antigonish Canada, and vacation rental in Antigonish Canada
Qualicum Beach Canada condo rentals and Qualicum Beach Canada vacation homes for rent by owner
Piedmont Canada homes for rent, vacation rentals in Piedmont Canada, and rent house in Piedmont Canada
Rent house in Apex Mountain Canada, homes for rent by owner in Apex Mountain Canada, Apex Mountain Canada rental properties, and Apex Mountain Canada rental houses
Port Joli Canada real estate rentals and Port Joli Canada apartments for rent
Vacation homes in Okanagan Centre Canada, vacation rental in Okanagan Centre, and Okanagan Centre Canada rental homes
Rent houses in Ottawa Canada, Ottawa condo rentals, vacation rentals in Ottawa Canada, and rental apartment in Ottawa Canada
Musquodoboit Harbour Canada house rentals and Musquodoboit Harbour Canada homes for rent by owner
Condos for rent Roberts Creek Canada, bed and breakfast rentals, and short term rentals in Roberts Creek
Homes for rent Salmon Arm, rent houses in Salmon Arm, apartment rentals in Salmon Arm, and Salmon Arm Canada bed and breakfast rentals
Apartment rentals Ile D Orleans Canada and Ile D Orleans for rent by owner homes
Big White Canada home rentals, condo rentals Big White, and vacation rentals Big White
Vacation homes for rent by owner, short term rentals in Sidney Canada, Sidney Canada rental home, and vacation homes in Sidney Canada
Sicamous rental homes and home rentals Sicamous
North Lake Canada vacation homes, short term rentals in North Lake, and North Lake Canada home rentals
House rentals Penticton, apartment rentals Penticton, rental properties in Penticton Canada, and Penticton condos for rent
Vacation rental in Montague Canada and house rentals in Montague Canada
Design and espy vacation rentals Cardston Canada and holiday rentals Cardston.
Ferret out and originate vacation rentals and homes for rent by owner in Bellefeuille Canada.
Holiday rentals Labrolette Bay and condo rentals in Labrolette Bay St Lucia
Detect, come upon, and uncover Saint Jean sur Richelieu home rentals, Saint Jean sur Richelieu Canada for rent by owner homes, and for rent by owner homes in Saint Jean sur Richelieu Canada.
Join our beach listed properties, lake lists of marked properties, waterfront ad directories, and beach classified advertisements mailing list for rental homes in Bay Fortune Canada and homes for rent by owner Bay Fortune.
Invent, notice, and originate condos for rent in Bridgewater, vacation homes in Bridgewater Canada, and houses for rent Bridgewater Canada.
Bay Fortune rental property owners and brokers leasing foreclosures list short term rentals in Bay Fortune Canada, condo rentals, Bay Fortune Canada apartment rentals, and condo rentals in Bay Fortune Canada.
You can go through the romantic lists of marked properties, decadent listed properties, decadent classified ads, and log listed properties under vacation homes for rent by owner in Bay Fortune and Bay Fortune Canada rent houses.
Residers, wanderers, and traveling women inspect, check, and scan For Rent By Owner and catch hidden house, exclusive chalet, penthouse townhouse, and city flat.
See city classified advertisements, exotic indexes, studio ads, and lakeside listed properties that brokers leasing foreclosures and agents serving the condo market post on this extensive website, FRBO.com.
Design and debunk Lac-Mégantic Canada bed and breakfast rentals and homes for rent by owner in Lac-Mégantic.
Design and ascertain apartment rentals in Carcross Canada and Carcross Canada rental properties.
The Bay Fortune Canada advertisements docketed and set down on this extensive website, FRBO.com embrace well appointed cabin, loft hacienda, spacious apartment, and exotic lodge.
Our site, FRBO.com does encompass various tract loft and beach home, townhouse, and apartments.
Appoint and place this weekend to open and lead off on this visit.
Hear, move, and learn Osoyoos Canada rental houses, house rentals Osoyoos, and Osoyoos vacation rental.
Locate, design, and determine Valleyfield home rentals, house rentals in Valleyfield, and vacation rental.
Move and detect rent houses Stoney Creek Canada and apartments for rent in Stoney Creek Canada.
La Isla Palo Seco Costa Rica rental homes, real estate rentals in La Isla Palo Seco Costa Rica, for rent by owner homes La Isla Palo Seco Costa Rica, and apartment rentals La Isla Palo Seco
Light upon, recognize, and hear Aylmer Canada vacation rental, house rentals, and holiday rentals in Aylmer.
|
|
