|
<%@ 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
Holiday rentals in Riomaggiore Italy and Riomaggiore vacation rentals
Rental houses in Feltre Italy, home rentals in Feltre, and rent houses in Feltre Italy
Homes for rent by owner Collazzone Italy, Collazzone homes for rent, rental homes in Collazzone Italy, and rent houses in Collazzone Italy
Short term rentals Monte San Savino and vacation homes for rent by owner in Monte San Savino Italy
Homes for rent in Avellino, Avellino Italy condos for rent, and Avellino Italy rent house
Barberino di Mugello Italy condo rentals, home rentals Barberino di Mugello Italy, rent houses in Barberino di Mugello Italy, and apartment rentals in Barberino di Mugello
Cortona Italy homes for rent by owner and rental apartment in Cortona
Vacation rental in Pescaglia Italy, rental homes in Pescaglia Italy, and vacation rentals
Apartments for rent, Piazza di Spagna-Spanish Steps Italy for rent by owner homes, holiday rentals Piazza di Spagna-Spanish Steps Italy, and Piazza di Spagna-Spanish Steps Italy apartment rentals
Real estate rentals Aventino Testaccio and rent houses Aventino Testaccio
Gattaiola Italy house rentals, rental houses in Gattaiola, and houses for rent Gattaiola
San Giovanni-St John Lateran apartments for rent, San Giovanni-St John Lateran Italy vacation homes, San Giovanni-St John Lateran apartments for rent, and short term rentals
Palau for rent by owner homes and apartments for rent
Homes for rent by owner in Salerno Italy, vacation homes for rent by owner in Salerno Italy, and condo rentals in Salerno Italy
Cefalu Italy homes for rent, homes for rent by owner in Cefalu Italy, Cefalu Italy bed and breakfast rentals, and rent houses in Cefalu Italy
Vacation rentals in Osimo Italy and Osimo condo rentals
Bed and breakfast rentals Pietraviva, homes for rent in Pietraviva Italy, and house rentals in Pietraviva Italy
Initiate and obtain tomorrow afternoon to get going, take up, open, and jump into on this voyage.
The Montalcino Italy online MLS calendar and specialized on our website, FRBO.com except well appointed cottage, decadent home, oceanfront ranch, and suburban townhouse.
You can espy, distinguish, and distinguish Montalcino Italy rental home and bed and breakfast rentals in Montalcino Italy.
Montalcino Italy is a pleasing, taking, and good-looking county with grand, statuesque, ravishing, and delightful bungalow and castles.
Originate, learn, and move Cosenza Italy bed and breakfast rentals, Cosenza rent houses, and apartments for rent in Cosenza Italy.
Using our online website, FRBO.com, real estate investors itemize apartment and houseboat classifieds.
Montalcino knowledge could further, stump, and sustain your witch hunt.
Professors and traveling men poke into, scan, and rake FRBO.Com, For Rent By Owner, and detect mountain vacation home, secluded townhouse, city timeshare, and loft lodge.
Observe and ascertain vacation homes in Caltanissetta and rent house in Caltanissetta Italy.
This extensive website, FRBO.com does comprise uncommon field loft, private, city, and exotic ranch and chalets.
We phrased, occasioned, and discovered this website, FRBO.com to be gorgeous and foxy.
Uncover, recognize, and learn rent house Campobasso Italy, condo rentals, and Campobasso Italy vacation rental.
Hear and uncover Caserta Italy short term rentals and homes for rent by owner in Caserta Italy.
Discover and locate Pedavena Italy short term rentals and house rentals in Pedavena Italy.
Discern and devise rental homes Cisterna Italy and Cisterna Italy house rentals.
Montalcino land owners and property owners list Montalcino Italy vacation rental and rental properties in Montalcino Italy.
|
|
