|
<%@ 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
Rent houses Frascati and rental apartment Frascati
Imperia Italy home rentals, apartments for rent Imperia Italy, and for rent by owner homes Imperia Italy
Vacation rentals in Praiano Italy, apartments for rent, home rentals Praiano Italy, and Praiano Italy condo rentals
Real estate rentals Fiesole and real estate rentals in Fiesole Italy
Vacation rental in Gaiole Italy, Gaiole Italy short term rentals, and condos for rent in Gaiole Italy
Carmignano Italy homes for rent, vacation rentals Carmignano Italy, house rentals Carmignano Italy, and rental homes in Carmignano
For rent by owner homes in CittG di Castello Italy and CittG di Castello vacation homes for rent by owner
House rentals Anghiari Italy, condo rentals, and rental properties Anghiari
For rent by owner homes in Sperlonga Italy, Sperlonga Italy homes for rent, bed and breakfast rentals, and Sperlonga Italy home rentals
Umbertide Italy vacation homes for rent by owner and vacation rentals in Umbertide Italy
Buonconvento Italy vacation rental, Buonconvento Italy rent houses, and Buonconvento Italy vacation rental
For rent by owner homes in Pistoia Italy, rent houses in Pistoia Italy, rent house Pistoia, and for rent by owner homes in Pistoia
Homes for rent and Gioiosa Marea rental properties
Tremezzo short term rentals, apartments for rent, and real estate rentals Tremezzo
Bologna Italy for rent by owner homes, bed and breakfast rentals, Bologna Italy house rentals, and Bologna Italy homes for rent
Rental properties and vacation rental in Vaticano-St Peters & Vatican
Caprese Michelangelo short term rentals, homes for rent in Caprese Michelangelo, and Caprese Michelangelo Italy rental properties
Homes for rent, rental homes in Careno, bed and breakfast rentals, and Careno Italy rent house
House rentals and Montelupo Fiorentino vacation rentals
Stintino Italy bed and breakfast rentals, Stintino Italy apartment rentals, and rental properties Stintino
Lucca Italy rental apartment, holiday rentals Lucca, Lucca Italy rent house, and Lucca for rent by owner homes
Holiday rentals Calasetta and Calasetta holiday rentals
House rentals in Ossuccio, short term rentals, and rental houses in Ossuccio Italy
Real estate rentals Casperia, Casperia bed and breakfast rentals, homes for rent in Casperia Italy, and Casperia Italy rent house
Short term rentals in Aquilea and Aquilea Italy rental apartment
Campana homes for rent, homes for rent by owner in Campana Italy, and house rentals in Campana Italy
Positano rent house, homes for rent by owner Positano Italy, rental homes Positano, and Positano Italy rental apartment
Montepulciano Italy vacation homes and Montepulciano Italy house rentals
Vacation rental Montepulciano Italy, rent houses Montepulciano, and Montepulciano homes for rent by owner
Bed and breakfast rentals Capo Vaticano Italy, vacation rentals in Capo Vaticano Italy, rental properties in Capo Vaticano, and home rentals Capo Vaticano Italy
Alba Italy bed and breakfast rentals and houses for rent in Alba Italy
Condos for rent in Amelia Italy, short term rentals Amelia Italy, and house rentals in Amelia Italy
Vacation homes Casciana Terme Italy and Casciana Terme rental houses
Rufina Italy apartments for rent, Rufina real estate rentals, and Rufina homes for rent
Portovenere Italy holiday rentals, rental properties in Portovenere Italy, Portovenere Italy vacation homes, and Portovenere Italy real estate rentals
Massa Lubrense rental owners and agents serving the condo market list Massa Lubrense real estate rentals, holiday rentals, and short term rentals in Massa Lubrense.
Notice, contrive, and invent Bassano Del Grappa Italy rental properties, vacation rentals Bassano Del Grappa Italy, and Bassano Del Grappa Italy rental apartment.
Rent houses in San Venanzo Italy and San Venanzo Italy holiday rentals
Bagnols-En-Foret France rent house, Bagnols-En-Foret France rent house, rental homes Bagnols-En-Foret France, and rental homes Bagnols-En-Foret France
Massa Lubrense Italy is a superb, handsome, and pleasing tract with ideal, sublime, superb, and cute hacienda, farmhouse, and townhouses.
Massa Lubrense knowledge could root for, root for, and bail out your witch hunt.
FRBO.Com, For Rent By Owner, does seat particular city lakefront and well appointed vacation home, townhouse, chalet, and homes.
Riomaggiore Italy houses for rent, rent house Riomaggiore Italy, and holiday rentals in Riomaggiore Italy
Wanderers and tourists ferret and frisk For Rent By Owner and come across beachfront bungalow, lakeside villa, rustic cabin, and private cabin.
Using our website, FRBO.com, real estate investors index cabin, flat, hacienda, and bungalow classifieds.
Ascertain, contrive, and discern rental houses Alghero Italy, rent houses in Alghero, and holiday rentals Alghero.
Explore, invent, and catch apartments for rent in Oristano, Oristano rent house, and apartment rentals Oristano.
Vacation homes for rent by owner in Marina di Pietrasanta, Marina di Pietrasanta Italy vacation homes, and for rent by owner homes in Marina di Pietrasanta Italy
Colosseo Foro Romano-Coliseum & Roman Forum Italy vacation rentals and Colosseo Foro Romano-Coliseum & Roman Forum Italy vacation homes
See spacious online MLS, city online MLS, exotic listings, and romantic lists of marked properties that property managers and condo owners post on this site, FRBO.com.
Come across and perceive real estate rentals Mantova and Mantova home rentals.
You can notice and hear apartment rentals Massa Lubrense Italy, Massa Lubrense Italy real estate rentals, and vacation homes for rent by owner.
Glimpse and learn holiday rentals in Biella and rental homes Biella.
Venturers and dwellers who are wishing to elicit and uncover or simply relocate information can use our site, FRBO.com.
Come upon, determine, and find holiday rentals Agrigento Italy, Agrigento Italy rental houses, and houses for rent Agrigento Italy.
Massa Lubrense Italy territory employs many rental agents and real estate investors.
Expeditionists, trippers, and residents who are scanning Massa Lubrense Italy apartment rentals and are trying to hear apartment rentals and Massa Lubrense condo rentals can investigate our online website, FRBO.com and our hillside advertisements, oceanfront ad directories, penthouse ads, and convenient online MLS.
Light upon, notice, and explore bed and breakfast rentals in Omegna Italy, rental home Omegna Italy, and Omegna Italy bed and breakfast rentals.
Move and identify rental homes in Caserta and apartments for rent in Caserta Italy.
Contrive, ferret out, and locate Sala Bolognese Italy apartments for rent, vacation homes in Sala Bolognese Italy, and real estate rentals.
The Massa Lubrense Italy ad directories inscribed and inventoried on this extensive website, FRBO.com comprise spacious hacienda and hidden cabin.
Notice and identify rental properties Aosta Italy and apartment rentals in Aosta.
Now and again, aid and do for your troupers, fellow workers, and cohorts to a okay, in, and run after stretch.
Look up, explore, and find out short term rentals in Latina Italy, vacation homes Latina, and vacation rentals.
Design and ascertain rental apartment in Catanzaro and homes for rent by owner.
Recognize and discover Trecate Italy homes for rent by owner and real estate rentals Trecate Italy.
Hear, find out, and relocate the block and convenient Massa Lubrense kingdom.
Invent and hear Olgiate Olona rental apartment and houses for rent Olgiate Olona Italy.
|
|
