|
<%@ 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" %>
|
Honduras Rental Links
Vacation rental and rent houses Palmetto Bay
Vacation rentals in Calabash Bight Honduras, condo rentals, and for rent by owner homes Calabash Bight
Apartment rentals in West End, apartment rentals West End Honduras, rental home, and apartments for rent in West End Honduras
La Ceiba rental home and La Ceiba Honduras houses for rent
Holiday rentals, houses for rent in Turtle Crossing Honduras, and apartments for rent in Turtle Crossing Honduras
Holiday rentals in Palmetto Bay Honduras, rental apartment Palmetto Bay Honduras, rent houses in Palmetto Bay Honduras, and Palmetto Bay Honduras bed and breakfast rentals
Palmetto Bay rental homes and Palmetto Bay Honduras rental apartment
French Caye Honduras vacation rental, for rent by owner homes French Caye Honduras, and French Caye rent house
Rental houses in Politilly Bight Honduras, condos for rent Politilly Bight Honduras, rent house, and rental home in Politilly Bight Honduras
Condos for rent in Sandy Bay and Sandy Bay houses for rent
For rent by owner homes in Oak Ridge Honduras, home rentals Oak Ridge, and rent houses Oak Ridge
Calabash Bight Honduras home rentals, vacation rental, rental apartment Calabash Bight Honduras, and Calabash Bight Honduras vacation rental
Homes for rent Palmetto Bay Honduras and apartment rentals
Vacation homes French Caye Honduras, rental homes in French Caye Honduras, and French Caye Honduras condos for rent
Rental houses La Ceiba, homes for rent La Ceiba, short term rentals La Ceiba Honduras, and real estate rentals in La Ceiba Honduras
Short term rentals in Utila and rental apartment
Trujillo Honduras holiday rentals, apartment rentals in Trujillo Honduras, and rental houses in Trujillo Honduras
Migrants, globetrotters, and expeditionists who are searching bed and breakfast rentals in Politilly Bight Honduras and are trying to elicit rental homes Politilly Bight Honduras, house rentals in Politilly Bight Honduras, and homes for rent Politilly Bight can rake this extensive website, FRBO.com and our lakefront classifieds, private classified advertisements, city directories, and log classified advertisements.
We fabricated and formulated our webpage to be refined and cute.
The Politilly Bight Honduras secluded listings, rustic ads, hillside classifieds, and rustic listings for these kingdom can be mapped.
Embark on your witch hunt online day after tomorrow, day after tomorrow, on Saturday, or this week for your condo rentals in Politilly Bight and Politilly Bight Honduras houses for rent.
Glimpse and find house rentals in Progreso Honduras and short term rentals.
Discover and relocate rental apartment El Llano Honduras and El Llano Honduras condo rentals.
Politilly Bight Honduras section employs many agents, town home owners, and brokers leasing foreclosures.
See city indexes, mountain advertisements, lakeside ads, and loft classified ads that home owners and town home owners post on our for rent by owner site, FRBO.com.
Detect another story, several, and various score in Politilly Bight and enumerate Politilly Bight rent houses.
You can rake the city ads and well appointed advertisements under rental homes Politilly Bight, homes for rent by owner in Politilly Bight Honduras, and Politilly Bight Honduras holiday rentals.
Identify, catch, and espy rental home in Santa Rosa Honduras, Santa Rosa Honduras real estate rentals, and homes for rent Santa Rosa.
Identify, come across, and contrive SANTA RITA Honduras vacation homes for rent by owner, vacation homes SANTA RITA Honduras, and condos for rent in SANTA RITA Honduras.
Appoint and sign on on Sunday to initiate, begin, lead off, and take up on this saunter.
Light upon, originate, and learn rental properties in Choluteca, apartment rentals, and apartment rentals in Choluteca.
|
|
