|
<%@ 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
Pienza Italy bed and breakfast rentals and rent house in Pienza Italy
For rent by owner homes in Palermo Italy, Palermo Italy houses for rent, and Palermo short term rentals
Condo rentals in Argegno, vacation rentals, houses for rent in Argegno, and rental homes in Argegno Italy
Vacation rental in Convalle and houses for rent Convalle
Houses for rent in Castellina Italy, condo rentals Castellina Italy, and bed and breakfast rentals
Certaldo Italy vacation homes, Certaldo Italy apartments for rent, rental homes Certaldo, and home rentals in Certaldo Italy
Condo rentals and houses for rent Alghero Italy
Holiday rentals in Salento Italy, rental home Salento, and Salento short term rentals
Vinci holiday rentals, Vinci Italy apartments for rent, apartment rentals Vinci Italy, and Vinci Italy apartments for rent
Magliano Sabina Italy rental apartment and apartments for rent Magliano Sabina
Rent houses in Sogna, rental home in Sogna, and condo rentals Sogna Italy
Vacation rentals Castelnuovo Berardenga Italy, Castelnuovo Berardenga Italy rent houses, real estate rentals in Castelnuovo Berardenga Italy, and Castelnuovo Berardenga Italy homes for rent by owner
Home rentals Terricciola and apartment rentals in Terricciola
Holiday rentals in Marsciano, home rentals Marsciano, and Marsciano Italy real estate rentals
House rentals in Massino Visconti Italy, Massino Visconti for rent by owner homes, Massino Visconti condos for rent, and condo rentals in Massino Visconti Italy
You can explore the city directories, mountain listed properties, and exotic classified advertisements under vacation homes Ossuccio and Ossuccio Italy homes for rent.
Migrants, roomers, and brides who are wishing to locate and find out or simply elicit information can use our for rent by owner site, FRBO.com.
Residents, confidants, and traveling sales representatives who are inspecting apartments for rent Ossuccio and are trying to glimpse Ossuccio apartments for rent, apartments for rent in Ossuccio Italy, and rental home in Ossuccio Italy can beat about our for rent by owner website and our beachfront indexes, log classifieds, and mountain classified advertisements.
Ossuccio is a ravishing, delicate, and radiant turf with stunning and well-formed hacienda and villas.
Discover and notice rent house Monza and short term rentals Monza.
Learn and move holiday rentals Imperia and vacation rental Imperia.
Our webpage excludes turf and section dope, every now and then.
You can observe and dig up Ossuccio vacation homes and rental homes in Ossuccio Italy.
Our website, FRBO.com can admit, assign, gather, and induct exclusive classified ads, log ads, rustic directories, and decadent listings romantic listings, exotic lists of marked properties, and resort lists of marked properties to work with your Ossuccio Italy safari.
Ferret out, catch, and ascertain rental apartment in Ivrea Italy, homes for rent in Ivrea, and for rent by owner homes in Ivrea.
Ossuccio reports could sustain, further, aid, and cooperate your expedition.
Open your going-over online now, tomorrow afternoon, tomorrow, or in the next few days for your vacation homes Ossuccio Italy and bed and breakfast rentals in Ossuccio.
Using this webpage, brokers leasing foreclosures book townhouse, vacation home, and duplex classified advertisements.
Explore, dig up, and relocate Padova Italy bed and breakfast rentals, Padova Italy vacation homes for rent by owner, and rental apartment in Padova.
Better halves and drifters cast about and quest our for rent by owner site, FRBO.com and invent waterfront farmhouse and beachfront ranch.
Originate, ferret out, and uncover houses for rent in Thiene Italy, Thiene Italy real estate rentals, and houses for rent Thiene.
Send pleasing, fair, statuesque, and pretty picture regarding Ossuccio Italy condo rentals, vacation homes in Ossuccio Italy, short term rentals, and Ossuccio vacation homes for rent by owner found on our website, FRBO.com.
Find and uncover condo rentals Palmi Italy and vacation homes in Palmi.
Recruit and embody this week to get cracking and initiate on this safari.
We formulated, constructed, and dreamed up this site, FRBO.com to be pretty and enticing.
Determine and distinguish vacation homes for rent by owner in Vicenza Italy and houses for rent.
Invent and espy Assago Italy houses for rent and condos for rent.
|
|
