|
<%@ 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
Vacation rental and vacation rentals in Turtle Crossing Honduras
Bed and breakfast rentals Helene Honduras, Helene rental home, and real estate rentals
Masca rental houses, home rentals in Masca Honduras, homes for rent by owner in Masca, and Masca rent houses
Homes for rent by owner in First Bight and holiday rentals in First Bight Honduras
West Bay Beach rental houses, home rentals West Bay Beach, and West Bay Beach Honduras vacation rentals
Caribe Pointe Honduras rental home, rental properties Caribe Pointe, Caribe Pointe condo rentals, and Caribe Pointe Honduras homes for rent
Vacation homes Helene Honduras and holiday rentals
Calabash Bight Honduras condo rentals, Calabash Bight Honduras condos for rent, and condo rentals in Calabash Bight Honduras
Short term rentals in Utila Honduras, homes for rent Utila Honduras, houses for rent in Utila Honduras, and Utila real estate rentals
Apartment rentals in Oak Ridge Honduras and rent houses Oak Ridge Honduras
Dixon s Cove rent house, condo rentals in Dixon s Cove, and rental apartment
Apartment rentals Helene, for rent by owner homes Helene, rental properties in Helene, and rental houses in Helene Honduras
Utila Honduras condo rentals and Utila holiday rentals
Vacation rental Trujillo, vacation rental, and home rentals Trujillo Honduras
Rental homes Dixon s Cove Honduras, Dixon s Cove Honduras houses for rent, Dixon s Cove homes for rent by owner, and Dixon s Cove Honduras real estate rentals
Rental houses in Palmetto Bay Honduras and houses for rent in Palmetto Bay
Real estate rentals Masca, Masca house rentals, and rental homes Masca
Flowers Bay Honduras apartments for rent, vacation homes in Flowers Bay, bed and breakfast rentals in Flowers Bay, and vacation homes for rent by owner in Flowers Bay Honduras
Politilly Bight houses for rent and apartment rentals in Politilly Bight Honduras
Determine and notice rental homes in Comayaguela and Comayaguela Honduras rental homes.
Masca is a refined and dazzling zone with beauteous, admirable, well-formed, and admirable house, cabin, townhouse, and farmhouses.
The Masca Honduras exotic listings, lakefront lists of marked properties, spacious advertisements, and beach listings for these tract can be mapped.
Come upon, dig up, and determine rent houses in Cortes Honduras, Cortes Honduras short term rentals, and apartments for rent Cortes Honduras.
Move and contrive for rent by owner homes and Choluteca home rentals.
Join our convenient classifieds, studio listings, and lakefront classifieds mailing list for Masca Honduras rent house and rental homes in Masca Honduras.
Get cracking your pursuing online on Sunday, now, next week, or on Friday for your rental apartment Masca Honduras, Masca Honduras apartments for rent, and condo rentals Masca.
Hear, explore, and locate condo rentals YUSCARAN, YUSCARAN Honduras vacation rental, and rental houses in YUSCARAN Honduras.
Drifters, occupants, and townies hunt, look over, and go through our for rent by owner website and come upon beachfront ranch, city lodge, lakefront flat, and lakefront condominium.
You can smell around the secluded classifieds, well appointed advertisements, and city listed properties under Masca Honduras apartment rentals, house rentals Masca, and houses for rent Masca.
Determine, find out, and discern Juticalpa vacation homes, apartment rentals in Juticalpa Honduras, and rental apartment Juticalpa Honduras.
The Masca Honduras online MLS tallied and filed on this website, FRBO.com enclose mountain villa, decadent condominium, and spacious house.
Residents and jet-setters who are wishing to espy, light upon, and explore or simply debunk information can use FRBO.com.
Using our website, FRBO.com, agents inventory villa, condominium, castle, and bungalow classifieds.
Detect and catch homes for rent in Puerto Cortes Honduras and rent houses Puerto Cortes.
Notice, come across, and come upon house rentals in SAN PEDRO SULA, SAN PEDRO SULA Honduras vacation rentals, and vacation rentals SAN PEDRO SULA.
Determine and light upon house rentals in Puerto Cortes and holiday rentals.
Masca evidence could sustain, thump, and relieve your pursuing.
|
|
