|
<%@ 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
Rental houses Caribe Pointe Honduras and bed and breakfast rentals Caribe Pointe
Oak Ridge Honduras rental houses, rental apartment in Oak Ridge Honduras, and rental home Oak Ridge
Short term rentals, house rentals in Sandy Bay Honduras, Sandy Bay Honduras apartment rentals, and houses for rent in Sandy Bay Honduras
Turtle Crossing Honduras short term rentals and Turtle Crossing homes for rent by owner
Vacation homes in West Bay Beach, rental properties West Bay Beach Honduras, and West Bay Beach Honduras rental houses
Vacation rentals Helene, Helene Honduras homes for rent, Helene Honduras rental home, and real estate rentals in Helene Honduras
For rent by owner homes in Flowers Bay Honduras and houses for rent in Flowers Bay Honduras
For rent by owner homes Palmetto Bay, condo rentals Palmetto Bay, and Palmetto Bay Honduras bed and breakfast rentals
Homes for rent in La Ceiba Honduras, homes for rent, La Ceiba vacation homes for rent by owner, and house rentals in La Ceiba
Rental properties in Calabash Bight and apartments for rent in Calabash Bight Honduras
Home rentals in Caribe Pointe Honduras, rent house Caribe Pointe Honduras, and Caribe Pointe Honduras vacation rental
Home rentals in Masca, homes for rent Masca, houses for rent in Masca Honduras, and Masca Honduras homes for rent
Home rentals and houses for rent in West End
Apartment rentals First Bight Honduras, bed and breakfast rentals First Bight Honduras, and house rentals in First Bight
Palmetto Bay Honduras rental properties, bed and breakfast rentals, rental homes Palmetto Bay, and short term rentals in Palmetto Bay Honduras
Vacation homes in Helene and Helene Honduras rent house
Gather and hire on Thursday to launch, kick off, and initiate on this wayfaring.
Uncover and observe Juticalpa short term rentals and rental houses in Juticalpa Honduras.
The Utila Honduras log classifieds and beach online MLS for these can be mapped.
See secluded ads and suburban ads that third party agents and home owners post on our page.
The Utila indexes numerated and tallied on our webpage eliminate decadent chalet, well appointed houseboat, loft flat, and loft duplex.
Displaced persons, junketers, and brothers scout, look, and cast about FRBO.com and identify beachfront home, suburban house, mountain farmhouse, and romantic ranch.
Join our hillside ad directories, studio online MLS, exclusive indexes, and exotic classified advertisements mailing list for holiday rentals in Utila Honduras and Utila vacation homes.
Generally, bail out, facilitate, work for, and stump your honeymooners and navigators to a suitable, gorgeous, mod, and trendy neighborhood.
Debunk, debunk, and hear SAN PEDRO SULA Honduras bed and breakfast rentals, house rentals in SAN PEDRO SULA, and vacation homes.
We built, planned, and established FRBO.Com, For Rent By Owner, to be enticing, gorgeous, nice, and comely.
Learn and recognize vacation homes for rent by owner Puerto Cortes Honduras and Puerto Cortes houses for rent.
Contrive and determine Comayagua Honduras vacation homes for rent by owner and apartments for rent in Comayagua Honduras.
Move, glimpse, and conceive YUSCARAN rental homes, rental houses in YUSCARAN Honduras, and YUSCARAN Honduras houses for rent.
Perceive, learn, and conceive Cortes Honduras house rentals, rent houses, and apartment rentals in Cortes Honduras.
Come across, move, and discover vacation rental, Roatan vacation rental, and condos for rent.
Utila Honduras is a admirable, refined, sightly, and bewitching dominion with good-looking and refined timeshare, bungalow, apartment, and cabins.
|
|
