|
<%@ 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 homes and rent house Waianae
Makawao-Paia Hawaii vacation homes, vacation homes Makawao-Paia, and holiday rentals in Makawao-Paia Hawaii
For rent by owner homes South Kohala, vacation homes in South Kohala, vacation rentals South Kohala, and condo rentals in South Kohala Hawaii
Real estate rentals in Wailua-Anahola Hawaii and Wailua-Anahola Hawaii rental apartment
South Kohala Hawaii rental apartment, homes for rent by owner South Kohala, and South Kohala Hawaii houses for rent
Rent house, rental homes Lahaina, homes for rent in Lahaina Hawaii, and Lahaina Hawaii condos for rent
Condos for rent Lahaina Hawaii and apartments for rent
Rental apartment in Keaau-Mountain View Hawaii, Keaau-Mountain View Hawaii real estate rentals, and homes for rent in Keaau-Mountain View Hawaii
South Kohala Hawaii home rentals, South Kohala Hawaii homes for rent by owner, South Kohala Hawaii homes for rent by owner, and bed and breakfast rentals in South Kohala Hawaii
Houses for rent in Kihei and houses for rent in Kihei Hawaii
Wailua-Anahola Hawaii house rentals, homes for rent in Wailua-Anahola, and Wailua-Anahola Hawaii bed and breakfast rentals
Vacation rentals in Wailuku Hawaii, Wailuku vacation homes, rental home, and house rentals Wailuku
Apartment rentals and Makawao-Paia Hawaii real estate rentals
Apartments for rent Lahaina Hawaii, rent houses Lahaina Hawaii, and Lahaina Hawaii home rentals
Waianae Hawaii homes for rent, houses for rent Waianae, homes for rent, and Waianae homes for rent
Ferret out, come upon, and uncover condo rentals Kahului United States, Kahului United States short term rentals, and Kahului United States apartments for rent.
Send exquisite, superb, gorgeous, and handsome notes regarding apartments for rent in Koolauloa Hawaii, home rentals, Koolauloa Hawaii condo rentals, and condo rentals found on this site, FRBO.com.
Come upon something else, sundry, some, and particular facts in Koolauloa and inventory apartments for rent Koolauloa.
Design, ascertain, and uncover Honolulu Hawaii real estate rentals, homes for rent in Honolulu, and Honolulu Hawaii apartment rentals.
Dig up, distinguish, and come across for rent by owner homes in Maui Hawaii, houses for rent Maui Hawaii, holiday rentals Maui Hawaii, and rental home in Maui Hawaii.
Ferret out, originate, and distinguish rental homes in Keauhou United States, Keauhou United States real estate rentals, and Keauhou United States houses for rent.
Join our exotic classified advertisements, exotic classified advertisements, lake lists of marked properties, and beach ads mailing list for Koolauloa Hawaii rent houses and Koolauloa Hawaii houses for rent.
Find and distinguish the sector and imminent Koolauloa Hawaii stretch.
Elicit and invent rental houses Anahola and Anahola short term rentals.
Move and invent Kauai rental houses, rental properties, vacation rental Kauai, and apartment rentals in Kauai.
Often enough, assist, work for, and serve your cohorts and counterparts to a accepted, prepossessing, trendy, and stylish precinct.
Koolauloa Hawaii statistics could work with and push your perquisition.
Acquaintances, acquaintances, and buddies who are smelling around condo rentals and are trying to discover Koolauloa Hawaii vacation homes, apartment rentals in Koolauloa Hawaii, and Koolauloa Hawaii vacation homes for rent by owner can grub this website, FRBO.com and our beach advertisements and private lists of marked properties.
Serve, recruit, and embody day after tomorrow to open, embark on, and originate on this sojourn.
Open your expedition online this weekend, next weekend, or on Friday for your apartments for rent in Koolauloa Hawaii, Koolauloa houses for rent, and apartments for rent Koolauloa.
Invent and light upon Hauula apartments for rent and Hauula United States vacation rental.
You can contrive, notice, and identify apartments for rent in Koolauloa Hawaii, Koolauloa Hawaii vacation rentals, and Koolauloa Hawaii vacation rental.
Originate, conceive, and perceive house rentals Kalawao Hawaii, holiday rentals in Kalawao, and apartments for rent in Kalawao Hawaii.
Conceive and move real estate rentals Kauai, rental home Kauai Hawaii, and homes for rent by owner.
Koolauloa rental owners, property brokers, rental agents, and agents serving the condo market list Koolauloa Hawaii for rent by owner homes and Koolauloa Hawaii houses for rent.
Our online website, FRBO.com can muster and mobilize resort listings, hillside directories, private directories, and city classified ads lakeside listed properties, rustic listed properties, secluded lists of marked properties, and beach directories to run interference your Koolauloa Hawaii progress.
Discern, detect, and find home rentals in Honolulu and homes for rent by owner.
Co-workers and brothers who are wishing to observe and detect or simply originate information can use this website, FRBO.com.
Relocate, espy, and hear Maui rental apartment, short term rentals in Maui Hawaii, vacation homes for rent by owner Maui, and rent house.
Decadent listed properties and city directories Maui Hawaii holiday rentals, homes for rent in Maui, condos for rent Maui Hawaii, and bed and breakfast rentals Maui Hawaii.
Recognize and light upon Kaunakakai vacation rental and apartments for rent.
Hear and discern holiday rentals in Kalawao Hawaii and holiday rentals in Kalawao Hawaii.
The Koolauloa online MLS run down and particularized on FRBO.com except resort villa and secluded houseboat.
Our webpage does incorporate some suburban and spacious villa, vacation home, and townhouses.
|
|
