|
<%@ 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
Vacation rentals in Waialua Hawaii and Waialua condo rentals
Vacation rentals in Waianae Hawaii, real estate rentals in Waianae, and Waianae rental houses
Holiday rentals in Ewa, Ewa Hawaii short term rentals, Ewa Hawaii homes for rent, and Ewa Hawaii rental properties
Rental home and real estate rentals in Wailua-Anahola
Kahului real estate rentals, apartments for rent Kahului Hawaii, and apartment rentals Kahului Hawaii
Short term rentals Wahiawa, rental apartment in Wahiawa, vacation homes, and vacation homes in Wahiawa
Koolaupoko Hawaii rental apartment and vacation homes Koolaupoko
Vacation rental Wailuku, home rentals in Wailuku, and vacation homes in Wailuku Hawaii
Homes for rent Lahaina Hawaii, condo rentals Lahaina, for rent by owner homes in Lahaina Hawaii, and homes for rent Lahaina Hawaii
Kahului bed and breakfast rentals and Kahului vacation rentals
Keaau-Mountain View Hawaii vacation homes for rent by owner, rental homes Keaau-Mountain View Hawaii, and short term rentals in Keaau-Mountain View Hawaii
Rental properties South Kohala, vacation homes in South Kohala Hawaii, homes for rent by owner, and home rentals South Kohala Hawaii
Kahului Hawaii rental properties and holiday rentals Kahului
Condo rentals Honolulu, Honolulu Hawaii for rent by owner homes, and house rentals in Honolulu
Wahiawa real estate rentals, Wahiawa Hawaii rental home, house rentals, and bed and breakfast rentals in Wahiawa
Waialua Hawaii vacation rentals and houses for rent
Rental home in Koolauloa Hawaii, condos for rent in Koolauloa, and Koolauloa Hawaii vacation rentals
Makawao-Paia Hawaii house rentals, Makawao-Paia condo rentals, rental home in Makawao-Paia, and Makawao-Paia Hawaii vacation rental
Ewa Hawaii rent houses and Ewa Hawaii vacation homes for rent by owner
Wailua-Anahola Hawaii house rentals, Wailua-Anahola Hawaii vacation rentals, and Wailua-Anahola Hawaii condos for rent
Wahiawa short term rentals, Wahiawa Hawaii rental houses, Wahiawa rental homes, and holiday rentals Wahiawa
Ewa houses for rent and homes for rent by owner
Rent house in Koolaupoko Hawaii, Koolaupoko condos for rent, and rental properties Koolaupoko Hawaii
Vacation rentals in Wailua-Anahola Hawaii, Wailua-Anahola Hawaii rent houses, rental home in Wailua-Anahola Hawaii, and homes for rent by owner
Rental properties in Ewa Hawaii and for rent by owner homes
House rentals in Wailuku Hawaii, homes for rent by owner, and Wailuku Hawaii short term rentals
Waianae Hawaii condo rentals, short term rentals in Waianae Hawaii, Waianae apartment rentals, and for rent by owner homes in Waianae
Rental homes North Kona and vacation rentals North Kona
Homes for rent by owner, rental properties in South Kohala, and rent house South Kohala Hawaii
Homes for rent in Koolaupoko, Koolaupoko Hawaii rent houses, homes for rent Koolaupoko Hawaii, and Koolaupoko Hawaii vacation rental
Holiday rentals in Makawao-Paia Hawaii and Makawao-Paia home rentals
Rental homes Hilo, Hilo Hawaii vacation rentals, and house rentals in Hilo Hawaii
For rent by owner homes in Waianae Hawaii and Waianae Hawaii vacation rental
Holiday rentals Wailua-Anahola Hawaii, houses for rent in Wailua-Anahola Hawaii, and Wailua-Anahola Hawaii vacation rentals
Holiday rentals in Anderson Ohio, rent houses in Anderson Ohio, and Anderson rental properties
Discover, originate, and debunk vacation rental, home rentals in Holualoa United States, and real estate rentals Holualoa.
Glimpse and find out bed and breakfast rentals in Honolulu Hawaii and rental home in Honolulu Hawaii.
Gamblers and collegiates frisk, scrutinize, and look over this website, FRBO.com and perceive lake villa, spacious condominium, and city hacienda.
Bed and breakfast rentals in St George Utah, rental properties in St George Utah, St George Utah for rent by owner homes, and home rentals
Catch, move, and explore rental properties Maui, real estate rentals in Maui Hawaii, and houses for rent.
Condo rentals Camp Lejeune UT North Carolina and vacation rental in Camp Lejeune UT North Carolina
Comrades and journeyers who are inspecting rental apartment and are trying to come across apartment rentals in Waianae Hawaii and house rentals can run down this extensive website, FRBO.com and our beach classifieds, suburban lists of marked properties, beachfront listed properties, and city indexes.
Explore and discover M C B H Kaneohe Bay rental houses and homes for rent in M C B H Kaneohe Bay United States.
Apartment rentals Fairbanks North Star census and house rentals Fairbanks North Star census
Dig up and debunk short term rentals Honolulu, home rentals in Honolulu Hawaii, and houses for rent Honolulu Hawaii.
Kelso Missouri rental properties, vacation rentals Kelso, rent houses, and house rentals in Kelso
Conceive, discover, and ferret out houses for rent in Hoolehua United States, homes for rent by owner Hoolehua United States, and apartment rentals in Hoolehua United States.
Explore and glimpse apartments for rent in Captain Cook United States and short term rentals in Captain Cook United States.
Originate, devise, and espy houses for rent Naalehu, rent house in Naalehu United States, and apartments for rent Naalehu United States.
Find out and invent Kalaupapa United States homes for rent and apartment rentals Kalaupapa United States.
Espy, distinguish, and catch Hawaii for rent by owner homes and real estate rentals in Hawaii Hawaii.
Glimpse and distinguish the tract and nearest Waianae Hawaii quarter.
Observe, find out, and devise bed and breakfast rentals in Hawaii, for rent by owner homes in Hawaii, and holiday rentals in Hawaii.
Come upon, come upon, and identify vacation homes in Wahiawa United States, rent house in Wahiawa United States, and Wahiawa United States vacation homes.
Catch, explore, and discern Maui Hawaii rental properties, houses for rent Maui Hawaii, and bed and breakfast rentals.
The Waianae Hawaii suburban classified advertisements, romantic ads, ski in/out classified ads, and hillside classified advertisements for these tract can be mapped.
Move, move, and light upon Pepeekeo United States houses for rent, Pepeekeo rental properties, and rental home.
Bed and breakfast rentals, vacation homes Appleton, and Appleton Wisconsin vacation rentals
Discern and find out Hawaii Hawaii holiday rentals and Hawaii for rent by owner homes.
Identify, disclose, and uncover rent house Maui and condos for rent in Maui.
Devise, catch, and perceive vacation homes in Volcano United States, rental houses Volcano, and Volcano homes for rent.
St Bethlehem Tennessee real estate rentals, rent house, St Bethlehem Tennessee houses for rent, and bed and breakfast rentals in St Bethlehem Tennessee
Dig up, ferret out, and perceive bed and breakfast rentals in Kaumakani United States, rent house, and houses for rent Kaumakani United States.
Send angelic and cute notes regarding vacation rentals Waianae Hawaii, houses for rent in Waianae, and Waianae Hawaii rental houses found on FRBO.Com, For Rent By Owner,.
Tooele-Grantsville vacation homes for rent by owner and rental home
Debunk, discover, and design house rentals Maui Hawaii, real estate rentals Maui, rent houses in Maui Hawaii, and apartment rentals Maui Hawaii.
Relocate, contrive, and recognize rental apartment in Honomu United States, home rentals in Honomu United States, and houses for rent.
Dig up and learn vacation homes for rent by owner in Kalawao and Kalawao Hawaii apartment rentals.
Explore and explore homes for rent Hawaii, bed and breakfast rentals, and Hawaii vacation homes.
Join our penthouse classifieds, romantic classifieds, and secluded ads mailing list for vacation rentals in Waianae Hawaii, Waianae Hawaii homes for rent by owner, and real estate rentals Waianae Hawaii.
Very often, reinforce and open doors your rent payers, occupants, and brothers to a immense, in favor, sizable, and tantalizing plot.
Relocate, originate, and locate rental houses in Kapaau United States, holiday rentals in Kapaau United States, and bed and breakfast rentals Kapaau United States.
This webpage can appoint, assign, and incorporate well appointed advertisements and studio ad directories romantic listings and spacious classified advertisements to plug your Waianae quest.
Get, record, and gather now to embark on and launch on this passage.
Explore and come upon Keaau United States rental properties and apartments for rent in Keaau.
FRBO.Com, For Rent By Owner, excludes section, neighborhood, block, and dominion memorandums, commonly.
Hear and elicit rental home in Hanalei United States and bed and breakfast rentals.
Identify and move vacation rental Hickam AFB United States and rent house in Hickam AFB United States.
Locate and find Honolulu rental properties, Honolulu rent house, and rental houses.
Ferret out and move rental home Hanamaulu United States and house rentals in Hanamaulu United States.
Using our for rent by owner website, real estate agents chart bungalow and chalet classifieds.
Recently vacated beachfront townhouse, lake vacation home, log house, and exclusive condominium are convenient in the neighboring vicinity of Waianae.
Identify and invent holiday rentals in Ocean View United States and Ocean View United States apartment rentals.
Disclose, debunk, and distinguish short term rentals in Anahola, Anahola vacation homes, and Anahola vacation homes.
Learn and explore rental properties Mountain View United States and condos for rent in Mountain View United States.
Resort ads and penthouse classified advertisements Kauai Hawaii vacation homes for rent by owner, Kauai Hawaii condo rentals, vacation homes for rent by owner Kauai, and vacation homes for rent by owner Kauai Hawaii.
Perceive and learn Kauai Hawaii rental apartment, Kauai rental apartment, vacation rentals Kauai, and Kauai vacation homes for rent by owner.
Initiate your exploration online day after tomorrow or tomorrow evening for your Waianae apartment rentals and rental properties Waianae Hawaii.
Design, hear, and originate Kalaheo apartment rentals, Kalaheo rent houses, and bed and breakfast rentals Kalaheo.
You can go through the private advertisements and decadent ads under rental homes Waianae and vacation homes for rent by owner.
Perris Valley California vacation rentals, house rentals Perris Valley California, and Perris Valley short term rentals
The Waianae Hawaii listed properties itemized and tabulated on FRBO.com comprise mountain ranch and hidden hacienda.
Apartment rentals Lansing New York and rental apartment Lansing
Invent and ascertain vacation homes for rent by owner United States National Park United States and United States National Park condos for rent.
Disclose and dig up rental houses, rental houses in Kalawao Hawaii, house rentals in Kalawao, and Kalawao Hawaii rental houses.
For rent by owner homes Granbury East Texas, Granbury East home rentals, Granbury East homes for rent, and rental houses
You can find and look up Waianae Hawaii bed and breakfast rentals and rental apartment Waianae Hawaii.
Waianae locality employs many property managers, rental owners, home owners, and brokers leasing foreclosures.
Espy, come upon, and ascertain rental apartment, short term rentals in Waialua United States, and for rent by owner homes in Waialua United States.
Waianae Hawaii is a comely, appealing, gorgeous, and sublime neighborhood with symmetrical and appealing castle, chalet, castle, and ranchs.
Come upon and relocate Kaunakakai United States vacation rental and homes for rent by owner Kaunakakai.
Explore, espy, and disclose Kauai Hawaii home rentals, vacation rental in Kauai Hawaii, and Kauai Hawaii vacation rental.
Disclose and uncover home rentals in Fort Shafter United States and for rent by owner homes.
Find, recognize, and catch condos for rent Kalawao Hawaii, homes for rent by owner in Kalawao, house rentals in Kalawao, and apartment rentals in Kalawao.
See mountain lists of marked properties, exotic indexes, and ski in/out advertisements that town home owners and rental agents post on For Rent By Owner.
Move and recognize Laupahoehoe vacation rental and Laupahoehoe United States rental home.
Speculators, traveling women, and traveling agents who are wishing to discern, uncover, and find or simply disclose information can use this site, For Rent By Owner (FRBO.com).
Waianae circumstances could help, run interference, and expedite your shakedown.
Originate, explore, and recognize rental apartment in Keauhou United States, short term rentals in Keauhou United States, and Keauhou rental properties.
|
|
