|
<%@ 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 for rent by owner in Biarritz France and bed and breakfast rentals in Biarritz France
Cairanne France condos for rent, short term rentals in Cairanne France, and Cairanne rental apartment
Homes for rent by owner Tain-l hermitage France, vacation rentals in Tain-l hermitage, apartments for rent in Tain-l hermitage, and rental apartment Tain-l hermitage France
Vacation homes for rent by owner in St Martin de Bromes France and St Martin de Bromes France condo rentals
St Tropez France real estate rentals, real estate rentals in St Tropez, and real estate rentals St Tropez France
Condos for rent in Dauphin, Dauphin France bed and breakfast rentals, rental home Dauphin, and Dauphin France rental homes
Embres-et-Castelmaure France condos for rent and real estate rentals in Embres-et-Castelmaure France
Arles sur Tech vacation homes for rent by owner, houses for rent in Arles sur Tech France, and Arles sur Tech France rental homes
Holiday rentals, houses for rent Auch, Auch France rental apartment, and holiday rentals
Rental home Villecroze France and condo rentals in Villecroze
Cotignac vacation homes for rent by owner, Cotignac France rental home, and houses for rent Cotignac
Condo rentals in St-Canadet France, St-Canadet France bed and breakfast rentals, rental houses, and St-Canadet France rental properties
Vacation rentals Les Arcs Sur Argens and Les Arcs Sur Argens France vacation homes for rent by owner
Lorgues France vacation rentals, Lorgues holiday rentals, and Lorgues France real estate rentals
Rental home, rental properties in Villiers sur Yonne, Villiers sur Yonne France short term rentals, and apartment rentals Villiers sur Yonne France
Condo rentals and rental home in La Ciotat France
Carrieres sur Seine France holiday rentals, Carrieres sur Seine bed and breakfast rentals, and vacation homes in Carrieres sur Seine France
Bagnols-En-Foret France house rentals, apartments for rent in Bagnols-En-Foret France, Bagnols-En-Foret France vacation rentals, and home rentals
Houses for rent and condos for rent
Homes for rent in Montouliers France, vacation rental in Montouliers France, and Montouliers rental houses
Real estate rentals, rent houses, homes for rent in Maussane-Les-Alpilles, and Maussane-Les-Alpilles France apartment rentals
La Ciotat France condo rentals and apartment rentals La Ciotat
Agde landlords and home owners list Agde France vacation homes for rent by owner, house rentals Agde, and vacation homes in Agde France.
Trippers, peers, and speculators who are wishing to discover, invent, and originate or simply identify information can use For Rent By Owner.
Uncover special and rare dope in Agde France and button down rental homes Agde.
Elicit, distinguish, and devise Eguisheim France apartment rentals, Eguisheim homes for rent by owner, and condo rentals.
Identify, ascertain, and design Abbeville homes for rent, Abbeville France apartment rentals, and vacation rental in Abbeville France.
Join our exclusive advertisements and private advertisements mailing list for condos for rent, rental houses Agde, and Agde rent houses.
Identify, learn, and move rent house Gap France, Gap France rent houses, and rental home in Gap France.
Debunk and learn vacation homes for rent by owner in Chambolle-Musigny France and rental home in Chambolle-Musigny.
Secure, enter into, and hitch on Sunday to initiate, take up, initiate, and embark on on this roaming.
You can ferret out, come upon, and ascertain real estate rentals Agde and home rentals.
This webpage does incorporate specific city loft, resort, and resort timeshare, condominium, and chalets.
Successively, push, do for, and collaborate your itinerants and acquaintances to a sought, magnetic, walloping, and okay plot.
Agde poop sheet could benefit and relieve your expedition.
Confidants and brides look for, hunt, and investigate our site, FRBO.com and relocate waterfront duplex, hillside farmhouse, private bungalow, and decadent vacation home.
Come upon, learn, and hear Hyères vacation homes, holiday rentals in Hyères France, and homes for rent by owner Hyères France.
Discern and hear Les Ulis France house rentals and rental properties in Les Ulis France.
Identify and disclose for rent by owner homes in Saint Mande and apartments for rent Saint Mande France.
Agde is a pulchritudinous, cute, refined, and pleasing patch with well-formed, pulchritudinous, wonderful, and good-looking vacation home, cottage, villa, and villas.
See private listings, beach indexes, hidden ads, and penthouse ad directories that third party listing companies and third party agents post on For Rent By Owner.
Detect, discern, and espy vacation homes for rent by owner in Noisy-le-Grand France, Noisy-le-Grand France vacation homes for rent by owner, and Noisy-le-Grand for rent by owner homes.
You can hunt for the secluded classified advertisements and hillside online MLS under Agde France homes for rent by owner, rent house in Agde France, and houses for rent in Agde France.
Our for rent by owner website involves county and locality materials, very often.
|
|
