|
<%@ 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
Caribe Pointe Honduras rental apartment and homes for rent by owner
Rental homes La Ceiba, La Ceiba Honduras vacation homes, and for rent by owner homes La Ceiba
Holiday rentals in Oak Ridge Honduras, Oak Ridge Honduras condo rentals, short term rentals Oak Ridge, and Oak Ridge Honduras vacation homes
Trujillo homes for rent by owner and homes for rent by owner Trujillo
Home rentals in La Ceiba Honduras, La Ceiba holiday rentals, and condos for rent in La Ceiba Honduras
Rental apartment, for rent by owner homes Helene Honduras, condos for rent, and Helene Honduras rental home
Houses for rent in Masca Honduras and Masca Honduras apartments for rent
Rental homes in La Ceiba Honduras, rental houses in La Ceiba Honduras, and vacation homes for rent by owner in La Ceiba Honduras
House rentals Utila Honduras, apartment rentals in Utila Honduras, Utila Honduras apartment rentals, and short term rentals in Utila
Real estate rentals in West Bay Beach and West Bay Beach Honduras rent houses
La Ceiba Honduras apartment rentals, apartment rentals in La Ceiba Honduras, and condo rentals
Vacation homes for rent by owner in Dixon s Cove Honduras, for rent by owner homes in Dixon s Cove, apartment rentals Dixon s Cove Honduras, and rent houses
Homes for rent by owner Dixon s Cove Honduras and Dixon s Cove for rent by owner homes
Vacation rental in Palmetto Bay, Palmetto Bay Honduras vacation homes for rent by owner, and Palmetto Bay rental properties
Condos for rent in Caribe Pointe Honduras, vacation rental in Caribe Pointe, vacation rentals Caribe Pointe, and houses for rent in Caribe Pointe Honduras
Homes for rent Caribe Pointe Honduras and rental homes in Caribe Pointe
French Caye vacation rental, rental apartment in French Caye Honduras, and French Caye Honduras apartment rentals
Calabash Bight Honduras vacation rental, Calabash Bight Honduras rental properties, Calabash Bight Honduras real estate rentals, and rental home in Calabash Bight
Palmetto Bay Honduras holiday rentals and short term rentals
Calabash Bight rental houses, house rentals in Calabash Bight Honduras, and house rentals in Calabash Bight
West End Honduras condo rentals, vacation rentals in West End, vacation homes for rent by owner West End Honduras, and West End vacation homes for rent by owner
Real estate rentals in French Caye and vacation rental in French Caye
Rent houses in Palmetto Bay, rental homes in Palmetto Bay Honduras, and Palmetto Bay Honduras condo rentals
Holiday rentals Utila Honduras, Utila condos for rent, for rent by owner homes Utila Honduras, and vacation rental in Utila
Condo rentals Calabash Bight and rental apartment Calabash Bight Honduras
House rentals in Utila, Utila Honduras rent houses, and Utila Honduras rental apartment
Rovers, co-workers, and possessors cast about and inquire this site, FRBO.com and move decadent townhouse, oceanfront castle, private home, and exclusive condominium.
Light upon and light upon apartments for rent and house rentals.
Find small number, specific, and special notes in French Caye Honduras and register French Caye Honduras vacation rentals.
Identify, debunk, and debunk rental home in Choluteca, rental properties, and vacation homes for rent by owner Choluteca.
Our website, FRBO.com does accommodate specific rustic, waterfront, hillside, and exclusive condominium, timeshare, and homes.
Relocate, glimpse, and contrive holiday rentals in SANTA RITA, home rentals in SANTA RITA Honduras, and real estate rentals in SANTA RITA Honduras.
Draft and join this week to initiate and enter upon on this progress.
Originate and ascertain houses for rent and condo rentals.
Ferret out and explore rent houses in SAN PEDRO SULA and houses for rent in SAN PEDRO SULA Honduras.
Glimpse and elicit house rentals and Danli Honduras rental houses.
Detect and uncover TELA Honduras condos for rent and rental home in TELA Honduras.
Relocate, relocate, and determine rental homes Progreso Honduras, rent house Progreso, and short term rentals in Progreso Honduras.
Explore and elicit short term rentals and vacation rentals in Puerto Cortes.
Determine, explore, and discern the territory and nearby French Caye zone.
You can look the mountain lists of marked properties, spacious listed properties, beachfront indexes, and secluded ad directories under French Caye Honduras homes for rent by owner, short term rentals in French Caye Honduras, and condos for rent French Caye Honduras.
Detect, debunk, and explore vacation rental La Lima, La Lima Honduras for rent by owner homes, and La Lima apartment rentals.
Observe, look up, and contrive short term rentals Comayaguela, vacation homes, and Comayaguela Honduras rental home.
The French Caye studio lists of marked properties, waterfront classifieds, hillside listed properties, and exotic listed properties for these township can be mapped.
Oyster Pond rental home, vacation rentals Oyster Pond St Maarten, and vacation homes in Oyster Pond
Join our lakeside directories, lake advertisements, and well appointed ads mailing list for French Caye Honduras home rentals and French Caye Honduras vacation rental.
Notice and elicit rental properties SANTA RITA and vacation homes for rent by owner in SANTA RITA Honduras.
|
|
