|
<%@ 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
Home rentals Piano Di Sorrento Italy and rental apartment Piano Di Sorrento
Trevi Italy rental home, real estate rentals, and holiday rentals in Trevi
Vacation rentals Rapolano Terme, apartments for rent in Rapolano Terme Italy, rent houses Rapolano Terme, and apartment rentals Rapolano Terme
Real estate rentals and apartments for rent
Rapolano Terme for rent by owner homes, holiday rentals Rapolano Terme, and Rapolano Terme Italy rent houses
For rent by owner homes in Pontassieve Italy, Pontassieve Italy vacation rentals, houses for rent Pontassieve, and vacation homes in Pontassieve
Fiaiano Italy rental home and homes for rent by owner in Fiaiano Italy
Vacation homes Pistoia, Pistoia vacation homes, and rental houses Pistoia Italy
Bracciano Italy houses for rent, rental apartment in Bracciano Italy, Bracciano Italy condos for rent, and holiday rentals Bracciano Italy
Trevignano Romano Italy home rentals and home rentals Trevignano Romano Italy
Home rentals in Anghiari, rental properties Anghiari Italy, and homes for rent by owner in Anghiari Italy
Vacation homes, Montichiari Italy vacation rental, condos for rent Montichiari Italy, and vacation homes for rent by owner in Montichiari Italy
House rentals in Toirano Italy and real estate rentals Toirano Italy
Rent house Fossombrone Italy, vacation homes for rent by owner Fossombrone Italy, and rental home in Fossombrone Italy
Forte dei Marmi vacation rentals, vacation homes in Forte dei Marmi, Forte dei Marmi Italy real estate rentals, and Forte dei Marmi Italy homes for rent
Tremezzo Italy condo rentals and real estate rentals in Tremezzo Italy
Reggello Italy bed and breakfast rentals, Reggello Italy condo rentals, and vacation rentals in Reggello Italy
Condos for rent, short term rentals in Stintino Italy, houses for rent in Stintino Italy, and Stintino Italy rental home
Castelnuovo Berardenga homes for rent and Castelnuovo Berardenga Italy home rentals
San Casciano in Val di Pesa condo rentals, San Casciano in Val di Pesa Italy rental properties, and rent houses in San Casciano in Val di Pesa
San Giovanni-St John Lateran Italy rent houses, homes for rent by owner, rent house San Giovanni-St John Lateran, and holiday rentals in San Giovanni-St John Lateran Italy
Paciano bed and breakfast rentals and rent house Paciano Italy
Fara In Sabina Italy homes for rent by owner, vacation rental in Fara In Sabina Italy, and Fara In Sabina short term rentals
Houses for rent Careno, rental homes in Careno, Careno Italy bed and breakfast rentals, and condo rentals in Careno Italy
Colosseo Foro Romano-Coliseum & Roman Forum home rentals and apartments for rent
Homes for rent by owner Monte Verde, houses for rent in Monte Verde Italy, and vacation homes in Monte Verde Italy
Vacation rentals Finale Ligure Italy, homes for rent in Finale Ligure Italy, Finale Ligure for rent by owner homes, and homes for rent by owner in Finale Ligure
Home rentals in Montpellier France, Montpellier France condo rentals, and apartment rentals Montpellier France
Using FRBO.com, home owners specialize villa and condominium directories.
The Zoagli listings ticked off and entered on our for rent by owner site, FRBO.com enclose well appointed cabin, ski in/out hacienda, and well appointed condominium.
Our for rent by owner site, FRBO.com encloses section and domain evidence, regularly.
Elicit, distinguish, and relocate Avellino homes for rent by owner, home rentals in Avellino Italy, and rent houses Avellino Italy.
Send cute, beauteous, refined, and superb abstracts regarding vacation rental Zoagli, Zoagli Italy homes for rent by owner, and rent house in Zoagli Italy found on this site, FRBO.com.
Unused private condominium, oceanfront townhouse, lakefront flat, and romantic houseboat are adjacent in the convenient patch of Zoagli.
Comrades, tourists, and locals hunt for and frisk this webpage and catch loft farmhouse and exotic castle.
This site, For Rent By Owner (FRBO.com) can draft, attract, induct, and obtain beach classified ads and exclusive classified ads loft classified advertisements and exotic lists of marked properties to open doors your Zoagli Italy trek.
Discern and recognize apartments for rent Lainate and Lainate Italy house rentals.
Zoagli is a grand, cute, elegant, and exquisite domain with radiant and ravishing cabin, hacienda, houseboat, and chalets.
Find and explore rental home and homes for rent by owner Torino Italy.
You can locate, invent, and contrive rental homes and Zoagli Italy condo rentals.
See mountain ad directories and well appointed online MLS that agents serving the condo market and town home owners post on FRBO.com.
Perceive, come upon, and observe apartment rentals Augusta, rental homes in Augusta, and holiday rentals in Augusta.
Mirambeau France condo rentals, vacation rental in Mirambeau France, rent houses in Mirambeau, and bed and breakfast rentals Mirambeau France
Zoagli territory employs many property managers, third party agents, real estate investors, and real estate investors.
|
|
