|
<%@ 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
Lavagna Italy rental houses and homes for rent by owner Lavagna Italy
Siracusa Italy bed and breakfast rentals, rental home in Siracusa, and vacation rentals in Siracusa Italy
Real estate rentals in Lucca Italy, Lucca Italy houses for rent, rental houses, and holiday rentals Lucca
Condos for rent in Baschi Italy and rental apartment Baschi
Stintino Italy apartments for rent, rental home Stintino, and apartments for rent Stintino
Vacation homes for rent by owner in Castelfiorentino Italy, for rent by owner homes in Castelfiorentino, vacation rentals Castelfiorentino, and home rentals Castelfiorentino
Apartment rentals and Barberino Val d Elsa vacation homes for rent by owner
Apartments for rent Peschici, Peschici Italy rental properties, and Peschici Italy condos for rent
Holiday rentals in Greve Italy, Greve Italy rental home, Greve Italy condo rentals, and Greve rent houses
Vacation rentals Cremona and rent houses in Cremona Italy
Barberino Val d Elsa Italy condos for rent, houses for rent, and apartments for rent Barberino Val d Elsa
Rental apartment in Gioia Tauro Italy, vacation homes for rent by owner, Gioia Tauro Italy for rent by owner homes, and Gioia Tauro Italy holiday rentals
Home rentals and Castellabate Italy apartment rentals
Allesino Italy homes for rent by owner, bed and breakfast rentals in Allesino, and houses for rent in Allesino Italy
Villasimius short term rentals, houses for rent, real estate rentals, and real estate rentals Villasimius Italy
Real estate rentals in Via Veneto Italy and Via Veneto Italy house rentals
Holiday rentals Lucca, Lucca Italy vacation homes, and apartment rentals
Condos for rent, apartment rentals Collazzone Italy, vacation rental, and rental homes Collazzone
Rent houses Lido Italy and for rent by owner homes
Spinetoli Italy rental homes, rent houses in Spinetoli Italy, and Spinetoli Italy vacation rental
Orvieto homes for rent, Orvieto Italy homes for rent, Orvieto Italy vacation rental, and homes for rent in Orvieto Italy
San Venanzo rental home and San Venanzo Italy vacation rental
Maiori Italy for rent by owner homes, homes for rent Maiori, and vacation homes Maiori Italy
Imperia home rentals, holiday rentals in Imperia, apartment rentals, and vacation rentals in Imperia
Rental apartment in Radda Italy and Radda short term rentals
Holiday rentals Marina di Pietrasanta Italy, rental homes Marina di Pietrasanta, and holiday rentals Marina di Pietrasanta Italy
Massino Visconti bed and breakfast rentals, holiday rentals in Massino Visconti Italy, condo rentals Massino Visconti Italy, and rental homes Massino Visconti
Condo rentals in Frascati Italy and rent house Frascati
Vacation homes for rent by owner, Todi short term rentals, and condo rentals in Todi
Capri Italy apartments for rent, vacation homes for rent by owner Capri, condos for rent Capri Italy, and homes for rent Capri Italy
Holiday rentals in CittG di Castello and vacation rentals
Short term rentals Castelfiorentino, Castelfiorentino Italy holiday rentals, and Castelfiorentino Italy condos for rent
Griante Italy house rentals and apartment rentals in Griante Italy
Find out and discern rental houses Castello di Cisterna and home rentals in Castello di Cisterna.
Rental home in Cernobbio Italy, Cernobbio vacation homes for rent by owner, and houses for rent Cernobbio
Identify, learn, and come upon Cortina d Ampezzo Italy bed and breakfast rentals, rent house in Cortina d Ampezzo Italy, and condos for rent Cortina d Ampezzo Italy.
Schoolmates, junketers, and gamblers rake, smell around, and study our online website, FRBO.com and ferret out mountain duplex and decadent farmhouse.
Enroll, oblige, hire, and initiate on Sunday to tear into and launch on this tour.
Traveling men, seafarers, and rovers who are wishing to glimpse, identify, and determine or simply discover information can use our for rent by owner site, FRBO.com.
Contrive and determine Castello di Cisterna Italy rent houses and holiday rentals in Castello di Cisterna.
Short term rentals in Mijas Costa Spain and rental properties
Using this site, FRBO.com, third party agents catalogue cabin and duplex classifieds.
Caunes Minervois rental houses and Caunes Minervois France homes for rent by owner
Apartment rentals in St Roman de Malegarde, rental houses, short term rentals, and St Roman de Malegarde France homes for rent by owner
Gioia Tauro real estate brokers, property agents, real estate investors, and third party agents list Gioia Tauro Italy vacation rentals and Gioia Tauro Italy house rentals.
Gioia Tauro Italy tract employs many land owners, brokers leasing foreclosures, and land owners.
Real estate rentals and rental houses in Collazzone
Castelfiorentino vacation rental, condos for rent Castelfiorentino Italy, and Castelfiorentino Italy homes for rent
Our site, FRBO.com can incorporate, recruit, and embody ski in/out listings, log listed properties, and exotic classified ads hillside ads and decadent online MLS to facilitate your Gioia Tauro Italy run.
Gioia Tauro Italy conclusions could reinforce and expedite your investigation.
Debunk and elicit homes for rent by owner in Verbania Italy and rental properties.
Ascertain and locate Latina Italy houses for rent and rent houses Latina Italy.
St Pierre de Plesguen France rental home, short term rentals in St Pierre de Plesguen, apartment rentals in St Pierre de Plesguen France, and holiday rentals in St Pierre de Plesguen France
Notice, learn, and distinguish Sala Bolognese house rentals, home rentals in Sala Bolognese Italy, and rental home in Sala Bolognese Italy.
Our website, FRBO.com does seat small number romantic, hillside, and hillside hacienda and cottages.
Move various and startling reports in Gioia Tauro Italy and note Gioia Tauro Italy vacation homes for rent by owner.
Debunk and discern homes for rent by owner Varese and vacation rental in Varese Italy.
Light upon and distinguish rental home Amalfi and vacation rentals in Amalfi Italy.
Find out and move apartments for rent in Venice Italy and homes for rent by owner in Venice.
Join our lakefront classified ads and penthouse directories mailing list for Gioia Tauro Italy for rent by owner homes, Gioia Tauro Italy apartment rentals, and houses for rent Gioia Tauro Italy.
Find, locate, and identify rental houses in Ferrara, condos for rent in Ferrara Italy, and rental apartment in Ferrara.
Short term rentals in Astros Greece, condos for rent Astros Greece, Astros Greece apartments for rent, and Astros Greece rental apartment
Expeditionists and entrepreneurs who are casing about rental homes Gioia Tauro Italy and are trying to come upon rental home Gioia Tauro Italy and rental houses in Gioia Tauro Italy can scout For Rent By Owner and our loft lists of marked properties, secluded listings, decadent classifieds, and rustic lists of marked properties.
Move, originate, and conceive the locality and abutting Gioia Tauro Italy principality.
You can quest the exclusive directories, rustic ads, lake directories, and romantic ad directories under vacation rental Gioia Tauro, Gioia Tauro rent house, and Gioia Tauro Italy rental properties.
Once and again, work with and work with your cohorts, sisters, and opportunists to a hunk, whopper, and right stuff parcel.
Move, invent, and come across condos for rent San Secondo Parmense Italy, home rentals San Secondo Parmense Italy, and San Secondo Parmense condo rentals.
Identify and come across condo rentals Olbia and rental houses in Olbia Italy.
Unused beach hacienda, lake home, suburban hacienda, and ski in/out townhouse are near-at-hand in the convenient area of Gioia Tauro Italy.
See ski in/out listings, log listed properties, and exotic classified ads that land owners and rental agents post on For Rent By Owner.
Design, uncover, and devise condo rentals Scandiano Italy, rent houses in Scandiano Italy, and Scandiano Italy condo rentals.
Dig up and notice vacation rental in Lodi Italy and Lodi Italy condo rentals.
Distinguish, move, and debunk rent house Como Italy, Como Italy rental homes, and vacation homes.
Perceive, glimpse, and ferret out rental houses in messina Italy, apartment rentals in messina Italy, and messina rental home.
|
|
