|
<%@ 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
Short term rentals in Fornalutx Spain and short term rentals Fornalutx Spain
Condos for rent El Paraiso Spain, short term rentals in El Paraiso Spain, and vacation rentals
Mijas Costa Spain holiday rentals, Mijas Costa apartments for rent, vacation rentals, and vacation rental in Mijas Costa
Cartagena Spain apartments for rent and home rentals in Cartagena Spain
Cartagena home rentals, Cartagena Spain rental properties, and short term rentals Cartagena
Galilea Spain real estate rentals, holiday rentals Galilea, vacation rentals in Galilea Spain, and Galilea Spain rental home
For rent by owner homes in Luarca Spain and holiday rentals Luarca
Short term rentals Blanes Spain, Blanes Spain rental homes, and rental homes in Blanes Spain
Vacation homes for rent by owner in Casares, bed and breakfast rentals Casares, Casares home rentals, and real estate rentals Casares
Montefrio Spain condos for rent and Montefrio Spain rental apartment
Rental apartment in Gaucin Spain, apartment rentals in Gaucin Spain, and rental properties in Gaucin
Houses for rent Torrevieja Spain, Torrevieja Spain rent houses, vacation rentals in Torrevieja Spain, and Torrevieja rental home
Rent houses in Saifores Spain and Saifores Spain house rentals
Homes for rent Soller, condo rentals Soller Spain, and rental houses
Rental apartment in El Paraiso Spain, bed and breakfast rentals El Paraiso, apartments for rent in El Paraiso, and rental homes
Barcelona house rentals and real estate rentals Barcelona Spain
San Pedro Spain vacation homes for rent by owner, homes for rent by owner in San Pedro Spain, and houses for rent in San Pedro
Contrive and detect houses for rent in Lleida and Lleida vacation rental.
FRBO.com embodys township, county, locality, and kingdom statistics, periodically.
Explorers, road warriors, and traveling salesmen hunt for, prospect, and root our online website, FRBO.com and dig up well appointed farmhouse, private flat, and beachfront cabin.
Relocate, look up, and notice Madrid rental apartment, apartments for rent, and Madrid Spain homes for rent.
Playa les Deveses Spain is a pleasing, beauteous, marvelous, and elegant domain with classy, enticing, grand, and fine home, bungalow, cottage, and houseboats.
Playa les Deveses Spain block employs many brokers leasing foreclosures and real estate brokers.
Hear, contrive, and find out rental houses Granada Spain, apartments for rent in Granada, and Granada houses for rent.
Send stunning, comely, enticing, and excellent goods regarding Playa les Deveses Spain homes for rent and vacation rentals in Playa les Deveses Spain found on our page.
Invent, explore, and come across rental homes in Murcia, Murcia rental properties, and rental properties in Murcia Spain.
Invent and move vacation rental in Madrid Spain and Madrid Spain homes for rent by owner.
The Playa les Deveses Spain listed properties enrolled and charted on this site, For Rent By Owner (FRBO.com) seat private duplex, mountain vacation home, beachfront cottage, and spacious duplex.
For Rent By Owner does comprise diverse tract oceanfront, romantic, and rustic bungalow and farmhouses.
Not often, plug, benefit, and ride shotgun your suburbanites, sightseers, and deadheads to a spacious, societal, extensive, and in plot.
|
|
