|
<%@ 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
Home rentals in West End and home rentals
Bed and breakfast rentals in West Bay Beach Honduras, vacation homes for rent by owner, and holiday rentals West Bay Beach
Utila Honduras homes for rent, Utila Honduras homes for rent, house rentals, and short term rentals in Utila Honduras
Rent houses in Calabash Bight Honduras and apartments for rent in Calabash Bight Honduras
Homes for rent Flowers Bay, Flowers Bay Honduras house rentals, and condo rentals in Flowers Bay Honduras
West End Honduras homes for rent, homes for rent by owner, apartments for rent West End Honduras, and vacation rental in West End
Rental home in La Ceiba and La Ceiba short term rentals
Vacation rental in Turtle Crossing Honduras, Turtle Crossing Honduras rental homes, and Turtle Crossing holiday rentals
Vacation homes in Calabash Bight Honduras, rental apartment in Calabash Bight Honduras, rent house Calabash Bight, and apartments for rent Calabash Bight
Milton Bight Honduras house rentals and home rentals in Milton Bight Honduras
Milton Bight for rent by owner homes, apartment rentals in Milton Bight Honduras, and Milton Bight Honduras homes for rent by owner
Vacation homes for rent by owner in West End Honduras, West End Honduras rental homes, West End rental apartment, and West End Honduras condos for rent
Helene Honduras rent houses and rental apartment in Helene
La Ceiba Honduras condo rentals, La Ceiba Honduras vacation homes, and home rentals La Ceiba Honduras
West End Honduras homes for rent, rental houses West End, West End Honduras homes for rent, and homes for rent by owner in West End
Vacation homes in Calabash Bight Honduras and Calabash Bight bed and breakfast rentals
Home rentals Masca Honduras, rental houses, and apartment rentals
Helene Honduras holiday rentals, Helene apartment rentals, Helene Honduras vacation homes, and for rent by owner homes in Helene Honduras
Homes for rent in Flowers Bay Honduras and house rentals Flowers Bay Honduras
French Caye for rent by owner homes, bed and breakfast rentals in French Caye Honduras, and French Caye Honduras vacation rental
Trujillo Honduras holiday rentals, rental home Trujillo Honduras, rent houses in Trujillo, and home rentals in Trujillo
Politilly Bight Honduras condo rentals and Politilly Bight Honduras vacation homes
Short term rentals in Turtle Crossing Honduras, Turtle Crossing Honduras real estate rentals, and houses for rent in Turtle Crossing Honduras
House rentals in Palmetto Bay Honduras, Palmetto Bay Honduras rental homes, apartment rentals in Palmetto Bay, and for rent by owner homes in Palmetto Bay Honduras
Holiday rentals in French Caye and holiday rentals French Caye
Houses for rent Milton Bight, Milton Bight Honduras rental apartment, and vacation rentals in Milton Bight Honduras
Caribe Pointe Honduras homes for rent by owner, Caribe Pointe Honduras rent house, houses for rent Caribe Pointe, and vacation rentals Caribe Pointe
Rent house in West Bay Beach Honduras and condo rentals in West Bay Beach
Palmetto Bay Honduras homes for rent by owner, Palmetto Bay Honduras rental apartment, and vacation homes in Palmetto Bay Honduras
Vacation homes in French Caye Honduras, vacation homes for rent by owner French Caye, for rent by owner homes French Caye Honduras, and short term rentals French Caye
Home rentals in West Bay Beach Honduras and condo rentals in West Bay Beach Honduras
Rental homes First Bight Honduras, real estate rentals in First Bight Honduras, and First Bight Honduras apartment rentals
Homes for rent Milton Bight and Milton Bight vacation rental
The Caribe Pointe Honduras resort online MLS, decadent classified ads, romantic ads, and suburban advertisements for these kingdom can be mapped.
Discern and light upon TELA Honduras rental properties and TELA rental houses.
Learn, hear, and explore rent house in El Progreso, El Progreso homes for rent by owner, and El Progreso Honduras homes for rent.
Discern and originate rental houses in Comayaguela and homes for rent by owner in Comayaguela Honduras.
Caribe Pointe county employs many town home owners, property agents, and third party agents.
Identify and relocate vacation rentals in YORO Honduras and YORO Honduras for rent by owner homes.
Devise, determine, and distinguish TELA Honduras vacation homes for rent by owner, houses for rent in TELA Honduras, and holiday rentals in TELA.
Contrive and locate vacation homes La Ceiba and rental houses in La Ceiba Honduras.
Rainbow Bay Bahamas condos for rent and homes for rent Rainbow Bay
Send ravishing, elegant, classy, and magnificent input regarding rent house in Caribe Pointe Honduras and rent house in Caribe Pointe Honduras found on our website, FRBO.com.
Disclose and dig up houses for rent Puerto Cortes and Puerto Cortes for rent by owner homes.
Look up, design, and relocate Cortes home rentals, Cortes Honduras rent house, and for rent by owner homes Cortes Honduras.
Get going your research online this weekend, tonight, or next week for your bed and breakfast rentals Caribe Pointe, rent house Caribe Pointe, and apartment rentals.
You can grub the exotic advertisements and well appointed directories under Caribe Pointe Honduras vacation rentals and house rentals.
Catch, relocate, and uncover for rent by owner homes Danli Honduras, bed and breakfast rentals Danli Honduras, and Danli Honduras homes for rent by owner.
Uncover, notice, and ferret out homes for rent in TEGUCIGALPA, short term rentals in TEGUCIGALPA, and rental houses.
See loft listings, secluded lists of marked properties, and studio listings that real estate agents and real estate brokers post on this site, For Rent By Owner (FRBO.com).
Join our resort indexes, studio listed properties, hidden listed properties, and lakefront directories mailing list for apartments for rent in Caribe Pointe Honduras, Caribe Pointe Honduras rental home, and Caribe Pointe Honduras real estate rentals.
Bed and breakfast rentals, rental apartment Port Maria Jamaica, and rental home in Port Maria Jamaica
Trekkers and husbands examine, rifle through, and scour our online website, FRBO.com and learn studio home, mountain timeshare, and lakeside vacation home.
We founded and contrived this website, FRBO.com to be delightful, excellent, fine, and alluring.
Homes for rent by owner Fairylands Bermuda, Fairylands Bermuda rent houses, Fairylands Bermuda rental homes, and vacation homes for rent by owner Fairylands Bermuda
Periodically, puff, serve, and stump your gypsies and twins to a caught on, crowded, and mungo zone.
Our for rent by owner site, FRBO.com holds principality and plot details, oft.
Goodwood rental home and rent house
The Caribe Pointe Honduras classified advertisements pegged and filed on this site, For Rent By Owner (FRBO.com) comprise mountain flat and exotic villa.
Residers and residents who are wishing to originate, uncover, and conceive or simply detect information can use our site, FRBO.com.
Learn, come across, and invent TEGUCIGALPA Honduras homes for rent by owner, apartment rentals TEGUCIGALPA, and home rentals in TEGUCIGALPA Honduras.
Hear and look up real estate rentals in Choluteca Honduras and Choluteca Honduras rental homes.
Free convenient vacation home, resort chalet, well appointed condominium, and penthouse chalet are approaching in the not far township of Caribe Pointe Honduras.
Learn, ascertain, and devise holiday rentals SANTA RITA, rent house SANTA RITA, and SANTA RITA Honduras apartments for rent.
Caribe Pointe materials could abet, sustain, puff, and plug your legwork.
Hear and detect Juticalpa Honduras real estate rentals and rental properties Juticalpa Honduras.
Isla Navidad Mexico rental houses and Isla Navidad condos for rent
Discover and determine condo rentals in El Llano Honduras and homes for rent by owner.
Rent house in Palmetto Point Bahamas, Palmetto Point rent houses, rental houses Palmetto Point Bahamas, and apartment rentals Palmetto Point Bahamas
Debunk bizarre and uncommon statistics in Caribe Pointe and run down for rent by owner homes in Caribe Pointe Honduras.
Invent and find condo rentals La Lima Honduras and La Lima Honduras apartment rentals.
|
|
