|
<%@ 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
For rent by owner homes in Marsciano Italy and homes for rent by owner in Marsciano
Rental homes, apartments for rent in Convalle Italy, and Convalle Italy vacation rental
Barberino di Mugello Italy condo rentals, Barberino di Mugello Italy vacation homes, rental apartment in Barberino di Mugello, and Barberino di Mugello Italy bed and breakfast rentals
Condo rentals in Marlia and rental apartment in Marlia Italy
Laglio vacation homes for rent by owner, rental homes in Laglio Italy, and Laglio Italy real estate rentals
Homes for rent by owner Certaldo, rental home in Certaldo Italy, rental homes, and Certaldo Italy condos for rent
Borgo a Mozzano Italy rental home and vacation rental in Borgo a Mozzano Italy
Rental home in Pognana Lario, Pognana Lario houses for rent, and Pognana Lario Italy condo rentals
Magliano Sabina Italy apartments for rent, apartment rentals in Magliano Sabina Italy, apartment rentals in Magliano Sabina, and vacation homes for rent by owner in Magliano Sabina Italy
House rentals in Monterubbiano Italy and rental properties in Monterubbiano
San Casciano dei Bagni homes for rent by owner, house rentals, and vacation homes for rent by owner San Casciano dei Bagni
Rental home, condo rentals, Cecina Italy short term rentals, and holiday rentals in Cecina Italy
Apartment rentals in Amelia Italy and Amelia homes for rent by owner
Rent houses Pianello del Lario, rental properties, and Pianello del Lario Italy bed and breakfast rentals
Via Veneto apartments for rent, vacation rental in Via Veneto Italy, rental homes Via Veneto, and rental homes Via Veneto
Vacation homes Minori Italy and vacation homes for rent by owner Minori Italy
Trani Italy homes for rent by owner, Trani vacation homes for rent by owner, and rental properties Trani Italy
Short term rentals Venice, Venice Italy vacation rental, condo rentals Venice, and for rent by owner homes Venice
Bed and breakfast rentals and Montespertoli Italy condos for rent
Bolsena Italy rental homes, rent houses in Bolsena, and Bolsena Italy rent houses
Rental apartment in Cerveteri Italy, short term rentals in Cerveteri Italy, rental houses Cerveteri, and rent house in Cerveteri Italy
Condo rentals in Conversano Italy and Conversano Italy homes for rent
Convalle apartment rentals, Convalle Italy real estate rentals, and condos for rent in Convalle
Finale Ligure condo rentals, homes for rent by owner Finale Ligure, houses for rent in Finale Ligure, and vacation homes for rent by owner in Finale Ligure Italy
Castiglione del Lago Italy rental apartment and bed and breakfast rentals
House rentals in Castelfiorentino, house rentals Castelfiorentino Italy, and Castelfiorentino Italy homes for rent by owner
Vacation rental in Bucine Italy, vacation rental in Bucine Italy, Bucine Italy rental home, and rent house in Bucine
Perugia Italy rental properties and Perugia Italy condo rentals
Home rentals in Porto Ercole Italy, home rentals Porto Ercole Italy, and Porto Ercole Italy vacation rental
Carmignano Italy short term rentals, rental home Carmignano Italy, homes for rent Carmignano Italy, and Carmignano Italy for rent by owner homes
Rent house in Pianello del Lario Italy and bed and breakfast rentals Pianello del Lario
Rental homes Milan Italy, Milan Italy homes for rent, and bed and breakfast rentals in Milan Italy
Vacation rental in Montalto delle Marche Italy and holiday rentals
Houses for rent, short term rentals Greve, and Greve Italy for rent by owner homes
Ferret out, hear, and find out houses for rent La Spezia Italy, La Spezia rental properties, and La Spezia apartment rentals.
This site, FRBO.com embraces square, vicinity, zone, and state poop sheet, spasmodically.
You can hunt for the decadent listed properties and hillside listings under Monte Verde Italy condo rentals, for rent by owner homes, and rent houses Monte Verde.
Learn, locate, and recognize Bassano Del Grappa Italy bed and breakfast rentals, rent houses, and vacation rental in Bassano Del Grappa.
Using our page, home owners detail ranch, cottage, townhouse, and cottage directories.
St-Jean-D Aulps France rental apartment, St-Jean-D Aulps France rental homes, and rental houses
This webpage can appoint and volunteer ski in/out listings, mountain listed properties, beachfront classified advertisements, and suburban directories rustic online MLS, ski in/out advertisements, and hillside classified advertisements to abet your Monte Verde Italy tour.
Ferret out, observe, and catch Budoia apartment rentals, rental properties, and real estate rentals Budoia Italy.
Come across and uncover Scandiano Italy short term rentals and Scandiano Italy vacation rental.
Identify and debunk rent houses in Verona Italy and Verona apartment rentals.
Monte Verde rental owners, real estate agents, and agents serving the condo market list houses for rent in Monte Verde Italy, Monte Verde Italy homes for rent, and rental homes Monte Verde Italy.
Explore, discern, and locate Capurso Italy holiday rentals, condos for rent Capurso Italy, and vacation rentals Capurso Italy.
Ascertain, find, and look up bed and breakfast rentals, house rentals, and apartments for rent in Merano.
Come across various and ad hoc info in Monte Verde Italy and bill rent houses.
Relocate and identify condo rentals Alghero Italy and Alghero for rent by owner homes.
You can devise, hear, and observe condo rentals in Monte Verde Italy, Monte Verde Italy vacation rentals, and for rent by owner homes in Monte Verde Italy.
Send excellent, elegant, excellent, and angelic evidence regarding rental properties in Monte Verde, rental homes in Monte Verde Italy, home rentals, and Monte Verde rent houses found on FRBO.Com, For Rent By Owner,.
Contrive and find out Rimini Italy house rentals and rent house Rimini Italy.
Initiate your perquisition online this week or this weekend for your rental properties Monte Verde Italy and rent houses Monte Verde Italy.
This site, For Rent By Owner (FRBO.com) does comprise ad hoc beach, lakeside, romantic, and studio vacation home, house, and haciendas.
Devise, identify, and uncover Genzano Di Lucania Italy real estate rentals, rental apartment Genzano Di Lucania Italy, and vacation homes in Genzano Di Lucania Italy.
The Monte Verde Italy directories ticked off and spelled out on this site, FRBO.com involve resort farmhouse, well appointed townhouse, secluded vacation home, and waterfront ranch.
Monte Verde materials could benefit, open doors, work with, and back your fishing expedition.
Venturers and commuters who are wishing to identify, find, and ascertain or simply learn information can use this extensive website, FRBO.com.
Move, notice, and originate Piacenza Italy houses for rent, holiday rentals in Piacenza Italy, and vacation rental in Piacenza Italy.
Rent houses Avellino Italy, Avellino vacation rental, home rentals in Avellino, and vacation homes
Condos for rent in Alicante and Alicante apartment rentals
Disclose and observe apartments for rent in Cervinia Italy and Cervinia apartments for rent.
Identify and devise Cesena Italy houses for rent and vacation homes Cesena.
Piraeus Greece apartments for rent and for rent by owner homes
|
|
