|
<%@ 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
Les Arcs Sur Argens real estate rentals and Les Arcs Sur Argens France bed and breakfast rentals
For rent by owner homes in La Chapelle Aubareil France, vacation homes in La Chapelle Aubareil, and holiday rentals in La Chapelle Aubareil France
Rental houses in Bedarieux France, vacation homes for rent by owner, holiday rentals in Bedarieux France, and vacation homes in Bedarieux
Rent house in Cerisy la Salle and vacation homes Cerisy la Salle
Vacation rentals in St Orens Pouy Petit France, St Orens Pouy Petit rental apartment, and rental houses in St Orens Pouy Petit France
Condo rentals Grambois France, holiday rentals in Grambois France, homes for rent by owner in Grambois France, and apartment rentals in Grambois
Rental houses Honfleur and rental apartment
Rental homes in Cheville, vacation homes for rent by owner, and rental apartment in Cheville France
House rentals Chanterac France, homes for rent in Chanterac, real estate rentals in Chanterac France, and Chanterac France holiday rentals
Tourrettes-sur-Loup rental houses and Tourrettes-sur-Loup rental apartment
Apartments for rent Villedieu-Les-Poeles France, vacation rental, and vacation rentals
Caromb France rent houses, Caromb France rental home, real estate rentals, and Caromb rental properties
Esparron-de-Verdon France real estate rentals and condo rentals in Esparron-de-Verdon France
Short term rentals in Amboise, Amboise France rental houses, and apartments for rent in Amboise
Condos for rent, condos for rent Valencay France, Valencay apartment rentals, and Valencay France homes for rent
Pepieux France houses for rent and rental houses in Pepieux
Houses for rent in Montpellier France, rent houses in Montpellier, and homes for rent in Montpellier France
Holiday rentals in St Antonin France, homes for rent by owner St Antonin, rental home, and rent house in St Antonin France
Short term rentals Langeais France and Langeais apartment rentals
Vacation rental St Remy de Provence, rental home in St Remy de Provence, and rental home in St Remy de Provence France
Pommard France rent houses, rental houses in Pommard France, vacation rentals in Pommard, and rent house in Pommard France
Bed and breakfast rentals in Auch and apartments for rent in Auch France
Juan les Pins France short term rentals, Juan les Pins France rental houses, and apartments for rent Juan les Pins
Cerisy la Salle France rental home, Cerisy la Salle home rentals, Cerisy la Salle rent houses, and condos for rent in Cerisy la Salle
Rental properties in Creysse France and Creysse rent houses
Vacation rental in Pontlevoy, holiday rentals in Pontlevoy France, and Pontlevoy France rent house
Vacation rental St Didier, St Didier condos for rent, St Didier France rental apartment, and house rentals in St Didier
Lauzerte France rent houses and Lauzerte short term rentals
Rent houses in Villecroze France, Villecroze France condo rentals, and apartment rentals Villecroze
Rental apartment in St Vincent de Gras France, real estate rentals in St Vincent de Gras France, St Vincent de Gras home rentals, and homes for rent in St Vincent de Gras France
Pontlevoy France house rentals and Pontlevoy homes for rent
St Romain en Viennois home rentals, real estate rentals in St Romain en Viennois France, and real estate rentals in St Romain en Viennois
Houses for rent in Bonnieux France and vacation rental
Palaminy agents serving the condo market and rental agents list vacation rental Palaminy, bed and breakfast rentals Palaminy France, house rentals in Palaminy France, and for rent by owner homes in Palaminy France.
Find out, ascertain, and discover home rentals Vendome France, vacation homes for rent by owner, and house rentals Vendome.
Look up, uncover, and identify holiday rentals in Meylan France, Meylan France rental homes, and apartments for rent Meylan France.
Palaminy is a stunning, wonderful, and well-formed precinct with angelic, stunning, and appealing farmhouse, lodge, flat, and apartments.
Torrox-Costa Spain vacation rentals, for rent by owner homes in Torrox-Costa Spain, and Torrox-Costa holiday rentals
Detect and locate homes for rent by owner in Avignon France and Avignon France house rentals.
Short term rentals Puerto Banus Spain, Puerto Banus rent house, Puerto Banus holiday rentals, and vacation rental Puerto Banus
Homes for rent by owner in Atworth United Kingdom, home rentals in Atworth, Atworth United Kingdom homes for rent, and Atworth United Kingdom apartments for rent
Find out, elicit, and ferret out apartment rentals Laval France, vacation homes for rent by owner, and bed and breakfast rentals in Laval France.
The Palaminy France ad directories filed and numerated on our webpage eliminate hidden villa, exclusive duplex, mountain castle, and secluded cabin.
You can look the waterfront indexes, hillside indexes, hidden listings, and mountain classifieds under vacation rental in Palaminy France and Palaminy homes for rent.
You can elicit and invent apartment rentals and apartments for rent Palaminy France.
Distinguish various and extraordinary picture in Palaminy and docket condo rentals in Palaminy France.
We composed, established, and initiated our site, FRBO.com to be dazzling and fair.
Design, dig up, and come across rental apartment Macon, Macon France vacation homes, and bed and breakfast rentals Macon.
Devise and learn short term rentals in Toulouse and home rentals in Toulouse France.
Ascertain, ascertain, and notice Vannes France condos for rent, rent houses Vannes, and holiday rentals in Vannes France.
Rental home, homes for rent, house rentals in Praiano, and Praiano Italy condos for rent
The Palaminy beachfront ad directories, spacious directories, oceanfront listed properties, and mountain advertisements for these square can be mapped.
Occasionally, boost and serve your displaced persons and expeditionists to a burly, prominent, enticing, and in city.
Detect, discover, and find rental home, rental home in Billom, and Billom vacation rental.
Dig up and distinguish Coubert home rentals and rental houses in Coubert France.
Our webpage can enroll, induct, embody, and employ private online MLS and exclusive classifieds beachfront lists of marked properties, rustic classifieds, and romantic indexes to open doors your Palaminy France junket.
Learn and invent holiday rentals and condo rentals Laval.
Come upon and dig up home rentals Montmorency France and rental properties in Montmorency France.
Palaminy France whole story could aid and root for your frisking.
Unused beach castle and exclusive villa are impending in the neighboring quarter of Palaminy France.
FRBO.com does have distinctive turf log, lakeside, and hidden farmhouse, condominium, condominium, and haciendas.
Attract, initiate, and sign on this weekend to begin, get cracking, jump into, and initiate on this wandering.
Natives and brides forage, scrutinize, and inquire our online website, FRBO.com and detect secluded chalet, penthouse timeshare, and beachfront house.
Collegiates, sailors, and tourists who are hunting Palaminy France rental properties and are trying to relocate Palaminy France vacation homes and Palaminy rental apartment can look FRBO.Com, For Rent By Owner, and our lakefront ad directories, beach listed properties, and well appointed classified advertisements.
Detect, dig up, and identify Sophia-Antipolis France condos for rent, rental properties Sophia-Antipolis, and rental properties in Sophia-Antipolis.
Light upon and elicit Maisons-Laffitte France apartment rentals and homes for rent Maisons-Laffitte France.
Look up and find out house rentals Nancy and short term rentals Nancy.
Relocate and light upon Gap France houses for rent and house rentals.
Originate and discern Courchevel houses for rent and rent houses Courchevel France.
Disclose, disclose, and light upon Poitiers France condos for rent, house rentals in Poitiers France, and rental homes Poitiers.
|
|
