|
<%@ 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
Apartment rentals in Keaau-Mountain View and vacation homes for rent by owner Keaau-Mountain View Hawaii
Vacation rental, bed and breakfast rentals Waialua Hawaii, and vacation homes in Waialua Hawaii
Real estate rentals in South Kohala, rental homes in South Kohala Hawaii, vacation rentals South Kohala, and rental home South Kohala Hawaii
Vacation rental in Makawao-Paia Hawaii and houses for rent in Makawao-Paia
Makawao-Paia Hawaii condos for rent, rental properties Makawao-Paia Hawaii, and apartments for rent
Homes for rent in Kahului Hawaii, rental properties in Kahului, rental houses in Kahului, and Kahului for rent by owner homes
Short term rentals in Makawao-Paia and Makawao-Paia Hawaii bed and breakfast rentals
Rental apartment in Keaau-Mountain View, apartment rentals Keaau-Mountain View, and rent houses Keaau-Mountain View Hawaii
North Kona rental properties, North Kona Hawaii for rent by owner homes, vacation rentals in North Kona, and North Kona Hawaii condos for rent
Ewa Hawaii rental properties and Ewa Hawaii vacation homes
Koolaupoko Hawaii rental properties, Koolaupoko rent houses, and houses for rent Koolaupoko
Waialua rental home, Waialua for rent by owner homes, condo rentals in Waialua Hawaii, and Waialua home rentals
Keaau-Mountain View houses for rent and holiday rentals in Keaau-Mountain View
Honolulu Hawaii rent house, vacation homes in Honolulu Hawaii, and apartment rentals in Honolulu Hawaii
Rent houses, homes for rent by owner Koolaupoko Hawaii, condo rentals in Koolaupoko Hawaii, and rental home in Koolaupoko Hawaii
Keaau-Mountain View vacation homes and Keaau-Mountain View Hawaii apartments for rent
Apartment rentals Ewa, condo rentals in Ewa Hawaii, and house rentals in Ewa Hawaii
Kihei Hawaii condos for rent, Kihei Hawaii home rentals, homes for rent Kihei Hawaii, and rental apartment Kihei Hawaii
Apartment rentals in Honolulu and rent houses in Honolulu Hawaii
Recognize and determine vacation homes for rent by owner Haleiwa and for rent by owner homes Haleiwa.
At times, puff and aid your cohorts and tourists to a prepossessing, spacious, chock-full, and handsome tract.
Nearly ready exotic houseboat and waterfront duplex are impending in the not to distant precinct of Wailuku Hawaii.
Look up, look up, and hear home rentals Eleele, bed and breakfast rentals in Eleele, and Eleele short term rentals.
Observe and originate Maunaloa United States bed and breakfast rentals and houses for rent in Maunaloa United States.
FRBO.Com, For Rent By Owner, subsumes territory and neighborhood scoop, not infrequently.
Find out and distinguish house rentals Kalawao Hawaii, Kalawao Hawaii house rentals, rental properties in Kalawao Hawaii, and Kalawao real estate rentals.
Traveling men and navigators who are scouring Wailuku Hawaii homes for rent by owner and are trying to find condos for rent Wailuku Hawaii and Wailuku real estate rentals can explore this site, For Rent By Owner (FRBO.com) and our exotic lists of marked properties, rustic listings, and waterfront listed properties.
Ferret out, espy, and light upon rental home Kaneohe United States, rental homes Kaneohe, and rental houses in Kaneohe.
Distinguish, locate, and hear rental homes in Kauai Hawaii and apartments for rent Kauai.
Glimpse ad hoc, diverse, and special notes in Wailuku Hawaii and specialize Wailuku Hawaii vacation homes.
Using FRBO.com, land owners invoice cabin and chalet ad directories.
Find, design, and locate Honolulu Hawaii for rent by owner homes, rental houses Honolulu, and rental houses Honolulu.
Locate and disclose Kalawao Hawaii apartments for rent and bed and breakfast rentals.
Conceive, explore, and detect rental properties, short term rentals, and vacation homes.
Come across and relocate short term rentals Kauai, rental houses Kauai Hawaii, Kauai houses for rent, and real estate rentals.
Catch, observe, and disclose Hawaii apartments for rent, short term rentals Hawaii, and Hawaii bed and breakfast rentals.
Learn and identify rental home in Hauula and rental apartment Hauula United States.
We created and coined FRBO.Com, For Rent By Owner, to be ravishing, grand, superb, and classy.
|
|
