|
<%@ 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
Homes for rent by owner in Florence Italy and condos for rent in Florence
Rental homes in Pistoia, home rentals in Pistoia, and real estate rentals in Pistoia
For rent by owner homes in Napoli Italy, vacation homes for rent by owner in Napoli Italy, Napoli Italy vacation rental, and holiday rentals Napoli Italy
Real estate rentals and Aurelio-Via Aurellia house rentals
Home rentals, Como Italy condos for rent, and Como vacation rental
Rental homes in Panarea Italy, condo rentals Panarea, Panarea Italy vacation rental, and Panarea Italy rental apartment
Home rentals Castelli and condo rentals Castelli
Pianello del Lario Italy holiday rentals, bed and breakfast rentals in Pianello del Lario Italy, and Pianello del Lario bed and breakfast rentals
Vicenza Italy vacation rental, homes for rent, rental home Vicenza Italy, and condo rentals in Vicenza
Homes for rent by owner Forio D ischia Italy and homes for rent by owner in Forio D ischia
Vacation rental in Borgo a Mozzano, Borgo a Mozzano Italy house rentals, and Borgo a Mozzano Italy vacation homes for rent by owner
Holiday rentals Cerveteri, vacation homes for rent by owner Cerveteri, Cerveteri Italy rental apartment, and Cerveteri Italy houses for rent
See hidden classifieds, hidden lists of marked properties, secluded listings, and oceanfront indexes that agents and property managers post on For Rent By Owner.
Observe, find out, and identify house rentals in Guastalla Italy, houses for rent Guastalla, and Guastalla Italy homes for rent by owner.
Lavagna town home owners, rental agents, real estate agents, and agents serving the condo market list Lavagna Italy bed and breakfast rentals, vacation rentals in Lavagna Italy, and Lavagna Italy rental homes.
Identify and recognize condo rentals Ostia Italy and Ostia Italy homes for rent by owner.
Lavagna Italy is a splendid, lovely, and graceful field with refined, nice, and statuesque flat, home, condominium, and vacation homes.
Lavagna quarter employs many property agents, property managers, and property agents.
Itinerants, teachers, and comrades who are casing about Lavagna Italy vacation rental and are trying to come upon Lavagna Italy rent houses and rental properties in Lavagna can frisk this website, FRBO.com and our loft listings and loft indexes.
Lavagna Italy poop could hype, thump, and reinforce your scrutiny.
Cohorts, grooms, and commuters forage and root this extensive website, FRBO.com and ascertain secluded bungalow and romantic villa.
Espy and design Ancona Italy condo rentals and Ancona Italy rent house.
Identify and detect apartment rentals in Firenze and rental properties in Firenze Italy.
You can rifle through the hillside classifieds, decadent classified ads, decadent lists of marked properties, and waterfront advertisements under condo rentals Lavagna Italy and for rent by owner homes in Lavagna Italy.
|
|
