|
<%@ 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 homes in Annecy France and bed and breakfast rentals Annecy France
For rent by owner homes in Sourdeval, rental home in Sourdeval France, and Sourdeval vacation rental
Vacation homes for rent by owner, rental houses Avignon France, vacation homes Avignon France, and Avignon vacation rental
Rent house Villiers sur Yonne and Villiers sur Yonne apartments for rent
Vacation homes, short term rentals in Benodet, and rental apartment in Benodet
Real estate rentals Gargas, Gargas France rental home, Gargas France rental homes, and bed and breakfast rentals in Gargas France
Rental properties and short term rentals in Aniane France
Vacation rentals in Six-Fours-Les-Plages, rent houses Six-Fours-Les-Plages France, and homes for rent in Six-Fours-Les-Plages France
Houses for rent, vacation homes Juan les Pins France, Juan les Pins France rental properties, and house rentals in Juan les Pins
Vacation rental Ste Maxime and home rentals Ste Maxime France
Ambert condos for rent, rent houses Ambert, and real estate rentals in Ambert France
Palaminy vacation homes for rent by owner, homes for rent by owner in Palaminy, Palaminy home rentals, and home rentals in Palaminy France
Armagnac Region France rent house and rental apartment Armagnac Region
Real estate rentals, vacation homes in Rognes France, and house rentals in Rognes France
Roussillon house rentals, Roussillon apartment rentals, Roussillon homes for rent, and Roussillon France condos for rent
Rental apartment Antibes France and short term rentals in Antibes France
St Jeannet for rent by owner homes, bed and breakfast rentals, and St Jeannet France homes for rent
Valbonne France apartments for rent, holiday rentals Valbonne, house rentals Valbonne, and homes for rent by owner Valbonne France
Rental houses in St Tropez and short term rentals in St Tropez France
House rentals in St Pierre de Plesguen France, real estate rentals in St Pierre de Plesguen France, and rental houses St Pierre de Plesguen
Rent houses in Chanterac France, home rentals Chanterac, holiday rentals, and for rent by owner homes Chanterac France
Bormes-les-Mimosas France holiday rentals and rental home
Apartments for rent Lacoste, Lacoste France vacation rental, and Lacoste France for rent by owner homes
Cheville France homes for rent by owner, condo rentals in Cheville France, homes for rent Cheville, and for rent by owner homes
Rental home in Chanterac France and Chanterac France rent houses
Rental apartment in Croissy-sur-Seine France, vacation homes for rent by owner in Croissy-sur-Seine, and Croissy-sur-Seine France house rentals
Rental home in Soreze, apartment rentals Soreze, Soreze France rental apartment, and rent house Soreze France
Locate and locate Chantilly condo rentals and vacation rental Chantilly.
The Robion exotic advertisements and hidden classified advertisements for these township can be mapped.
Light upon, detect, and find vacation rentals, apartment rentals, and Albi France short term rentals.
Join our exclusive lists of marked properties, studio listings, studio classified advertisements, and suburban advertisements mailing list for rent house Robion France and houses for rent in Robion France.
FRBO.com can take on and assign beach ad directories and exotic indexes penthouse listings and waterfront online MLS to boost your Robion France traverse.
The Robion France ad directories catalogued and tabulated on FRBO.com comprehend private apartment, loft chalet, and private townhouse.
Look up, disclose, and relocate Billom France homes for rent by owner, houses for rent, and Billom houses for rent.
Perceive, explore, and invent rental home in Dormans France, homes for rent by owner in Dormans France, and short term rentals.
You can root the well appointed advertisements, well appointed online MLS, and secluded classified advertisements under rental properties and vacation rentals in Robion France.
Explorers, travelers, and brothers-in-law who are exploring rental apartment in Robion France and are trying to determine Robion short term rentals and Robion for rent by owner homes can investigate FRBO.Com, For Rent By Owner, and our ski in/out online MLS, mountain directories, beach advertisements, and mountain classified ads.
Using our website, FRBO.com, property brokers detail duplex, timeshare, and castle lists of marked properties.
Tear into your examination online on Wednesday, in the morning, on Wednesday, or next weekend for your Robion France rental homes and Robion France real estate rentals.
Our site, FRBO.com does arrange other block mountain, lakeside, and spacious bungalow, duplex, and homes.
Collegiates and sailors who are wishing to discover and invent or simply detect information can use this site, FRBO.com.
Vacated lakeside apartment, hillside cabin, and beach ranch are neighboring in the not far precinct of Robion France.
Robion dominion employs many condo owners, home owners, third party listing companies, and real estate brokers.
Uncover and disclose Grenoble France vacation homes and homes for rent.
Catch and detect bed and breakfast rentals and vacation homes for rent by owner in Levallois-Perret France.
Contrive, discover, and ferret out Voiron France apartment rentals, vacation homes for rent by owner in Voiron, and vacation homes in Voiron France.
|
|
