|
<%@ 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
Holiday rentals Certaldo and Certaldo Italy houses for rent
Viterbo Italy vacation rentals, house rentals in Viterbo Italy, and short term rentals
Rental properties in Orvieto, Orvieto Italy real estate rentals, vacation rentals, and rental home in Orvieto
Homes for rent by owner Careno Italy and rental home Careno Italy
Casteldaccia Italy homes for rent, Casteldaccia rental apartment, and vacation homes Casteldaccia Italy
Apartment rentals in Montespertoli Italy, condos for rent in Montespertoli Italy, homes for rent in Montespertoli Italy, and house rentals in Montespertoli Italy
Apartment rentals in Gioiosa Marea and Gioiosa Marea Italy rental apartment
Rent house in Piazza di Spagna-Spanish Steps Italy, homes for rent by owner in Piazza di Spagna-Spanish Steps, and rental apartment
Vacation rentals in Orte, rental home in Orte Italy, Orte Italy apartment rentals, and Orte Italy homes for rent by owner
Borgo a Mozzano apartment rentals and Borgo a Mozzano Italy rental houses
Real estate rentals in Orte Italy, Orte houses for rent, and vacation rental Orte Italy
Vacation rental Varenna Italy, rental properties in Varenna Italy, Varenna Italy rental houses, and vacation rental in Varenna Italy
Homes for rent by owner Rosia and vacation homes for rent by owner in Rosia Italy
Rent house in Montefalco Italy, homes for rent in Montefalco, and houses for rent in Montefalco Italy
Varese Ligure Italy apartments for rent, rental homes Varese Ligure Italy, Varese Ligure Italy rental apartment, and Varese Ligure apartments for rent
Holiday rentals Buonconvento and rental homes Buonconvento Italy
Castelfiorentino Italy info could reinforce, benefit, bail out, and work for your research.
You can inspect the lakeside classified ads and lakefront indexes under condo rentals, house rentals in Castelfiorentino Italy, and homes for rent Castelfiorentino Italy.
Castelfiorentino is a good-looking, grand, and fine dominion with cute, foxy, radiant, and gorgeous house, hacienda, and duplexs.
Detect specific, various, special, and extraordinary picture in Castelfiorentino and file vacation rental.
Discern, learn, and come upon house rentals in Palermo Italy, Palermo rental home, and rental houses Palermo Italy.
Distinguish and discover Voghera Italy home rentals and Voghera Italy vacation homes for rent by owner.
This site, For Rent By Owner (FRBO.com) does hold peculiar locality city, romantic, beach, and hidden ranch, houseboat, lodge, and farmhouses.
Find, perceive, and conceive homes for rent Belmonte Mezzagno Italy, Belmonte Mezzagno Italy rental homes, and Belmonte Mezzagno Italy condos for rent.
Join our suburban advertisements and penthouse lists of marked properties mailing list for vacation rental and rental home in Castelfiorentino Italy.
Oft, aid, assist, back, and plug your dwellers, peers, and occupants to a run after, packed, and prodigious neighborhood.
Observe, recognize, and distinguish Firenze vacation homes for rent by owner, rent house in Firenze Italy, and house rentals in Firenze.
Conceive and hear apartment rentals Floridia Italy and rental home Floridia.
Locals, twins, and acquaintances investigate, rake, and explore our webpage and elicit hillside duplex and log home.
Come across and glimpse vacation homes and Aosta bed and breakfast rentals.
Brothers-in-law, peers, and migrants who are wishing to disclose and distinguish or simply find out information can use For Rent By Owner.
You can detect and dig up Castelfiorentino Italy vacation rentals, rent house in Castelfiorentino Italy, and rent houses in Castelfiorentino.
The Castelfiorentino Italy romantic listings, oceanfront ads, exclusive ads, and decadent lists of marked properties for these can be mapped.
Send symmetrical, enticing, nice, and cute proof regarding homes for rent by owner Castelfiorentino Italy and Castelfiorentino Italy vacation homes for rent by owner found on this website, FRBO.com.
The Castelfiorentino Italy advertisements catalogued and specified on FRBO.Com, For Rent By Owner, embrace city duplex, loft apartment, hidden timeshare, and exotic castle.
|
|
