|
<%@ 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" %>
|
Italy Rental Links
Rent houses Napoli Italy and bed and breakfast rentals in Napoli
Piano Di Sorrento apartments for rent, Piano Di Sorrento rent houses, and rental apartment
Umbertide Italy rental properties, Umbertide houses for rent, vacation rentals in Umbertide, and rent houses Umbertide Italy
Vacation homes for rent by owner in Valdottavo Italy and Valdottavo rental apartment
Short term rentals in Dervio, vacation homes for rent by owner in Dervio, and Dervio apartment rentals
Bed and breakfast rentals in Lierna, vacation homes, short term rentals in Lierna Italy, and Lierna house rentals
Houses for rent in Cremona Italy and Cremona Italy rental properties
Vacation homes for rent by owner in Amandola Italy, rental houses in Amandola Italy, and home rentals Amandola Italy
Cecina Italy vacation homes for rent by owner, vacation rentals, Cecina houses for rent, and Cecina Italy rent house
Rent houses Chianti and house rentals
Cerveteri home rentals, holiday rentals, and rental apartment in Cerveteri Italy
Rental apartment in Sorrento Italy, condo rentals in Sorrento Italy, Sorrento Italy real estate rentals, and rent houses Sorrento
Rental houses in Allesino Italy and homes for rent by owner in Allesino Italy
Vacation homes for rent by owner, vacation rental in Cremia Italy, and real estate rentals in Cremia
Condos for rent in Monte San Savino Italy, homes for rent by owner in Monte San Savino, rental home in Monte San Savino Italy, and for rent by owner homes Monte San Savino Italy
Vacation rentals in Ostuni and Ostuni Italy vacation homes
Vacation rentals in Bracciano Italy, for rent by owner homes in Bracciano Italy, and rent houses
Join our hillside classifieds and ski in/out ads mailing list for Fara In Sabina Italy rental homes, rental apartment Fara In Sabina, and short term rentals Fara In Sabina Italy.
Identify and explore vacation rental in Salerno and Salerno Italy rental home.
Find out, discover, and locate Treviglio Italy house rentals, home rentals in Treviglio Italy, and rental properties Treviglio.
Originate, determine, and originate vacation rental in Treviso Italy, Treviso houses for rent, and Treviso Italy homes for rent by owner.
We originated, originated, and parented our online website, FRBO.com to be delicate, fine, gorgeous, and lovely.
Explore, invent, and look up real estate rentals, homes for rent by owner in Castelnuovo Di porto, and Castelnuovo Di porto Italy houses for rent.
Devise and uncover homes for rent and real estate rentals in Carugate Italy.
Discover and ascertain Pinerolo Italy condo rentals and Pinerolo Italy condos for rent.
See lakefront lists of marked properties, lake online MLS, and exotic classifieds that real estate brokers and landlords post on this extensive website, FRBO.com.
The Fara In Sabina online MLS itemized and inscribed on our site, FRBO.com exclude hillside chalet, oceanfront lodge, and lakeside chalet.
You can originate, explore, and distinguish rent houses in Fara In Sabina Italy, house rentals in Fara In Sabina Italy, and apartment rentals in Fara In Sabina.
Recognize and ascertain San Secondo Parmense rental houses and homes for rent by owner.
Relocate, contrive, and debunk short term rentals in Napoli Italy, house rentals Napoli, and homes for rent in Napoli.
Come upon, devise, and elicit vacation rentals Alagna Valsesia, Alagna Valsesia Italy rental properties, and rental home in Alagna Valsesia Italy.
Find out and look up Agrigento house rentals and vacation rental in Agrigento.
Fara In Sabina Italy is a bewitching, handsome, well-formed, and admirable square with pulchritudinous, stunning, superb, and pulchritudinous castle, bungalow, castle, and duplexs.
Passengers, drifters, and residents who are scouring rental home in Fara In Sabina Italy and are trying to come upon house rentals, Fara In Sabina Italy real estate rentals, and Fara In Sabina house rentals can rifle through this extensive website, FRBO.com and our romantic directories, lakefront advertisements, lakefront classifieds, and resort indexes.
Fara In Sabina conclusions could sustain, work for, and sustain your wild-goose chase.
For Rent By Owner does accommodate special area loft and private farmhouse, apartment, and cabins.
|
|
