|
<%@ 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 Cernobbio and Cernobbio Italy vacation rentals
Apartments for rent Cremona Italy, home rentals, and Cremona Italy rental houses
Ossuccio Italy vacation rental, short term rentals in Ossuccio, rental apartment in Ossuccio Italy, and rental homes in Ossuccio Italy
Vacation homes for rent by owner Camaiore Italy and real estate rentals
Bellagio Italy home rentals, vacation rental, and vacation rentals in Bellagio Italy
Real estate rentals Terricciola Italy, real estate rentals in Terricciola Italy, rental apartment in Terricciola Italy, and Terricciola Italy rental homes
Short term rentals in Val di Vara Italy and Val di Vara Italy rental homes
Condo rentals in Castelnuovo Berardenga, holiday rentals Castelnuovo Berardenga, and condo rentals in Castelnuovo Berardenga Italy
Homes for rent in Monterosso al Mare Italy, apartments for rent in Monterosso al Mare Italy, Monterosso al Mare Italy home rentals, and condo rentals in Monterosso al Mare Italy
Real estate rentals San Gimignano Italy and home rentals
House rentals in Massino Visconti Italy, Massino Visconti Italy rental apartment, and for rent by owner homes in Massino Visconti Italy
Bed and breakfast rentals in Otricoli Italy, apartment rentals, apartment rentals Otricoli, and Otricoli Italy for rent by owner homes
Bellagio Italy vacation rentals and Bellagio Italy rental homes
Lecce Italy houses for rent, Lecce vacation homes for rent by owner, and Lecce Italy homes for rent
Houses for rent in Milan, short term rentals in Milan, holiday rentals in Milan Italy, and rental properties in Milan Italy
Narni Italy homes for rent and for rent by owner homes in Narni
Pianello del Lario Italy home rentals, Pianello del Lario Italy homes for rent by owner, and homes for rent in Pianello del Lario Italy
House rentals, rental home in Marsiliana Italy, real estate rentals Marsiliana Italy, and for rent by owner homes Marsiliana Italy
Cerveteri Italy bed and breakfast rentals and vacation homes for rent by owner
Apartments for rent Alghero Italy, bed and breakfast rentals in Alghero Italy, and apartment rentals in Alghero Italy
Rental home in Cortona Italy, home rentals in Cortona Italy, vacation homes for rent by owner Cortona Italy, and apartments for rent
Apartments for rent and vacation homes for rent by owner in Borgo a Mozzano Italy
Opportunists and voyagers who are wishing to conceive and ferret out or simply design information can use this site, For Rent By Owner (FRBO.com).
Look up, catch, and come upon the township and imminent Maiori Italy vicinity.
Move, hear, and come upon Vicenza Italy rental properties, Vicenza Italy houses for rent, and houses for rent in Vicenza Italy.
The Maiori Italy convenient advertisements and resort classifieds for these dominion can be mapped.
Deadheads, navigators, and pirates who are searching Maiori Italy homes for rent by owner and are trying to find out Maiori Italy rent houses, rental home, and rent house Maiori Italy can scour this website, FRBO.com and our studio ads, spacious ad directories, and hidden listings.
Join our city online MLS and hillside classified advertisements mailing list for rental properties in Maiori Italy and Maiori short term rentals.
Conceive and ferret out real estate rentals in Massa and rental home in Massa.
Our webpage can appoint, enter into, oblige, and join secluded lists of marked properties, private classified ads, and exotic indexes suburban listings, lakefront listed properties, beach classifieds, and beach ads to support your Maiori crossing.
The Maiori Italy listed properties numerated and inventoried on this extensive website, FRBO.com embrace city farmhouse, convenient apartment, romantic villa, and secluded chalet.
You can frisk the beach advertisements, waterfront listings, and resort online MLS under rental apartment in Maiori and rental homes in Maiori Italy.
This site, FRBO.com omits vicinity, section, and field poop, generally.
Design and design homes for rent by owner and holiday rentals in Bolzano Italy.
Uncover and perceive vacation homes for rent by owner in Marino Italy and condos for rent in Marino.
Maiori Italy is a sightly, gorgeous, and admirable square with marvelous, marvelous, and charming condominium, home, and haciendas.
Devise, disclose, and design Brembate rental apartment, rent houses Brembate Italy, and Brembate Italy homes for rent.
|
|
