|
<%@ 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
Condo rentals in Cassis France and Cassis real estate rentals
Holiday rentals Greasque, houses for rent Greasque France, and Greasque rental home
Condo rentals St Paul de Vence France, apartments for rent in St Paul de Vence France, rental home in St Paul de Vence France, and apartment rentals in St Paul de Vence France
Vacation homes for rent by owner St-Cannat and rental properties St-Cannat France
Eguilles France for rent by owner homes, rental homes, and Eguilles apartment rentals
Pezenas France home rentals, for rent by owner homes in Pezenas France, bed and breakfast rentals, and apartment rentals in Pezenas
Vacation rentals in Civray and rent houses
Homes for rent by owner in St Jeannet, vacation rental in St Jeannet France, and St Jeannet house rentals
Golfe du Morbihan France real estate rentals, Golfe du Morbihan France rental home, Golfe du Morbihan rental properties, and houses for rent in Golfe du Morbihan
Apartment rentals Sainte Maure De Touraine France and rent houses in Sainte Maure De Touraine France
Houses for rent in Lorgues France, vacation homes for rent by owner in Lorgues, and Lorgues bed and breakfast rentals
St Caradec condo rentals, condo rentals in St Caradec, home rentals St Caradec France, and St Caradec France rental properties
Short term rentals in Pepieux and Pepieux France home rentals
St-Cannat France rental homes, for rent by owner homes in St-Cannat France, and vacation rentals St-Cannat France
Short term rentals Lorgues, real estate rentals in Lorgues France, short term rentals in Lorgues France, and Lorgues France homes for rent
Houses for rent La Motte France and house rentals in La Motte
Relocate several, another story, and uncommon proof in Millau France and detail Millau short term rentals.
Come across and identify bed and breakfast rentals Abbeville and rental houses in Abbeville France.
We set up, erected, and performed this webpage to be magnificent and gorgeous.
Floaters, teachers, and better halves who are exploring rental homes in Millau and are trying to catch rent house Millau, holiday rentals in Millau France, and Millau France homes for rent by owner can hunt for this webpage and our city indexes and beachfront lists of marked properties.
Millau property owners, agents, rental agents, and property brokers list Millau home rentals, Millau rent houses, vacation rental in Millau, and Millau France house rentals.
Originate and discover Sophia-Antipolis France rental houses and Sophia-Antipolis France rental home.
Find and devise the territory and near-at-hand Millau France parcel.
Find, learn, and determine Orleans France rental homes, vacation rental in Orleans France, and short term rentals in Orleans France.
Send well-formed and cute picture regarding rental apartment and Millau France condo rentals found on this website, FRBO.com.
The Millau secluded classifieds, well appointed classified advertisements, resort classified ads, and well appointed online MLS for these turf can be mapped.
Detect and design rent houses in Lille France and homes for rent by owner.
Glimpse, determine, and learn apartment rentals in Rombas France, condos for rent Rombas France, and Rombas homes for rent.
Ascertain and find Les Ulis France condos for rent and Les Ulis house rentals.
|
|
