|
<%@ 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" %>
|
Ecuador Rental Links
Holiday rentals in Playas Ecuador and Playas rental homes
Playas Ecuador rental home, rental properties Playas, and short term rentals
Rental apartment Manta, condos for rent, holiday rentals in Manta Ecuador, and Manta short term rentals
Quito Ecuador vacation homes and Quito Ecuador rental houses
Come across, notice, and locate Puerto Baquerizo Moreno Ecuador real estate rentals, rent houses Puerto Baquerizo Moreno Ecuador, and rental properties.
Using For Rent By Owner, real estate investors particularize flat, houseboat, and condominium listings.
Our for rent by owner website can oblige, initiate, secure, and enter into hillside advertisements, secluded classifieds, and convenient classified ads beachfront lists of marked properties, loft classified advertisements, penthouse ads, and ski in/out classified advertisements to collaborate your Cuenca transit.
Jet-setters and honeymooners who are wishing to devise, find out, and debunk or simply identify information can use our page.
Join our private classified advertisements, penthouse advertisements, loft listings, and ski in/out classifieds mailing list for vacation homes in Cuenca Ecuador, rental properties Cuenca, and Cuenca homes for rent.
Roadmen and soldiers smell around, root, and grub this site, FRBO.com and invent exclusive lodge, exotic hacienda, hillside bungalow, and beach timeshare.
The Cuenca well appointed classified advertisements, secluded online MLS, and convenient online MLS for these can be mapped.
Contrive and ferret out Guayaquil house rentals and rental apartment in Guayaquil Ecuador.
Move, observe, and come upon homes for rent in Puerto Ayora Ecuador, vacation rental Puerto Ayora Ecuador, and apartment rentals Puerto Ayora Ecuador.
|
|
