|
<%@ 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
Biot France real estate rentals and houses for rent in Biot
Apartments for rent in Signes France, short term rentals Signes France, and rental houses in Signes France
Bed and breakfast rentals, house rentals in Viens France, Viens holiday rentals, and apartments for rent Viens France
Vacation homes Cubjac and rental houses in Cubjac
Lacoste homes for rent by owner, Lacoste bed and breakfast rentals, and condos for rent
Rent houses in Ambert France, home rentals in Ambert France, rental properties in Ambert, and rent houses in Ambert France
Condo rentals in Port-Grimaud France and vacation homes in Port-Grimaud France
Auch France homes for rent, Auch France rent house, and rental houses Auch
Vacation homes in Chasteaux, short term rentals, vacation rentals in Chasteaux, and home rentals in Chasteaux
Bed and breakfast rentals Venasque France and Venasque France house rentals
Rental houses, La Hume house rentals, and house rentals in La Hume France
Rental home Pontlevoy, bed and breakfast rentals, vacation rental Pontlevoy, and Pontlevoy France rental home
Condos for rent and vacation homes
Lacoste apartments for rent, Lacoste rental houses, and Lacoste France apartment rentals
Apartment rentals in Lorgues France, Lorgues vacation homes, house rentals Lorgues France, and rental home in Lorgues France
Houses for rent in Coutances France and Coutances France condos for rent
Vence France homes for rent by owner, Vence France vacation rentals, and rental home in Vence France
Houses for rent in St Saveur de Carrouges France, condo rentals in St Saveur de Carrouges, St Saveur de Carrouges France bed and breakfast rentals, and St Saveur de Carrouges France short term rentals
Apartment rentals Gordes France and houses for rent
Vaison-la-Romaine France apartment rentals, apartment rentals in Vaison-la-Romaine, and real estate rentals in Vaison-la-Romaine France
Rent houses in Granville France, vacation homes Granville, rental home, and rental houses in Granville France
Golfe-Juan homes for rent by owner and rental houses in Golfe-Juan France
Apartment rentals in Monoblet France, holiday rentals in Monoblet France, and Monoblet France apartments for rent
Bed and breakfast rentals in Caromb France, short term rentals in Caromb France, vacation homes for rent by owner in Caromb France, and rental houses Caromb
Home rentals Signes and Signes France apartments for rent
Vacation homes for rent by owner Chamonix-Mont-Blanc France, real estate rentals in Chamonix-Mont-Blanc France, and for rent by owner homes in Chamonix-Mont-Blanc
Barcelonnette for rent by owner homes, rental homes in Barcelonnette France, real estate rentals in Barcelonnette France, and real estate rentals in Barcelonnette France
Traveling sales representatives and sisters investigate and frisk our for rent by owner site, FRBO.com and invent studio vacation home, beachfront bungalow, waterfront home, and convenient house.
Move and debunk Lourdes France vacation homes for rent by owner and vacation rental in Lourdes.
Violes dossier could back and work with your investigation.
Vacated exotic condominium, exclusive apartment, spacious condominium, and private castle are adjacent in the not far turf of Violes.
We created and fashioned FRBO.com to be magnificent, enticing, resplendent, and lovely.
Procure, conscribe, muster, and enroll on Friday to originate, lead off, kick off, and initiate on this safari.
Violes real estate agents and agents serving the condo market list Violes vacation rental and holiday rentals.
Contrive, light upon, and glimpse Arcachon France home rentals, Arcachon France holiday rentals, and homes for rent by owner in Arcachon.
Come upon and look up vacation homes for rent by owner and Elancourt France rent house.
Locate, perceive, and hear Auxerre vacation homes for rent by owner, rental homes Auxerre France, and rental homes Auxerre.
The Violes France exclusive advertisements and mountain directories for these sector can be mapped.
Uncover, find out, and relocate house rentals in La Garde-Freinet France, house rentals, and vacation homes La Garde-Freinet.
Ascertain, ascertain, and determine home rentals Chambery, holiday rentals in Chambery, and Chambery condos for rent.
Glimpse and recognize rental properties Marcq-En-Baroeul France and Marcq-En-Baroeul France apartments for rent.
Contrive and discern Lille France vacation rental and holiday rentals Lille.
Send pulchritudinous, ideal, and comely poop sheet regarding homes for rent by owner, vacation rentals, and Violes rent houses found on our site, FRBO.com.
Distinguish and debunk vacation rental Saint-Julien-en-Genevois and real estate rentals in Saint-Julien-en-Genevois.
Conceive, contrive, and light upon rental apartment in Avignon France, short term rentals, and Avignon rental apartment.
Ferret out, discover, and determine Saint-Etienne France rent house, condos for rent Saint-Etienne France, and Saint-Etienne France rental apartment.
Violes France is a symmetrical and radiant parcel with statuesque, resplendent, delicate, and sightly cabin and townhouses.
You can glimpse, catch, and discern apartments for rent Violes France and rental homes.
|
|
