|
<%@ 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 Maple Ridge and rent house in Maple Ridge
Rent house, Montague Canada houses for rent, and for rent by owner homes in Montague Canada
Parrsboro Canada apartments for rent, rent house, rent house, and Parrsboro Canada short term rentals
Homes for rent Bracebridge and Bracebridge Canada bed and breakfast rentals
Vacation rentals in Ste Adele Canada, bed and breakfast rentals in Ste Adele Canada, and Ste Adele rental apartment
Holiday rentals in Gabarus Canada, homes for rent by owner, Gabarus Canada rent house, and apartments for rent Gabarus
Vacation rental in Ayers Cliff Canada and houses for rent Ayers Cliff
Holiday rentals in Chemong Lake Canada, houses for rent Chemong Lake, and Chemong Lake bed and breakfast rentals
Brigus Canada rental home, Brigus Canada houses for rent, rental apartment Brigus, and Brigus real estate rentals
Neil s Harbour Canada house rentals and real estate rentals
Yarmouth Canada homes for rent by owner, houses for rent Yarmouth Canada, and home rentals in Yarmouth
Rental homes in Calabogie Canada, condos for rent Calabogie Canada, Calabogie Canada rental houses, and rental homes
Bed and breakfast rentals Gabarus Canada and Gabarus Canada apartment rentals
Rent house Parksville, Parksville Canada condos for rent, and Parksville Canada rental houses
Apartment rentals in Margaretsville Canada, Margaretsville condo rentals, vacation homes in Margaretsville, and Margaretsville Canada house rentals
Bowser Canada rent house and houses for rent Bowser
Apartment rentals Labelle Canada, rent house in Labelle, and Labelle condo rentals
Short term rentals Piedmont, Piedmont Canada homes for rent, Piedmont Canada rent houses, and Piedmont Canada home rentals
Rent houses Gulf Islands Canada and Gulf Islands bed and breakfast rentals
Mont Tremblant Canada bed and breakfast rentals, short term rentals in Mont Tremblant Canada, and Mont Tremblant Canada apartment rentals
Rental home in Quebec City, Quebec City house rentals, Quebec City Canada rent house, and Quebec City Canada rental properties
Apartment rentals in Jasper Canada and condos for rent in Jasper Canada
Ile D Orleans Canada bed and breakfast rentals, vacation rental in Ile D Orleans Canada, and homes for rent in Ile D Orleans
Bed and breakfast rentals Harbourville Canada, Harbourville condo rentals, Harbourville Canada condo rentals, and holiday rentals
Houses for rent Greenfield and apartment rentals Greenfield Canada
Rent houses in Fernie Canada, holiday rentals Fernie Canada, and Fernie Canada rental homes
Holiday rentals Brampton, bed and breakfast rentals in Brampton, vacation rental in Brampton Canada, and Brampton Canada for rent by owner homes
Home rentals in Charlotte s Shore and vacation rental Charlotte s Shore Canada
Look up, devise, and identify vacation homes for rent by owner, for rent by owner homes Grimshaw, and rental homes in Grimshaw Canada.
Light upon something else and individual goods in Ayers Cliff Canada and register vacation rental Ayers Cliff.
Discover and contrive vacation rentals in Edmonton Canada and Edmonton Canada homes for rent by owner.
Discover, notice, and disclose vacation rental in Sainte-Victoire Canada, short term rentals in Sainte-Victoire Canada, and holiday rentals in Sainte-Victoire Canada.
Houses for rent in Isabel Segundo Puerto Rico and holiday rentals
Determine and learn holiday rentals in Nestor Falls Canada and real estate rentals.
Roadmen, occupants, and globetrotters scout, quest, and hunt for our online website, FRBO.com and recognize beachfront bungalow, romantic condominium, studio vacation home, and log chalet.
Devise, ascertain, and espy rent houses in Hall Beach Canada, home rentals, and rent houses in Hall Beach Canada.
Discern, discover, and debunk homes for rent Beausejour Canada, Beausejour Canada apartments for rent, and Beausejour Canada rental properties.
You can hunt the spacious listed properties and spacious classifieds under Ayers Cliff Canada rental apartment and Ayers Cliff vacation homes.
Ayers Cliff Canada precinct employs many property managers, property managers, property managers, and rental property owners.
Determine, ascertain, and espy Medicine Hat Canada home rentals, Medicine Hat Canada rent house, and short term rentals in Medicine Hat.
See hillside ads, loft classified advertisements, decadent listed properties, and hillside advertisements that agents and brokers leasing foreclosures post on FRBO.com.
Disclose and glimpse homes for rent by owner in Carleton Place Canada and home rentals Carleton Place Canada.
Conceive, catch, and come across for rent by owner homes in Rexdale Canada, vacation homes in Rexdale, and Rexdale Canada vacation rentals.
Houses for rent, rental homes Whitehouse Jamaica, Whitehouse Jamaica homes for rent by owner, and real estate rentals
|
|
