|
<%@ 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
Rental properties and home rentals St Martin de Bromes
Condo rentals Ste Colombe de Duras France, vacation rental Ste Colombe de Duras France, and homes for rent by owner in Ste Colombe de Duras France
St Jeannet rental properties, rental homes in St Jeannet, St Jeannet short term rentals, and apartments for rent in St Jeannet France
Caromb France rental homes and Caromb France rental apartment
Condo rentals in Bellac, Bellac France rental homes, and home rentals Bellac France
Civray France homes for rent, condo rentals in Civray France, Civray France rental properties, and Civray condo rentals
Holiday rentals and real estate rentals Clerac
Condo rentals, vacation rentals in Villiers sur Yonne France, and Villiers sur Yonne France house rentals
La Motte France bed and breakfast rentals, La Motte France homes for rent, rental apartment La Motte, and rent house in La Motte
Vacation rentals in Palaminy France and homes for rent in Palaminy
Condo rentals, Erce France rent houses, and Erce condo rentals
Fayence France rental apartment, Fayence France house rentals, Fayence France rent house, and Fayence France rental home
Find and find out rent houses Calais and Calais France rent houses.
Move, identify, and identify rent house in Saint Mande, holiday rentals Saint Mande France, and houses for rent Saint Mande.
This webpage seats block, field, and locality whole story, sporadically.
Design and uncover Senonches bed and breakfast rentals and for rent by owner homes in Senonches France.
Devise and recognize real estate rentals in Troyes and rental homes Troyes.
Locate, debunk, and light upon the stretch and not far Vernon France township.
Using our website, FRBO.com, home owners tally flat, home, houseboat, and vacation home classifieds.
Ascertain and come across vacation homes for rent by owner in Courchevel and rental houses.
Vernon patch employs many rental property owners, third party listing companies, home owners, and rental agents.
Hear and relocate Toulouse France vacation homes and rental properties.
Observe, ferret out, and find out Troyes France rent houses, apartments for rent Troyes France, and Troyes France condo rentals.
Vernon brokers leasing foreclosures and third party listing companies list Vernon France real estate rentals, Vernon France houses for rent, house rentals in Vernon, and home rentals in Vernon.
The Vernon classified ads specified and written down on this extensive website, FRBO.com involve private flat, ski in/out lodge, and well appointed castle.
This site, For Rent By Owner (FRBO.com) can draft, induct, enroll, and incorporate city lists of marked properties, rustic listed properties, loft directories, and studio classified ads well appointed listings, suburban directories, well appointed classified ads, and beach classified advertisements to back your Vernon transmigration.
|
|
