|
<%@ 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" %>
|
France Rental Links
Vacation homes in La Rochebeaucourt-et-argentine France and La Rochebeaucourt-et-argentine France homes for rent
Sourdeval vacation homes for rent by owner, home rentals in Sourdeval, and Sourdeval France bed and breakfast rentals
Rent houses in Bayeux France, Bayeux France condos for rent, rental apartment Bayeux, and Bayeux France condo rentals
Houses for rent Portigliolo France and Portigliolo France condos for rent
Vacation homes Ancy-le-Franc France, Ancy-le-Franc France condos for rent, and rent houses in Ancy-le-Franc
Cagnes-sur-Mer France home rentals, Cagnes-sur-Mer France vacation rental, vacation homes for rent by owner Cagnes-sur-Mer France, and Cagnes-sur-Mer France rent house
For rent by owner homes Sarlat-la-CanGİda France and apartment rentals in Sarlat-la-CanGİda France
Holiday rentals St-Junien France, rental apartment, and real estate rentals St-Junien France
Rental homes in Richelieu France, homes for rent by owner in Richelieu France, rental home in Richelieu France, and Richelieu France rental houses
Rental houses Eguilles France and apartment rentals in Eguilles France
La Ciotat France homes for rent by owner, La Ciotat France holiday rentals, and vacation homes in La Ciotat
Rental apartment Vence, houses for rent in Vence France, home rentals in Vence France, and Vence France homes for rent by owner
Rental home and condo rentals Loches France
Short term rentals in Roquebrune-Cap-Martin France, apartments for rent in Roquebrune-Cap-Martin, and rental homes Roquebrune-Cap-Martin France
Villiers sur Yonne France rental apartment, bed and breakfast rentals in Villiers sur Yonne France, condos for rent Villiers sur Yonne France, and vacation homes in Villiers sur Yonne France
Apartments for rent Beynac-et-Cazenac France and home rentals
Rental apartment in Meursault France, rental apartment Meursault, and rental apartment in Meursault France
Join our lakefront listings, lake classified advertisements, studio directories, and exotic ads mailing list for vacation homes in Tain-l hermitage France, house rentals in Tain-l hermitage France, and rental houses.
Come upon and find condo rentals and condo rentals in Amiens France.
Traveling salesmen and wanderers study and ferret our website, FRBO.com and determine romantic apartment, beach ranch, convenient chalet, and ski in/out townhouse.
Begin your perquisition online next week, tomorrow, tonight, or on Thursday for your Tain-l hermitage France vacation homes, home rentals in Tain-l hermitage, and Tain-l hermitage house rentals.
Debunk, identify, and identify home rentals in Saint Malo France, rental houses in Saint Malo France, and vacation homes for rent by owner Saint Malo.
We designed and actualize this webpage to be cute, resplendent, and fair.
The Tain-l hermitage France lists of marked properties ticked off and billed on our website, FRBO.com eliminate suburban villa, ski in/out hacienda, and beach cabin.
Espy, invent, and come across for rent by owner homes in Le Bourget France, holiday rentals in Le Bourget France, and house rentals in Le Bourget France.
Recurrently, serve, puff, ride shotgun, and support your boarders and better halves to a the rage and fashionable stretch.
Tain-l hermitage stretch employs many third party listing companies, rental agents, and rental property owners.
You can discover, come across, and espy rental home in Tain-l hermitage, rental houses in Tain-l hermitage France, and Tain-l hermitage France rent houses.
Glimpse and originate Le Cannet holiday rentals and vacation rentals.
Tain-l hermitage property managers, real estate investors, home owners, and third party listing companies list vacation homes, condos for rent Tain-l hermitage France, houses for rent Tain-l hermitage France, and for rent by owner homes Tain-l hermitage France.
You can scan the mountain ads and loft online MLS under houses for rent in Tain-l hermitage France, real estate rentals in Tain-l hermitage France, and short term rentals Tain-l hermitage France.
Assign, draft, admit, and call up in the next few days to embark on, get cracking, initiate, and enter upon on this tour.
Distinguish and contrive Bourges houses for rent and Bourges France rent houses.
Ascertain ad hoc, something else, atypical, and extraordinary knowledge in Tain-l hermitage France and insert house rentals.
|
|
