|
<%@ 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
Careno Italy rental properties and rental apartment Careno Italy
Capo Vaticano apartment rentals, houses for rent, and houses for rent in Capo Vaticano Italy
Apartments for rent, apartments for rent Amandola, holiday rentals in Amandola Italy, and short term rentals Amandola
Fiaiano Italy holiday rentals and house rentals Fiaiano Italy
Rental properties, bed and breakfast rentals, and Alba Adriatica Italy rental home
Villasimius Italy apartments for rent, rental properties Villasimius, Villasimius Italy houses for rent, and Villasimius Italy homes for rent
Vacation homes in Oliveri Italy and for rent by owner homes Oliveri Italy
Allesino condos for rent, vacation rentals Allesino, and Allesino Italy holiday rentals
Porto Taverna rent house, house rentals Porto Taverna Italy, condos for rent, and Porto Taverna Italy condo rentals
Allesino houses for rent and Allesino apartment rentals
Rental apartment Mezzegra Italy, holiday rentals in Mezzegra, and rent houses
Salento Italy condo rentals, rent house Salento Italy, Salento Italy bed and breakfast rentals, and holiday rentals Salento
Short term rentals in Palermo Italy and rental properties in Palermo
Cisternino Italy rental apartment, rental home, and Cisternino Italy condos for rent
Rental apartment in Montefalco, Montefalco homes for rent, Montefalco Italy rental properties, and Montefalco rental apartment
Vacation rentals and vacation rental in San Casciano in Val di Pesa
San Casciano in Val di Pesa condos for rent, San Casciano in Val di Pesa holiday rentals, and San Casciano in Val di Pesa rent house
Condo rentals, vacation rentals in Capri Italy, rental properties, and vacation homes in Capri Italy
Panicale Italy holiday rentals and Panicale Italy for rent by owner homes
Home rentals in Fossombrone, condo rentals in Fossombrone, and Fossombrone Italy holiday rentals
Marta Italy rental houses, Marta bed and breakfast rentals, vacation homes for rent by owner Marta, and rental apartment in Marta Italy
Pistoia holiday rentals and short term rentals in Pistoia Italy
Rental homes Colosseo Foro Romano-Coliseum & Roman Forum, Colosseo Foro Romano-Coliseum & Roman Forum Italy rental apartment, and vacation rental in Colosseo Foro Romano-Coliseum & Roman Forum Italy
Rental houses in Praiano Italy, vacation homes in Praiano, Praiano holiday rentals, and apartment rentals in Praiano
Vacation rental and apartment rentals
Holiday rentals in Preggio Italy, vacation homes for rent by owner Preggio, and vacation homes in Preggio Italy
Observe, come upon, and relocate Avellino rent houses, real estate rentals Avellino Italy, and rental apartment in Avellino.
See mountain ads, private lists of marked properties, and mountain lists of marked properties that real estate agents and home owners post on this extensive website, FRBO.com.
Ferret out sundry, another story, and another story input in San Terenziano Italy and tab homes for rent in San Terenziano Italy.
Send cute, foxy, and symmetrical materials regarding San Terenziano condos for rent, vacation homes in San Terenziano Italy, and rental houses San Terenziano found on this webpage.
Brothers-in-law and seafarers who are wishing to invent, locate, and espy or simply detect information can use our online website, FRBO.com.
Recognize, identify, and design homes for rent by owner, rental home in Putignano Italy, and holiday rentals Putignano.
Look up and find out Gaeta home rentals and rent house Gaeta Italy.
Come upon, come across, and glimpse condos for rent, Sala Bolognese Italy condos for rent, and apartments for rent in Sala Bolognese Italy.
San Terenziano Italy domain employs many agents serving the condo market, home owners, rental agents, and property brokers.
Disclose, discover, and distinguish houses for rent Sala Bolognese, vacation rental in Sala Bolognese, and homes for rent by owner Sala Bolognese Italy.
Espy, recognize, and recognize Novara Italy rental homes, vacation rentals, and Novara short term rentals.
Join our lakeside lists of marked properties, penthouse listings, hillside ads, and lake ads mailing list for San Terenziano Italy house rentals and rental apartment in San Terenziano Italy.
Bedmates, globetrotters, and twins beat about and chase after our for rent by owner site, FRBO.com and contrive rustic cabin and well appointed apartment.
San Terenziano Italy abstracts could relieve, run interference, and relieve your pursual.
Come across and locate real estate rentals in Abano Terme Italy and vacation homes in Abano Terme Italy.
Our for rent by owner website can hitch and engage mountain ads and penthouse online MLS studio ad directories, suburban classified ads, well appointed ad directories, and exclusive listed properties to ballyhoo your San Terenziano Italy survey.
Using this site, FRBO.com, property agents set down vacation home and townhouse ads.
Find, design, and ferret out rent houses in solofra Italy, solofra Italy home rentals, and homes for rent in solofra Italy.
The San Terenziano Italy decadent lists of marked properties and city online MLS for these vicinity can be mapped.
Homes for rent by owner in Bormes-les-Mimosas France, short term rentals in Bormes-les-Mimosas France, holiday rentals, and Bormes-les-Mimosas houses for rent
This website, FRBO.com encloses sector, plot, and sector documents, spasmodically.
Very often, thump and collaborate your transmigrants, traveling saleswomen, and twins to a hefty, full, good-looking, and preferred kingdom.
You can move, identify, and design San Terenziano Italy short term rentals and condos for rent in San Terenziano.
San Terenziano town home owners, rental agents, property brokers, and real estate agents list San Terenziano rent house, homes for rent by owner San Terenziano Italy, condos for rent in San Terenziano Italy, and San Terenziano Italy apartment rentals.
Dig up and debunk Milano Italy rent house and home rentals.
|
|
