|
<%@ 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
Condo rentals Noosa Heads and house rentals in Noosa Heads Australia
Hunter Valley homes for rent, house rentals in Hunter Valley Australia, and homes for rent Hunter Valley
Rental homes Coolum Beach, short term rentals Coolum Beach Australia, Coolum Beach Australia apartment rentals, and Coolum Beach homes for rent by owner
Houses for rent in Hamilton Island Australia and Hamilton Island Australia houses for rent
Cairns rental homes, for rent by owner homes Cairns, and vacation homes for rent by owner Cairns
Cairns Australia homes for rent, Cairns Australia condos for rent, houses for rent, and Cairns Australia rent house
Houses for rent and home rentals in Manly
Rental home in Robertson Australia, house rentals in Robertson, and short term rentals Robertson Australia
Caloundra Australia vacation homes, Caloundra Australia homes for rent by owner, Caloundra rental apartment, and homes for rent by owner Caloundra
Hunter Valley Australia rent house and houses for rent Hunter Valley Australia
Vacation rental in Robertson Australia, rental homes Robertson Australia, and Robertson Australia rental properties
Manly Australia bed and breakfast rentals, Manly houses for rent, real estate rentals, and rental apartment Manly Australia
Rental houses 1770 and vacation rental 1770 Australia
Rental apartment in Palm Cove, home rentals in Palm Cove Australia, and condo rentals in Palm Cove
Melbourne Australia vacation rentals, Melbourne Australia vacation homes for rent by owner, holiday rentals Melbourne, and holiday rentals in Melbourne Australia
Home rentals in Robertson Australia and Robertson Australia home rentals
Pre-rented decadent houseboat, lake houseboat, beach farmhouse, and exclusive castle are handy in the not far stretch of Cairns Australia.
Cairns Australia field employs many rental agents, landlords, property brokers, and agents serving the condo market.
We contrived and created For Rent By Owner to be excellent, comely, and exquisite.
Traveling sales representatives, professors, and roadmen cast about and hunt our site, FRBO.com and learn convenient home, private apartment, and beach farmhouse.
You can relocate, ferret out, and design Cairns Australia rental properties, apartments for rent, and rental houses in Cairns Australia.
See spacious ads and city classified ads that agents serving the condo market and rental property owners post on FRBO.com.
Find, uncover, and relocate Bendigo Australia vacation rentals, Bendigo Australia vacation homes, and rental homes in Bendigo Australia.
The Cairns Australia listed properties placed and pegged on this webpage incorporate beach bungalow, lake ranch, and secluded castle.
Identify and look up vacation rental in Hurstbridge Australia and Hurstbridge real estate rentals.
Espy and distinguish home rentals Williamstown Australia and houses for rent in Williamstown.
Cairns Australia is a stunning and taking quarter with ideal and comely duplex, bungalow, condominium, and houses.
Come across, find, and espy rental apartment in Penguin Australia, Penguin Australia apartment rentals, and Penguin condo rentals.
The Cairns Australia suburban ad directories, exotic classifieds, rustic classified advertisements, and private advertisements for these precinct can be mapped.
Hitch, secure, and inscribe on Saturday to get cracking and inaugurate on this tour.
You can look for the private advertisements and resort classified advertisements under house rentals in Cairns Australia and rent house Cairns.
Cairns Australia circumstances could open doors and root for your inspection.
Learn and relocate Inverell Australia apartment rentals and Inverell Australia rental home.
Originate and conceive short term rentals Redcliffe Australia and rental apartment in Redcliffe Australia.
|
|
