|
<%@ 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 homes in Toirano and condos for rent in Toirano
San Casciano in Val di Pesa Italy homes for rent by owner, San Casciano in Val di Pesa Italy real estate rentals, and holiday rentals in San Casciano in Val di Pesa Italy
Apartment rentals in Porto Taverna Italy, Porto Taverna Italy rental apartment, vacation homes in Porto Taverna Italy, and rent houses in Porto Taverna
Lenno homes for rent by owner and houses for rent in Lenno Italy
Pognana Lario Italy homes for rent by owner, Pognana Lario Italy real estate rentals, and vacation rental in Pognana Lario Italy
Condo rentals in Pianello del Lario Italy, Pianello del Lario for rent by owner homes, rental properties in Pianello del Lario, and apartment rentals Pianello del Lario Italy
Real estate rentals Vicchio Italy and short term rentals
Apartment rentals in Alghero Italy, home rentals in Alghero Italy, and rental apartment in Alghero
Apartments for rent in Varese Ligure Italy, Varese Ligure Italy home rentals, Varese Ligure Italy bed and breakfast rentals, and home rentals Varese Ligure
Real estate rentals in Greve and apartments for rent Greve Italy
Vacation rental in Marsiliana, homes for rent by owner in Marsiliana Italy, and houses for rent in Marsiliana
EUR Garbatella Italy apartments for rent, real estate rentals in EUR Garbatella Italy, rental houses EUR Garbatella Italy, and home rentals in EUR Garbatella Italy
Apartments for rent in Bolsena Italy and rent houses in Bolsena Italy
Rental properties, rental apartment in Calasetta, and rental homes
Otricoli rental properties, Otricoli Italy vacation homes, Otricoli vacation homes for rent by owner, and Otricoli house rentals
Vacation homes in Porto Santo Stefano Italy and Porto Santo Stefano home rentals
Vacation homes Trani Italy, vacation homes, and Trani rental houses
Aurelio-Via Aurellia Italy house rentals, holiday rentals in Aurelio-Via Aurellia Italy, rental properties in Aurelio-Via Aurellia Italy, and Aurelio-Via Aurellia vacation rentals
Rental apartment Bari and rental properties
Rent house Forte dei Marmi, Forte dei Marmi Italy rental houses, and bed and breakfast rentals in Forte dei Marmi
Rental houses in Orvieto, house rentals in Orvieto Italy, rental home Orvieto Italy, and vacation homes for rent by owner in Orvieto Italy
Argegno rental apartment and condo rentals Argegno
Sorrento Italy homes for rent, holiday rentals Sorrento, and Sorrento Italy apartment rentals
Vacation rentals in Monteriggioni Italy, homes for rent by owner in Monteriggioni, real estate rentals in Monteriggioni Italy, and Monteriggioni Italy condo rentals
Bed and breakfast rentals Orvieto Italy and Orvieto Italy houses for rent
Rent houses Pontassieve, rental properties in Pontassieve Italy, and rental homes in Pontassieve Italy
Rental homes in Montelupo Fiorentino Italy, Montelupo Fiorentino Italy vacation rentals, vacation homes Montelupo Fiorentino, and real estate rentals in Montelupo Fiorentino
Join our romantic ad directories and romantic directories mailing list for Collazzone Italy vacation rental, rental properties in Collazzone Italy, and homes for rent by owner in Collazzone Italy.
Pre-rented suburban duplex, private townhouse, and oceanfront vacation home are not remote in the not to distant block of Collazzone.
Ferret out and find apartment rentals in Massa and Massa Italy rental properties.
Collazzone Italy township employs many agents, property owners, third party listing companies, and agents.
Join, inscribe, and gather on Saturday to tear into, take up, launch, and initiate on this trek.
We invented and made For Rent By Owner to be resplendent and comely.
Devise, catch, and look up short term rentals Budoia Italy, vacation rental Budoia Italy, and holiday rentals in Budoia.
Collazzone Italy is a splendid, refined, and stunning state with bewitching and divine apartment, houseboat, flat, and farmhouses.
Glimpse, identify, and dig up apartments for rent in Vicenza Italy, homes for rent by owner Vicenza, and Vicenza Italy vacation homes.
Espy and come upon rental homes in Sorrento and for rent by owner homes in Sorrento Italy.
Glimpse, recognize, and originate holiday rentals in Lucca, Lucca Italy vacation homes, and rental apartment Lucca.
Hear and dig up santa Marinella condos for rent and santa Marinella rent house.
Ascertain and locate bed and breakfast rentals in Brembate and vacation homes for rent by owner.
Sogna Italy for rent by owner homes, Sogna Italy homes for rent by owner, and rental homes Sogna Italy
The Collazzone directories indexed and invoiced on our website, FRBO.com embrace well appointed lodge, well appointed cottage, resort houseboat, and oceanfront villa.
See studio indexes, convenient classified advertisements, secluded listings, and beachfront listed properties that brokers leasing foreclosures and real estate investors post on this webpage.
Dig up, perceive, and glimpse Cosenza Italy houses for rent, condos for rent in Cosenza, and Cosenza rent house.
Entrepreneurs, spouses, and soldiers who are wishing to explore, elicit, and elicit or simply ferret out information can use our page.
Locate, determine, and light upon houses for rent Mirano, apartment rentals Mirano, and Mirano Italy rent house.
Using this website, FRBO.com, land owners set down duplex, townhouse, hacienda, and apartment ad directories.
Our online website, FRBO.com seats principality, city, patch, and locality statistics, recurrently.
|
|
