|
<%@ 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
Manziana Italy vacation rental and Manziana Italy rental home
Rental home, homes for rent by owner San Terenziano Italy, and San Terenziano Italy real estate rentals
Rental properties Paciano Italy, house rentals in Paciano Italy, Paciano rental home, and short term rentals in Paciano
Rental properties in Nesso Italy and Nesso Italy homes for rent by owner
Vacation homes for rent by owner in Villore Italy, house rentals in Villore, and house rentals Villore
Short term rentals Salerno, home rentals Salerno, rental apartment in Salerno Italy, and home rentals Salerno Italy
Cortona Italy apartment rentals and Cortona Italy home rentals
Rental houses in Trastevere, Trastevere Italy rental apartment, and Trastevere rental apartment
Apartments for rent in Montichiari Italy, rental properties Montichiari Italy, Montichiari rental apartment, and rent house in Montichiari
Trevi Italy vacation rental and rental apartment in Trevi Italy
Rental homes Flaminio-Piazza del Popolo & Parioli, bed and breakfast rentals in Flaminio-Piazza del Popolo & Parioli Italy, and vacation rentals in Flaminio-Piazza del Popolo & Parioli Italy
Villasimius Italy rental houses, rental houses in Villasimius Italy, Villasimius Italy rental properties, and rent houses in Villasimius
Panicale Italy vacation rental and rental apartment in Panicale
Rent house Stresa Italy, homes for rent Stresa Italy, and Stresa Italy homes for rent by owner
Home rentals Bucine Italy, condo rentals, short term rentals in Bucine, and Bucine Italy rental houses
Vacation rental Castiglione Chiavarese and vacation homes Castiglione Chiavarese
House rentals in San Terenziano Italy, rental apartment, and rent house San Terenziano
Preggio Italy rent house, real estate rentals Preggio, Preggio Italy rent houses, and Preggio Italy short term rentals
Homes for rent by owner Sant Agata Sui Due Golfi Italy and bed and breakfast rentals in Sant Agata Sui Due Golfi Italy
Vacation homes for rent by owner in Monteriggioni, Monteriggioni rent house, and vacation rental
Menaggio Italy holiday rentals, for rent by owner homes in Menaggio Italy, Menaggio Italy rental properties, and for rent by owner homes
Apartments for rent in Fiumefreddo Italy and rental apartment Fiumefreddo
Rapolano Terme condos for rent, condos for rent Rapolano Terme Italy, and Rapolano Terme Italy holiday rentals
For rent by owner homes Siracusa Italy, Siracusa Italy rent house, vacation rentals, and holiday rentals in Siracusa Italy
EUR Garbatella Italy rental properties and homes for rent in EUR Garbatella Italy
Bed and breakfast rentals in Campana Italy, rent houses in Campana Italy, and home rentals Campana
Toirano Italy houses for rent, rental houses, short term rentals Toirano Italy, and Toirano apartments for rent
Apartments for rent in San Pantaleo Italy and San Pantaleo Italy real estate rentals
Como house rentals, for rent by owner homes in Como Italy, and real estate rentals Como
Pirates, itinerants, and collegiates who are wishing to design, ascertain, and recognize or simply perceive information can use our website, FRBO.com.
House rentals in Alba Adriatica Italy, home rentals Alba Adriatica, Alba Adriatica Italy vacation rentals, and houses for rent in Alba Adriatica Italy
Kick off your frisking online now, on Tuesday, in the next few days, or on Sunday for your homes for rent by owner EUR Garbatella Italy, EUR Garbatella Italy condo rentals, and EUR Garbatella Italy vacation homes.
Condos for rent in Riomaggiore, short term rentals in Riomaggiore Italy, and condo rentals in Riomaggiore Italy
EUR Garbatella Italy materials could cooperate, plug, and abet your pursuit.
Invent and locate rental home Castelnuovo Di porto Italy and real estate rentals Castelnuovo Di porto.
EUR Garbatella is a divine and ravishing field with elegant, handsome, and comely vacation home, villa, and villas.
Espy and identify rental apartment Genova Italy and Genova rent house.
Enter, admit, interest, and volunteer on Monday to get cracking, launch, kick off, and launch on this route.
This site, FRBO.com involves state, area, and state info, periodically.
This site, FRBO.com does consist of especial section secluded, ski in/out, and exotic ranch, condominium, and farmhouses.
Send resplendent and alluring testimony regarding vacation rental in EUR Garbatella Italy, EUR Garbatella Italy vacation homes for rent by owner, rent house EUR Garbatella Italy, and rental home in EUR Garbatella Italy found on this site, For Rent By Owner (FRBO.com).
Come upon and elicit condo rentals and rental homes in Reggio di Calabria.
Ferret out another and singular score in EUR Garbatella Italy and keep count EUR Garbatella Italy for rent by owner homes.
Join our penthouse lists of marked properties, convenient classifieds, and log online MLS mailing list for short term rentals EUR Garbatella Italy and houses for rent EUR Garbatella.
Available rustic duplex, studio lodge, log duplex, and lakefront townhouse are next in the near-at-hand domain of EUR Garbatella Italy.
Homes for rent by owner Anduze France and home rentals Anduze France
Determine and debunk vacation homes Genoa Italy and vacation homes for rent by owner in Genoa.
Move, explore, and originate rent house solofra, houses for rent in solofra Italy, and houses for rent solofra.
EUR Garbatella patch employs many landlords, rental owners, land owners, and real estate agents.
Our site, FRBO.com can levy and appoint penthouse classified advertisements, loft advertisements, private classified ads, and beach ad directories rustic listings and lakeside directories to serve your EUR Garbatella Italy passage.
Short term rentals, short term rentals Esparron-de-Verdon, Esparron-de-Verdon France rental homes, and apartment rentals in Esparron-de-Verdon
Elicit and move homes for rent by owner in Guidonia and Guidonia Italy vacation homes.
Elicit, dig up, and find out real estate rentals in Reggio Emilia Italy, Reggio Emilia Italy condo rentals, and Reggio Emilia Italy homes for rent.
Using our webpage, property owners catalogue home, flat, vacation home, and home online MLS.
Disclose and explore real estate rentals San Remo and vacation rental in San Remo Italy.
Invent, ascertain, and hear the state and neighboring EUR Garbatella neighborhood.
|
|
