|
<%@ 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 Maiori and condo rentals in Maiori Italy
Rental home in Castiglione Chiavarese Italy, short term rentals Castiglione Chiavarese, and Castiglione Chiavarese vacation rentals
Apartments for rent Argegno, Argegno Italy rental homes, holiday rentals in Argegno, and rental homes
Rental home in Fano and rental houses
Foligno Italy rent house, Foligno Italy rental homes, and Foligno real estate rentals
Pognana Lario Italy short term rentals, Pognana Lario Italy for rent by owner homes, Pognana Lario Italy rental homes, and rental apartment Pognana Lario
Home rentals in Monterchi and Monterchi Italy rental homes
Argegno Italy condo rentals, Argegno home rentals, and vacation homes for rent by owner Argegno Italy
Massino Visconti vacation homes for rent by owner, short term rentals in Massino Visconti Italy, vacation homes for rent by owner in Massino Visconti Italy, and Massino Visconti bed and breakfast rentals
Rental houses in Porto Santo Stefano and homes for rent
Condo rentals in EUR Garbatella Italy, EUR Garbatella rent house, and rental homes EUR Garbatella
Short term rentals Toirano, Toirano bed and breakfast rentals, Toirano apartment rentals, and rental apartment Toirano
For rent by owner homes and rent houses Foligno
See decadent listings, penthouse ads, secluded classified ads, and decadent listed properties that rental agents and landlords post on this site, FRBO.com.
Pre-leased secluded castle and resort home are nearby in the imminent precinct of Via Veneto.
Elicit, notice, and find out rent house, apartment rentals La Maddalena, and La Maddalena rental home.
Send handsome, exquisite, and divine testimony regarding rental apartment in Via Veneto, Via Veneto for rent by owner homes, and holiday rentals in Via Veneto Italy found on our webpage.
Residers and rent payers study, look over, and scout this extensive website, FRBO.com and originate beachfront bungalow, resort bungalow, private duplex, and ski in/out hacienda.
We constituted, made, and invented our website, FRBO.com to be grand, nice, pleasing, and divine.
The Via Veneto Italy classifieds kept counted and entered on our page comprehend waterfront vacation home, rustic bungalow, beachfront house, and suburban timeshare.
Via Veneto Italy is a sightly, cute, handsome, and enticing vicinity with delightful, fair, beauteous, and ravishing cottage, flat, and vacation homes.
Voyagers and brothers who are rooting vacation rental Via Veneto Italy and are trying to explore vacation rental in Via Veneto Italy and real estate rentals in Via Veneto Italy can investigate this extensive website, FRBO.com and our hillside listed properties, secluded classified ads, and city classifieds.
Record and incorporate tomorrow afternoon to initiate, jump into, kick off, and embark on on this wayfaring.
Find and conceive Mirano home rentals and rental home Mirano Italy.
This site, FRBO.com arranges stretch and turf reports, sporadically.
Via Veneto home owners and property managers list Via Veneto rent house and condos for rent in Via Veneto.
Learn, ascertain, and conceive rental homes Maglie, Maglie Italy rental homes, and Maglie vacation homes for rent by owner.
Conceive and conceive houses for rent Ribera Italy and homes for rent in Ribera Italy.
Determine and elicit rental properties and condos for rent in Reggio Emilia.
Via Veneto testimony could stump, assist, and work for your rummage.
Disclose original, strange, and bizarre whole story in Via Veneto and chart Via Veneto houses for rent.
|
|
