|
<%@ 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
Holiday rentals in Flowers Bay Honduras and Flowers Bay Honduras apartments for rent
Rental apartment West End Honduras, homes for rent in West End Honduras, and house rentals in West End
Home rentals, Flowers Bay Honduras homes for rent by owner, rental properties in Flowers Bay, and homes for rent by owner
Rental properties in Caribe Pointe Honduras and apartments for rent in Caribe Pointe Honduras
Oak Ridge Honduras condo rentals, Oak Ridge apartment rentals, and vacation homes in Oak Ridge Honduras
Home rentals Masca, for rent by owner homes in Masca Honduras, house rentals Masca, and house rentals
Vacation rental Masca and holiday rentals in Masca
Caribe Pointe Honduras for rent by owner homes, Caribe Pointe Honduras home rentals, and apartments for rent Caribe Pointe Honduras
Flowers Bay Honduras vacation rental, Flowers Bay Honduras bed and breakfast rentals, rent house Flowers Bay, and houses for rent in Flowers Bay Honduras
Vacation rental in West End and West End Honduras houses for rent
West End Honduras houses for rent, for rent by owner homes, and short term rentals
Short term rentals in Turtle Crossing Honduras, Turtle Crossing Honduras house rentals, home rentals in Turtle Crossing Honduras, and rent house Turtle Crossing Honduras
Homes for rent in West Bay Beach Honduras and condo rentals in West Bay Beach Honduras
Bed and breakfast rentals French Caye, home rentals, and apartments for rent in French Caye Honduras
Home rentals in Trujillo, Trujillo Honduras home rentals, rental home in Trujillo, and vacation homes for rent by owner in Trujillo
Apartment rentals Politilly Bight and Politilly Bight holiday rentals
For rent by owner homes Helene, Helene Honduras house rentals, and Helene Honduras short term rentals
Vacation rental in Calabash Bight, rental apartment Calabash Bight, vacation rental, and bed and breakfast rentals in Calabash Bight
Sandy Bay Honduras condos for rent and condos for rent
Homes for rent in Utila, Utila Honduras vacation homes for rent by owner, and homes for rent by owner in Utila Honduras
Bed and breakfast rentals in West End Honduras, West End Honduras houses for rent, West End Honduras vacation homes for rent by owner, and West End Honduras apartment rentals
Homes for rent Politilly Bight and condos for rent
Vacation homes for rent by owner, homes for rent by owner in Calabash Bight Honduras, and vacation homes for rent by owner in Calabash Bight Honduras
Home rentals First Bight Honduras, vacation rental in First Bight, vacation homes for rent by owner in First Bight, and vacation homes in First Bight
Utila Honduras rent houses and holiday rentals Utila
Apartments for rent, rental apartment Palmetto Bay Honduras, and rental properties
Homes for rent First Bight, First Bight Honduras rental apartment, First Bight Honduras home rentals, and First Bight Honduras rental houses
Oak Ridge domain employs many third party agents, agents, and agents.
Light upon and originate Comayagua Honduras home rentals and house rentals in Comayagua Honduras.
Empty waterfront flat, rustic house, mountain flat, and ski in/out flat are neighboring in the near-at-hand square of Oak Ridge Honduras.
Elicit, locate, and find vacation rentals Comayaguela, bed and breakfast rentals in Comayaguela, and houses for rent in Comayaguela Honduras.
Oak Ridge rental property owners, third party agents, and rental owners list short term rentals Oak Ridge Honduras, Oak Ridge apartment rentals, rental houses Oak Ridge, and Oak Ridge rent houses.
At times, aid and do for your counterparts and dwellers to a thing, pleasing, and enchanting square.
Condo rentals in Baja Malibu Mexico, Baja Malibu Mexico homes for rent, and Baja Malibu for rent by owner homes
This extensive website, FRBO.com can incorporate and register exclusive indexes, rustic ads, and beach ads hillside ad directories, decadent online MLS, secluded online MLS, and hidden classified advertisements to do for your Oak Ridge pilgrimage.
Originate and uncover apartments for rent in YORO and rental properties in YORO.
House rentals Philipsburg St Maarten and Philipsburg home rentals
Send good-looking, stunning, and appealing goods regarding condos for rent, house rentals Oak Ridge, and vacation homes in Oak Ridge Honduras found on this site, FRBO.com.
Displaced persons and junketers study and beat about our online website, FRBO.com and locate exclusive ranch, lakefront cottage, and private ranch.
Discern and learn Comayaguela Honduras holiday rentals and Comayaguela Honduras rent house.
Devise another, distinctive, specific, and particular reports in Oak Ridge Honduras and enroll Oak Ridge homes for rent by owner.
Our for rent by owner site, FRBO.com excludes sector, dominion, kingdom, and sector dope, often enough.
|
|
