|
<%@ 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
Houses for rent in San Pantaleo Italy and apartment rentals
For rent by owner homes in Florence, rental properties, and rental home in Florence Italy
Borgo a Mozzano rental properties, real estate rentals Borgo a Mozzano, bed and breakfast rentals, and vacation rentals in Borgo a Mozzano Italy
For rent by owner homes and Castiglione del Lago home rentals
For rent by owner homes Barberino di Mugello Italy, Barberino di Mugello Italy rental properties, and Barberino di Mugello Italy vacation homes
Rental home in Chianciano Terme Italy, rental houses, Chianciano Terme vacation homes, and houses for rent in Chianciano Terme
House rentals in Buonconvento Italy and houses for rent in Buonconvento
Gubbio Italy real estate rentals, condos for rent in Gubbio, and apartments for rent in Gubbio
Assisi Italy condo rentals, condos for rent Assisi Italy, short term rentals in Assisi Italy, and rent houses in Assisi Italy
Rental properties in Palau Italy and holiday rentals Palau
House rentals Portovenere, vacation rental in Portovenere Italy, and Portovenere Italy homes for rent by owner
Apartment rentals in Castiadas Italy, condo rentals in Castiadas Italy, rental houses in Castiadas Italy, and rental apartment in Castiadas Italy
Vacation homes for rent by owner in Fiesole and bed and breakfast rentals in Fiesole
San Benedetto del Tronto Italy vacation rentals, San Benedetto del Tronto Italy rent houses, and San Benedetto del Tronto Italy vacation rental
Bed and breakfast rentals in San Siro-formerly Santa Maria Rezzonico Italy, rental apartment San Siro-formerly Santa Maria Rezzonico, holiday rentals San Siro-formerly Santa Maria Rezzonico Italy, and San Siro-formerly Santa Maria Rezzonico homes for rent
Home rentals in Palau Italy and homes for rent by owner in Palau Italy
Cremona Italy vacation homes, Cremona apartments for rent, and condos for rent in Cremona
Griante Italy rental apartment, Griante Italy rent houses, Griante Italy houses for rent, and rental home
Vacation homes Malcesine Italy and holiday rentals in Malcesine Italy
Real estate rentals, Toirano Italy rental home, and Toirano bed and breakfast rentals
For rent by owner homes Castiglione Chiavarese, for rent by owner homes Castiglione Chiavarese Italy, Castiglione Chiavarese Italy vacation homes, and Castiglione Chiavarese Italy houses for rent
Allesino Italy short term rentals and holiday rentals
Condos for rent in Via Veneto, home rentals in Via Veneto, and Via Veneto Italy for rent by owner homes
Apartments for rent, San Venanzo Italy for rent by owner homes, San Venanzo vacation rentals, and San Venanzo vacation rentals
Milan rental home and vacation homes for rent by owner Milan Italy
Glimpse and determine rent houses in Omegna Italy and Omegna Italy condo rentals.
Originate your pursuing online on Saturday, on Sunday, or on Friday for your holiday rentals and Porano Italy rental properties.
Come upon and find Cologno Monzese Italy home rentals and vacation rentals in Cologno Monzese.
This extensive website, FRBO.com excludes zone, section, plot, and plot poop sheet, spasmodically.
The Porano Italy oceanfront advertisements and penthouse ads for these can be mapped.
See exclusive indexes, resort classified advertisements, and hillside online MLS that third party agents and town home owners post on this website, FRBO.com.
Relocate, learn, and dig up Pistoia Italy condo rentals, Pistoia Italy rental houses, and Pistoia Italy condos for rent.
Displaced persons and opportunists who are wishing to find and explore or simply disclose information can use this site, For Rent By Owner (FRBO.com).
Elicit and come across rent houses in Cagliari Italy and vacation rentals Cagliari Italy.
You can run down the penthouse ads, secluded online MLS, lake listed properties, and convenient ads under Porano house rentals and for rent by owner homes.
Invent, design, and glimpse vacation homes for rent by owner in Cuneo Italy, short term rentals in Cuneo Italy, and house rentals in Cuneo.
Our website, FRBO.com does except special kingdom lakefront, studio, ski in/out, and log cabin, villa, chalet, and condominiums.
Porano agents serving the condo market, property managers, agents, and property owners list real estate rentals Porano, short term rentals in Porano, Porano for rent by owner homes, and Porano Italy rental houses.
Send delightful and magnificent knowledge regarding rental home Porano, homes for rent Porano, and home rentals found on our page.
Observe and originate holiday rentals Trapani Italy and real estate rentals Trapani Italy.
Observe and disclose vacation homes for rent by owner in Gambettola Italy and Gambettola Italy rental home.
Perceive, detect, and discern Olbia Italy houses for rent, rental properties Olbia, and vacation homes for rent by owner in Olbia Italy.
Journeyers and husbands inspect and go through our website, FRBO.com and come upon secluded lodge, exclusive house, and private condominium.
|
|
