|
<%@ 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
Rental home in Roses Spain and Roses Spain homes for rent
Blanes rent house, Blanes Spain rental houses, and rental houses Blanes Spain
Condos for rent in La Cala Del Moral Spain, condos for rent La Cala Del Moral Spain, La Cala Del Moral Spain houses for rent, and real estate rentals
Golf del Sur Spain apartments for rent and vacation rentals Golf del Sur Spain
Rent house Galilea Spain, houses for rent Galilea Spain, and Galilea home rentals
Rental properties Playa les Deveses Spain, Playa les Deveses Spain apartment rentals, Playa les Deveses Spain holiday rentals, and rental houses in Playa les Deveses Spain
Mijas Costa Spain home rentals and houses for rent Mijas Costa
Barcelona rent houses, home rentals in Barcelona Spain, and Barcelona Spain homes for rent by owner
Benalmadena Costa condo rentals, rent houses, rent house in Benalmadena Costa Spain, and Benalmadena Costa vacation homes for rent by owner
Rental homes Los Gigantes Spain and Los Gigantes Spain rental houses
Calahonda Spain homes for rent by owner, rent house, and Calahonda Spain rental houses
Los Gigantes bed and breakfast rentals, rental home in Los Gigantes Spain, rental houses Los Gigantes Spain, and vacation homes in Los Gigantes Spain
Rental apartment in Granada Spain and condo rentals in Granada
Vacation rentals Carboneras Spain, vacation homes in Carboneras, and bed and breakfast rentals Carboneras Spain
Gaucin Spain home rentals, short term rentals in Gaucin Spain, vacation rental, and Gaucin vacation homes
Granada condos for rent and Granada Spain homes for rent by owner
Salobrena Spain rent house, Salobrena Spain bed and breakfast rentals, and rent houses Salobrena Spain
Girona Spain for rent by owner homes, vacation rental, bed and breakfast rentals Girona, and rental home
Condo rentals Mijas Spain and rental apartment in Mijas Spain
House rentals in Playa del Ingles Spain, Playa del Ingles vacation homes for rent by owner, and Playa del Ingles Spain rent house
Bed and breakfast rentals in Puerto Banus Spain, house rentals Puerto Banus Spain, for rent by owner homes in Puerto Banus Spain, and vacation homes for rent by owner Puerto Banus
House rentals in Galilea Spain and holiday rentals in Galilea Spain
House rentals in Mojacar Spain, Mojacar real estate rentals, and vacation rental in Mojacar
San Pedro Spain real estate rentals, condos for rent in San Pedro, San Pedro Spain vacation rental, and real estate rentals San Pedro
Apartment rentals Playa del Ingles and house rentals in Playa del Ingles
Rent house Llanca, short term rentals, and homes for rent by owner in Llanca Spain
Holiday rentals in Puerto Duquesa, vacation homes in Puerto Duquesa Spain, Puerto Duquesa holiday rentals, and Puerto Duquesa Spain bed and breakfast rentals
Guajar Alto Spain rental homes and rent houses
Vacation rentals in Guajar Alto, rental homes Guajar Alto, and Guajar Alto Spain rental apartment
Rental houses, Salobrena apartment rentals, for rent by owner homes, and home rentals in Salobrena Spain
Cadaques Spain holiday rentals and short term rentals in Cadaques Spain
Generally, support and abet your habitants and tourists to a prominent, taking, bull, and bewitching locality.
Draft and assign on Thursday to open, take up, and kick off on this sally.
Soon to be vacant ski in/out villa, beachfront timeshare, penthouse bungalow, and exotic cottage are convenient in the not far block of Mijas Costa Spain.
Hear, identify, and espy Petra Spain homes for rent by owner, real estate rentals Petra Spain, and condos for rent.
Ascertain and dig up holiday rentals and Aviles Spain vacation rental.
Learn and notice homes for rent Córdoba and rent houses Córdoba.
Taormina Italy rent house and vacation rentals Taormina
Homes for rent Ennis Ireland, rental properties in Ennis, condos for rent in Ennis Ireland, and rent houses in Ennis Ireland
Conceive and distinguish Aledo Spain rental apartment and rental homes in Aledo Spain.
House rentals in Citta della Pieve Italy, Citta della Pieve condos for rent, and Citta della Pieve Italy rental houses
Observe, elicit, and learn apartment rentals in Burriana Spain, rental apartment in Burriana Spain, and condos for rent in Burriana.
Lamia short term rentals, rental houses, Lamia Greece vacation rental, and for rent by owner homes in Lamia Greece
Send comely and graceful dossier regarding bed and breakfast rentals Mijas Costa, holiday rentals Mijas Costa Spain, Mijas Costa for rent by owner homes, and homes for rent Mijas Costa found on FRBO.com.
Our page can draft, induct, and levy resort directories, waterfront directories, convenient classified ads, and convenient listed properties beachfront directories and rustic classified advertisements to boost your Mijas Costa transit.
You can detect, catch, and learn rent house and homes for rent.
Learn, notice, and conceive rental home Santander, vacation homes in Santander Spain, and homes for rent by owner Santander.
Distinguish and discover houses for rent and home rentals in Valdepenas Spain.
Discover, invent, and perceive bed and breakfast rentals, Yecla vacation rental, and homes for rent by owner Yecla.
Determine, come across, and detect house rentals El Prat De Llobregat, El Prat De Llobregat Spain for rent by owner homes, and vacation rentals in El Prat De Llobregat Spain.
Rent payers, explorers, and confidants who are wishing to explore and discern or simply locate information can use our site, FRBO.com.
Rental homes, holiday rentals in Skopelos, short term rentals in Skopelos, and Skopelos Greece rental apartment
Identify, disclose, and catch Santa Fe rent house, short term rentals in Santa Fe, and houses for rent in Santa Fe Spain.
Debunk and detect house rentals and houses for rent in Jerez de la Frontera.
Conceive, invent, and determine home rentals Daganzo de Arriba Spain, Daganzo de Arriba rent house, and homes for rent Daganzo de Arriba Spain.
Espy and discover rental properties in Mazarron and real estate rentals in Mazarron Spain.
Look up and notice Vera Spain rent house and condos for rent.
Perpignan France rental properties and rental home in Perpignan France
Mijas Costa is a divine, alluring, pulchritudinous, and angelic territory with classy and elegant apartment, lodge, farmhouse, and bungalows.
|
|
