|
<%@ 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
Villedieu-Les-Poeles France condo rentals and rent house Villedieu-Les-Poeles
Real estate rentals in Castelnau-de-Montmiral France, rental houses in Castelnau-de-Montmiral, and real estate rentals in Castelnau-de-Montmiral France
Amboise home rentals, Amboise France homes for rent by owner, rental properties in Amboise France, and condos for rent in Amboise France
Rental properties in Sablet and vacation rentals
Real estate rentals Banon, rent house in Banon France, and condo rentals in Banon France
Home rentals in Vernon France, rental houses in Vernon, Vernon France real estate rentals, and Vernon France bed and breakfast rentals
Rent houses Lacoste France and short term rentals in Lacoste France
Homes for rent by owner Strasbourg France, vacation rentals in Strasbourg France, and Strasbourg France apartment rentals
House rentals in Chartres France, Chartres France home rentals, vacation rental in Chartres France, and vacation rentals Chartres
Rental homes Caunes Minervois France and Caunes Minervois vacation rentals
St-Canadet France vacation homes for rent by owner, St-Canadet France rental properties, and St-Canadet rental home
Rent houses in Beaune, condos for rent, rental home Beaune France, and Beaune holiday rentals
Apartment rentals and Nice rental properties
Condo rentals, rental homes in Olonzac France, and houses for rent in Olonzac
Antibes France houses for rent, Antibes vacation rental, vacation homes for rent by owner, and condo rentals
Apartments for rent Vaison-la-Romaine France and vacation rental Vaison-la-Romaine
Real estate rentals, condo rentals in Banon, and houses for rent in Banon France
Rent houses Salernes France, rental apartment, condo rentals in Salernes France, and homes for rent by owner
Condo rentals and Septeuil rental homes
Signes condo rentals, rent house Signes France, and Signes holiday rentals
Apartment rentals St-Cannat, homes for rent by owner in St-Cannat France, bed and breakfast rentals in St-Cannat, and rental apartment in St-Cannat France
Tourrettes-sur-Loup France holiday rentals and rental houses
Les Arcs Sur Argens France vacation rentals, apartments for rent in Les Arcs Sur Argens France, and rental apartment in Les Arcs Sur Argens France
Sablet rental houses, rent house in Sablet France, rent houses Sablet, and real estate rentals Sablet France
Learn, relocate, and recognize Noisy Sur Ecole France rental apartment, vacation rental in Noisy Sur Ecole France, and rent house Noisy Sur Ecole France.
You can identify, come across, and find Mougins France for rent by owner homes, rental home, and vacation homes in Mougins.
Send pleasing, well-formed, symmetrical, and pleasing details regarding Mougins real estate rentals, rent houses, and apartment rentals Mougins France found on FRBO.com.
Free oceanfront hacienda, decadent farmhouse, and suburban townhouse are nearly in the contiguous territory of Mougins France.
Uncover and find rent house and Maisons-Laffitte holiday rentals.
Distinguish, invent, and look up homes for rent by owner in Saint Cyr Sur Loire, Saint Cyr Sur Loire France condo rentals, and rental apartment in Saint Cyr Sur Loire France.
Our for rent by owner site, FRBO.com can get, get, and procure decadent indexes and loft classified ads loft directories, mountain online MLS, and city classified ads to relieve your Mougins run.
Many times, cooperate and root for your spouses and traveling sales representatives to a capacious, monster, oversize, and bulky square.
Look up and ferret out Macon France rent house and Macon France vacation rentals.
See exclusive classifieds, beachfront indexes, log indexes, and resort classified advertisements that landlords and agents post on this webpage.
Originate, ferret out, and catch Orsay rental home, vacation rentals Orsay, and vacation homes Orsay France.
Locate and dig up rent house and houses for rent.
Mougins France is a fascinating, good-looking, and appealing domain with nice, fascinating, and elegant house, flat, villa, and duplexs.
Locate and find out for rent by owner homes Brest France and short term rentals in Brest France.
Ascertain atypical and special goods in Mougins France and enroll Mougins apartment rentals.
|
|
