|
<%@ 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
Dixon s Cove homes for rent by owner and Dixon s Cove Honduras rental home
Caribe Pointe Honduras vacation homes, bed and breakfast rentals Caribe Pointe Honduras, and home rentals in Caribe Pointe Honduras
Homes for rent by owner in Helene Honduras, apartments for rent in Helene Honduras, vacation homes for rent by owner in Helene, and Helene Honduras rental properties
Turtle Crossing rental home and Turtle Crossing Honduras rent houses
Homes for rent, Turtle Crossing Honduras houses for rent, and rental homes
Masca vacation rentals, Masca short term rentals, Masca Honduras home rentals, and vacation rental in Masca Honduras
La Ceiba Honduras vacation homes and La Ceiba Honduras homes for rent
Flowers Bay home rentals, Flowers Bay rental apartment, and apartments for rent in Flowers Bay Honduras
Rental homes First Bight Honduras, apartments for rent in First Bight Honduras, First Bight Honduras house rentals, and apartment rentals in First Bight Honduras
West Bay Beach Honduras rental homes and rental homes West Bay Beach
Vacation rentals Calabash Bight Honduras, home rentals Calabash Bight Honduras, and Calabash Bight Honduras vacation homes for rent by owner
Vacation rental, rental home, rental apartment, and vacation homes for rent by owner
Homes for rent Palmetto Bay Honduras and vacation homes for rent by owner in Palmetto Bay
Politilly Bight Honduras home rentals, homes for rent in Politilly Bight Honduras, and for rent by owner homes Politilly Bight Honduras
Rental homes French Caye Honduras, French Caye Honduras rental home, rent houses in French Caye Honduras, and apartments for rent French Caye
Real estate rentals in Caribe Pointe Honduras and holiday rentals
Condo rentals, Milton Bight rental homes, and vacation homes for rent by owner
Send nice and classy conclusions regarding Turtle Crossing Honduras rental properties, condo rentals in Turtle Crossing Honduras, apartment rentals, and apartments for rent found on our online website, FRBO.com.
Move, come across, and contrive Danli Honduras apartment rentals, homes for rent by owner, and condos for rent.
Discover and relocate rental houses SAN PEDRO SULA Honduras and SAN PEDRO SULA Honduras houses for rent.
Look up and learn homes for rent in Comayaguela Honduras and rental properties in Comayaguela Honduras.
Conceive, distinguish, and find out homes for rent by owner La Ceiba, rent house in La Ceiba Honduras, and La Ceiba for rent by owner homes.
Join our beachfront ads, romantic listings, studio directories, and exclusive indexes mailing list for rental home in Turtle Crossing and Turtle Crossing Honduras rental houses.
We imagined and devised FRBO.Com, For Rent By Owner, to be well-formed, refined, fine, and radiant.
Notice, detect, and disclose Roatan Honduras bed and breakfast rentals, Roatan vacation homes, and Roatan Honduras apartment rentals.
Discover and originate TEGUCIGALPA Honduras rental apartment and rent house in TEGUCIGALPA Honduras.
Determine and ascertain for rent by owner homes La Lima and homes for rent La Lima.
Learn, relocate, and detect the locality and immediate Turtle Crossing Honduras block.
See hillside ad directories and oceanfront indexes that property owners and rental owners post on For Rent By Owner.
Using For Rent By Owner, property brokers place vacation home, townhouse, and chalet classified advertisements.
Notice, explore, and catch short term rentals Danli Honduras, homes for rent in Danli Honduras, and vacation homes Danli.
Glimpse, contrive, and perceive rental houses in SAN PEDRO SULA, condo rentals in SAN PEDRO SULA Honduras, and apartment rentals SAN PEDRO SULA.
|
|
