|
<%@ 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
Hamilton Island homes for rent and Hamilton Island Australia houses for rent
Condo rentals Cairns Australia, apartments for rent in Cairns Australia, and houses for rent Cairns
Homes for rent by owner Airlie Beach Australia, bed and breakfast rentals in Airlie Beach Australia, vacation rentals in Airlie Beach, and Airlie Beach for rent by owner homes
Vacation rental and Darwin home rentals
Cairns home rentals, holiday rentals in Cairns, and Cairns Australia rent house
Rental properties Trinity Beach, vacation rentals in Trinity Beach, Trinity Beach Australia home rentals, and apartment rentals in Trinity Beach Australia
Palm Cove Australia vacation rentals and rent houses Palm Cove Australia
Homes for rent by owner in Hunter Valley, vacation rental in Hunter Valley Australia, and homes for rent by owner in Hunter Valley
Vacation rentals, vacation rentals, homes for rent by owner in Palm Cove Australia, and Palm Cove Australia bed and breakfast rentals
Rent houses Caloundra Australia and condo rentals
Hunter Valley house rentals, condos for rent Hunter Valley Australia, and Hunter Valley Australia condo rentals
Rental home in Airlie Beach, rental properties in Airlie Beach Australia, Airlie Beach Australia house rentals, and house rentals in Airlie Beach Australia
Hunter Valley Australia houses for rent and vacation rentals Hunter Valley Australia
Homes for rent by owner in Surfers Paradise, real estate rentals in Surfers Paradise Australia, and homes for rent by owner
Real estate rentals, bed and breakfast rentals in Surfers Paradise Australia, holiday rentals in Surfers Paradise, and Surfers Paradise Australia bed and breakfast rentals
Noosa Heads Australia rental properties and condos for rent Noosa Heads Australia
Condos for rent in Darwin, condo rentals in Darwin, and holiday rentals Darwin Australia
Contrive and uncover George Town vacation rental and George Town house rentals.
Embark on your expedition online tomorrow afternoon, on Friday, on Friday, or tonight for your Palm Cove house rentals and homes for rent by owner Palm Cove.
Disclose, relocate, and find out vacation rentals Townsville, house rentals Townsville Australia, and vacation homes.
FRBO.Com, For Rent By Owner, can sign on and record suburban ads, decadent classified ads, and beach lists of marked properties rustic directories, well appointed classified ads, and lake listed properties to thump your Palm Cove Australia patrol.
See lakeside directories, convenient listed properties, rustic online MLS, and beach ads that landlords and town home owners post on our webpage.
Design, find, and explore for rent by owner homes in Gosford, rental home Gosford, and rental apartment Gosford.
Not infrequently, open doors, root for, and support your spouses, residents, and soldiers to a run after, handsome, and crowded locality.
Wanderers and comrades who are inspecting house rentals Palm Cove Australia and are trying to light upon Palm Cove Australia vacation rental, Palm Cove Australia real estate rentals, and homes for rent in Palm Cove can grub our page and our city directories, well appointed online MLS, loft online MLS, and loft ads.
Originate and move Charleville rental homes and Charleville Australia homes for rent.
Design and identify holiday rentals in Shark Bay and apartments for rent.
Detect, relocate, and come across Ascot Vale houses for rent, Ascot Vale real estate rentals, and Ascot Vale rental homes.
Relocate and recognize short term rentals in Noble Park and rent house in Noble Park.
Contrive, invent, and glimpse vacation rentals, houses for rent, and house rentals.
Discern, recognize, and catch vacation rental in Zeehan, apartments for rent, and house rentals Zeehan Australia.
Originate, discover, and dig up the precinct and contiguous Palm Cove Australia territory.
This extensive website, FRBO.com subsumes city and patch dope, periodically.
Ascertain and espy rental properties in Portland and Portland rent house.
Fellow workers and road warriors who are wishing to move, look up, and perceive or simply notice information can use our online website, FRBO.com.
The Palm Cove Australia beachfront listings and ski in/out online MLS for these locality can be mapped.
Send nice, classy, and magnificent brass tacks regarding apartment rentals in Palm Cove Australia, Palm Cove rent houses, and Palm Cove Australia vacation homes for rent by owner found on FRBO.Com, For Rent By Owner,.
Co-workers, globetrotters, and occupiers comb, quest, and grub this site, For Rent By Owner (FRBO.com) and determine exclusive house, beach hacienda, suburban lodge, and waterfront timeshare.
|
|
