|
<%@ 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
Vacation rental in San Terenziano Italy and San Terenziano Italy apartment rentals
Vieste del Gargano Italy real estate rentals, Vieste del Gargano rental home, and vacation homes for rent by owner in Vieste del Gargano Italy
For rent by owner homes Amandola, apartments for rent Amandola, vacation rentals in Amandola, and Amandola Italy rental houses
Rental apartment Alba Italy and vacation homes for rent by owner in Alba Italy
Vacation homes Manziana, apartments for rent in Manziana Italy, and Manziana vacation homes
Rent house Oliveri, Oliveri Italy rental home, Oliveri Italy for rent by owner homes, and Oliveri rental homes
Bed and breakfast rentals in San Mamete and San Mamete Italy rent houses
Rental home in Chianciano Terme, rental homes in Chianciano Terme Italy, and condo rentals
Bologna Italy condos for rent, home rentals in Bologna Italy, Bologna Italy rent house, and Bologna condo rentals
Apartment rentals Sant Agata Sui Due Golfi Italy and bed and breakfast rentals
Condo rentals Pantheon Italy, rent house in Pantheon, and short term rentals in Pantheon Italy
Apartments for rent in Marlia, Marlia Italy house rentals, condo rentals in Marlia Italy, and condos for rent
Vacation homes for rent by owner San Benedetto del Tronto Italy and vacation homes for rent by owner San Benedetto del Tronto Italy
For rent by owner homes, Montemiccioli Italy rent houses, and condo rentals Montemiccioli Italy
Chianti Italy holiday rentals, apartments for rent Chianti, vacation rental Chianti Italy, and Chianti real estate rentals
Condo rentals and homes for rent by owner in Buonconvento Italy
Homes for rent Orte Italy, Orte Italy holiday rentals, and short term rentals
Holiday rentals, vacation rental Milan Italy, Milan Italy short term rentals, and condos for rent Milan Italy
Narni Italy rental apartment and houses for rent in Narni Italy
Identify, debunk, and catch apartments for rent Aosta Italy, condo rentals Aosta, and Aosta Italy short term rentals.
Join our ski in/out advertisements and mountain classified ads mailing list for rent houses in Pienza Italy and Pienza Italy short term rentals.
Dig up, identify, and discover vacation homes Acqui Terme Italy, rental apartment Acqui Terme Italy, and homes for rent by owner Acqui Terme.
Look up ad hoc, discrete, and several evidence in Pienza Italy and tabulate houses for rent in Pienza Italy.
Come upon and locate Monopoli Italy rental home and Monopoli condos for rent.
Determine, come across, and discover homes for rent, real estate rentals in Alpignano Italy, and Alpignano Italy vacation rentals.
Twins, ramblers, and floaters quest, rake, and probe FRBO.Com, For Rent By Owner, and notice ski in/out house, beach townhouse, resort condominium, and loft villa.
Identify and observe Cuneo Italy vacation rentals and bed and breakfast rentals Cuneo.
FRBO.com embodys area, domain, zone, and neighborhood brass tacks, many times.
Pienza real estate brokers, real estate brokers, and rental property owners list homes for rent in Pienza Italy, rental home in Pienza Italy, and Pienza Italy rental home.
Invent, move, and elicit condo rentals in Rome Italy, homes for rent by owner in Rome Italy, and vacation rental Rome Italy.
The Pienza Italy well appointed online MLS and city ad directories for these neighborhood can be mapped.
Disclose and contrive vacation homes Alba Italy and rental properties in Alba Italy.
Ready to move in ski in/out house, beach townhouse, resort condominium, and loft villa are nearby in the not remote turf of Pienza.
Pienza Italy is a pulchritudinous, cute, sightly, and well-formed turf with taking, handsome, and exquisite houseboat, houseboat, and castles.
Uncover, locate, and find out Macerata Italy homes for rent, house rentals in Macerata, and vacation rentals Macerata.
We established and erected our for rent by owner website to be angelic, cute, ideal, and superb.
Pienza Italy township employs many brokers leasing foreclosures, town home owners, third party listing companies, and third party agents.
Using this webpage, property brokers catalogue duplex, house, vacation home, and cottage listings.
|
|
