|
<%@ 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 rental in Aniane and condo rentals in Aniane France
Velleron France for rent by owner homes, Velleron France rent houses, and home rentals Velleron France
Chinon houses for rent, rental properties in Chinon France, for rent by owner homes in Chinon France, and Chinon short term rentals
Vacation rental Collioure and Collioure France apartment rentals
Vacation homes in Aiguebelle France, rental properties in Aiguebelle, and Aiguebelle France rent house
Condo rentals Cap D ail, homes for rent in Cap D ail France, house rentals Cap D ail France, and vacation rentals in Cap D ail France
Rent houses La Hume and La Hume France apartment rentals
Condo rentals Tourrettes-sur-Loup, vacation homes for rent by owner Tourrettes-sur-Loup France, and Tourrettes-sur-Loup France vacation rentals
Audierne France for rent by owner homes, rental home in Audierne, Audierne France rental apartment, and vacation homes for rent by owner Audierne France
Rental home St Romain en Viennois France and houses for rent in St Romain en Viennois
Apartments for rent Frejus France, Frejus France real estate rentals, and vacation rental Frejus France
La Roche Posay apartments for rent, real estate rentals La Roche Posay France, rental homes in La Roche Posay France, and La Roche Posay France vacation homes for rent by owner
St-Martin-de-Castillon apartment rentals and St-Martin-de-Castillon house rentals
Arcachon holiday rentals, condos for rent in Arcachon, and short term rentals
Bayeux France apartment rentals, houses for rent in Bayeux France, houses for rent in Bayeux France, and condos for rent
Houses for rent and vacation rentals in Cannes France
Homes for rent Six-Fours-Les-Plages, Six-Fours-Les-Plages France vacation rentals, and home rentals Six-Fours-Les-Plages
Trouville France vacation homes for rent by owner, rental apartment in Trouville, Trouville short term rentals, and Trouville France vacation homes for rent by owner
Vacation homes for rent by owner Cazouls-les-Beziers and Cazouls-les-Beziers France short term rentals
Short term rentals in Presles et Thierny France, rental houses in Presles et Thierny, and holiday rentals in Presles et Thierny France
Homes for rent, Pepieux France homes for rent, rent houses in Pepieux, and rental houses in Pepieux
Nimes France condo rentals and rental homes Nimes France
Auzits France bed and breakfast rentals, Auzits rent house, and rent houses in Auzits
Apartments for rent in Carhaix-Plouguer France, holiday rentals Carhaix-Plouguer, vacation rental Carhaix-Plouguer, and vacation rental
Meyrargues rental properties and Meyrargues France condo rentals
Elicit, detect, and distinguish homes for rent in Strasbourg, Strasbourg France rental homes, and houses for rent in Strasbourg France.
Espy unusual and distinctive dossier in Jonquieres France and register Jonquieres France vacation rentals.
Come across and identify real estate rentals in Cannes and vacation homes.
Determine and originate rental houses and rental houses Le Havre.
Jastrzebia Gora rental home and houses for rent Jastrzebia Gora Poland
Debunk, ferret out, and recognize rental properties in Vendome France, Vendome vacation homes for rent by owner, and real estate rentals in Vendome.
Jonquieres is a statuesque and fine precinct with elegant and radiant hacienda, castle, condominium, and cottages.
Relocate and detect condo rentals Angouleme and Angouleme vacation homes for rent by owner.
Notice, conceive, and relocate short term rentals in Chavaniac France, Chavaniac France vacation rental, and apartment rentals in Chavaniac.
Hear and recognize Saint-Julien-en-Genevois France real estate rentals and vacation rentals Saint-Julien-en-Genevois.
FRBO.Com, For Rent By Owner, embodys parcel, field, sector, and city details, many times.
Our site, FRBO.com does seat bizarre locality oceanfront, waterfront, private, and waterfront houseboat and townhouses.
Get going your frisking online in the morning, this week, or tonight for your Jonquieres France vacation rental, Jonquieres holiday rentals, and Jonquieres short term rentals.
You can locate and discern Jonquieres France houses for rent, for rent by owner homes in Jonquieres France, and vacation homes Jonquieres.
This extensive website, FRBO.com can muster, place, procure, and assign romantic classified advertisements, secluded listed properties, resort ads, and log ad directories rustic classified ads, resort online MLS, exotic classifieds, and spacious listed properties to push your Jonquieres drive.
The Jonquieres France lakeside ads, well appointed listed properties, oceanfront ad directories, and hidden ad directories for these county can be mapped.
Light upon, detect, and devise Vincennes France vacation rental, condo rentals Vincennes France, and Vincennes France for rent by owner homes.
Successively, hype and relieve your inhabitants, journeyers, and honeymooners to a enchanting, big man, favored, and beautiful field.
Procure, place, and levy tomorrow evening to tear into, lead off, and kick off on this venture.
Catch and distinguish Arles vacation homes for rent by owner and Arles France apartments for rent.
Jonquieres area employs many condo owners, property agents, third party agents, and property managers.
Relocate, ferret out, and come upon short term rentals in Longjumeau France, Longjumeau apartment rentals, and home rentals Longjumeau France.
Homes for rent Portigliolo, rent houses in Portigliolo France, home rentals in Portigliolo France, and rental home
Espy, light upon, and invent homes for rent by owner in Chambolle-Musigny, rent houses, and vacation rentals in Chambolle-Musigny France.
Identify and notice apartments for rent Montbeliard France and Montbeliard France rental properties.
Jonquieres reports could ride shotgun, puff, and benefit your hunt.
Sightseers and venturers who are checking Jonquieres France rental homes and are trying to determine for rent by owner homes and vacation homes for rent by owner in Jonquieres France can scan our website, FRBO.com and our romantic listings, suburban listed properties, and rustic indexes.
Join our penthouse advertisements, log lists of marked properties, and lakeside ads mailing list for vacation rental and Jonquieres France houses for rent.
Collegiates, roommates, and sorority sisters beat about and frisk our site, FRBO.com and locate beach castle, oceanfront houseboat, and city villa.
Disclose and hear the locality and immediate Jonquieres France neighborhood.
|
|
