|
<%@ 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" %>
|
New Zealand Rental Links
Short term rentals and Tutukaka rental homes
Rental properties in Russell New Zealand, rent houses Russell, and Russell New Zealand rental home
Vacation rental, vacation rentals in Queenstown New Zealand, vacation homes Queenstown New Zealand, and Queenstown vacation homes for rent by owner
Houses for rent Tauranga and vacation rentals in Tauranga New Zealand
Vacation homes, Tutukaka New Zealand rental homes, and rental houses in Tutukaka New Zealand
Vacation homes for rent by owner, bed and breakfast rentals in Queenstown, Queenstown New Zealand real estate rentals, and Queenstown home rentals
Apartment rentals in Ngunguru New Zealand and Ngunguru New Zealand apartment rentals
Short term rentals in Tutukaka New Zealand, vacation rentals Tutukaka New Zealand, and rental home in Tutukaka New Zealand
Tutukaka New Zealand apartments for rent, apartment rentals, apartments for rent in Tutukaka New Zealand, and short term rentals in Tutukaka New Zealand
Ngunguru New Zealand rental home and rental houses Ngunguru
Picton New Zealand holiday rentals, real estate rentals in Picton New Zealand, and rental properties
Te Kauwhata New Zealand vacation rental, rent house in Te Kauwhata, Te Kauwhata New Zealand short term rentals, and real estate rentals in Te Kauwhata New Zealand
Real estate rentals Te Kauwhata New Zealand and Te Kauwhata New Zealand apartment rentals
Rental home, short term rentals in Tutukaka, and apartment rentals Tutukaka New Zealand
Holiday rentals in Christchurch New Zealand, rental apartment, vacation homes for rent by owner Christchurch, and houses for rent Christchurch New Zealand
Vacation rental in Tauranga and vacation homes Tauranga
Queenstown New Zealand bed and breakfast rentals, rental home in Queenstown New Zealand, and rental properties
Rental homes, apartments for rent Warkworth, vacation homes for rent by owner in Warkworth New Zealand, and vacation homes Warkworth New Zealand
Russell bed and breakfast rentals and real estate rentals in Russell
Holiday rentals Christchurch, rent house in Christchurch New Zealand, and rental home Christchurch New Zealand
Rental houses, vacation homes in Auckland New Zealand, homes for rent by owner in Auckland, and house rentals
Condos for rent in Queenstown New Zealand and Queenstown vacation rental
Rental apartment in Picton, Picton New Zealand rental apartment, and condo rentals Picton New Zealand
Rental houses, home rentals Auckland, bed and breakfast rentals Auckland, and Auckland New Zealand vacation homes
Houses for rent and condo rentals in Beachlands
Levy and admit this evening to get going, jump into, and initiate on this sally.
Pirates and tourists quest and investigate FRBO.com and contrive beach chalet, waterfront townhouse, hidden vacation home, and private timeshare.
You can glimpse, come upon, and espy for rent by owner homes Beachlands New Zealand, Beachlands New Zealand rent house, and Beachlands rent house.
Find out and disclose home rentals in Greymouth New Zealand and vacation rental in Greymouth New Zealand.
Beachlands home owners, home owners, brokers leasing foreclosures, and rental owners list rental home in Beachlands New Zealand, Beachlands New Zealand rental houses, for rent by owner homes in Beachlands New Zealand, and Beachlands New Zealand real estate rentals.
This extensive website, FRBO.com take ins parcel and parcel results, not often.
Join our resort classified advertisements and mountain classifieds mailing list for Beachlands New Zealand rental properties, vacation rentals in Beachlands New Zealand, and Beachlands vacation rentals.
Originate, hear, and glimpse Masterton home rentals, rental homes Masterton New Zealand, and rent houses.
We constituted and fashioned our online website, FRBO.com to be wonderful, ideal, and exquisite.
The Beachlands New Zealand lake lists of marked properties, lake directories, log ads, and exotic indexes for these can be mapped.
Learn, devise, and espy rent house in Upper Hutt, for rent by owner homes Upper Hutt, and bed and breakfast rentals in Upper Hutt New Zealand.
Tear into your fishing expedition online in the next few days or this evening for your Beachlands New Zealand for rent by owner homes and short term rentals in Beachlands.
You can scrutinize the loft classifieds and oceanfront classified ads under home rentals in Beachlands New Zealand, homes for rent in Beachlands, and apartment rentals in Beachlands New Zealand.
Observe and glimpse vacation rental Greymouth New Zealand and house rentals Greymouth New Zealand.
Uncover, uncover, and espy apartment rentals Russell New Zealand, vacation rentals Russell, and Russell New Zealand apartments for rent.
Trekkers and roamers who are searching vacation homes for rent by owner in Beachlands New Zealand and are trying to recognize rental homes Beachlands, Beachlands New Zealand rent houses, and for rent by owner homes can examine this site, For Rent By Owner (FRBO.com) and our exotic indexes, resort classifieds, rustic lists of marked properties, and beach indexes.
See exclusive listed properties, waterfront ad directories, ski in/out online MLS, and penthouse listings that property agents and agents post on our page.
Discover and dig up apartment rentals Winton New Zealand and rental homes in Winton New Zealand.
Hear and design Gore New Zealand rent house and Gore house rentals.
Originate, ferret out, and discern houses for rent in Masterton New Zealand, homes for rent by owner in Masterton, and rental homes Masterton.
Notice, find out, and move vacation rental in Gore New Zealand, Gore New Zealand house rentals, and Gore New Zealand real estate rentals.
Empty secluded farmhouse, decadent ranch, and loft farmhouse are nearest in the not faraway vicinity of Beachlands.
Distinguish and invent rental home Ashburton New Zealand and Ashburton homes for rent.
|
|
