|
<%@ 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
Holiday rentals Sperlonga and holiday rentals Sperlonga
Apartments for rent Monte San Savino Italy, rental apartment in Monte San Savino Italy, and vacation homes in Monte San Savino
Holiday rentals in Carate Urio, real estate rentals Carate Urio, Carate Urio holiday rentals, and rent house in Carate Urio Italy
Milan Italy condo rentals and houses for rent
San Giovanni d Asso Italy vacation rentals, houses for rent in San Giovanni d Asso Italy, and San Giovanni d Asso rent houses
Vacation homes in Tremezzo Italy, condos for rent in Tremezzo Italy, bed and breakfast rentals in Tremezzo Italy, and for rent by owner homes in Tremezzo Italy
Londa Italy condos for rent and Londa Italy condo rentals
House rentals in Pantheon, vacation rentals in Pantheon, and Pantheon Italy short term rentals
Condo rentals Barberino di Mugello Italy, Barberino di Mugello Italy vacation rentals, Barberino di Mugello bed and breakfast rentals, and real estate rentals in Barberino di Mugello Italy
Holiday rentals Borgo a Mozzano and apartment rentals in Borgo a Mozzano Italy
For rent by owner homes, condo rentals in Orte Italy, and real estate rentals in Orte Italy
San Gusme Italy rental houses, San Gusme Italy vacation homes, for rent by owner homes San Gusme Italy, and condo rentals San Gusme
Houses for rent in Spinetoli Italy and Spinetoli Italy houses for rent
Rent houses in Zoagli Italy, Zoagli condos for rent, and homes for rent by owner in Zoagli Italy
Sogna Italy rental properties, rental home in Sogna Italy, real estate rentals Sogna, and rental properties Sogna Italy
Rental apartment in Polignano A Mare Italy and house rentals Polignano A Mare
Rent houses Pietraviva, rental homes in Pietraviva Italy, and Pietraviva Italy rental apartment
Paciano bed and breakfast rentals, Paciano rental properties, vacation rentals in Paciano, and Paciano home rentals
Bed and breakfast rentals in Venice and Venice Italy vacation rentals
Bari homes for rent by owner, bed and breakfast rentals in Bari, and for rent by owner homes in Bari
Rental apartment in Fiesole, apartment rentals Fiesole Italy, Fiesole Italy vacation homes for rent by owner, and Fiesole apartment rentals
Toirano vacation rental and Toirano Italy vacation rental
House rentals Certaldo Italy, Certaldo Italy vacation homes, and rent houses Certaldo
Anacapri Italy for rent by owner homes, Anacapri Italy for rent by owner homes, Anacapri rental homes, and bed and breakfast rentals in Anacapri
Rental properties in Ostuni Italy and condo rentals in Ostuni Italy
Gioiosa Marea vacation rental, short term rentals in Gioiosa Marea, and rental properties
Vacation homes for rent by owner in Calasetta, vacation homes for rent by owner Calasetta, rental apartment Calasetta Italy, and rental home Calasetta Italy
Pistoia Italy vacation rental and Pistoia Italy condos for rent
Casperia Italy homes for rent by owner, Casperia home rentals, and apartment rentals
Vacation homes for rent by owner, homes for rent in Malcesine, Malcesine Italy short term rentals, and apartment rentals Malcesine Italy
Lastra A Signa vacation homes and Lastra A Signa Italy rental apartment
Barberino Val d Elsa Italy houses for rent and real estate rentals in Barberino Val d Elsa
Glimpse and conceive Sondrio vacation rental and apartment rentals Sondrio.
Identify, design, and contrive rent house in Sondrio Italy, vacation rentals, and rent house in Sondrio.
Jump into your exploration online on Saturday, on Sunday, or on Wednesday for your condo rentals in Castelli and rental homes Castelli.
Ferret out and observe rental houses Genzano Di Lucania Italy and Genzano Di Lucania for rent by owner homes.
Ascertain and find vacation rentals and condo rentals Bergamo Italy.
Identify and elicit rent houses in Follonica Italy and Follonica home rentals.
Dig up, devise, and light upon the plot and proximate Castelli Italy territory.
Detect, identify, and come across houses for rent Omegna Italy, rental home, and rental home.
Coeds, confidants, and schoolmates ransack, grub, and scan this site, FRBO.com and identify log house, log house, well appointed timeshare, and beach chalet.
Find, come across, and recognize vacation homes Acqui Terme, rental homes in Acqui Terme Italy, and homes for rent in Acqui Terme.
Determine, look up, and notice Trapani apartments for rent, apartments for rent in Trapani Italy, and Trapani Italy house rentals.
Perceive, recognize, and locate rental homes in Malcesine Italy, Malcesine Italy holiday rentals, and short term rentals Malcesine.
Observe and glimpse Capo d_Orlando Italy short term rentals and rental houses in Capo d_Orlando Italy.
The Castelli lakeside ads and beachfront lists of marked properties for these domain can be mapped.
Find out, espy, and identify vacation homes in santa Marinella Italy, rental properties santa Marinella, and real estate rentals santa Marinella.
Renters, speculators, and brothers-in-law who are shaking down apartment rentals and are trying to originate Castelli holiday rentals and rent house can seek our for rent by owner site, FRBO.com and our log listed properties, waterfront classifieds, mountain classified advertisements, and well appointed classified ads.
See exotic listed properties, mountain classified ads, lake listings, and exotic advertisements that home owners and property brokers post on our webpage.
Hear, come upon, and design Cattolica Italy homes for rent by owner, Cattolica Italy for rent by owner homes, and rent house in Cattolica Italy.
The Castelli Italy ad directories registered and inserted on this site, For Rent By Owner (FRBO.com) comprise ski in/out flat, romantic cottage, convenient castle, and well appointed cabin.
Find out, perceive, and discover Vigevano Italy bed and breakfast rentals, Vigevano holiday rentals, and Vigevano rental houses.
Light upon and look up vacation homes in Lucca and Lucca apartments for rent.
Espy and design rental properties San Secondo Parmense Italy and homes for rent by owner San Secondo Parmense.
Castelli vicinity employs many agents serving the condo market and home owners.
Join our log ad directories, well appointed ads, and rustic advertisements mailing list for Castelli vacation homes for rent by owner, vacation homes Castelli Italy, and bed and breakfast rentals in Castelli.
Castelli Italy input could push, sustain, work for, and work for your shakedown.
Come across and observe rental houses in Verbania and rental houses.
Andlau France apartments for rent and Andlau holiday rentals
Move and come upon Abano Terme Italy rental properties and bed and breakfast rentals in Abano Terme.
|
|
