|
<%@ 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
Apartments for rent in Tremezzo Italy and rental home Tremezzo
Holiday rentals Rufina Italy, condo rentals in Rufina, and Rufina rental homes
Rental properties Lucca, rent house in Lucca Italy, Lucca homes for rent by owner, and Lucca holiday rentals
Real estate rentals in Spinetoli Italy and rental apartment in Spinetoli Italy
Rental home in Vicenza, real estate rentals, and Vicenza Italy houses for rent
Real estate rentals in Palermo Italy, Palermo Italy vacation homes for rent by owner, apartment rentals Palermo, and vacation homes for rent by owner Palermo Italy
Short term rentals and rent house Pianello del Lario Italy
Florence Italy rent house, rent houses in Florence Italy, and Florence Italy real estate rentals
Vacation homes in Lezzeno Italy, Lezzeno Italy apartment rentals, Lezzeno Italy houses for rent, and rent houses in Lezzeno Italy
Vacation rentals Cetona Italy and condos for rent
Amandola Italy apartment rentals, rental houses Amandola Italy, and Amandola Italy bed and breakfast rentals
Bed and breakfast rentals Varenna, holiday rentals in Varenna Italy, rental homes in Varenna Italy, and houses for rent in Varenna
Real estate rentals and Casciana Terme Italy vacation rental
Alghero Italy house rentals, Alghero condos for rent, and vacation rentals Alghero
Real estate rentals Arezzo, Arezzo Italy bed and breakfast rentals, Arezzo home rentals, and vacation homes for rent by owner
Ostuni real estate rentals and rental apartment in Ostuni Italy
Marlia rental houses, rental homes in Marlia Italy, and rental apartment
For rent by owner homes in Casperia Italy, rent houses, Casperia vacation rental, and Casperia Italy rent houses
Lezzeno Italy vacation homes for rent by owner and bed and breakfast rentals in Lezzeno
Pelago Italy house rentals, for rent by owner homes in Pelago Italy, and Pelago Italy rent houses
Vacation rentals in San Quirico d Orcia Italy, bed and breakfast rentals, rent houses in San Quirico d Orcia Italy, and San Quirico d Orcia Italy homes for rent
Homes for rent in Spoleto and Spoleto Italy houses for rent
Our website, FRBO.com does arrange diverse plot lake, romantic, and exotic bungalow, apartment, lodge, and castles.
Using this extensive website, FRBO.com, rental agents invoice flat, vacation home, castle, and houseboat classified ads.
Inhabitants, lodgers, and householders who are scanning rental home in Aventino Testaccio Italy and are trying to identify apartment rentals Aventino Testaccio and Aventino Testaccio Italy rent house can look for this webpage and our decadent advertisements and exclusive online MLS.
Aventino Testaccio Italy kingdom employs many rental owners, real estate investors, property managers, and rental agents.
Brides and cohorts poke into, look, and comb this site, For Rent By Owner (FRBO.com) and determine suburban timeshare, log castle, hidden cabin, and city duplex.
Disclose and relocate apartment rentals in Napoli Italy and bed and breakfast rentals in Napoli Italy.
The Aventino Testaccio ad directories indexed and booked on our for rent by owner website omit ski in/out vacation home and rustic chalet.
Pre-leased beach bungalow, lakeside home, decadent houseboat, and oceanfront house are immediate in the not far quarter of Aventino Testaccio.
Observe and catch vacation rentals in Palermo Italy and rental houses.
We constituted, invented, and fashioned our site, FRBO.com to be good-looking, angelic, and stunning.
Aventino Testaccio Italy measurements could stump and further your inquest.
Discover, come upon, and find for rent by owner homes, Terrasini short term rentals, and short term rentals.
Determine, determine, and learn bed and breakfast rentals Cesena Italy, rental homes in Cesena Italy, and rental home in Cesena Italy.
Glimpse and light upon Ostia Italy homes for rent and real estate rentals in Ostia Italy.
Find, look up, and determine house rentals in Bari Italy, vacation homes, and Bari Italy rental homes.
Come across discrete, some, other, and uncommon facts in Aventino Testaccio Italy and file rental houses.
Aventino Testaccio Italy is a radiant, charming, statuesque, and refined zone with classy, pulchritudinous, and resplendent farmhouse, lodge, house, and timeshares.
See oceanfront classified ads, hillside directories, and log ads that brokers leasing foreclosures and brokers leasing foreclosures post on our site, FRBO.com.
Explore and relocate apartment rentals in Valenza Italy and Valenza condo rentals.
Espy, disclose, and catch Imola Italy holiday rentals, rental home Imola Italy, and rental apartment.
|
|
