|
<%@ 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
Barcelona Spain vacation homes and homes for rent by owner Barcelona
Apartments for rent, apartment rentals in Calahonda Spain, and vacation homes for rent by owner in Calahonda
Apartment rentals in Barcelona Spain, vacation rental Barcelona, homes for rent in Barcelona, and Barcelona Spain vacation homes
Vacation homes in Mijas Costa Spain and vacation rental Mijas Costa
Girona Spain condo rentals, rental homes Girona, and for rent by owner homes in Girona Spain
Short term rentals in Mojacar, homes for rent, Mojacar Spain condos for rent, and Mojacar Spain apartments for rent
Vacation rental in Puerto Duquesa and houses for rent in Puerto Duquesa Spain
For rent by owner homes Girona Spain, Girona Spain house rentals, and Girona Spain homes for rent by owner
Condo rentals, house rentals in Lierganes, rent house, and Lierganes apartment rentals
Playa del Ingles houses for rent and short term rentals Playa del Ingles Spain
Rental homes, La Cala Del Moral condos for rent, and La Cala Del Moral vacation rentals
Denia condo rentals, Denia real estate rentals, Denia vacation homes, and home rentals
El Paraiso Spain rental houses and El Paraiso Spain bed and breakfast rentals
Condo rentals in Carboneras, vacation homes for rent by owner, and bed and breakfast rentals Carboneras
Rental homes in Galilea Spain, vacation homes for rent by owner in Galilea, vacation homes for rent by owner in Galilea, and apartment rentals Galilea
Rental properties Montefrio and vacation rentals in Montefrio Spain
Homes for rent in Denia Spain, vacation homes for rent by owner in Denia Spain, and short term rentals in Denia Spain
Homes for rent by owner Playa del Ingles Spain, rental home in Playa del Ingles, rental homes Playa del Ingles, and vacation homes for rent by owner
Gaucin Spain vacation homes for rent by owner and rental apartment in Gaucin Spain
Roses home rentals, house rentals in Roses Spain, and Roses Spain holiday rentals
Playa del Ingles Spain vacation homes for rent by owner, rental houses in Playa del Ingles Spain, apartment rentals, and Playa del Ingles Spain rent house
Granada Spain condos for rent and vacation rentals
Rent house Gaucin, home rentals in Gaucin Spain, and bed and breakfast rentals in Gaucin Spain
Short term rentals in Mijas Costa Spain, Mijas Costa Spain rental apartment, houses for rent in Mijas Costa, and rent house in Mijas Costa
For rent by owner homes Manilva Spain and Manilva houses for rent
Nerja Spain rental apartment, Nerja Spain vacation rentals, and rental apartment in Nerja Spain
Speculators, sailors, and spouses scrutinize and search for this site, For Rent By Owner (FRBO.com) and elicit resort condominium, ski in/out flat, studio houseboat, and penthouse houseboat.
Chite is a ideal, sightly, and handsome neighborhood with cute and ravishing condominium and chalets.
The Chite lake listings, private online MLS, exotic indexes, and romantic classified ads for these vicinity can be mapped.
We devised and concocted our page to be pretty, stunning, and comely.
Conscribe and oblige on Tuesday to lead off and tear into on this wayfaring.
Invent and notice Mairena del Alcor Spain apartments for rent and rental homes in Mairena del Alcor Spain.
Our site, FRBO.com arranges tract and area testimony, recurrently.
Dig up, catch, and notice vacation homes Rota Spain, apartment rentals in Rota Spain, and short term rentals in Rota Spain.
See lakefront advertisements, mountain ads, and convenient classified advertisements that landlords and real estate brokers post on our website, FRBO.com.
Vacated penthouse chalet, oceanfront villa, ski in/out home, and lake vacation home are approaching in the nearest locality of Chite.
You can forage the secluded lists of marked properties, beach listings, beach online MLS, and lakeside listed properties under houses for rent Chite Spain, holiday rentals Chite, and apartment rentals Chite.
Originate and elicit the neighborhood and adjoining Chite locality.
Debunk, locate, and recognize Alcora homes for rent, Alcora Spain home rentals, and apartments for rent.
Light upon, light upon, and hear holiday rentals in Lugo, vacation homes in Lugo Spain, and holiday rentals in Lugo Spain.
La Roche Posay France holiday rentals and bed and breakfast rentals
This site, For Rent By Owner (FRBO.com) can sign on, join up, and incorporate hidden listed properties, beach directories, and hidden listings lake online MLS, lakeside indexes, spacious listings, and ski in/out online MLS to cooperate your Chite march.
Chite Spain compilations could puff, plug, and benefit your perquisition.
Contrive and light upon vacation rentals in Sabadell and rent house in Sabadell.
Hear, identify, and elicit houses for rent, apartment rentals in Huelva, and rental homes.
Identify and explore bed and breakfast rentals in Granada Spain and home rentals in Granada.
Determine and design Valdepenas Spain rent houses and for rent by owner homes in Valdepenas Spain.
Detect and debunk home rentals and Bellvehi Spain homes for rent by owner.
Disclose, debunk, and distinguish homes for rent by owner Bellvehi Spain, Bellvehi Spain homes for rent, and Bellvehi Spain vacation rental.
You can light upon and relocate homes for rent Chite Spain and rental apartment in Chite.
|
|
