|
<%@ 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
Flowers Bay vacation rental and vacation rental in Flowers Bay
Vacation rental Masca, Masca Honduras short term rentals, and homes for rent by owner Masca Honduras
Politilly Bight Honduras rental houses, Politilly Bight Honduras for rent by owner homes, Politilly Bight home rentals, and real estate rentals Politilly Bight
Homes for rent by owner in Palmetto Bay Honduras and condo rentals in Palmetto Bay Honduras
Turtle Crossing Honduras vacation rental, Turtle Crossing Honduras rental home, and Turtle Crossing vacation rental
Helene Honduras vacation rentals, apartment rentals in Helene Honduras, rental home in Helene, and Helene Honduras bed and breakfast rentals
Vacation rental in First Bight Honduras and houses for rent
Real estate rentals in Sandy Bay Honduras, short term rentals in Sandy Bay, and Sandy Bay Honduras apartments for rent
West End Honduras homes for rent, homes for rent in West End Honduras, apartments for rent, and condo rentals in West End Honduras
Short term rentals and Masca bed and breakfast rentals
La Ceiba Honduras apartment rentals, real estate rentals in La Ceiba Honduras, and rent house in La Ceiba Honduras
House rentals in Palmetto Bay, for rent by owner homes, Palmetto Bay condo rentals, and Palmetto Bay rental apartment
Vacation homes for rent by owner and for rent by owner homes in Sandy Bay
Rental apartment, homes for rent La Ceiba Honduras, and apartment rentals La Ceiba
Trujillo Honduras homes for rent, houses for rent, vacation homes in Trujillo, and rental home Trujillo Honduras
Rental home in Trujillo and Trujillo Honduras condo rentals
Calabash Bight Honduras apartments for rent, vacation homes for rent by owner Calabash Bight Honduras, and Calabash Bight Honduras rental home
Masca rental properties, houses for rent in Masca, rental homes Masca Honduras, and rent house Masca Honduras
Caribe Pointe Honduras vacation rental and rent houses Caribe Pointe Honduras
Houses for rent Helene Honduras, Helene Honduras for rent by owner homes, and rental home Helene
Milton Bight home rentals, Milton Bight vacation homes, homes for rent in Milton Bight Honduras, and Milton Bight Honduras short term rentals
Rent houses French Caye and apartment rentals French Caye
Vacation rental Dixon s Cove Honduras, apartment rentals in Dixon s Cove, and Dixon s Cove Honduras home rentals
Rent house in Milton Bight Honduras, Milton Bight Honduras bed and breakfast rentals, Milton Bight vacation homes for rent by owner, and rental apartment in Milton Bight Honduras
Vacation homes Masca and bed and breakfast rentals in Masca Honduras
Vacation homes in Palmetto Bay, rent houses in Palmetto Bay Honduras, and Palmetto Bay homes for rent by owner
Rental houses, vacation rentals in First Bight Honduras, condos for rent in First Bight, and First Bight home rentals
Real estate rentals and houses for rent in Trujillo Honduras
Condo rentals Trujillo, holiday rentals Trujillo Honduras, and Trujillo Honduras vacation homes
Rental houses in Milton Bight Honduras, Milton Bight Honduras rental home, home rentals in Milton Bight, and condo rentals in Milton Bight Honduras
Vacation homes for rent by owner and Helene Honduras holiday rentals
Vacation rentals, vacation rental in Politilly Bight, and rental houses Politilly Bight
Using our for rent by owner site, FRBO.com, property owners calendar home and townhouse classified ads.
West Bay Beach goods could work for, further, open doors, and thump your pursuing.
Ferret out and hear El Llano Honduras vacation homes and holiday rentals El Llano Honduras.
Explore, elicit, and debunk vacation homes for rent by owner, rental houses in Progreso Honduras, and home rentals in Progreso Honduras.
Navigators, buddies, and troupers who are wishing to recognize, explore, and design or simply explore information can use our online website, FRBO.com.
You can discern and look up home rentals West Bay Beach Honduras, vacation rentals West Bay Beach Honduras, and West Bay Beach Honduras rent house.
Disclose and contrive Danli Honduras short term rentals and Danli rental houses.
Dig up, look up, and come across house rentals in TEGUCIGALPA Honduras, homes for rent in TEGUCIGALPA, and TEGUCIGALPA Honduras condos for rent.
Ascertain, ferret out, and look up homes for rent by owner YORO Honduras, vacation homes, and rent houses in YORO Honduras.
Drifters, sightseers, and entrepreneurs who are rifling through West Bay Beach vacation rentals and are trying to light upon bed and breakfast rentals West Bay Beach, apartments for rent West Bay Beach Honduras, and home rentals West Bay Beach can look FRBO.com and our waterfront classified advertisements and spacious lists of marked properties.
Identify and find Juticalpa Honduras rental homes and Juticalpa Honduras apartment rentals.
Ferret out and relocate La Lima Honduras house rentals and La Lima Honduras rent houses.
Discover and espy the section and proximate West Bay Beach neighborhood.
Espy and perceive rental homes in Roatan Honduras and Roatan Honduras homes for rent.
Rent house in Bluefield Jamaica, rental properties in Bluefield Jamaica, and Bluefield homes for rent
Our online website, FRBO.com involves city and patch circumstances, infrequently.
La Libertad El Salvador house rentals, vacation rentals in La Libertad El Salvador, condos for rent La Libertad El Salvador, and La Libertad El Salvador apartments for rent
Vacation homes for rent by owner in Loreto Mexico, condos for rent Loreto Mexico, and vacation rental Loreto
Apartments for rent Stella Maris Bahamas and Stella Maris Bahamas condos for rent
Ferret out and move rent houses SAN PEDRO SULA Honduras and SAN PEDRO SULA apartments for rent.
Find out, elicit, and discover rental homes, rental homes in Comayaguela, and house rentals in Comayaguela Honduras.
Determine, elicit, and locate rent house, houses for rent YORO Honduras, and vacation rental YORO.
|
|
