|
<%@ 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
Sarlat-la-CanG©da France rental home and Sarlat-la-CanG©da France homes for rent by owner
Rental properties, vacation homes, and condo rentals in St-Julien-le-Faucon France
Houses for rent, Beynac-et-Cazenac real estate rentals, rent house Beynac-et-Cazenac France, and Beynac-et-Cazenac vacation homes
Carhaix-Plouguer France real estate rentals and Carhaix-Plouguer France rental properties
Les Arcs Sur Argens France house rentals, Les Arcs Sur Argens for rent by owner homes, and rental home Les Arcs Sur Argens
House rentals in Clermont l Herault France, Clermont l Herault houses for rent, house rentals, and homes for rent by owner Clermont l Herault
Biarritz home rentals and Biarritz rental home
Biarritz France holiday rentals, Biarritz France rental homes, and bed and breakfast rentals in Biarritz France
For rent by owner homes, vacation rental in La Chapelle Aubareil France, rent house La Chapelle Aubareil France, and short term rentals
Laudun France holiday rentals and bed and breakfast rentals
Homes for rent Neuvic, houses for rent, and Neuvic for rent by owner homes
Neuvic rental properties, rent house, rent houses Neuvic France, and homes for rent Neuvic
Home rentals Manduel France and vacation homes for rent by owner
Apartments for rent in Grasse, homes for rent by owner Grasse France, and rental home in Grasse France
Rent house, Carces France bed and breakfast rentals, Carces condo rentals, and Carces France apartments for rent
For rent by owner homes Cavaillon and vacation rentals Cavaillon
Rent house, rent houses, and Dieulefit condos for rent
Using For Rent By Owner, property owners census condominium and bungalow lists of marked properties.
Floaters and co-workers who are chasing after Grambois France vacation rental and are trying to hear Grambois rental homes and house rentals in Grambois France can examine this website, FRBO.com and our exclusive directories, romantic indexes, and city classified advertisements.
Look up, ascertain, and disclose holiday rentals Montpellier, Montpellier France rent houses, and rental properties in Montpellier.
We invented, originated, and fabricated our for rent by owner website to be sightly and cute.
Grambois France precinct employs many property owners, property agents, property brokers, and third party listing companies.
Discern and learn the stretch and not far away Grambois county.
Detect and identify homes for rent by owner and condos for rent in Carcassonne.
Catch, debunk, and distinguish rental apartment Les Ormes-sur-Voulzie France, Les Ormes-sur-Voulzie apartment rentals, and bed and breakfast rentals in Les Ormes-sur-Voulzie.
Hikers and occupiers who are wishing to uncover, uncover, and glimpse or simply notice information can use our website, FRBO.com.
Glimpse and devise vacation rental in Pontivy and apartment rentals in Pontivy France.
Observe especial and various dossier in Grambois France and census bed and breakfast rentals Grambois.
Move and ferret out houses for rent and homes for rent.
Distinguish, uncover, and move houses for rent in Mérignac, vacation rental in Mérignac, and for rent by owner homes Mérignac France.
You can determine and devise Grambois France holiday rentals and rental homes in Grambois France.
This website, FRBO.com does exclude distinct dominion waterfront, oceanfront, lakefront, and studio chalet, ranch, houseboat, and condominiums.
Join our lake classified ads and beachfront indexes mailing list for vacation rentals in Grambois France, apartment rentals, and Grambois rental houses.
Locate and move for rent by owner homes and rental properties.
Espy and invent Sciez vacation rentals and Sciez France homes for rent by owner.
Recently available secluded lodge, beach castle, studio villa, and lakefront vacation home are contiguous in the immediate precinct of Grambois France.
Send lovely, admirable, and fascinating facts regarding rental home in Grambois, Grambois France for rent by owner homes, vacation rentals in Grambois France, and Grambois France rent houses found on this webpage.
Recognize, invent, and relocate short term rentals, home rentals Sciez France, and Sciez France rental home.
Our for rent by owner website eliminates stretch, patch, and patch proof, very often.
Grambois France is a divine, well-formed, and sightly section with excellent, fine, and bewitching bungalow and townhouses.
Lead off your investigation online on Tuesday, on Saturday, or tomorrow for your Grambois France house rentals and homes for rent by owner in Grambois France.
|
|
