|
<%@ 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" %>
|
Australia Rental Links
Homes for rent in Hunter Valley Australia and Hunter Valley Australia rental properties
Manly Australia houses for rent, Manly rental properties, and rental apartment
Hamilton Island Australia condo rentals, Hamilton Island Australia rent houses, Hamilton Island Australia houses for rent, and vacation homes
Surfers Paradise Australia bed and breakfast rentals and vacation homes Surfers Paradise Australia
Vacation homes for rent by owner in Noosa Heads Australia, rent house in Noosa Heads, and vacation rentals
House rentals in Noosa Heads, Noosa Heads Australia real estate rentals, homes for rent by owner, and rental properties Noosa Heads
Manly Australia vacation rental and condo rentals Manly Australia
Airlie Beach Australia rental homes, Airlie Beach Australia houses for rent, and Airlie Beach bed and breakfast rentals
Trinity Beach Australia holiday rentals, for rent by owner homes Trinity Beach, Trinity Beach rental homes, and Trinity Beach vacation rentals
Vacation rentals in Melbourne Australia and holiday rentals Melbourne
Manly Australia home rentals, Manly holiday rentals, and vacation rentals Manly Australia
Condo rentals in Manly Australia, Manly vacation homes, Manly Australia vacation homes for rent by owner, and condo rentals in Manly Australia
Coolum Beach Australia rental homes and real estate rentals Coolum Beach Australia
Homes for rent in Palm Cove Australia, vacation homes, and holiday rentals
Condos for rent in Surfers Paradise Australia, rent house in Surfers Paradise, rental homes Surfers Paradise, and vacation rentals in Surfers Paradise Australia
Houses for rent Coolum Beach and houses for rent Coolum Beach Australia
Holiday rentals in Melbourne Australia, rent house, and apartment rentals Melbourne
Sunrise Beach Australia rental properties, Sunrise Beach Australia houses for rent, rent houses in Sunrise Beach Australia, and Sunrise Beach house rentals
Apartment rentals in Caloundra and houses for rent Caloundra Australia
Hunter Valley rental properties, holiday rentals in Hunter Valley Australia, and short term rentals
Rent houses in Surfers Paradise Australia, apartments for rent in Surfers Paradise Australia, house rentals Surfers Paradise, and Surfers Paradise Australia vacation homes
Homes for rent by owner in Noosa Heads Australia and rental homes in Noosa Heads Australia
Bed and breakfast rentals Palm Cove Australia, condos for rent Palm Cove Australia, and rental homes Palm Cove Australia
Apartment rentals in Sunrise Beach Australia, Sunrise Beach vacation rental, vacation rentals Sunrise Beach, and rental home
Rental houses in Hamilton Island Australia and Hamilton Island Australia rental properties
Surfers Paradise Australia houses for rent, homes for rent in Surfers Paradise, and Surfers Paradise Australia condo rentals
Vacation rentals in Surfers Paradise Australia, houses for rent Surfers Paradise Australia, real estate rentals in Surfers Paradise Australia, and Surfers Paradise Australia vacation homes for rent by owner
Home rentals in Airlie Beach Australia and vacation rental in Airlie Beach Australia
Homes for rent by owner Sydney, Sydney Australia apartment rentals, and Sydney homes for rent by owner
Rent houses Caloundra, apartments for rent Caloundra, rent house Caloundra, and Caloundra vacation homes
Apartments for rent in Sunrise Beach Australia and Sunrise Beach Australia rental home
Brides, students, and road warriors who are scouting Airlie Beach Australia for rent by owner homes and are trying to locate holiday rentals in Airlie Beach Australia and holiday rentals in Airlie Beach Australia can inspect this website, FRBO.com and our rustic indexes, lakefront ad directories, lakeside directories, and penthouse lists of marked properties.
Look up, move, and identify condo rentals in Oodnadatta Australia, rental apartment Oodnadatta Australia, and condo rentals Oodnadatta Australia.
Our for rent by owner website does subsume distinctive domain oceanfront, mountain, romantic, and lakefront home, cabin, houseboat, and farmhouses.
The Airlie Beach lakeside classified advertisements, spacious advertisements, secluded classified advertisements, and beach classifieds for these state can be mapped.
Reserve and get on Wednesday to launch, initiate, and launch on this march.
Come upon and glimpse rental home in Deer Park Australia and Deer Park Australia rental properties.
Airlie Beach Australia is a ideal, delightful, fine, and graceful quarter with fascinating, bewitching, and superb houseboat, house, and vacation homes.
We spawned, devised, and imagined this extensive website, FRBO.com to be sublime and stunning.
Catch and explore houses for rent Hamilton and vacation rental in Hamilton Australia.
Devise and discern holiday rentals Red Cliffs and Red Cliffs Australia short term rentals.
Send sublime, superb, charming, and refined input regarding Airlie Beach Australia real estate rentals, Airlie Beach Australia rental home, and rent houses in Airlie Beach Australia found on FRBO.com.
Join our exclusive listings, resort lists of marked properties, and resort ads mailing list for rental home Airlie Beach and rent house in Airlie Beach Australia.
Debunk, espy, and perceive vacation rentals Sale Australia, rent house in Sale Australia, and real estate rentals Sale Australia.
Come across, uncover, and explore rental properties in Maryborough, Maryborough vacation homes, and rental home in Maryborough.
Determine and invent rental properties in Elizabeth and rental home in Elizabeth Australia.
Vacant convenient townhouse, private houseboat, beachfront condominium, and city timeshare are not remote in the handy turf of Airlie Beach.
Contrive and recognize houses for rent Mornington and Mornington Australia vacation rental.
Devise, discern, and ferret out Goulburn apartments for rent, rent house in Goulburn, and Goulburn rental home.
See hillside classified advertisements, log directories, ski in/out classified ads, and city ads that rental agents and third party listing companies post on our online website, FRBO.com.
Move, perceive, and recognize rental home in Sunshine Australia, short term rentals in Sunshine, and rental properties in Sunshine Australia.
|
|
