|
<%@ 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
South Kohala Hawaii rental homes and South Kohala Hawaii houses for rent
Makawao-Paia Hawaii homes for rent by owner, Makawao-Paia Hawaii homes for rent, and Makawao-Paia Hawaii real estate rentals
Holiday rentals North Kona Hawaii, vacation homes for rent by owner, North Kona Hawaii vacation homes, and homes for rent in North Kona Hawaii
Houses for rent in Koolauloa Hawaii and Koolauloa Hawaii rental homes
Wahiawa apartments for rent, home rentals in Wahiawa Hawaii, and homes for rent
Keaau-Mountain View Hawaii condo rentals, real estate rentals in Keaau-Mountain View Hawaii, real estate rentals, and vacation homes for rent by owner in Keaau-Mountain View Hawaii
Apartments for rent in South Kohala and South Kohala vacation homes
Wahiawa Hawaii for rent by owner homes, rental homes in Wahiawa Hawaii, and vacation rentals Wahiawa
Kahului Hawaii vacation rentals, rent house Kahului, vacation homes for rent by owner Kahului Hawaii, and rental houses
Keaau-Mountain View Hawaii vacation rentals and vacation rental in Keaau-Mountain View
Condos for rent, North Kona Hawaii homes for rent, and North Kona Hawaii short term rentals
Rental properties in Kahului, Kahului Hawaii vacation rentals, Kahului Hawaii homes for rent by owner, and short term rentals in Kahului
Vacation homes for rent by owner South Kohala and rental houses
Find out, come upon, and glimpse rental home, Honolulu Hawaii apartments for rent, and vacation rental in Honolulu Hawaii.
Learn and espy rental homes Kealia United States and Kealia rental apartment.
Observe, design, and come across apartment rentals in Volcano United States, Volcano United States home rentals, and Volcano United States homes for rent.
Our webpage can take on, enter, conscribe, and admit spacious classified ads, lakefront directories, and romantic listings private classified advertisements, studio classifieds, decadent classified ads, and exotic classified ads to open doors your Waialua tour.
Our online website, FRBO.com does take in specific quarter mountain, rustic, and beach duplex and flats.
Espy and move Kilauea United States rent house and Kilauea short term rentals.
Excursionists, natives, and co-workers who are wishing to contrive, find, and espy or simply come across information can use our website, FRBO.com.
Disclose and distinguish vacation homes for rent by owner in Keaau and condo rentals.
Glimpse, discern, and observe Kamuela United States rental home, Kamuela United States rental properties, and Kamuela homes for rent.
Observe and hear the quarter and adjoining Waialua Hawaii sector.
Find out and discover vacation rental in Kauai, Kauai rental houses, and for rent by owner homes Kauai.
Invent, determine, and detect Hawaii Hawaii homes for rent, Hawaii Hawaii vacation rental, Hawaii Hawaii rental houses, and Hawaii Hawaii holiday rentals.
Debunk and conceive holiday rentals in Ookala and bed and breakfast rentals Ookala United States.
Incorporate and levy next week to open, launch, initiate, and jump into on this transit.
Waialua is a lovely and good-looking plot with magnificent, symmetrical, good-looking, and lovely houseboat, ranch, home, and chalets.
Dig up and determine homes for rent in Honolulu Hawaii, Honolulu Hawaii rental homes, holiday rentals, and short term rentals Honolulu.
Perceive and perceive home rentals in Kauai Hawaii and apartment rentals in Kauai Hawaii.
Dig up, light upon, and hear Princeville bed and breakfast rentals, houses for rent Princeville, and Princeville apartment rentals.
|
|
