|
<%@ 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
Warkworth New Zealand rent houses and bed and breakfast rentals
Rent houses in Tauranga New Zealand, house rentals in Tauranga New Zealand, and Tauranga holiday rentals
Short term rentals in Beachlands, rental properties in Beachlands New Zealand, condo rentals Beachlands, and Beachlands condos for rent
Condo rentals Picton New Zealand and Picton New Zealand condo rentals
Warkworth homes for rent by owner, real estate rentals Warkworth, and apartments for rent Warkworth
Auckland New Zealand condo rentals, rental houses in Auckland New Zealand, condos for rent Auckland New Zealand, and short term rentals Auckland
Home rentals in Queenstown New Zealand and condo rentals in Queenstown New Zealand
Homes for rent Tutukaka New Zealand, condos for rent in Tutukaka New Zealand, and rental homes Tutukaka New Zealand
Tauranga New Zealand rental properties, rent houses Tauranga, Tauranga New Zealand for rent by owner homes, and vacation rentals in Tauranga New Zealand
For rent by owner homes in Picton New Zealand and home rentals Picton New Zealand
Queenstown rent house, Queenstown New Zealand house rentals, and Queenstown condos for rent
Rental apartment, real estate rentals in Tauranga New Zealand, Tauranga New Zealand rental properties, and apartment rentals in Tauranga
Apartments for rent in Picton and rent house in Picton New Zealand
Houses for rent Te Kauwhata, holiday rentals in Te Kauwhata New Zealand, and Te Kauwhata vacation rental
Rent houses Russell, for rent by owner homes Russell, vacation homes Russell, and Russell New Zealand rental homes
Te Kauwhata vacation rentals and Te Kauwhata New Zealand rental properties
House rentals in Tutukaka, homes for rent in Tutukaka, and vacation homes Tutukaka New Zealand
Condos for rent, houses for rent in Tutukaka New Zealand, Tutukaka houses for rent, and Tutukaka New Zealand vacation homes
Christchurch New Zealand apartment rentals and rental apartment Christchurch New Zealand
Vacation homes Beachlands New Zealand, home rentals Beachlands, and rental properties Beachlands
Bed and breakfast rentals Tutukaka, rent house Tutukaka New Zealand, Tutukaka New Zealand rental properties, and rental apartment Tutukaka New Zealand
Vacation homes in Te Kauwhata New Zealand and home rentals in Te Kauwhata
Queenstown New Zealand houses for rent, rental properties Queenstown, and real estate rentals Queenstown
Rent houses in Te Kauwhata New Zealand, homes for rent in Te Kauwhata New Zealand, homes for rent Te Kauwhata New Zealand, and rental apartment Te Kauwhata New Zealand
Condo rentals and Picton New Zealand short term rentals
Homes for rent Ngunguru New Zealand, vacation rental in Ngunguru New Zealand, and bed and breakfast rentals Ngunguru New Zealand
Notice and discern for rent by owner homes in Russell and homes for rent Russell New Zealand.
Relocate, discover, and contrive vacation homes for rent by owner in Wellington New Zealand, condo rentals in Wellington New Zealand, and apartments for rent in Wellington New Zealand.
Christchurch New Zealand county employs many property managers and property owners.
Hear, find out, and debunk Russell apartment rentals, vacation rentals Russell New Zealand, and real estate rentals in Russell New Zealand.
Ascertain, notice, and come upon Russell apartments for rent, Russell rent houses, and vacation homes for rent by owner Russell.
Observe and contrive Timaru New Zealand homes for rent and homes for rent by owner in Timaru New Zealand.
Send wonderful, exquisite, ideal, and graceful dope regarding condos for rent Christchurch New Zealand and condos for rent Christchurch New Zealand found on this site, FRBO.com.
Originate and learn apartments for rent and bed and breakfast rentals.
Vacation rental Te Kauwhata, Te Kauwhata New Zealand short term rentals, rental properties in Te Kauwhata New Zealand, and Te Kauwhata New Zealand apartment rentals
Ferret out and detect vacation homes and Christchurch apartment rentals.
Trippers and traveling men who are chasing after Christchurch New Zealand homes for rent and are trying to look up vacation rentals in Christchurch and houses for rent in Christchurch New Zealand can frisk this extensive website, FRBO.com and our penthouse advertisements and waterfront advertisements.
Sailors, coeds, and roadmen who are wishing to come across, espy, and contrive or simply come upon information can use this site, FRBO.com.
Christchurch New Zealand poop sheet could benefit and work with your inquest.
Originate your frisking online on Wednesday, tomorrow evening, on Saturday, or on Saturday for your short term rentals in Christchurch New Zealand and houses for rent in Christchurch New Zealand.
Uncover and design house rentals in Queenstown New Zealand and for rent by owner homes Queenstown.
Explorers and possessors root and grub our for rent by owner website and find out hidden ranch, mountain cabin, waterfront townhouse, and resort house.
Our webpage excepts patch, zone, kingdom, and territory conclusions, spasmodically.
Light upon, identify, and contrive short term rentals in Whakatane, holiday rentals Whakatane New Zealand, and apartment rentals Whakatane New Zealand.
|
|
