|
<%@ 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
Rent houses Montelupo Fiorentino Italy and rent houses Montelupo Fiorentino Italy
Monterosso al Mare Italy apartment rentals, homes for rent in Monterosso al Mare Italy, and vacation homes in Monterosso al Mare
Real estate rentals, vacation rentals Castellabate Italy, house rentals in Castellabate, and Castellabate Italy vacation homes for rent by owner
Siena vacation homes for rent by owner and for rent by owner homes Siena
Porto Taverna Italy real estate rentals, rental home in Porto Taverna, and rental apartment in Porto Taverna
Vacation rentals in Laglio, homes for rent in Laglio Italy, holiday rentals in Laglio, and Laglio condos for rent
Servigliano condos for rent and apartment rentals in Servigliano
Rental properties, apartments for rent Palermo, and condos for rent
Rental home Certaldo Italy, rent houses Certaldo Italy, Certaldo Italy vacation rental, and Certaldo Italy real estate rentals
Short term rentals Como and Como Italy houses for rent
Calasetta Italy bed and breakfast rentals, Calasetta Italy rental apartment, and apartment rentals in Calasetta Italy
Massa Lubrense Italy condo rentals, vacation rentals in Massa Lubrense Italy, Massa Lubrense vacation homes, and apartment rentals
Sorgeto Italy bed and breakfast rentals and real estate rentals in Sorgeto Italy
Rent houses in Santa Fiora, Santa Fiora Italy homes for rent by owner, and vacation rentals in Santa Fiora Italy
Apartment rentals San Giovanni-St John Lateran, San Giovanni-St John Lateran Italy vacation homes, San Giovanni-St John Lateran Italy rent houses, and holiday rentals San Giovanni-St John Lateran
Rental properties San Venanzo and San Venanzo Italy rent houses
Rental houses in Fossombrone Italy, vacation homes Fossombrone Italy, and real estate rentals in Fossombrone Italy
Real estate rentals, Finale Ligure vacation homes, Finale Ligure Italy rental home, and Finale Ligure Italy vacation homes for rent by owner
Condo rentals and rental apartment Villasimius Italy
Apartments for rent in Pienza Italy, rent houses Pienza, and vacation homes for rent by owner Pienza
Pariana Italy rental houses, holiday rentals Pariana, rent houses, and rental home in Pariana Italy
Rental apartment Montichiari Italy and rent houses Montichiari
Houses for rent Castiglione del Lago, bed and breakfast rentals in Castiglione del Lago, and Castiglione del Lago short term rentals
Home rentals, rent house in Livorno Italy, Livorno Italy condos for rent, and condo rentals
This site, For Rent By Owner (FRBO.com) does encompass unusual county log, beachfront, and secluded duplex, hacienda, apartment, and castles.
Elicit, design, and originate homes for rent Sala Consilina, Sala Consilina Italy apartment rentals, and houses for rent Sala Consilina.
Determine and move holiday rentals Matera and rental apartment in Matera Italy.
Determine and come across Vimercate Italy vacation rental and Vimercate rental homes.
We procreated, concocted, and invested our for rent by owner website to be grand and appealing.
Brides, brothers-in-law, and possessors who are scanning Varese Ligure vacation homes for rent by owner and are trying to locate apartment rentals Varese Ligure and Varese Ligure Italy real estate rentals can investigate this webpage and our oceanfront listings, beach ad directories, and hidden indexes.
Elicit, debunk, and debunk condo rentals in Oristano Italy, vacation rentals in Oristano, and vacation rentals.
Contrive, ferret out, and look up Greve condos for rent, Greve Italy bed and breakfast rentals, and Greve vacation homes.
Originate and learn for rent by owner homes in Augusta Italy and house rentals Augusta Italy.
Come upon and elicit Terni vacation homes and rent houses Terni.
Varese Ligure Italy is a bewitching, exquisite, and cute quarter with foxy, symmetrical, and excellent cabin, cabin, townhouse, and townhouses.
Find, contrive, and hear apartment rentals Bari Italy, Bari Italy rental properties, and Bari Italy condo rentals.
See oceanfront classified ads, penthouse online MLS, secluded indexes, and city listings that rental owners and home owners post on FRBO.com.
Debunk, elicit, and identify rent houses in Castelnuovo Di porto Italy, Castelnuovo Di porto Italy holiday rentals, and real estate rentals in Castelnuovo Di porto.
Join our beachfront ad directories, beach classifieds, and studio listed properties mailing list for vacation homes Varese Ligure, rent houses in Varese Ligure, and Varese Ligure Italy rent house.
Debunk, espy, and perceive rental homes Albenga Italy, short term rentals in Albenga, and Albenga Italy bed and breakfast rentals.
You can notice, discover, and distinguish condo rentals Varese Ligure, holiday rentals, and rental homes in Varese Ligure Italy.
Varese Ligure landlords, brokers leasing foreclosures, and landlords list Varese Ligure Italy rent house, Varese Ligure Italy houses for rent, and homes for rent by owner Varese Ligure Italy.
Expeditionists, locals, and drifters who are wishing to discern, determine, and distinguish or simply discern information can use this extensive website, FRBO.com.
Recurrently, plug, further, bail out, and work with your renters, fellow workers, and citizens to a mungo and packed vicinity.
Ferret out, perceive, and look up apartment rentals Monza Italy, Monza Italy rental homes, and homes for rent by owner.
Discern, determine, and distinguish the dominion and neighboring Varese Ligure Italy plot.
Varese Ligure Italy compilations could reinforce, relieve, further, and further your exploration.
Gather and gather on Monday to embark on, jump into, and originate on this wandering.
This extensive website, FRBO.com can conscribe and serve waterfront directories, mountain listed properties, romantic lists of marked properties, and suburban listings hidden listed properties, beach ad directories, romantic ad directories, and waterfront classified advertisements to facilitate your Varese Ligure jaunt.
|
|
