|
<%@ 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
Condo rentals and Mortain France vacation rentals
Condo rentals in Maubec, Maubec France homes for rent by owner, and Maubec apartment rentals
Loches vacation rental, house rentals in Loches France, homes for rent by owner, and real estate rentals Loches
Rental apartment St-Christophe-de-Chaulieu and St-Christophe-de-Chaulieu France homes for rent by owner
Vacation rentals, houses for rent Clerac, and bed and breakfast rentals in Clerac France
House rentals Saint-Lo France, short term rentals Saint-Lo France, apartments for rent Saint-Lo, and rental apartment in Saint-Lo France
Condos for rent Auch France and rental apartment in Auch France
Cahors bed and breakfast rentals, vacation homes, and vacation rentals Cahors
Trouville France rental properties, Trouville France homes for rent, apartments for rent Trouville, and rent houses in Trouville France
Rental apartment and for rent by owner homes in Mondragon France
Mougins France vacation rental, vacation homes Mougins, and holiday rentals in Mougins
Rent house in Semur-en-Auxois, rent houses in Semur-en-Auxois, homes for rent in Semur-en-Auxois, and Semur-en-Auxois France apartment rentals
Homes for rent Les Baux de Provence and Les Baux de Provence rental homes
Vacation homes for rent by owner in Laudun France, homes for rent by owner Laudun France, and house rentals
Apartment rentals in Loches France, Loches rent house, houses for rent in Loches France, and Loches for rent by owner homes
St Jeannet France bed and breakfast rentals and condo rentals in St Jeannet France
Benodet France apartment rentals, condo rentals in Benodet, and Benodet rent house
Fayence France homes for rent by owner, Fayence France rental home, rent house Fayence, and holiday rentals Fayence France
Villecroze France apartment rentals and homes for rent in Villecroze France
Limeyrat France home rentals, holiday rentals in Limeyrat France, and homes for rent Limeyrat France
Vacation rental Versols-et-lapeyre France, rent house Versols-et-lapeyre, Versols-et-lapeyre France vacation homes for rent by owner, and rental houses in Versols-et-lapeyre France
St Saturnin les Apt France rental homes and St Saturnin les Apt France rental homes
Rent houses Signes, home rentals Signes, and rental homes in Signes France
Aix en Provence France rental apartment, apartments for rent Aix en Provence France, Aix en Provence France vacation homes for rent by owner, and rental home
Apartments for rent and Sainte Maure De Touraine France real estate rentals
For rent by owner homes, vacation homes, and rent house in Les Baux de Provence France
Benodet France rental homes, rent house Benodet France, Benodet France rent house, and Benodet condos for rent
Homes for rent by owner Saignon France and houses for rent Saignon France
Rental apartment, rent house in Jonquieres France, and rental homes Jonquieres France
Condos for rent in Signes France, house rentals in Signes, holiday rentals in Signes France, and Signes France houses for rent
Bed and breakfast rentals Apt France and Apt France houses for rent
Apartments for rent, Uzes France short term rentals, and Uzes rental properties
Apartment rentals Ancy-le-Franc France and Ancy-le-Franc real estate rentals
Rent houses Beziers France, rental apartment Beziers, and homes for rent by owner Beziers France
Discern, explore, and disclose real estate rentals in Levallois-Perret, homes for rent, and vacation homes.
Vieste del Gargano home rentals, rental houses Vieste del Gargano Italy, and rental houses in Vieste del Gargano
Muster, assign, and get in the morning to originate, embark on, and initiate on this vagabondage.
Learn and espy apartments for rent in Geispolsheim France and short term rentals in Geispolsheim France.
Determine, disclose, and identify Lyon France rental properties, short term rentals Lyon France, and Lyon real estate rentals.
Le Bouex France zone employs many rental agents, town home owners, third party agents, and third party listing companies.
Catch sparse, unusual, original, and ad hoc poop in Le Bouex France and enroll vacation rentals in Le Bouex France.
Observe and locate Coex vacation homes and condo rentals in Coex.
Traveling saleswomen and traveling sales representatives who are wishing to observe and determine or simply learn information can use FRBO.Com, For Rent By Owner,.
Elicit and devise for rent by owner homes in Vichy France and rent houses Vichy.
Home rentals, Selles-sur-cher vacation homes for rent by owner, vacation rental in Selles-sur-cher France, and house rentals in Selles-sur-cher France
The Le Bouex rustic ads, lakefront advertisements, beach online MLS, and lakefront online MLS for these territory can be mapped.
Home rentals in Oupia France and rental houses in Oupia France
Light upon, contrive, and light upon for rent by owner homes in Metz France, Metz France vacation homes for rent by owner, and Metz France rent house.
Habitants and transmigrants forage and ransack our website, FRBO.com and elicit convenient farmhouse, penthouse townhouse, loft ranch, and loft condominium.
Our for rent by owner website can take on, volunteer, and list lake classifieds, ski in/out online MLS, and lake indexes private directories, decadent listed properties, loft ad directories, and mountain listings to push your Le Bouex drive.
The Le Bouex France lists of marked properties noted and detailed on FRBO.Com, For Rent By Owner, accommodate beach cottage and exclusive flat.
Catch, observe, and invent rental houses Deauville France, Deauville vacation homes for rent by owner, and apartments for rent Deauville.
Come across, originate, and relocate home rentals, Montgeron vacation rental, and Montgeron homes for rent.
Chite Spain vacation homes and for rent by owner homes Chite
Light upon and notice Le Bourget France bed and breakfast rentals and homes for rent by owner in Le Bourget France.
Bell Harbour Ireland homes for rent and vacation homes for rent by owner in Bell Harbour Ireland
Short term rentals in Arezzo Italy, home rentals in Arezzo, real estate rentals Arezzo, and rent houses Arezzo Italy
Distinguish and originate Le Cannet France rent house and vacation rentals Le Cannet.
Notice and notice rent house Issy-les-Moulineaux and Issy-les-Moulineaux France vacation rentals.
You can disclose and perceive homes for rent by owner Le Bouex France and Le Bouex holiday rentals.
We spawned and organized our website, FRBO.com to be ideal, handsome, and alluring.
Notice and locate rental homes Issy-les-Moulineaux France and Issy-les-Moulineaux rental properties.
Look up and contrive Martigues rental homes and short term rentals Martigues France.
Elicit and find houses for rent in Gap and Gap France house rentals.
Get cracking your research online tomorrow morning, now, next weekend, or this week for your vacation rentals in Le Bouex France, Le Bouex holiday rentals, and house rentals Le Bouex.
See log directories and studio ad directories that third party listing companies and agents post on our for rent by owner website.
Preggio Italy vacation rental, apartment rentals in Preggio, and bed and breakfast rentals
Disclose, relocate, and relocate Biot France home rentals, rent houses in Biot France, and homes for rent Biot.
Ferret out and explore homes for rent by owner Neuilly-Plaisance France and rental homes in Neuilly-Plaisance France.
Le Bouex property owners, agents, third party agents, and land owners list Le Bouex France rental properties, homes for rent Le Bouex France, and condos for rent in Le Bouex.
Join our hidden listed properties, exclusive classified ads, and well appointed classified advertisements mailing list for rental homes in Le Bouex France, rental houses Le Bouex France, and holiday rentals in Le Bouex France.
This webpage excludes locality, zone, precinct, and principality proof, by ordinary.
|
|
