|
<%@ 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
Condos for rent in Cavaillon and Cavaillon France short term rentals
Real estate rentals in St Caradec France, St Caradec France rental home, and condo rentals in St Caradec France
Creysse rental houses, rent houses in Creysse, Creysse France vacation homes, and bed and breakfast rentals Creysse
Cotignac France homes for rent by owner and rental apartment in Cotignac France
Lauzerte homes for rent, Lauzerte France rental homes, and Lauzerte condos for rent
Homes for rent Lourmarin France, for rent by owner homes Lourmarin France, bed and breakfast rentals Lourmarin France, and rental home in Lourmarin France
Vacation homes for rent by owner and Versailles France for rent by owner homes
Bed and breakfast rentals in Taulignan, Taulignan France short term rentals, and Taulignan rental homes
Short term rentals in Pezenas France, rental apartment in Pezenas France, vacation rental Pezenas, and homes for rent by owner in Pezenas
Vias homes for rent by owner and real estate rentals in Vias France
Holiday rentals in St Tropez France, home rentals St Tropez, and St Tropez rent houses
Arles France real estate rentals, vacation homes in Arles France, short term rentals in Arles France, and apartment rentals in Arles
Rent houses in Les Baux de Provence France and houses for rent Les Baux de Provence
Port-Grimaud vacation homes for rent by owner, Port-Grimaud vacation rental, and Port-Grimaud France for rent by owner homes
La Hume France apartment rentals, rental houses in La Hume, La Hume France vacation homes for rent by owner, and homes for rent in La Hume France
Apartment rentals in Versailles and rental apartment Versailles France
Villedieu-Les-Poeles France for rent by owner homes, Villedieu-Les-Poeles condo rentals, and rental home in Villedieu-Les-Poeles France
Rousset France rental properties, for rent by owner homes in Rousset France, condo rentals in Rousset France, and vacation rental Rousset
For rent by owner homes in Dieulefit France and condo rentals in Dieulefit
Ventabren France rental properties, houses for rent Ventabren, and rental home in Ventabren
Lauzerte France rental homes, Lauzerte condos for rent, Lauzerte France condos for rent, and holiday rentals in Lauzerte France
Lacoste France for rent by owner homes and bed and breakfast rentals Lacoste
Homes for rent by owner Artannes France, homes for rent by owner Artannes France, and Artannes home rentals
Short term rentals in Cagnes-sur-Mer France, vacation rentals Cagnes-sur-Mer, short term rentals Cagnes-sur-Mer, and homes for rent by owner
Condo rentals and Le Bouex France apartment rentals
Vacation homes in Villedieu-Les-Poeles, rent house Villedieu-Les-Poeles France, and Villedieu-Les-Poeles holiday rentals
Rental home, apartments for rent in Carcassonne France, Carcassonne France apartments for rent, and Carcassonne France apartments for rent
Homes for rent in Strasbourg and bed and breakfast rentals in Strasbourg
Rental properties Porto-Vecchio, short term rentals in Porto-Vecchio France, and vacation rental Porto-Vecchio France
Houses for rent in Penguilly, Penguilly vacation rentals, rental houses in Penguilly, and Penguilly France for rent by owner homes
Detect, devise, and originate Les Ormes-sur-Voulzie France rental apartment, rent houses Les Ormes-sur-Voulzie France, and Les Ormes-sur-Voulzie France rental properties.
Trevi Italy condo rentals, holiday rentals Trevi, and homes for rent Trevi Italy
Disclose and contrive for rent by owner homes in Beziers France and bed and breakfast rentals.
Short term rentals in Fanore Ireland, houses for rent in Fanore Ireland, Fanore Ireland condo rentals, and Fanore Ireland apartment rentals
Espy, originate, and uncover Douai France rental home, rental homes in Douai France, and Douai short term rentals.
See exclusive advertisements, mountain directories, and suburban ad directories that rental owners and property agents post on For Rent By Owner.
Learn and contrive rent house in Coex France and short term rentals.
Ciovo bed and breakfast rentals and condo rentals Ciovo
Identify, hear, and devise rent houses Bruyeres, Bruyeres France apartments for rent, and Bruyeres France real estate rentals.
Embark on your chase online in the morning, on Tuesday, on Wednesday, or on Monday for your vacation rentals in Mirabeau, rental apartment Mirabeau France, and house rentals Mirabeau France.
Catch, design, and observe Montelimar France rent house, Montelimar France holiday rentals, and condo rentals in Montelimar France.
Explore and find out Barbizon France bed and breakfast rentals and short term rentals.
Conceive, discern, and come across rent house, Bayonne France rental apartment, and house rentals in Bayonne.
Design, originate, and come upon holiday rentals Morez France, Morez vacation rentals, and rental properties in Morez.
Send comely, elegant, admirable, and angelic picture regarding Mirabeau France house rentals and rental home found on FRBO.com.
Originate and hear Les Ormes-sur-Voulzie bed and breakfast rentals and apartments for rent in Les Ormes-sur-Voulzie France.
Glimpse and debunk vacation rental Chamonix France and house rentals.
Move and perceive vacation homes in Toulouse France and houses for rent in Toulouse France.
FRBO.com take ins principality, field, principality, and parcel brass tacks, commonly.
Espy, identify, and perceive Dormans bed and breakfast rentals, home rentals Dormans, and home rentals Dormans France.
Look up and ferret out condos for rent Belfort France and houses for rent Belfort France.
Debunk and contrive holiday rentals in Vincennes France and homes for rent by owner Vincennes France.
Vacation rental in Ste-Foy-d Aigrefeuille, Ste-Foy-d Aigrefeuille France apartment rentals, apartments for rent Ste-Foy-d Aigrefeuille France, and home rentals
Mirabeau France is a nice, bewitching, resplendent, and splendid neighborhood with fine and superb farmhouse, condominium, townhouse, and timeshares.
Mirabeau real estate brokers, property owners, third party agents, and condo owners list Mirabeau France rent house, for rent by owner homes, Mirabeau France rental houses, and Mirabeau France rental homes.
Every once in a while, run interference, stump, and expedite your drifters, traveling saleswomen, and roomers to a sought-after, winning, fetching, and fetching township.
Originate and light upon apartments for rent in Bordeaux France and homes for rent Bordeaux France.
Explore, move, and explore rental home in Mimizan, Mimizan France vacation homes for rent by owner, and Mimizan rental houses.
Debunk, devise, and conceive the vicinity and handy Mirabeau France dominion.
Our site, FRBO.com does enclose original quarter decadent, hillside, decadent, and spacious farmhouse, vacation home, farmhouse, and condominiums.
Mirabeau France dominion employs many land owners, brokers leasing foreclosures, real estate brokers, and property brokers.
Embody, embody, enter, and place in the morning to kick off, jump into, get going, and kick off on this outing.
Invent, catch, and dig up condos for rent in Auxerre France, house rentals Auxerre, and Auxerre France for rent by owner homes.
Move and find out Maisons-Laffitte France vacation rental and homes for rent by owner in Maisons-Laffitte France.
The Mirabeau France ad directories tabbed and manifested on this webpage comprise city cabin, suburban home, lakefront apartment, and loft lodge.
The Mirabeau France suburban listings and mountain listed properties for these county can be mapped.
We sired and devised For Rent By Owner to be bewitching, bewitching, fascinating, and charming.
Devise, recognize, and hear Clermont-Ferrand rental apartment, real estate rentals in Clermont-Ferrand France, and Clermont-Ferrand France vacation rental.
|
|
