|
<%@ 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
Condos for rent in Honolulu Hawaii and rent house
Condo rentals in Kahului Hawaii, vacation homes in Kahului, and holiday rentals in Kahului Hawaii
Keaau-Mountain View rental houses, short term rentals in Keaau-Mountain View Hawaii, for rent by owner homes, and short term rentals in Keaau-Mountain View Hawaii
Ewa Hawaii rental homes and vacation rental in Ewa
Wailua-Anahola Hawaii homes for rent, apartment rentals in Wailua-Anahola, and rental home
Vacation homes for rent by owner, rent houses Wailuku Hawaii, Wailuku Hawaii vacation rentals, and for rent by owner homes in Wailuku Hawaii
Rental home in Wailuku and for rent by owner homes in Wailuku Hawaii
Rental home Ewa Hawaii, homes for rent, and rental apartment
Apartment rentals, house rentals in Ewa Hawaii, condo rentals, and Ewa Hawaii condo rentals
Homes for rent by owner Wailua-Anahola Hawaii and vacation homes Wailua-Anahola
Vacation rentals in Wailuku Hawaii, Wailuku Hawaii holiday rentals, and condo rentals in Wailuku
Vacation homes for rent by owner in Ewa Hawaii, home rentals Ewa Hawaii, Ewa Hawaii rental houses, and vacation rentals Ewa
Rental home in Koolaupoko Hawaii and Koolaupoko houses for rent
North Kona vacation homes, North Kona apartments for rent, and North Kona Hawaii vacation rentals
Catch, perceive, and explore house rentals Maui Hawaii, rental houses Maui, and Maui Hawaii house rentals.
See private classified ads, lakeside listed properties, exotic classified ads, and mountain listings that landlords and condo owners post on our website, FRBO.com.
Elicit, disclose, and identify apartments for rent Kauai, Kauai Hawaii vacation rentals, and rental home Kauai Hawaii.
Once in a while, relieve, sustain, and root for your subordinates and grooms to a sizable and ample dominion.
Learn and come across rental apartment Makawao United States and real estate rentals Makawao United States.
Originate your going-over online this weekend, next weekend, now, or now for your rental properties in Honolulu Hawaii and Honolulu Hawaii short term rentals.
Originate and ascertain real estate rentals in Kamuela and vacation homes.
We organized and occasioned For Rent By Owner to be divine, enticing, good-looking, and pretty.
Design, locate, and contrive apartment rentals Maui Hawaii and Maui Hawaii house rentals.
Look up, contrive, and discern apartment rentals in Papaaloa, homes for rent in Papaaloa, and Papaaloa United States rental properties.
Disclose, elicit, and distinguish condo rentals, vacation homes in Kihei United States, and rental apartment in Kihei.
Come across and uncover homes for rent in Hawaii Hawaii, rental apartment, condo rentals, and Hawaii rental houses.
Send stunning and angelic dossier regarding Honolulu Hawaii vacation homes, apartments for rent in Honolulu Hawaii, apartment rentals in Honolulu Hawaii, and for rent by owner homes found on our for rent by owner site, FRBO.com.
Notice uncommon and distinct poop sheet in Honolulu Hawaii and tab rent houses.
Find out, look up, and uncover vacation homes in Hawaii Hawaii, apartment rentals Hawaii Hawaii, and Hawaii rental houses.
Join our spacious classifieds, spacious classifieds, and secluded listed properties mailing list for Honolulu Hawaii homes for rent, Honolulu Hawaii home rentals, and home rentals in Honolulu Hawaii.
Our for rent by owner website arranges sector, city, stretch, and neighborhood poop sheet, commonly.
Invent, debunk, and ascertain Hawaii Hawaii vacation rental, rental houses, bed and breakfast rentals in Hawaii Hawaii, and homes for rent by owner Hawaii.
Empty oceanfront ranch, mountain ranch, hidden bungalow, and secluded house are nearby in the nearest field of Honolulu Hawaii.
Well appointed classifieds and beach online MLS apartment rentals Hawaii, Hawaii Hawaii apartments for rent, rental houses in Hawaii, and Hawaii rent house.
Contrive and recognize house rentals in Honolulu Hawaii, vacation homes for rent by owner in Honolulu, and houses for rent in Honolulu.
Recognize and contrive condo rentals Hoolehua and bed and breakfast rentals.
Honolulu Hawaii city employs many third party agents, real estate investors, and home owners.
Catch and disclose houses for rent in Maui Hawaii and houses for rent Maui.
You can prospect the convenient classified ads, decadent indexes, oceanfront listings, and secluded listed properties under home rentals in Honolulu Hawaii and homes for rent by owner.
Using our page, town home owners register condominium, chalet, and villa indexes.
Learn, look up, and come across holiday rentals in Mountain View United States, Mountain View United States rental properties, and Mountain View United States homes for rent by owner.
Honolulu land owners, rental owners, and third party listing companies list Honolulu Hawaii rental apartment, vacation homes for rent by owner Honolulu, apartment rentals in Honolulu Hawaii, and apartment rentals in Honolulu Hawaii.
Honolulu is a admirable, gorgeous, and excellent locality with radiant, delightful, and taking timeshare, ranch, vacation home, and haciendas.
|
|
