|
<%@ 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" %>
|
Spain Rental Links
Real estate rentals in Girona Spain and Girona Spain rental home
Homes for rent, vacation rental Torrox-Costa, and for rent by owner homes Torrox-Costa
Vacation rental in Casares, Casares Spain rental home, Casares Spain houses for rent, and house rentals in Casares
Short term rentals in Malaga Spain and rental properties in Malaga Spain
Holiday rentals in Playa del Ingles Spain, rental houses in Playa del Ingles, and Playa del Ingles condos for rent
Rent house, rent house Gaucin Spain, vacation homes for rent by owner Gaucin Spain, and Gaucin Spain condos for rent
Rent house Ronda and Ronda rent houses
House rentals in Los Gigantes Spain, Los Gigantes Spain rental home, and apartment rentals Los Gigantes
Torrox-Costa Spain real estate rentals, house rentals in Torrox-Costa Spain, house rentals, and homes for rent in Torrox-Costa Spain
Rental houses in Girona and holiday rentals in Girona
Rental properties Angles Spain, homes for rent in Angles, and vacation homes Angles Spain
Angles rental home, Angles Spain for rent by owner homes, rental homes Angles, and bed and breakfast rentals
Roses Spain real estate rentals and Roses Spain rental properties
Rental home in Nerja Spain, Nerja condo rentals, and Nerja Spain rental houses
Rental houses Marbella Spain, Marbella Spain apartment rentals, rental homes Marbella, and apartments for rent in Marbella Spain
Short term rentals in Los Gigantes Spain and houses for rent Los Gigantes Spain
Mijas Costa Spain bed and breakfast rentals, Mijas Costa Spain homes for rent by owner, and real estate rentals in Mijas Costa
Rental houses in Cartagena Spain, vacation rentals Cartagena Spain, Cartagena Spain rental homes, and apartment rentals Cartagena Spain
Salobrena Spain rent house and Salobrena rental home
Vacation homes for rent by owner in Granada Spain, Granada Spain rent houses, and Granada Spain homes for rent by owner
Ronda Spain house rentals, holiday rentals Ronda Spain, Ronda Spain apartments for rent, and Ronda Spain rental homes
Cadaques Spain rental apartment and vacation homes for rent by owner Cadaques Spain
Torrox-Costa vacation rental, rent house, and home rentals in Torrox-Costa
San Antonia Abad Spain for rent by owner homes, rental apartment San Antonia Abad Spain, house rentals in San Antonia Abad Spain, and rental houses in San Antonia Abad Spain
Uncover and conceive homes for rent by owner in Pontevedra and condo rentals in Pontevedra Spain.
Elicit and ascertain house rentals Santiago de Compostela and Santiago de Compostela bed and breakfast rentals.
Glimpse peculiar, small number, and particular scoop in Soller Spain and invoice Soller Spain rental properties.
Send wonderful, angelic, and resplendent results regarding houses for rent in Soller and short term rentals found on our website, FRBO.com.
Ready to move in log timeshare, exclusive hacienda, and ski in/out flat are near-at-hand in the nearest patch of Soller Spain.
Soller dope could benefit, root for, stump, and support your inquest.
Invent, distinguish, and elicit rental home in Valencia Spain, rental apartment, and condo rentals in Valencia Spain.
Soller Spain is a taking and pleasing territory with ravishing, nice, wonderful, and pulchritudinous duplex, vacation home, apartment, and bungalows.
Notice and design apartment rentals Jerez de la Frontera Spain and Jerez de la Frontera Spain houses for rent.
Ferret out, relocate, and observe vacation homes in Córdoba, home rentals Córdoba Spain, and real estate rentals in Córdoba Spain.
Find and espy rental houses in Manresa Spain and Manresa Spain real estate rentals.
Notice and locate apartment rentals in Algeciras Spain and vacation rentals in Algeciras Spain.
Soller Spain territory employs many property brokers, brokers leasing foreclosures, third party listing companies, and third party agents.
Join our oceanfront ads, mountain lists of marked properties, lake advertisements, and studio advertisements mailing list for Soller houses for rent, Soller Spain short term rentals, and vacation rentals in Soller Spain.
Originate and ascertain Alcalá De Henares holiday rentals and house rentals in Alcalá De Henares Spain.
We initiated and established our for rent by owner site, FRBO.com to be superb, lovely, grand, and well-formed.
Disclose, determine, and perceive Mollerusa Spain apartments for rent, vacation rentals in Mollerusa Spain, and rental homes.
Originate your pursual online on Friday or this weekend for your real estate rentals in Soller, house rentals, and Soller bed and breakfast rentals.
Trekkers, road warriors, and confidants who are wishing to uncover and discern or simply design information can use this site, FRBO.com.
|
|
