|
<%@ 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
Home rentals in La Napoule and La Napoule France apartment rentals
Tornac France houses for rent, for rent by owner homes, and for rent by owner homes in Tornac
Penguilly France rental home, bed and breakfast rentals, Penguilly vacation rental, and for rent by owner homes in Penguilly
Rental houses and home rentals in Ancy-le-Franc France
For rent by owner homes in Palaminy, Palaminy homes for rent by owner, and Palaminy France vacation homes
Rent houses in Armagnac Region France, Armagnac Region France bed and breakfast rentals, real estate rentals in Armagnac Region, and homes for rent by owner in Armagnac Region France
Primelin France rental apartment and real estate rentals in Primelin France
Homes for rent by owner, homes for rent Neuilly-Sur-Seine, and apartments for rent in Neuilly-Sur-Seine France
Rental homes in St-Junien, house rentals, vacation homes, and St-Junien apartments for rent
Rent houses Primelin and Primelin condos for rent
Oupia France vacation rental, Oupia France rent house, and vacation homes for rent by owner Oupia France
Homes for rent in Arles, rental home in Arles France, condos for rent in Arles France, and condos for rent in Arles France
House rentals in Andlau France and house rentals in Andlau France
House rentals in St Aygulf France, St Aygulf France rent houses, and St Aygulf rental home
Civray France vacation homes for rent by owner, Civray France for rent by owner homes, Civray rent house, and apartment rentals in Civray
Pommard rent houses and Pommard France homes for rent by owner
Our for rent by owner site, FRBO.com can engage and list penthouse ads, private classified advertisements, and hidden ad directories loft ads, hidden classified advertisements, and lakeside classified advertisements to ride shotgun your Eguilles France transit.
We concocted and procreated this webpage to be lovely, bewitching, and admirable.
Pre-rented waterfront cabin and exclusive cottage are next in the imminent section of Eguilles.
Distinguish startling, diverse, and startling statistics in Eguilles and bill real estate rentals Eguilles France.
Ferret out and come upon real estate rentals Chantilly France and apartments for rent Chantilly France.
Not infrequently, abet and relieve your indwellers and traveling agents to a noted, fashionable, fetching, and winsome patch.
Eguilles dossier could open doors and plug your scrutiny.
Ascertain, debunk, and discover apartment rentals Bourges, Bourges short term rentals, and short term rentals in Bourges.
Using our webpage, third party listing companies enroll flat, houseboat, timeshare, and cabin online MLS.
You can scrutinize the studio directories, beachfront classified advertisements, exotic classified ads, and beach classifieds under Eguilles France rental properties and holiday rentals Eguilles.
Notice, relocate, and identify Viry Noureuil France condos for rent, Viry Noureuil France homes for rent by owner, and condo rentals Viry Noureuil.
Travelers, wanderers, and habitants who are scouting vacation homes for rent by owner in Eguilles France and are trying to design Eguilles vacation rental, condos for rent, and rental home in Eguilles France can explore For Rent By Owner and our mountain directories, log indexes, resort indexes, and decadent indexes.
Design and explore vacation homes and apartment rentals in Le Mans.
Identify, hear, and observe Terrasson France homes for rent, Terrasson rental home, and apartment rentals.
Conscribe, procure, appoint, and list on Sunday to tear into, inaugurate, and kick off on this course.
Eguilles France stretch employs many property agents, brokers leasing foreclosures, agents serving the condo market, and agents.
|
|
