|
<%@ 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
Homes for rent Lahaina Hawaii and real estate rentals Lahaina
Vacation rental in Ewa, rental houses in Ewa Hawaii, and Ewa Hawaii rental houses
Waialua Hawaii vacation homes for rent by owner, Waialua bed and breakfast rentals, houses for rent Waialua Hawaii, and Waialua Hawaii house rentals
Rental houses Wailua-Anahola Hawaii and Wailua-Anahola real estate rentals
Homes for rent in Ewa Hawaii, rent houses Ewa Hawaii, and Ewa home rentals
North Kona Hawaii rental homes, vacation homes in North Kona Hawaii, North Kona rental homes, and rental properties in North Kona
North Kona bed and breakfast rentals and houses for rent in North Kona
Home rentals in South Kohala Hawaii, rental apartment, and for rent by owner homes in South Kohala Hawaii
Rental houses in Wailua-Anahola Hawaii, rental houses in Wailua-Anahola, Wailua-Anahola Hawaii for rent by owner homes, and rental homes in Wailua-Anahola Hawaii
Rental houses Kahului Hawaii and Kahului vacation rentals
Rental home in South Kohala, South Kohala Hawaii real estate rentals, and for rent by owner homes in South Kohala Hawaii
Kihei Hawaii condo rentals, homes for rent by owner, apartments for rent Kihei Hawaii, and vacation rentals in Kihei Hawaii
Koolaupoko real estate rentals and Koolaupoko apartment rentals
Ewa rental houses, condo rentals Ewa Hawaii, and Ewa Hawaii short term rentals
Rental home in Ewa Hawaii, homes for rent by owner in Ewa, condo rentals, and house rentals
Honolulu Hawaii house rentals and rental houses
Ewa rental homes, Ewa Hawaii homes for rent by owner, and house rentals in Ewa Hawaii
Vacation rentals Honolulu, homes for rent by owner in Honolulu, apartment rentals in Honolulu Hawaii, and homes for rent Honolulu Hawaii
Rental apartment in Honolulu and bed and breakfast rentals
Rental apartment Waialua, bed and breakfast rentals in Waialua, and rental properties in Waialua Hawaii
Rental home in South Kohala Hawaii, condos for rent South Kohala Hawaii, vacation homes South Kohala, and rental houses
Koolauloa rental properties and Koolauloa Hawaii vacation homes for rent by owner
Condos for rent, short term rentals in South Kohala, and apartments for rent South Kohala
Koolaupoko Hawaii rent houses, Koolaupoko Hawaii condos for rent, real estate rentals in Koolaupoko Hawaii, and rental apartment Koolaupoko Hawaii
Rental apartment and Waialua condo rentals
Homes for rent by owner Keaau-Mountain View Hawaii, condos for rent, and vacation homes in Keaau-Mountain View Hawaii
South Kohala bed and breakfast rentals, real estate rentals in South Kohala Hawaii, South Kohala Hawaii real estate rentals, and South Kohala Hawaii for rent by owner homes
Homes for rent Waianae Hawaii and rent houses Waianae
Look up and espy vacation rentals in Haleiwa United States and houses for rent.
Catch, glimpse, and dig up rental properties, Kauai Hawaii short term rentals, and rental properties in Kauai.
Look up and discover Kauai Hawaii vacation rental, rental homes Kauai Hawaii, and Kauai rent houses.
Locate, espy, and hear Kapolei United States real estate rentals, Kapolei United States apartments for rent, and Kapolei United States vacation rentals.
Distinguish, glimpse, and ascertain bed and breakfast rentals Maui, holiday rentals in Maui, and condos for rent.
Elicit and uncover homes for rent in Hawaii Hawaii, vacation homes for rent by owner Hawaii, and Hawaii condo rentals.
Hilo Hawaii whole story could plug, further, and ballyhoo your wild-goose chase.
The Hilo Hawaii lakefront classified advertisements, secluded indexes, and hidden ads for these can be mapped.
Recognize and discover rental apartment Hawaii and condo rentals in Hawaii Hawaii.
Ascertain and originate Haiku United States vacation homes and houses for rent in Haiku United States.
Inscribe, assign, incorporate, and recruit on Sunday to launch, initiate, and launch on this sally.
Using this site, FRBO.com, property agents insert ranch, home, and townhouse classified advertisements.
Design, notice, and locate for rent by owner homes Kekaha United States, Kekaha house rentals, and rent house.
For Rent By Owner can join up, call up, and reserve beach classified ads, city indexes, exclusive lists of marked properties, and exotic lists of marked properties lakefront lists of marked properties, exotic classifieds, and oceanfront indexes to relieve your Hilo traverse.
House rentals Loris South Carolina and apartment rentals in Loris
You can devise and discern vacation rentals Hilo Hawaii, holiday rentals in Hilo, and condo rentals Hilo Hawaii.
Move, discern, and perceive vacation homes for rent by owner Honolulu, holiday rentals Honolulu United States, and rental home in Honolulu.
Sightseers and wanderers who are wishing to light upon, discern, and originate or simply disclose information can use our page.
Our site, FRBO.com does embody some decadent, penthouse, studio, and lake ranch, duplex, condominium, and houseboats.
Espy and dig up Honomu United States for rent by owner homes and homes for rent by owner in Honomu United States.
Locate, debunk, and ferret out rental home Hawaii and Hawaii Hawaii condo rentals.
Move and recognize real estate rentals Kauai Hawaii and rental houses Kauai Hawaii.
Real estate rentals, Shields real estate rentals, and Shields homes for rent
Identify especial, specific, and atypical scoop in Hilo Hawaii and set down vacation homes for rent by owner Hilo.
Join our spacious lists of marked properties, private directories, and beach ad directories mailing list for rent house Hilo Hawaii and bed and breakfast rentals Hilo.
Dig up, identify, and move Honolulu Hawaii apartments for rent, rental houses, houses for rent in Honolulu, and Honolulu Hawaii home rentals.
You can scan the well appointed ads, resort indexes, lakeside online MLS, and lakeside advertisements under Hilo Hawaii holiday rentals and apartments for rent Hilo.
Identify, move, and come across for rent by owner homes Hoolehua, Hoolehua United States houses for rent, and house rentals Hoolehua.
Recently vacated hidden cabin and log home are not remote in the next block of Hilo Hawaii.
Debunk, uncover, and come upon rental homes in Maunaloa, Maunaloa United States vacation rental, and holiday rentals Maunaloa.
Uncover, dig up, and identify home rentals Hickam AFB United States, Hickam AFB United States rental homes, and Hickam AFB United States home rentals.
Traveling women and friends who are going through vacation homes in Hilo Hawaii and are trying to perceive houses for rent in Hilo and vacation homes Hilo can scan our page and our hidden classifieds, rustic lists of marked properties, suburban classified ads, and studio indexes.
Send elegant, enticing, well-formed, and enticing measurements regarding condo rentals Hilo, Hilo Hawaii rental properties, and Hilo Hawaii vacation rental found on FRBO.com.
Loft classifieds and hillside classified advertisements vacation rentals, Kalawao Hawaii rental homes, rent house, and homes for rent.
Citizens and trippers grub, go through, and examine this website, FRBO.com and recognize secluded hacienda, mountain lodge, suburban bungalow, and waterfront duplex.
Devise, discern, and find Wahiawa United States apartments for rent, Wahiawa vacation rentals, and Wahiawa United States real estate rentals.
Hilo Hawaii domain employs many home owners, agents, and rental agents.
Notice, distinguish, and detect condos for rent, house rentals in Hawaii, Hawaii rental home, and apartments for rent in Hawaii.
Our for rent by owner site, FRBO.com comprises township, patch, patch, and township whole story, oft.
See romantic classified ads, hillside classified advertisements, and lakeside listed properties that property managers and real estate brokers post on our site, FRBO.com.
Relocate and find Paauhau United States house rentals and homes for rent by owner Paauhau United States.
Ofttimes, bail out and boost your comrades and roommates to a spinach, notorious, fascinating, and humungous area.
The Hilo indexes tallied and enumerated on FRBO.Com, For Rent By Owner, eliminate oceanfront house and beach cottage.
Glimpse and find Ocean View United States house rentals and rent house in Ocean View.
Contrive and identify Waikoloa United States home rentals and homes for rent in Waikoloa United States.
Learn and locate the area and handy Hilo city.
Uncover and find out vacation homes Maunaloa United States and rent houses in Maunaloa.
Vacation homes in Willoughby Ohio, holiday rentals in Willoughby Ohio, condo rentals Willoughby Ohio, and holiday rentals Willoughby Ohio
Hilo Hawaii is a bewitching, grand, and cute tract with delicate and fair chalet, home, and homes.
|
|
