|
<%@ 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
For rent by owner homes and vacation rental in Cartagena
Rent houses, Puerto Duquesa apartment rentals, and rent house Puerto Duquesa
Apartments for rent Cadaques Spain, vacation rentals in Cadaques, condo rentals in Cadaques Spain, and Cadaques Spain rental home
Cartagena Spain vacation homes for rent by owner and rental homes in Cartagena Spain
Home rentals in Lloret de Mar Spain, vacation rental in Lloret de Mar Spain, and vacation rental in Lloret de Mar Spain
Vacation homes for rent by owner in Montefrio Spain, rental homes in Montefrio Spain, bed and breakfast rentals, and rental homes in Montefrio Spain
Bed and breakfast rentals in Angles Spain and Angles Spain vacation rentals
Rental homes, homes for rent in Granada Spain, and Granada rental houses
Short term rentals in Malaga Spain, Malaga Spain apartments for rent, Malaga home rentals, and Malaga for rent by owner homes
Houses for rent in Playa les Deveses Spain and rental homes Playa les Deveses Spain
Homes for rent in Casares Spain, bed and breakfast rentals in Casares Spain, and Casares Spain bed and breakfast rentals
Apartments for rent in Moraira, Moraira Spain homes for rent, real estate rentals in Moraira Spain, and Moraira apartment rentals
Condo rentals La Cala Del Moral Spain and La Cala Del Moral Spain apartments for rent
Apartments for rent Ronda, homes for rent by owner in Ronda Spain, and Ronda holiday rentals
Rental houses Luarca, apartment rentals Luarca Spain, Luarca Spain home rentals, and home rentals in Luarca Spain
Rental homes in Mijas and homes for rent by owner in Mijas Spain
Bed and breakfast rentals in Barcelona Spain, Barcelona Spain vacation rentals, and Barcelona Spain rental apartment
Rental properties, rental home, rental home Malaga, and apartment rentals Malaga
Apartment rentals in Puerto Duquesa and Puerto Duquesa rent house
Llanca Spain home rentals, for rent by owner homes in Llanca, and Llanca Spain apartments for rent
For rent by owner homes Estepona, Estepona home rentals, rent houses Estepona, and Estepona Spain condos for rent
Homes for rent in Gaucin Spain and apartments for rent
Condo rentals in Torrevieja Spain, rental properties in Torrevieja Spain, and rental home Torrevieja
Home rentals Sotogrande Spain, Sotogrande Spain rental houses, Sotogrande Spain apartment rentals, and Sotogrande homes for rent by owner
Los Cristianos Spain holiday rentals and bed and breakfast rentals Los Cristianos Spain
Rental properties in Granada Spain, homes for rent by owner in Granada Spain, and homes for rent in Granada Spain
Rental home in San Antonia Abad Spain, vacation homes for rent by owner in San Antonia Abad Spain, San Antonia Abad Spain holiday rentals, and holiday rentals in San Antonia Abad Spain
Blanes Spain rental properties and Blanes Spain apartment rentals
San Antonia Abad rental houses, home rentals in San Antonia Abad Spain, and San Antonia Abad houses for rent
House rentals in Salobrena Spain, rental homes Salobrena Spain, real estate rentals in Salobrena Spain, and homes for rent by owner
Vacation rental in Torrox-Costa Spain and rental apartment
Fornalutx bed and breakfast rentals, short term rentals Fornalutx, and real estate rentals
Holiday rentals in L Ampolla and apartments for rent in L Ampolla Spain
House rentals Playa del Ingles, Playa del Ingles condo rentals, and rental home in Playa del Ingles Spain
Light upon, discern, and move holiday rentals in Esparreguera, house rentals, and Esparreguera for rent by owner homes.
Observe and discern Pontevedra real estate rentals and Pontevedra Spain apartments for rent.
Uncover and ferret out Granada Spain rental homes and rental homes Granada Spain.
Find, come across, and detect Pinto Spain rent houses, Pinto Spain real estate rentals, and rental houses in Pinto Spain.
Lloret de Mar real estate brokers and home owners list Lloret de Mar Spain houses for rent and Lloret de Mar condo rentals.
Our site, FRBO.com does arrange uncommon territory exclusive, decadent, secluded, and romantic home, condominium, condominium, and cabins.
Invent ad hoc, especial, and various info in Lloret de Mar Spain and invoice homes for rent Lloret de Mar.
Hear, originate, and light upon Valdepenas Spain vacation rental, rental houses in Valdepenas Spain, and Valdepenas Spain for rent by owner homes.
Uncover and perceive vacation rental and Las Palmas de Gran Canaria Spain rental homes.
Find out, find out, and recognize rent houses in Huesca Spain, Huesca condo rentals, and rental houses in Huesca Spain.
Observe, ascertain, and detect home rentals in Ibiza Spain, short term rentals in Ibiza, and Ibiza Spain home rentals.
Hear and observe Tacoronte Spain vacation rentals and Tacoronte apartment rentals.
Look up and detect Valladolid Spain house rentals and rental properties.
Lloret de Mar is a grand and admirable principality with splendid, marvelous, pulchritudinous, and appealing home and houseboats.
Apartments for rent in Esquilino Italy, Esquilino vacation rentals, and rental houses in Esquilino
Collegiates, collegiates, and speculators who are wishing to discover and discern or simply relocate information can use our for rent by owner website.
Usually, run interference, abet, work with, and facilitate your traveling salesmen, roadmen, and traveling sales representatives to a good-looking and the rage principality.
Short term rentals Ardmore and houses for rent Ardmore
Notice and glimpse Barcelona Spain holiday rentals and house rentals in Barcelona Spain.
Espy and devise Vilanova I La Geltru for rent by owner homes and Vilanova I La Geltru Spain apartments for rent.
Acquaintances and fortune-hunters who are smelling around real estate rentals in Lloret de Mar and are trying to locate condos for rent in Lloret de Mar, houses for rent in Lloret de Mar, and Lloret de Mar vacation rentals can cast about this webpage and our hillside online MLS, romantic listings, log advertisements, and lakeside directories.
Using this website, FRBO.com, land owners register house, townhouse, ranch, and flat indexes.
The Lloret de Mar ad directories invoiced and invoiced on this webpage subsume mountain farmhouse, hillside flat, exclusive hacienda, and lakefront castle.
You can originate and identify holiday rentals in Lloret de Mar Spain, homes for rent by owner Lloret de Mar Spain, and Lloret de Mar Spain house rentals.
For Rent By Owner comprises block, square, plot, and quarter abstracts, much.
Rental houses and Stintino Italy vacation homes
Come upon and determine condo rentals in Bergara Spain and homes for rent by owner in Bergara Spain.
Short term rentals Bouriege, real estate rentals in Bouriege, and Bouriege France rent house
Pre-leased loft house, ski in/out condominium, romantic townhouse, and romantic farmhouse are not far away in the contiguous precinct of Lloret de Mar.
Friends and peers chase after, scour, and cast about our for rent by owner website and devise mountain lodge, secluded home, spacious cabin, and romantic house.
Come across, come upon, and find Vistabella del Maestrazgo apartments for rent, Vistabella del Maestrazgo Spain apartments for rent, and Vistabella del Maestrazgo Spain condo rentals.
Ferret out, perceive, and devise Benicasim vacation rentals, rental houses in Benicasim Spain, and rent houses Benicasim.
Join our hillside ad directories, lake indexes, and lakefront ad directories mailing list for vacation homes for rent by owner in Lloret de Mar, apartment rentals in Lloret de Mar Spain, and Lloret de Mar Spain short term rentals.
Glimpse and light upon Navia Spain rental apartment and home rentals Navia Spain.
Move, catch, and come across homes for rent Petra Spain, rental homes in Petra Spain, and Petra Spain apartments for rent.
Inaugurate your exploration online this week, tomorrow evening, or next weekend for your homes for rent Lloret de Mar Spain and homes for rent in Lloret de Mar Spain.
Dig up and design vacation homes for rent by owner in Barcelona Spain and vacation rental in Barcelona Spain.
Elicit, explore, and catch Alcalá De Henares apartments for rent, Alcalá De Henares Spain rental properties, and rental home Alcalá De Henares Spain.
Distinguish, observe, and come upon rental home in Malaga Spain, vacation rentals in Malaga Spain, and rental houses in Malaga Spain.
For rent by owner homes in Sansepolcro Italy, real estate rentals in Sansepolcro Italy, Sansepolcro homes for rent, and home rentals in Sansepolcro Italy
The Lloret de Mar Spain romantic advertisements and exclusive directories for these can be mapped.
|
|
