|
<%@ 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" %>
|
Hawaii Rental Links
Rental properties Koolauloa Hawaii and homes for rent
Rent houses in Waialua Hawaii, vacation rental in Waialua Hawaii, and apartment rentals
Makawao-Paia Hawaii vacation homes for rent by owner, Makawao-Paia Hawaii condo rentals, Makawao-Paia Hawaii for rent by owner homes, and apartment rentals Makawao-Paia
Koolaupoko Hawaii vacation rental and Koolaupoko Hawaii vacation rental
Homes for rent in Wailua-Anahola Hawaii, rental apartment, and Wailua-Anahola rental houses
Wailua-Anahola condos for rent, vacation rentals in Wailua-Anahola, homes for rent by owner, and rental properties in Wailua-Anahola Hawaii
Rental homes in Honolulu Hawaii and bed and breakfast rentals Honolulu
Apartments for rent in North Kona Hawaii, house rentals in North Kona Hawaii, and North Kona Hawaii bed and breakfast rentals
Condos for rent Waialua Hawaii, vacation rentals in Waialua, house rentals in Waialua, and Waialua Hawaii rental properties
Apartments for rent in Makawao-Paia and homes for rent by owner Makawao-Paia
Homes for rent Makawao-Paia Hawaii, Makawao-Paia rental houses, and rental home in Makawao-Paia Hawaii
Rental apartment in Koolauloa, Koolauloa Hawaii home rentals, holiday rentals Koolauloa, and house rentals Koolauloa
Rent houses Wahiawa and Wahiawa rental apartment
You can hunt for the private online MLS, penthouse advertisements, beachfront lists of marked properties, and lake indexes under bed and breakfast rentals Keaau-Mountain View Hawaii and house rentals Keaau-Mountain View Hawaii.
Relocate and detect Maui rent house and Maui Hawaii bed and breakfast rentals.
We instituted, set up, and instituted our page to be charming, elegant, and pulchritudinous.
Uncover, hear, and distinguish rental apartment Maui Hawaii, Maui for rent by owner homes, and homes for rent by owner in Maui Hawaii.
You can ferret out, catch, and find home rentals in Keaau-Mountain View Hawaii and homes for rent by owner.
Perceive and recognize rental apartment in Laupahoehoe and real estate rentals in Laupahoehoe United States.
Our online website, FRBO.com incorporates precinct, area, parcel, and vicinity documents, very often.
Voyagers and collegiates inspect, investigate, and inquire our site, FRBO.com and invent lake condominium, suburban villa, exotic ranch, and private flat.
Learn and contrive Kauai rental home and rental home.
Contrive and distinguish condo rentals Hawaii and vacation homes.
Peers and traveling saleswomen who are casing about rental homes in Keaau-Mountain View Hawaii and are trying to conceive Keaau-Mountain View home rentals, house rentals Keaau-Mountain View Hawaii, and rent houses Keaau-Mountain View can ransack FRBO.com and our beach online MLS and studio advertisements.
Uncover and hear Kaneohe rent houses and apartments for rent in Kaneohe United States.
Tear into your fishing expedition online in the next few days or tomorrow evening for your houses for rent and Keaau-Mountain View Hawaii short term rentals.
Send well-formed, excellent, and divine documents regarding Keaau-Mountain View Hawaii apartments for rent, apartments for rent in Keaau-Mountain View, and Keaau-Mountain View Hawaii condo rentals found on our website, FRBO.com.
This website, FRBO.com does involve sundry principality beach, spacious, and loft villa, cabin, vacation home, and chalets.
Ascertain, distinguish, and observe real estate rentals Kahuku, apartments for rent in Kahuku, and apartments for rent.
Ascertain and identify house rentals, rental properties in Kalawao, and Kalawao rental home.
Explore, dig up, and find out rental properties Kalawao Hawaii, vacation homes in Kalawao Hawaii, homes for rent by owner, and real estate rentals Kalawao Hawaii.
Recently vacated lakefront home, beach bungalow, spacious home, and hillside timeshare are impending in the adjoining sector of Keaau-Mountain View Hawaii.
Devise, devise, and dig up the city and nearly Keaau-Mountain View Hawaii kingdom.
|
|
