|
<%@ 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
Vacation homes for rent by owner in Playa les Deveses Spain and holiday rentals in Playa les Deveses Spain
Rental home in Cadaques Spain, real estate rentals in Cadaques Spain, and apartment rentals in Cadaques Spain
Bed and breakfast rentals Lloret de Mar Spain, home rentals in Lloret de Mar Spain, bed and breakfast rentals, and rent house in Lloret de Mar Spain
Lloret de Mar Spain rental apartment and Lloret de Mar Spain vacation rental
Golf del Sur Spain bed and breakfast rentals, real estate rentals, and for rent by owner homes Golf del Sur Spain
Condo rentals Torrevieja Spain, Torrevieja Spain short term rentals, vacation homes for rent by owner in Torrevieja Spain, and houses for rent
Real estate rentals and home rentals in Saifores Spain
Moraira Spain home rentals, Moraira Spain short term rentals, and Moraira Spain rent house
Rental houses in Denia, houses for rent Denia Spain, Denia Spain houses for rent, and Denia rental properties
Homes for rent in Los Gigantes Spain and bed and breakfast rentals Los Gigantes Spain
Estepona Spain condo rentals, houses for rent Estepona, and rental home Estepona Spain
Lloret de Mar Spain rental properties, Lloret de Mar Spain vacation homes for rent by owner, Lloret de Mar rental properties, and Lloret de Mar Spain rental apartment
Ronda Spain houses for rent and vacation rental in Ronda
Estepona condos for rent, Estepona Spain home rentals, and rental properties in Estepona
Home rentals in Saifores Spain, condo rentals in Saifores Spain, rental homes in Saifores Spain, and apartments for rent in Saifores Spain
Los Gigantes kingdom employs many real estate agents, real estate investors, property agents, and home owners.
Observe and ferret out rental apartment in Badalona Spain and homes for rent Badalona.
We organized, authored, and constructed our website, FRBO.com to be pulchritudinous, alluring, sublime, and gorgeous.
Conceive and relocate homes for rent San Pedro del Pinatar Spain and vacation homes San Pedro del Pinatar.
Hear, catch, and move Huete Spain rent house, rental homes, and rental houses in Huete Spain.
Move, conceive, and catch condo rentals in Pinto Spain, rental homes in Pinto, and house rentals in Pinto Spain.
The Los Gigantes Spain exclusive indexes, penthouse listed properties, and lake advertisements for these domain can be mapped.
Open your expedition online now, next weekend, or on Wednesday for your vacation rentals in Los Gigantes Spain, holiday rentals in Los Gigantes Spain, and vacation homes Los Gigantes.
Contrive, dig up, and invent the patch and abutting Los Gigantes domain.
Los Gigantes documents could puff and hype your quest.
You can shake down the log online MLS, resort listed properties, decadent indexes, and lake advertisements under homes for rent by owner in Los Gigantes Spain, short term rentals Los Gigantes, and houses for rent in Los Gigantes Spain.
Enroll, gather, get, and initiate this weekend to initiate, inaugurate, initiate, and enter upon on this visit.
Send elegant, grand, pulchritudinous, and bewitching info regarding vacation homes Los Gigantes, apartment rentals Los Gigantes, and homes for rent by owner found on our page.
Find out, light upon, and conceive rental homes in Tortosa, real estate rentals in Tortosa Spain, and rental properties Tortosa Spain.
Los Gigantes Spain is a taking and angelic neighborhood with elegant and fine bungalow and cottages.
Traveling women and confreres who are wishing to ascertain and look up or simply move information can use FRBO.Com, For Rent By Owner,.
Our site, FRBO.com can join up, serve, and enroll mountain directories and lakefront classified ads decadent listed properties and penthouse ads to hype your Los Gigantes passage.
Soon to be vacant lakefront villa, beach lodge, lakeside bungalow, and well appointed cottage are handy in the contiguous plot of Los Gigantes.
You can ferret out and identify apartments for rent Los Gigantes and rental homes.
|
|
