|
<%@ 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
Bed and breakfast rentals and Hunter Valley rental properties
Rental houses in Manly Australia, vacation homes in Manly Australia, and rental houses Manly Australia
Homes for rent in Caloundra, vacation homes Caloundra, vacation homes for rent by owner in Caloundra Australia, and Caloundra Australia rental homes
Trinity Beach Australia rental apartment and rental homes in Trinity Beach Australia
Home rentals in Robertson Australia, rental properties, and rent houses
Hamilton Island Australia homes for rent by owner, home rentals Hamilton Island, homes for rent by owner Hamilton Island, and vacation rental in Hamilton Island Australia
Cairns Australia for rent by owner homes and rental homes in Cairns
Coolum Beach vacation homes, real estate rentals Coolum Beach Australia, and Coolum Beach Australia homes for rent by owner
Robertson short term rentals, bed and breakfast rentals, Robertson rental home, and rent house Robertson Australia
Cairns Australia for rent by owner homes and Cairns Australia real estate rentals
Noosa Heads Australia rental homes, rental apartment in Noosa Heads, and rental home in Noosa Heads
Rent house in Airlie Beach Australia, real estate rentals in Airlie Beach Australia, rent houses in Airlie Beach Australia, and Airlie Beach rent house
Airlie Beach apartments for rent and vacation homes Airlie Beach
Darwin Australia vacation homes for rent by owner, Darwin holiday rentals, and Darwin Australia vacation rentals
Real estate rentals Manly, rent house Manly, homes for rent by owner in Manly, and Manly apartment rentals
Apartments for rent Caloundra Australia and vacation rental in Caloundra
Condo rentals, vacation homes, and condo rentals Melbourne Australia
Homes for rent by owner in Palm Cove Australia, Palm Cove homes for rent by owner, condo rentals Palm Cove, and Palm Cove Australia short term rentals
Real estate rentals Noosa Heads Australia and vacation rental in Noosa Heads
House rentals, Manly rental apartment, and real estate rentals Manly Australia
Manly Australia rental apartment, real estate rentals in Manly Australia, homes for rent in Manly, and Manly Australia apartment rentals
Short term rentals Robertson and rent house in Robertson Australia
Rental home in Trinity Beach, homes for rent, and vacation rental in Trinity Beach Australia
Rent houses Cairns Australia, vacation rentals in Cairns Australia, for rent by owner homes in Cairns, and vacation rentals in Cairns Australia
Rental houses and bed and breakfast rentals in Hamilton Island Australia
Holiday rentals, rental homes in Sunrise Beach, and holiday rentals Sunrise Beach Australia
Rental homes in Sigatoka and Sigatoka Fiji for rent by owner homes
Perceive, come across, and discern Echuca Australia vacation homes for rent by owner, Echuca Australia for rent by owner homes, and rent houses in Echuca.
Distinguish, find out, and come across condo rentals, Albany Australia home rentals, and Albany Australia rental apartment.
Join our convenient ad directories and exotic ad directories mailing list for rental home in Coolum Beach Australia and apartment rentals.
Available studio vacation home, romantic condominium, beachfront houseboat, and secluded timeshare are adjacent in the adjacent area of Coolum Beach Australia.
Determine and design Longreach Australia condo rentals and Longreach Australia rental homes.
Disclose, look up, and dig up Toowoomba Australia condos for rent, vacation rental Toowoomba Australia, and homes for rent by owner.
Take up your expedition online in the next few days, on Sunday, or this week for your rental properties Coolum Beach, vacation rental, and Coolum Beach Australia apartments for rent.
You can explore the ski in/out lists of marked properties, beachfront indexes, and well appointed advertisements under rental apartment in Coolum Beach Australia and short term rentals in Coolum Beach Australia.
We erected, dreamed up, and made this site, FRBO.com to be pleasing, marvelous, and ravishing.
Coolum Beach third party listing companies and brokers leasing foreclosures list bed and breakfast rentals in Coolum Beach, condos for rent in Coolum Beach Australia, and Coolum Beach Australia homes for rent by owner.
Coolum Beach score could thump, support, and open doors your inspection.
Catch, debunk, and observe the kingdom and nearly Coolum Beach Australia county.
Determine and catch homes for rent by owner Carnarvon Australia and Carnarvon Australia homes for rent by owner.
Join up, oblige, record, and induct tomorrow evening to initiate, begin, take up, and kick off on this wayfaring.
The Coolum Beach Australia lists of marked properties calendar and calendar on this extensive website, FRBO.com have secluded cabin, penthouse house, and log timeshare.
|
|
