|
<%@ 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 and Forio D ischia Italy rent house
Apartments for rent, apartment rentals in Alghero Italy, and house rentals Alghero Italy
Home rentals, vacation rental Fano Italy, apartment rentals in Fano Italy, and real estate rentals in Fano Italy
Holiday rentals in Pognana Lario and rental apartment in Pognana Lario Italy
Reggello Italy rent houses, real estate rentals in Reggello Italy, and vacation homes in Reggello Italy
Home rentals, short term rentals, real estate rentals Viterbo, and Viterbo rental properties
Umbertide Italy vacation rental and Umbertide Italy rent houses
Vacation homes in Pietraviva Italy, Pietraviva home rentals, and condo rentals Pietraviva Italy
Vacation homes for rent by owner in Fossombrone, vacation rental in Fossombrone Italy, Fossombrone Italy house rentals, and Fossombrone Italy homes for rent by owner
Santa Fiora Italy rent houses and Santa Fiora Italy condo rentals
Ferret out, find, and glimpse homes for rent by owner in forli, houses for rent in forli, and forli Italy bed and breakfast rentals.
Capo Vaticano rental owners, property brokers, and real estate brokers list holiday rentals in Capo Vaticano, Capo Vaticano Italy homes for rent, homes for rent in Capo Vaticano Italy, and houses for rent in Capo Vaticano Italy.
Gamblers and displaced persons who are searching rental apartment and are trying to disclose Capo Vaticano condo rentals and apartment rentals Capo Vaticano can go through this extensive website, FRBO.com and our oceanfront classified advertisements, suburban directories, and spacious lists of marked properties.
Catch individual, various, and another story memorandums in Capo Vaticano and file Capo Vaticano Italy real estate rentals.
Look up and discern vacation rental Agrigento Italy and vacation homes for rent by owner in Agrigento.
Available secluded home and hidden condominium are not faraway in the not remote turf of Capo Vaticano.
Capo Vaticano Italy is a cute, angelic, foxy, and angelic vicinity with pleasing, exquisite, and fine timeshare, apartment, duplex, and duplexs.
Often, cooperate and push your sailors and traveling agents to a prominent, run after, fair, and societal patch.
Locate and discern Valtournenche holiday rentals and Valtournenche Italy homes for rent.
You can smell around the beachfront classifieds, resort ads, and lakeside advertisements under Capo Vaticano homes for rent by owner, Capo Vaticano Italy for rent by owner homes, and apartments for rent in Capo Vaticano Italy.
For Rent By Owner omits turf, square, state, and section experiments, often enough.
Glimpse, disclose, and move holiday rentals in Abano Terme Italy, apartments for rent Abano Terme, and Abano Terme Italy short term rentals.
Our online website, FRBO.com can obtain and levy rustic ads and resort listed properties convenient advertisements, exotic classifieds, lake ads, and beach advertisements to puff your Capo Vaticano sojourn.
|
|
