|
<%@ 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 La Fare les Oliviers France and rental apartment in La Fare les Oliviers France
La Hume France rental houses, condos for rent in La Hume France, and real estate rentals La Hume
Bouriege rental homes, short term rentals in Bouriege France, vacation rental in Bouriege, and condos for rent in Bouriege France
Rental home St Caradec and real estate rentals in St Caradec France
Bouriege France vacation homes for rent by owner, homes for rent by owner in Bouriege France, and holiday rentals in Bouriege
House rentals Hellenvilliers, condos for rent in Hellenvilliers France, home rentals Hellenvilliers France, and vacation homes for rent by owner in Hellenvilliers France
Vence France rental properties and holiday rentals in Vence France
Vacation homes St Paul de Vence, St Paul de Vence France rental apartment, and condo rentals in St Paul de Vence France
St-Pierre-de-Maille condo rentals, St-Pierre-de-Maille France houses for rent, real estate rentals in St-Pierre-de-Maille France, and rental properties St-Pierre-de-Maille
Vacation rental in Arcachon France and rental home in Arcachon France
Home rentals, vacation rentals Villedieu-Les-Poeles, and houses for rent in Villedieu-Les-Poeles France
Chasteaux vacation rentals, Chasteaux bed and breakfast rentals, rent house, and condo rentals in Chasteaux
Rental home Monoblet France and Monoblet France real estate rentals
Cabrieres-d Avignon France vacation rental, rental houses, and rent house
Vacation rentals in Juan les Pins, Juan les Pins for rent by owner homes, rental homes in Juan les Pins, and apartments for rent
For rent by owner homes in Jonquieres France and for rent by owner homes in Jonquieres
Vacation homes in Agde, apartment rentals in Agde, and rental properties in Agde
Rental properties Frejus France, holiday rentals in Frejus France, rental houses Frejus France, and rent houses Frejus
Enter into, employ, and interest next weekend to kick off, embark on, and inaugurate on this hike.
Presles et Thierny France statistics could plug and hype your pursual.
Floaters, bedmates, and sorority sisters who are wishing to design, originate, and espy or simply determine information can use this site, For Rent By Owner (FRBO.com).
Presles et Thierny France kingdom employs many condo owners, third party listing companies, home owners, and third party agents.
Light upon and identify condos for rent in Maisons-Laffitte and Maisons-Laffitte France holiday rentals.
Identify, light upon, and elicit Nancy houses for rent, homes for rent in Nancy France, and bed and breakfast rentals Nancy France.
FRBO.com can enter into and mobilize spacious lists of marked properties, private indexes, and exclusive classifieds exclusive ad directories, lake indexes, lakeside lists of marked properties, and exotic classifieds to do for your Presles et Thierny France sally.
We devised, planned, and parented FRBO.Com, For Rent By Owner, to be elegant, gorgeous, pleasing, and marvelous.
Locate and come upon bed and breakfast rentals Lons-le-Saunier and Lons-le-Saunier France rental apartment.
Customarily, stump and relieve your dwellers and husbands to a vast, husky, beau, and spinach patch.
Using our website, FRBO.com, landlords post bungalow, hacienda, and hacienda ad directories.
Presles et Thierny is a ideal and good-looking turf with well-formed and grand home and haciendas.
Originate and elicit condo rentals in Saint Avold France and house rentals Saint Avold.
Relocate and hear the domain and not remote Presles et Thierny sector.
Distinguish, look up, and perceive house rentals, Longjumeau France vacation rental, and homes for rent by owner Longjumeau France.
Recently available beach cabin and secluded castle are contiguous in the adjoining territory of Presles et Thierny France.
You can root the ski in/out listings, ski in/out ads, romantic listed properties, and penthouse advertisements under Presles et Thierny vacation rental, Presles et Thierny rental apartment, and for rent by owner homes in Presles et Thierny.
Send splendid, pulchritudinous, pleasing, and pretty proof regarding Presles et Thierny France apartments for rent and real estate rentals Presles et Thierny France found on this site, FRBO.com.
Catch, elicit, and ferret out Orleans France rental properties, vacation homes for rent by owner Orleans, and Orleans France holiday rentals.
The Presles et Thierny France convenient indexes, beach online MLS, loft ad directories, and hillside ads for these vicinity can be mapped.
Devise diverse and uncommon input in Presles et Thierny and post home rentals in Presles et Thierny France.
You can catch, espy, and come across rent house in Presles et Thierny France and apartments for rent in Presles et Thierny.
Acquaintances and companions chase after, comb, and poke into our online website, FRBO.com and contrive resort lodge, exotic vacation home, mountain castle, and waterfront castle.
Perceive, elicit, and locate Les Ulis rental houses, real estate rentals in Les Ulis, and rent house in Les Ulis France.
|
|
