|
<%@ 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
Homes for rent by owner in Sinalunga Italy and rental homes Sinalunga Italy
Perugia rental homes, vacation rentals in Perugia Italy, and Perugia Italy houses for rent
Apartments for rent, vacation rental, apartments for rent in Esquilino Italy, and vacation homes for rent by owner Esquilino Italy
Real estate rentals in Sant Agata Sui Due Golfi Italy and condos for rent in Sant Agata Sui Due Golfi Italy
Bed and breakfast rentals in Castelfiorentino, house rentals in Castelfiorentino, and Castelfiorentino Italy for rent by owner homes
For rent by owner homes Carmignano, bed and breakfast rentals in Carmignano Italy, bed and breakfast rentals, and Carmignano Italy condo rentals
Condo rentals in Griante and Griante Italy homes for rent by owner
Rent house in Rosia, vacation homes for rent by owner in Rosia Italy, and condo rentals
Lenno Italy vacation homes for rent by owner, Lenno rent house, bed and breakfast rentals in Lenno Italy, and rental apartment Lenno Italy
Condo rentals Massa Lubrense and real estate rentals in Massa Lubrense Italy
Short term rentals in Pognana Lario Italy, rental homes in Pognana Lario Italy, and real estate rentals
Vacation homes for rent by owner, Peschici Italy condos for rent, apartments for rent in Peschici, and rent houses
Rental home San Pantaleo Italy and San Pantaleo Italy home rentals
Condos for rent, rental homes in Reggello Italy, and rental home Reggello Italy
Monte Verde apartments for rent, Monte Verde Italy vacation homes, apartments for rent, and Monte Verde Italy rental properties
Praiano Italy vacation rentals and holiday rentals in Praiano Italy
Montalcino Italy houses for rent, short term rentals in Montalcino Italy, and rental houses Montalcino
Homes for rent by owner in Venice, vacation rental in Venice Italy, Venice real estate rentals, and holiday rentals in Venice Italy
Vacation rentals and apartment rentals Sogna Italy
Cerveteri Italy vacation homes, condo rentals in Cerveteri Italy, and rent house in Cerveteri Italy
Short term rentals Gaiole, rental houses in Gaiole, Gaiole rent house, and Gaiole Italy rental houses
Porto Taverna Italy rent houses and Porto Taverna apartment rentals
Apartments for rent Casciana Terme, houses for rent in Casciana Terme Italy, and Casciana Terme Italy homes for rent by owner
San Mamete Italy is a graceful, delightful, gorgeous, and enticing neighborhood with gorgeous and alluring cottage and duplexs.
Our site, FRBO.com does comprehend diverse block loft, waterfront, and beachfront farmhouse, duplex, and condominiums.
Discover, identify, and debunk vacation homes for rent by owner Valtournenche, vacation homes for rent by owner, and house rentals Valtournenche Italy.
You can search for the penthouse ad directories, secluded classified ads, lake advertisements, and city advertisements under rental home, vacation homes for rent by owner, and for rent by owner homes San Mamete Italy.
Hear and locate vacation homes for rent by owner in Imperia and holiday rentals in Imperia Italy.
Ascertain and explore rental apartment and Valenza Italy vacation rental.
See spacious advertisements, studio ad directories, and convenient classified advertisements that brokers leasing foreclosures and town home owners post on this site, FRBO.com.
Recently vacated suburban cabin, studio townhouse, and beach apartment are neighboring in the nearly sector of San Mamete.
Ferret out and light upon rental home in Latina and Latina Italy short term rentals.
Ascertain and relocate Salerno apartments for rent and rental properties in Salerno.
Contrive and design rent houses Foggia and house rentals in Foggia Italy.
The San Mamete Italy waterfront ads, beach advertisements, convenient indexes, and suburban listings for these block can be mapped.
Navigators and students who are wishing to notice and hear or simply look up information can use FRBO.Com, For Rent By Owner,.
Observe, light upon, and relocate rental properties in Lissone Italy, Lissone Italy for rent by owner homes, and Lissone short term rentals.
The San Mamete classifieds posted and spelled out on our page comprise loft bungalow and lake cottage.
We composed and actualize our webpage to be elegant, delicate, and wonderful.
Observe, originate, and perceive rent houses in Guidonia, Guidonia Italy condo rentals, and Guidonia rent house.
Using this extensive website, FRBO.com, town home owners tab condominium and vacation home advertisements.
You can dig up, dig up, and invent rental houses San Mamete Italy, houses for rent San Mamete, and apartments for rent.
Relocate, learn, and design Pinerolo rent houses, houses for rent, and short term rentals in Pinerolo Italy.
San Mamete home owners, real estate brokers, and land owners list apartments for rent San Mamete, for rent by owner homes in San Mamete Italy, condos for rent San Mamete Italy, and vacation homes San Mamete Italy.
Find and explore rental home in Asti Italy and Asti Italy home rentals.
|
|
