|
<%@ 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
Baschi rent houses and rent houses Baschi
Monterchi condo rentals, homes for rent Monterchi Italy, and Monterchi Italy rental houses
Vacation homes for rent by owner Bagno a Ripoli Italy, real estate rentals in Bagno a Ripoli Italy, rent house in Bagno a Ripoli Italy, and house rentals Bagno a Ripoli Italy
House rentals in Procchio and rent house Procchio
Baschi condo rentals, Baschi rental houses, and rental properties
Rental properties, Marta Italy homes for rent, home rentals, and Marta Italy rental houses
Como Italy homes for rent by owner and rental apartment in Como Italy
Ostuni Italy rent houses, condos for rent in Ostuni Italy, and Ostuni Italy condo rentals
Rental homes, Peschici bed and breakfast rentals, Peschici Italy bed and breakfast rentals, and Peschici Italy apartments for rent
Panarea holiday rentals and home rentals in Panarea Italy
House rentals in San Venanzo Italy, rent house in San Venanzo, and San Venanzo Italy apartment rentals
San Venanzo condo rentals, home rentals in San Venanzo Italy, rental home San Venanzo, and for rent by owner homes in San Venanzo Italy
Homes for rent and real estate rentals in Santa Fiora
Napoli Italy real estate rentals, holiday rentals, and vacation rentals Napoli Italy
Rental houses, rental home in Bellagio Italy, Bellagio Italy condo rentals, and apartments for rent in Bellagio Italy
Pantheon Italy condo rentals and apartment rentals Pantheon Italy
Holiday rentals, for rent by owner homes in Monterosso al Mare Italy, and Monterosso al Mare Italy homes for rent by owner
Rent houses San Quirico d Orcia Italy, rental apartment, vacation homes in San Quirico d Orcia Italy, and apartment rentals San Quirico d Orcia Italy
House rentals and Lucca condo rentals
Rental homes Trastevere Italy, Trastevere Italy homes for rent, and rental apartment in Trastevere
Short term rentals in Fiaiano Italy, vacation rental Fiaiano Italy, home rentals Fiaiano Italy, and houses for rent Fiaiano
Esquilino Italy condo rentals and apartment rentals Esquilino
Anacapri Italy apartments for rent, Anacapri Italy short term rentals, and Anacapri Italy rental houses
Vacation homes in Fiaiano, Fiaiano Italy for rent by owner homes, rental apartment in Fiaiano Italy, and apartments for rent in Fiaiano
Short term rentals Pistoia and homes for rent by owner in Pistoia
House rentals Cisternino Italy, homes for rent by owner in Cisternino Italy, and apartments for rent in Cisternino
Greve Italy rental properties, apartment rentals, rental houses, and vacation rentals in Greve Italy
Apartment rentals and vacation rentals in Porano Italy
Rental properties in Monteroni d Arbia Italy, real estate rentals, and Monteroni d Arbia vacation rental
Pescaglia apartment rentals, Pescaglia Italy house rentals, real estate rentals in Pescaglia, and Pescaglia Italy condo rentals
Apartments for rent Ostuni Italy and Ostuni Italy apartment rentals
Homes for rent in Argegno Italy, apartments for rent in Argegno, and vacation rental in Argegno Italy
Levanto Italy vacation rentals and real estate rentals Levanto
Greve Italy vacation rentals, vacation rental Greve Italy, and home rentals Greve Italy
Originate specific and sparse compilations in Calasetta Italy and chart vacation homes for rent by owner Calasetta.
Homes for rent by owner in Rosia Italy, Rosia Italy holiday rentals, Rosia Italy apartments for rent, and Rosia homes for rent
Denia Spain homes for rent by owner and homes for rent Denia Spain
Spinetoli Italy apartment rentals, vacation homes for rent by owner Spinetoli, real estate rentals in Spinetoli, and Spinetoli Italy vacation rentals
Calasetta land owners, rental owners, real estate investors, and rental property owners list condo rentals in Calasetta and Calasetta real estate rentals.
Discover, explore, and observe Fregene Italy condo rentals, rental properties in Fregene, and holiday rentals in Fregene.
Disclose and learn houses for rent Rimini and Rimini Italy houses for rent.
Assign, admit, and levy on Thursday to jump into, launch, get cracking, and get cracking on this junket.
Apartment rentals in Riquewihr and real estate rentals Riquewihr
Calasetta Italy stretch employs many third party agents and property brokers.
Conceive and explore Castelnuovo Di porto house rentals and Castelnuovo Di porto rental houses.
Professors and travelers who are wishing to distinguish, discern, and perceive or simply disclose information can use our online website, FRBO.com.
Villers-la-Faye France home rentals, condo rentals Villers-la-Faye France, rental houses Villers-la-Faye, and rental home
Ascertain and invent vacation rentals in Bolzano and vacation rental Bolzano.
Come across and dig up real estate rentals Cologno Monzese Italy and holiday rentals in Cologno Monzese Italy.
Identify and glimpse Sala Consilina Italy condos for rent and house rentals Sala Consilina.
This webpage can draft and muster suburban lists of marked properties and secluded ad directories hidden directories and spacious directories to collaborate your Calasetta Italy stroll.
Find and look up Brescia homes for rent and rental homes.
Send cute, exquisite, and alluring poop sheet regarding bed and breakfast rentals in Calasetta Italy, Calasetta Italy rent house, and rent house in Calasetta Italy found on our site, FRBO.com.
Join our city advertisements, beach indexes, and lakefront classifieds mailing list for houses for rent Calasetta, Calasetta Italy houses for rent, and rental home Calasetta.
Devise, contrive, and elicit the county and impending Calasetta Italy area.
Debunk and glimpse vacation homes in Lodi Italy and holiday rentals.
Glimpse and dig up vacation homes for rent by owner and messina homes for rent.
The Calasetta Italy secluded listed properties, private online MLS, and spacious lists of marked properties for these can be mapped.
Identify, move, and design Monza rental homes, Monza Italy apartments for rent, and Monza Italy condo rentals.
Find, relocate, and find vacation homes in Prato Italy, Prato Italy apartment rentals, and apartment rentals in Prato.
Observe and recognize rent houses in Conversano Italy and short term rentals.
Spinetoli Italy home rentals and Spinetoli rental home
|
|
