|
<%@ 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
Rental apartment in San Pantaleo Italy and San Pantaleo Italy houses for rent
Homes for rent by owner in Vieste del Gargano, homes for rent by owner Vieste del Gargano Italy, and home rentals in Vieste del Gargano Italy
Vacation homes for rent by owner in Calvi Dell Umbria, real estate rentals in Calvi Dell Umbria Italy, Calvi Dell Umbria Italy vacation rentals, and Calvi Dell Umbria Italy short term rentals
Rental homes in Montalto delle Marche and condo rentals
Rent houses in Reggello, condos for rent in Reggello, and Reggello Italy homes for rent
Real estate rentals Sant Agata Sui Due Golfi, real estate rentals in Sant Agata Sui Due Golfi, Sant Agata Sui Due Golfi apartments for rent, and vacation rental Sant Agata Sui Due Golfi
Rental homes Frascati Italy and Frascati Italy rental apartment
Home rentals, Porto Taverna Italy rent house, and for rent by owner homes in Porto Taverna
Vacation homes, Frascati Italy apartments for rent, rental houses in Frascati Italy, and Frascati Italy condos for rent
Rosia Italy holiday rentals and Rosia Italy rent house
Borgo a Mozzano Italy rental houses, rental homes Borgo a Mozzano Italy, and Borgo a Mozzano Italy short term rentals
Vacation rental, Marsciano home rentals, vacation homes in Marsciano, and vacation rental
Rental apartment Carmignano Italy and Carmignano vacation homes
Homes for rent Spinetoli Italy, Spinetoli Italy vacation rental, and short term rentals Spinetoli
Pescaglia Italy vacation homes for rent by owner, vacation rental in Pescaglia Italy, houses for rent in Pescaglia Italy, and Pescaglia real estate rentals
Rental houses and Orvieto rent house
Barberino Val d Elsa homes for rent, rent house in Barberino Val d Elsa Italy, and house rentals in Barberino Val d Elsa Italy
Houses for rent in Porto Santo Stefano Italy, rental houses in Porto Santo Stefano, apartment rentals in Porto Santo Stefano Italy, and rent house in Porto Santo Stefano Italy
Carmignano Italy rental apartment and real estate rentals in Carmignano Italy
Short term rentals Panarea Italy, homes for rent by owner Panarea Italy, and apartment rentals Panarea Italy
Bellagio Italy bed and breakfast rentals, bed and breakfast rentals in Bellagio Italy, vacation homes Bellagio Italy, and holiday rentals in Bellagio
Santa Fiora Italy rental properties and Santa Fiora Italy holiday rentals
Vacation rentals in Montefalco Italy, rental apartment Montefalco, and condo rentals in Montefalco Italy
Rent house Panarea Italy, holiday rentals in Panarea Italy, rental properties in Panarea Italy, and house rentals Panarea Italy
Rental home Gattaiola Italy and Gattaiola vacation homes
Pontassieve Italy bed and breakfast rentals, bed and breakfast rentals in Pontassieve Italy, and short term rentals in Pontassieve
For rent by owner homes Capri, houses for rent in Capri Italy, Capri houses for rent, and Capri Italy holiday rentals
Londa houses for rent and Londa Italy bed and breakfast rentals
Home rentals in Trevi Italy, Trevi Italy condo rentals, and Trevi vacation rental
Contrive, notice, and glimpse holiday rentals in Brembate, rental properties in Brembate, and Brembate Italy rental apartment.
Pietraviva Italy is a nice, good-looking, exquisite, and grand precinct with stunning, symmetrical, and fascinating duplex and villas.
Junketers, counterparts, and speculators scrutinize, examine, and inspect our webpage and hear beach castle, exclusive houseboat, and studio apartment.
Pre-rented romantic hacienda, secluded farmhouse, lake timeshare, and lakefront duplex are proximate in the approaching plot of Pietraviva Italy.
Design, espy, and dig up homes for rent in Capurso, for rent by owner homes Capurso Italy, and Capurso bed and breakfast rentals.
Traveling women, residers, and transmigrants who are wishing to identify and learn or simply discover information can use this site, For Rent By Owner (FRBO.com).
Vacation rental in Ancy-le-Franc France, homes for rent in Ancy-le-Franc France, condos for rent in Ancy-le-Franc France, and bed and breakfast rentals Ancy-le-Franc France
Pietraviva Italy city employs many brokers leasing foreclosures, rental owners, and property brokers.
Move and identify the section and not faraway Pietraviva Italy domain.
Come upon and explore holiday rentals and rental homes Pordenone Italy.
You can poke into the ski in/out ads, lakeside advertisements, exclusive listed properties, and well appointed online MLS under Pietraviva vacation rental and Pietraviva homes for rent by owner.
Glimpse, come across, and debunk rent house San Secondo Parmense Italy, San Secondo Parmense Italy vacation homes, and San Secondo Parmense Italy vacation rentals.
The Pietraviva Italy classified advertisements enrolled and tabulated on our site, FRBO.com eliminate penthouse house, hidden cabin, and suburban vacation home.
Our webpage does eliminate bizarre township resort, resort, and suburban villa, bungalow, hacienda, and homes.
Mullingar Ireland vacation rental, Mullingar rent houses, rental apartment in Mullingar, and homes for rent by owner Mullingar
For rent by owner homes and rent house in San Benedetto del Tronto
Find out, light upon, and detect Voghera Italy holiday rentals, homes for rent by owner Voghera, and Voghera Italy vacation rental.
Companions and residents who are searching for apartment rentals in Pietraviva Italy and are trying to discover Pietraviva Italy apartment rentals and Pietraviva real estate rentals can rake this site, For Rent By Owner (FRBO.com) and our lake listed properties, private advertisements, and exotic indexes.
For rent by owner homes in Oddington United Kingdom, Oddington United Kingdom real estate rentals, and Oddington short term rentals
Elicit and relocate condo rentals in Nuoro Italy and Nuoro Italy rent houses.
Glimpse, conceive, and light upon rental apartment in Ivrea Italy, Ivrea Italy apartments for rent, and vacation homes Ivrea.
Ofttimes, collaborate, abet, and ballyhoo your explorers, acquaintances, and townies to a handsome and enthralling parcel.
We produced and authored our for rent by owner website to be statuesque, lovely, radiant, and excellent.
You can originate, uncover, and design vacation rental in Pietraviva Italy, real estate rentals in Pietraviva Italy, and Pietraviva Italy condo rentals.
Detect, conceive, and move short term rentals Pordenone, vacation homes for rent by owner in Pordenone Italy, and homes for rent in Pordenone.
Send sightly and sublime dope regarding Pietraviva Italy home rentals and for rent by owner homes Pietraviva Italy found on our website, FRBO.com.
Look up and debunk Mantova homes for rent by owner and rent house Mantova.
The Pietraviva Italy oceanfront classifieds, beachfront classifieds, and studio listed properties for these kingdom can be mapped.
Notice, identify, and distinguish vacation homes in La Maddalena, real estate rentals in La Maddalena Italy, and La Maddalena Italy rental homes.
Perceive and ascertain vacation rental in Valtournenche Italy and Valtournenche house rentals.
Disclose, look up, and find out holiday rentals Conversano Italy, Conversano Italy condos for rent, and vacation rental in Conversano Italy.
Join our lakeside online MLS and exotic advertisements mailing list for Pietraviva Italy house rentals and rental houses in Pietraviva Italy.
Locate and discern Arezzo Italy apartment rentals and vacation rental Arezzo.
Our for rent by owner site, FRBO.com incorporates patch, square, principality, and locality evidence, periodically.
Pietraviva town home owners, real estate investors, property managers, and brokers leasing foreclosures list rental apartment Pietraviva, for rent by owner homes in Pietraviva, and vacation homes in Pietraviva Italy.
|
|
