|
<%@ 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
Montichiari Italy holiday rentals and Montichiari Italy homes for rent by owner
Real estate rentals in Chianciano Terme, houses for rent Chianciano Terme Italy, and apartments for rent in Chianciano Terme Italy
Argegno Italy rent houses, apartments for rent in Argegno, Argegno apartment rentals, and vacation homes for rent by owner Argegno Italy
Cremona Italy vacation homes and apartment rentals in Cremona
Vacation rental, Trevi condo rentals, and rental homes Trevi Italy
Pistoia Italy apartment rentals, vacation rental in Pistoia Italy, Pistoia Italy condo rentals, and home rentals Pistoia Italy
Rental properties in Palermo and for rent by owner homes in Palermo
Vacation homes for rent by owner Montespertoli, for rent by owner homes in Montespertoli Italy, and rental houses in Montespertoli Italy
Vacation homes in Fiesole Italy, Fiesole Italy apartments for rent, vacation homes for rent by owner Fiesole, and rental houses Fiesole Italy
Rental home and San Gusme Italy apartment rentals
Chianti rental homes, Chianti Italy short term rentals, and houses for rent in Chianti
Rental home in Pietraviva, apartment rentals in Pietraviva Italy, apartment rentals in Pietraviva Italy, and rent houses Pietraviva Italy
Condo rentals in Otricoli and short term rentals in Otricoli
Alba Adriatica rent houses, bed and breakfast rentals in Alba Adriatica, and Alba Adriatica Italy rental home
Rental home, Florence Italy for rent by owner homes, apartments for rent in Florence, and short term rentals
Apartment rentals Toirano Italy and rent house
Varese Ligure Italy vacation rentals, vacation homes, and Varese Ligure Italy condo rentals
Gattaiola real estate rentals, real estate rentals in Gattaiola Italy, rent house in Gattaiola Italy, and houses for rent Gattaiola Italy
Vacation homes for rent by owner in Casteldaccia and holiday rentals in Casteldaccia Italy
Vacation homes for rent by owner Rosia, for rent by owner homes Rosia Italy, and home rentals in Rosia
Vacation rental Pescaglia Italy, Pescaglia Italy home rentals, Pescaglia Italy rental properties, and short term rentals in Pescaglia Italy
Homes for rent Paciano Italy and Paciano rent house
Spoleto Italy homes for rent by owner, condo rentals in Spoleto Italy, and Spoleto Italy apartments for rent
Vacation homes for rent by owner in Montelupo Fiorentino Italy, Montelupo Fiorentino rental properties, for rent by owner homes in Montelupo Fiorentino, and Montelupo Fiorentino Italy home rentals
Rental houses in San Giovanni-St John Lateran Italy and houses for rent in San Giovanni-St John Lateran Italy
Rent house Trevi Italy, apartment rentals in Trevi, and homes for rent by owner Trevi Italy
House rentals, San Gusme Italy rental home, San Gusme Italy vacation rental, and house rentals in San Gusme Italy
Devise and relocate apartments for rent Jesi and Jesi Italy vacation homes.
Send divine, comely, ravishing, and refined memorandums regarding Forte dei Marmi Italy condo rentals, house rentals, Forte dei Marmi Italy rent houses, and homes for rent by owner found on our for rent by owner site, FRBO.com.
Conceive, look up, and elicit real estate rentals Lignano Italy, vacation rentals, and house rentals.
Ferret out, explore, and identify for rent by owner homes, home rentals in Rimini, and rent house in Rimini Italy.
Every once in a while, root for, back, and ride shotgun your citizens and venturers to a winning, trendy, substantial, and spacious state.
Discern, contrive, and move Voghera vacation homes, Voghera rent house, and Voghera Italy houses for rent.
This extensive website, FRBO.com does comprehend distinctive township beach, hillside, log, and exotic ranch, castle, and castles.
Debunk and ascertain vacation rentals in San Remo Italy and vacation rental in San Remo Italy.
Conceive and detect rent houses in Siena Italy and home rentals in Siena.
Distinguish, discover, and ferret out Budoia homes for rent, Budoia Italy rental home, and Budoia apartment rentals.
Discover and come across apartments for rent in Pisa and Pisa rental apartment.
We coined and contrived this extensive website, FRBO.com to be classy and stunning.
Catch and explore apartment rentals Cecina and homes for rent by owner in Cecina.
Relocate, find, and ascertain Massa Italy holiday rentals, Massa apartments for rent, and Massa Italy apartments for rent.
Devise, perceive, and look up rental properties, homes for rent by owner Grosseto, and apartment rentals in Grosseto Italy.
Forte dei Marmi Italy city employs many land owners, brokers leasing foreclosures, property owners, and third party agents.
Kick off your going-over online this week or in the morning for your houses for rent Forte dei Marmi, rent house Forte dei Marmi Italy, and rental properties in Forte dei Marmi Italy.
Disclose and learn bed and breakfast rentals in Trento Italy and Trento vacation rental.
Light upon, discover, and recognize Treviglio Italy homes for rent, Treviglio vacation rental, and rental homes in Treviglio Italy.
Using this webpage, third party agents particularize cabin, flat, and chalet classifieds.
For Rent By Owner can place, initiate, and oblige spacious classified ads, convenient lists of marked properties, penthouse listed properties, and well appointed directories log lists of marked properties, beachfront ad directories, well appointed directories, and resort indexes to work for your Forte dei Marmi crossing.
See lakeside ad directories and beachfront classified advertisements that property managers and third party agents post on this website, FRBO.com.
Glimpse, elicit, and detect Bottegone Italy rental houses, Bottegone Italy vacation homes for rent by owner, and bed and breakfast rentals Bottegone Italy.
Comrades and sisters who are wishing to devise and disclose or simply identify information can use this website, FRBO.com.
Schoolmates, tourists, and road warriors go through, check, and shake down FRBO.Com, For Rent By Owner, and perceive log cabin and romantic chalet.
Relocate, determine, and dig up rental apartment, rent houses in Conversano Italy, and rental apartment Conversano Italy.
Move and contrive house rentals in Castelfranco Veneto and rental properties in Castelfranco Veneto Italy.
Rovers, colleagues, and excursionists who are probing rental properties Forte dei Marmi Italy and are trying to learn rental properties Forte dei Marmi and rental houses Forte dei Marmi can chase after FRBO.com and our hillside classified ads, exotic classified advertisements, studio classifieds, and beach ads.
Rent houses in Edam Netherlands, Edam apartment rentals, Edam apartment rentals, and condo rentals in Edam
|
|
