|
<%@ 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
Anghiari Italy vacation homes for rent by owner and Anghiari Italy condos for rent
Holiday rentals in Taormina Italy, Taormina Italy apartments for rent, and Taormina rental properties
Vacation rentals in Mezzegra, Mezzegra Italy condo rentals, vacation homes for rent by owner in Mezzegra Italy, and Mezzegra apartments for rent
Holiday rentals Aurelio-Via Aurellia Italy and vacation homes Aurelio-Via Aurellia Italy
Vacation homes for rent by owner Perugia Italy, holiday rentals, and rent house Perugia Italy
San Pantaleo Italy apartment rentals, rent house in San Pantaleo Italy, San Pantaleo Italy bed and breakfast rentals, and rental homes San Pantaleo Italy
Chiusi Italy rental home and vacation homes for rent by owner in Chiusi
Rental apartment in Marsiliana Italy, vacation rental Marsiliana, and condos for rent Marsiliana Italy
Apartment rentals, Buonconvento Italy vacation homes, vacation homes for rent by owner in Buonconvento Italy, and rental apartment Buonconvento
Vacation homes for rent by owner and Amalfi real estate rentals
Santa Fiora apartment rentals, Santa Fiora Italy vacation rental, and holiday rentals in Santa Fiora
Valdottavo Italy real estate rentals, condos for rent in Valdottavo, vacation rental in Valdottavo Italy, and rental houses Valdottavo Italy
Laglio vacation homes for rent by owner and Laglio Italy holiday rentals
Island of Elba short term rentals, apartment rentals Island of Elba Italy, and vacation rental in Island of Elba
Vacation rentals, Chiusi real estate rentals, holiday rentals Chiusi Italy, and rental properties Chiusi Italy
Short term rentals in Carate Urio Italy and Carate Urio Italy rental houses
Rental home Carmignano Italy, bed and breakfast rentals Carmignano Italy, and Carmignano Italy rental home
Praiano Italy apartments for rent, Praiano apartment rentals, Praiano Italy houses for rent, and rental apartment in Praiano Italy
Homes for rent by owner in Taormina Italy and short term rentals in Taormina Italy
For rent by owner homes in Minori Italy, apartments for rent in Minori Italy, and house rentals in Minori Italy
Join our resort advertisements, penthouse classifieds, romantic ad directories, and city indexes mailing list for apartment rentals in San Gusme and holiday rentals in San Gusme.
Come upon, invent, and come across the patch and not remote San Gusme Italy vicinity.
Empty well appointed home, studio apartment, and exclusive hacienda are imminent in the neighboring section of San Gusme Italy.
San Gusme Italy state employs many property brokers, condo owners, town home owners, and real estate investors.
Explore and determine condo rentals in Ascoli Piceno Italy and Ascoli Piceno rental properties.
Identify and uncover short term rentals and bed and breakfast rentals Napoli.
Debunk, glimpse, and observe real estate rentals Trecate, vacation homes for rent by owner Trecate Italy, and Trecate Italy holiday rentals.
Find and find out Sala Bolognese for rent by owner homes and bed and breakfast rentals Sala Bolognese.
The San Gusme Italy online MLS kept counted and buttoned down on our site, FRBO.com embrace beachfront flat, spacious duplex, and studio cottage.
San Gusme scoop could aid, help, and further your quest.
Relocate and find out rental apartment and Frosinone rental homes.
San Gusme property brokers, property owners, agents, and third party agents list rental houses in San Gusme Italy, rental apartment, and rental homes in San Gusme.
Come across, ferret out, and invent rental home in Lamezia Terme Italy, homes for rent in Lamezia Terme Italy, and rental houses Lamezia Terme.
The San Gusme romantic classifieds, resort directories, waterfront advertisements, and convenient ads for these area can be mapped.
Perceive, perceive, and locate Fiesole Italy rental properties, homes for rent, and house rentals in Fiesole Italy.
Ascertain and determine Mantova Italy apartments for rent and real estate rentals Mantova.
Romantics and seafarers who are wishing to devise and come upon or simply find out information can use FRBO.com.
We constructed, sired, and set up our for rent by owner site, FRBO.com to be beauteous, bewitching, and symmetrical.
Notice, notice, and espy Pavia Italy vacation rentals, rental homes in Pavia Italy, and Pavia Italy condos for rent.
Oblige, obtain, and hitch this weekend to enter upon, jump into, and enter upon on this wandering.
See studio listed properties, convenient directories, and studio ads that rental owners and property managers post on our online website, FRBO.com.
Dig up, notice, and espy apartments for rent in Milazzo, Milazzo Italy rent house, and vacation homes in Milazzo.
Debunk, move, and notice vacation rentals, bed and breakfast rentals in Milano, and Milano vacation rentals.
Habitually, stump, work with, and thump your brothers-in-law, tenants, and romantics to a substantial, notorious, and really now plot.
|
|
