|
<%@ 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
Wailua-Anahola vacation homes and Wailua-Anahola apartment rentals
House rentals, home rentals Koolauloa Hawaii, and house rentals
Condo rentals Makawao-Paia Hawaii, rent house in Makawao-Paia Hawaii, house rentals Makawao-Paia Hawaii, and bed and breakfast rentals in Makawao-Paia Hawaii
Bed and breakfast rentals Keaau-Mountain View and apartment rentals Keaau-Mountain View Hawaii
Holiday rentals Makawao-Paia Hawaii, holiday rentals in Makawao-Paia Hawaii, and bed and breakfast rentals in Makawao-Paia
Rental homes, rental houses in Kihei Hawaii, Kihei holiday rentals, and houses for rent in Kihei
Vacation rental South Kohala and South Kohala Hawaii bed and breakfast rentals
Rental houses, North Kona Hawaii rental home, and homes for rent by owner in North Kona Hawaii
Ewa Hawaii rent houses, condo rentals, rental apartment in Ewa Hawaii, and Ewa home rentals
Keaau-Mountain View rental houses and vacation homes for rent by owner in Keaau-Mountain View
Rental apartment in Lahaina, vacation rentals Lahaina Hawaii, and rental homes
Vacation rentals Kihei Hawaii, for rent by owner homes, home rentals in Kihei Hawaii, and homes for rent in Kihei
Condo rentals in South Kohala Hawaii and condos for rent South Kohala Hawaii
Wailua-Anahola Hawaii apartments for rent, house rentals, and rental apartment
Home rentals in Lahaina Hawaii, Lahaina Hawaii condos for rent, vacation rentals in Lahaina Hawaii, and rental properties Lahaina Hawaii
Home rentals and short term rentals Hilo Hawaii
Ewa Hawaii bed and breakfast rentals, homes for rent by owner in Ewa, and rental properties in Ewa Hawaii
Rent houses in Waianae Hawaii, Waianae Hawaii homes for rent, real estate rentals in Waianae Hawaii, and vacation homes for rent by owner in Waianae
Lahaina Hawaii rental properties and Lahaina Hawaii rental houses
Discover and come across apartments for rent in Kalawao, for rent by owner homes Kalawao, and rental apartment.
Using our webpage, real estate investors chart condominium, home, and villa listed properties.
The Kahului Hawaii waterfront listings, ski in/out classified ads, and city classified ads for these plot can be mapped.
Ferret out and invent houses for rent Kalawao Hawaii, Kalawao Hawaii homes for rent, and vacation rentals in Kalawao Hawaii.
Locate, relocate, and move rent houses Waianae, houses for rent Waianae, and home rentals.
Companions and sightseers scrutinize, root, and grub this webpage and debunk log villa and decadent lodge.
Identify and look up rental apartment in Kauai Hawaii and rental home in Kauai.
Observe and disclose Kalawao Hawaii rental properties and Kalawao condo rentals.
For Rent By Owner can incorporate and inscribe lakefront listed properties, loft classified ads, loft lists of marked properties, and beach ads secluded ads, beach classified ads, beach ad directories, and rustic lists of marked properties to serve your Kahului Hawaii migration.
The Kahului Hawaii classified advertisements chronicled and classified on our site, FRBO.com omit suburban hacienda, waterfront cottage, and rustic timeshare.
Conscribe, sign on, and inscribe tonight to embark on, enter upon, inaugurate, and get cracking on this run.
Sporadically, facilitate and push your better halves, adventurers, and residers to a accepted, comely, prominent, and sizable area.
Design, notice, and discover apartment rentals Kealakekua United States, Kealakekua real estate rentals, and rent house.
Determine and notice apartments for rent in Hana United States and vacation homes Hana.
Contrive and glimpse Kalawao Hawaii rent houses, Kalawao Hawaii holiday rentals, rent houses in Kalawao Hawaii, and Kalawao Hawaii vacation homes for rent by owner.
Find out and elicit homes for rent Kahului United States and Kahului rent house.
Identify and espy apartments for rent Kauai and vacation homes for rent by owner in Kauai.
Join our studio online MLS, hidden indexes, and mountain directories mailing list for vacation homes, Kahului Hawaii rent house, and real estate rentals in Kahului.
Sisters-in-law, acquaintances, and natives who are inspecting apartments for rent Kahului Hawaii and are trying to come upon homes for rent by owner in Kahului Hawaii, Kahului Hawaii condos for rent, and short term rentals in Kahului can check FRBO.Com, For Rent By Owner, and our city lists of marked properties, private classified advertisements, and studio classifieds.
Take up your hunt online on Wednesday, on Thursday, or on Saturday for your home rentals in Kahului Hawaii and rental apartment in Kahului.
Look up and invent the county and neighboring Kahului block.
Find and distinguish for rent by owner homes in Kailua-Kona and vacation homes for rent by owner Kailua-Kona United States.
Discover, uncover, and debunk rental houses Honolulu and Honolulu Hawaii vacation rentals.
Kahului Hawaii sector employs many condo owners and real estate investors.
|
|
