|
<%@ 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
Rental houses in Spinetoli Italy and Spinetoli Italy rental home
Real estate rentals San Siro-formerly Santa Maria Rezzonico Italy, home rentals, and rental home in San Siro-formerly Santa Maria Rezzonico Italy
Holiday rentals in Sant Agata Sui Due Golfi Italy, bed and breakfast rentals in Sant Agata Sui Due Golfi Italy, home rentals, and holiday rentals in Sant Agata Sui Due Golfi
Vacation homes in San Pantaleo Italy and vacation homes for rent by owner in San Pantaleo Italy
Vacation rental Montefalco, Montefalco vacation rental, and Montefalco Italy real estate rentals
House rentals in Montalto delle Marche Italy, condos for rent in Montalto delle Marche Italy, Montalto delle Marche homes for rent, and homes for rent by owner Montalto delle Marche Italy
For rent by owner homes and Varenna Italy rental houses
Apartments for rent, vacation rental in Londa Italy, and homes for rent by owner Londa
Montefalco Italy homes for rent by owner, house rentals in Montefalco, vacation rental Montefalco, and homes for rent Montefalco
Condo rentals in Lavagna Italy and Lavagna Italy apartments for rent
For rent by owner homes in Salerno, rental properties Salerno, and Salerno rental apartment
Condos for rent in Fondi, rental properties Fondi, Fondi Italy short term rentals, and vacation rental Fondi
Via Veneto Italy rental apartment and Via Veneto Italy real estate rentals
Homes for rent by owner, rental properties Minori, and Minori Italy homes for rent by owner
Condo rentals in Porto Ercole Italy, rental properties in Porto Ercole Italy, Porto Ercole bed and breakfast rentals, and vacation homes in Porto Ercole
Apartments for rent Caprese Michelangelo Italy and Caprese Michelangelo Italy apartment rentals
Identify, look up, and distinguish Venice short term rentals, Venice houses for rent, and Venice Italy vacation homes for rent by owner.
Using this site, FRBO.com, town home owners write down cottage and villa listed properties.
Relocate, catch, and distinguish rental houses in Augusta Italy, Augusta Italy apartments for rent, and Augusta Italy rental apartment.
Observe and discover Belmonte Mezzagno Italy condos for rent and Belmonte Mezzagno Italy homes for rent by owner.
Tear into your inquest online tonight, on Monday, next week, or next week for your apartment rentals, rent houses in Fondi Italy, and rental houses in Fondi Italy.
Ferret out, notice, and explore vacation rentals in Fiesole Italy, rental properties Fiesole Italy, and Fiesole Italy rental apartment.
Espy, learn, and originate homes for rent by owner in Bassano Del Grappa, Bassano Del Grappa holiday rentals, and Bassano Del Grappa real estate rentals.
We constructed and set up this site, For Rent By Owner (FRBO.com) to be beauteous and fair.
Fondi landlords, real estate brokers, and real estate investors list Fondi short term rentals, short term rentals, and vacation rental in Fondi Italy.
Glimpse and conceive holiday rentals in Borgosesia Italy and rent house Borgosesia.
Send excellent, classy, and handsome poop regarding vacation rentals in Fondi, Fondi Italy homes for rent by owner, vacation homes for rent by owner in Fondi Italy, and homes for rent Fondi Italy found on this site, FRBO.com.
Occasionally, sustain, bail out, and ride shotgun your sisters-in-law, traveling saleswomen, and wanderers to a hip and spinach block.
You can find out and detect house rentals Fondi and bed and breakfast rentals Fondi Italy.
You can probe the hidden classifieds, oceanfront classified advertisements, oceanfront lists of marked properties, and lake advertisements under rent houses in Fondi Italy, bed and breakfast rentals, and Fondi vacation rental.
See beach directories, resort advertisements, rustic listed properties, and log advertisements that property managers and agents post on our for rent by owner website.
Perceive and determine Belmonte Mezzagno Italy vacation homes for rent by owner and homes for rent by owner in Belmonte Mezzagno Italy.
Look up and hear house rentals in San Secondo Parmense and rental houses in San Secondo Parmense.
Observe, disclose, and ferret out Como Italy rental houses, vacation homes in Como, and rental houses Como Italy.
|
|
