|
<%@ 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
House rentals Chamonix France and Chamonix rent house
Short term rentals in Bouriege, Bouriege France rental properties, and Bouriege rental home
Homes for rent in Banon France, for rent by owner homes in Banon France, Banon France rent house, and real estate rentals Banon
Rent houses Tornac and homes for rent by owner Tornac France
Goult France rent houses, vacation rentals in Goult France, and Goult houses for rent
Rent house in St Aquilin France, houses for rent in St Aquilin France, St Aquilin France apartment rentals, and St Aquilin France short term rentals
House rentals and bed and breakfast rentals in Rambouillet
Apartment rentals in Honfleur France, rental houses, and home rentals in Honfleur France
Rental home in Strasbourg France, Strasbourg France apartment rentals, rental apartment in Strasbourg, and Strasbourg France vacation rentals
Holiday rentals Laudun and houses for rent Laudun France
Rental houses in Ansouis, Ansouis France apartment rentals, and Ansouis France vacation rentals
Vacation rentals in La Napoule France, La Napoule France rent houses, La Napoule France real estate rentals, and vacation rental
Mortagne-sur-Gironde France parcel employs many rental property owners, condo owners, and rental agents.
Catch, identify, and look up vacation homes in Beziers France, real estate rentals in Beziers France, and short term rentals in Beziers.
Traveling women, tourists, and acquaintances inspect and check this extensive website, FRBO.com and come across beachfront condominium, suburban home, hidden home, and hidden hacienda.
Mortagne-sur-Gironde is a sublime and well-formed township with angelic and taking timeshare and haciendas.
Recently vacated lakefront condominium, waterfront vacation home, suburban bungalow, and studio apartment are not to distant in the proximate stretch of Mortagne-sur-Gironde France.
Come across and explore home rentals in Arcachon France and rental apartment.
Mortagne-sur-Gironde condo owners, rental property owners, town home owners, and property agents list apartments for rent in Mortagne-sur-Gironde, rental houses, and rental apartment in Mortagne-sur-Gironde France.
Hear and notice rental homes Bayonne France and Bayonne houses for rent.
Hear, conceive, and conceive rental houses, Terrasson vacation homes for rent by owner, and vacation homes Terrasson.
See hillside online MLS, beach classifieds, loft ad directories, and private classifieds that property managers and third party agents post on FRBO.com.
You can comb the lakefront listings, romantic classified ads, rustic indexes, and beachfront online MLS under rental properties in Mortagne-sur-Gironde France and houses for rent in Mortagne-sur-Gironde.
FRBO.com does encompass distinctive city hillside, exclusive, romantic, and city bungalow, condominium, and cabins.
|
|
