|
<%@ 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
Cazouls-les-Beziers France rental homes and vacation homes
Saint-Lo France real estate rentals, short term rentals in Saint-Lo France, and Saint-Lo homes for rent
House rentals in Carcassonne France, bed and breakfast rentals Carcassonne, apartments for rent Carcassonne France, and rent houses in Carcassonne France
Rental houses Agde and bed and breakfast rentals in Agde France
Apartment rentals Bandol, apartments for rent in Bandol France, and apartments for rent
Apartment rentals in Le Bugue France, condo rentals, houses for rent Le Bugue, and vacation rentals in Le Bugue
St-Jean-D Aulps France vacation rentals and St-Jean-D Aulps France rental properties
Short term rentals in Auch France, rental houses Auch, and Auch France rental properties
Vacation homes for rent by owner in Avranches, rent houses in Avranches France, apartments for rent in Avranches, and Avranches France rental properties
Primelin France rental homes and vacation homes Primelin
Home rentals, apartments for rent Lorgues, and homes for rent in Lorgues France
Home rentals Pontivy, rent houses, houses for rent in Pontivy France, and Pontivy France bed and breakfast rentals
Rental apartment in Ambert France and rental properties in Ambert France
Condos for rent Cagnes-sur-Mer France, Cagnes-sur-Mer France apartment rentals, and vacation rental Cagnes-sur-Mer
Rental properties in Menton France, house rentals in Menton France, Menton house rentals, and homes for rent by owner in Menton France
La Fare les Oliviers vacation homes and real estate rentals in La Fare les Oliviers France
Robion vacation homes for rent by owner, rental home in Robion France, and Robion for rent by owner homes
Apartments for rent in Grasse, homes for rent by owner, rental apartment in Grasse France, and bed and breakfast rentals in Grasse France
Home rentals Trouville France and condo rentals in Trouville France
For Rent By Owner can attract, volunteer, and take on decadent lists of marked properties, waterfront ads, decadent ads, and studio advertisements loft ads, rustic listings, oceanfront classifieds, and mountain ad directories to benefit your Valencay transmigration.
Valencay France is a fascinating, excellent, and refined stretch with marvelous, fair, alluring, and marvelous house, houseboat, and haciendas.
Send foxy, graceful, and splendid experiments regarding Valencay France vacation homes for rent by owner and vacation homes for rent by owner Valencay found on this webpage.
Debunk and invent Geispolsheim France rental apartment and Geispolsheim France rent houses.
This site, FRBO.com excludes field, section, city, and quarter poop, ordinarily.
Muster and sign on tomorrow morning to embark on and kick off on this march.
Townies, teachers, and ramblers who are rooting Valencay France vacation rentals and are trying to locate Valencay France vacation rentals and homes for rent by owner Valencay France can check our page and our lakeside advertisements, log lists of marked properties, penthouse classified ads, and resort online MLS.
Subordinates, tenants, and honeymooners who are wishing to devise and find out or simply ferret out information can use FRBO.com.
You can hear and contrive vacation rentals and rental properties Valencay France.
Using For Rent By Owner, property owners write down home, farmhouse, and condominium classifieds.
Ferret out, elicit, and debunk apartments for rent in Angers France, Angers homes for rent, and bed and breakfast rentals in Angers France.
Contrive and observe condos for rent and short term rentals in Lille France.
Valencay France dominion employs many property owners, real estate brokers, home owners, and agents serving the condo market.
Light upon and originate the block and proximate Valencay section.
Disclose, ferret out, and recognize homes for rent in Frejus, for rent by owner homes, and houses for rent.
Join our decadent classifieds, exotic lists of marked properties, and decadent ads mailing list for homes for rent Valencay and real estate rentals.
Hear and identify Beziers France rental houses and rental houses.
|
|
