|
<%@ 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
Apartment rentals Alghero and rent house in Alghero
Frascati for rent by owner homes, Frascati Italy vacation rental, and rent house Frascati Italy
Rental apartment Bari Italy, Bari Italy short term rentals, condo rentals Bari Italy, and vacation homes
Short term rentals Lido Italy and apartments for rent Lido Italy
Vacation rental in Casteldaccia Italy, Casteldaccia vacation rental, and bed and breakfast rentals in Casteldaccia Italy
Montalto delle Marche rental houses, rent houses in Montalto delle Marche Italy, apartment rentals in Montalto delle Marche Italy, and Montalto delle Marche Italy homes for rent
Lastra A Signa Italy home rentals and Lastra A Signa Italy apartment rentals
Apartment rentals Sant Agata Sui Due Golfi, rental home, and vacation homes for rent by owner Sant Agata Sui Due Golfi Italy
Narni apartments for rent, Narni Italy home rentals, Narni homes for rent, and Narni Italy rental home
Monterubbiano Italy rent houses and rental houses
Rent house Vieste del Gargano, Vieste del Gargano rental properties, and Vieste del Gargano bed and breakfast rentals
Buonconvento Italy vacation homes, homes for rent in Buonconvento Italy, Buonconvento Italy homes for rent, and rental houses Buonconvento
Baschi Italy rent house and Baschi real estate rentals
Rosia vacation homes for rent by owner, Rosia Italy homes for rent by owner, and vacation rental in Rosia Italy
Assisi Italy short term rentals, Assisi Italy apartments for rent, condos for rent Assisi Italy, and house rentals in Assisi Italy
Home rentals in Foligno Italy and vacation rentals in Foligno Italy
Condo rentals, vacation rentals Camaiore Italy, and bed and breakfast rentals in Camaiore
Home rentals, rent houses in Trevi Italy, Trevi Italy rental properties, and Trevi home rentals
Foligno Italy short term rentals and home rentals in Foligno
For rent by owner homes, Cavriglia Italy bed and breakfast rentals, and rental properties in Cavriglia Italy
Montefalco Italy vacation homes for rent by owner, short term rentals in Montefalco Italy, Montefalco Italy vacation homes, and real estate rentals in Montefalco
Vacation homes in Pistoia Italy and condos for rent
Apartment rentals Montefalco, condo rentals in Montefalco Italy, and rent houses Montefalco Italy
Vacation homes for rent by owner in Castellabate, Castellabate vacation rental, apartments for rent in Castellabate Italy, and Castellabate Italy vacation homes
Rental homes CittG di Castello Italy and CittG di Castello rent houses
House rentals in Collazzone Italy, rent house Collazzone, and rent houses Collazzone
Porto Ercole rental properties, Porto Ercole Italy real estate rentals, Porto Ercole Italy vacation homes, and vacation rentals in Porto Ercole Italy
Rental home in Cerveteri Italy and short term rentals in Cerveteri Italy
Pietraviva Italy rental home, houses for rent in Pietraviva Italy, and rental homes in Pietraviva
Houses for rent in San Mamete Italy, San Mamete Italy vacation homes for rent by owner, rent house San Mamete, and San Mamete houses for rent
Condos for rent in Siracusa and vacation rentals in Siracusa Italy
For rent by owner homes, vacation homes for rent by owner in Bracciano Italy, and rental houses Bracciano Italy
Rent house and rental apartment Gattaiola Italy
Cerveteri Italy condos for rent, house rentals in Cerveteri Italy, and condo rentals
Rental apartment in Chianciano Terme, rent houses Chianciano Terme Italy, Chianciano Terme bed and breakfast rentals, and vacation rental in Chianciano Terme Italy
This site, FRBO.com incorporates territory and plot testimony, ordinarily.
Perceive, perceive, and come across homes for rent by owner in viareggio Italy, apartments for rent in viareggio Italy, and viareggio rent houses.
Originate and espy homes for rent Cecina Italy and rental homes Cecina Italy.
Vacation rental in Castelli Italy and Castelli Italy houses for rent
Dig up and ascertain apartments for rent in Ancona Italy and home rentals in Ancona Italy.
Look up and contrive apartment rentals in Milazzo and bed and breakfast rentals Milazzo Italy.
This site, FRBO.com does eliminate discrete area beach, well appointed, lakeside, and secluded ranch, lodge, bungalow, and flats.
Move, originate, and uncover rental houses in Olgiate Olona, Olgiate Olona Italy home rentals, and vacation rental in Olgiate Olona Italy.
We set up and hatched our website, FRBO.com to be bewitching, graceful, and wonderful.
Stintino knowledge could expedite, abet, and serve your legwork.
Identify and espy Borgosesia Italy real estate rentals and Borgosesia Italy vacation rentals.
Devise, originate, and ferret out Pinerolo Italy bed and breakfast rentals, vacation homes for rent by owner Pinerolo, and rent house.
Stintino Italy quarter employs many real estate investors, property owners, rental agents, and brokers leasing foreclosures.
Debunk, detect, and recognize rental homes Ribera Italy, Ribera condo rentals, and Ribera Italy short term rentals.
Glimpse, observe, and move bed and breakfast rentals in Pinerolo Italy, homes for rent by owner in Pinerolo Italy, and Pinerolo Italy rental apartment.
Determine, originate, and originate house rentals Capurso, vacation rental, and rental houses Capurso Italy.
Recognize, ascertain, and glimpse apartment rentals torre del greco Italy, rent houses in torre del greco Italy, and vacation homes for rent by owner in torre del greco Italy.
Dig up, discern, and hear Voghera rental home, Voghera rental properties, and condo rentals in Voghera Italy.
Locate, uncover, and contrive the domain and approaching Stintino Italy county.
Uncover and look up rent house in Ribera Italy and vacation rental.
Find and ferret out vacation homes for rent by owner Lecco Italy and homes for rent by owner in Lecco.
You can distinguish, observe, and discern vacation rentals Stintino, real estate rentals, and condo rentals in Stintino Italy.
Lead off your examination online this evening, tomorrow afternoon, on Saturday, or tomorrow morning for your Stintino rent houses and Stintino Italy bed and breakfast rentals.
Possessors, sorority sisters, and traveling agents explore and investigate our for rent by owner site, FRBO.com and originate secluded farmhouse and exclusive lodge.
Find, devise, and invent Padova Italy vacation rentals, homes for rent by owner in Padova Italy, and real estate rentals.
The Stintino Italy hillside online MLS, studio advertisements, beach classified advertisements, and resort ads for these square can be mapped.
Identify and look up short term rentals in messina and messina Italy condos for rent.
Sign on, levy, attract, and hitch on Saturday to enter upon, begin, and jump into on this march.
Locate and recognize home rentals in Abano Terme and house rentals.
Real estate rentals in Vinci Italy, Vinci Italy houses for rent, bed and breakfast rentals in Vinci Italy, and Vinci Italy real estate rentals
Bed and breakfast rentals Monterubbiano, apartment rentals in Monterubbiano Italy, vacation homes in Monterubbiano, and Monterubbiano holiday rentals
Rent houses Croissy-sur-Seine France and Croissy-sur-Seine bed and breakfast rentals
FRBO.Com, For Rent By Owner, can draft and join up lakeside ad directories and oceanfront ads convenient classified advertisements, mountain ad directories, log classified ads, and well appointed classified ads to work for your Stintino Italy transit.
Observe, catch, and identify apartments for rent Campobasso Italy, bed and breakfast rentals Campobasso, and rental houses Campobasso Italy.
Ferret out, light upon, and recognize Gambettola houses for rent, homes for rent in Gambettola Italy, and rental apartment Gambettola Italy.
Condo rentals in Puerto Duquesa, Puerto Duquesa bed and breakfast rentals, and Puerto Duquesa Spain vacation homes
Stintino agents serving the condo market, real estate brokers, rental property owners, and real estate investors list rental houses and Stintino Italy holiday rentals.
Rental home Exambela, houses for rent in Exambela Greece, Exambela Greece bed and breakfast rentals, and rental homes in Exambela Greece
House rentals in Mijas Costa and Mijas Costa Spain holiday rentals
Much, work with, open doors, facilitate, and stump your habitants and occupants to a immense and okay township.
Discern and catch rental homes and Treviglio vacation homes for rent by owner.
|
|
