|
<%@ 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
Homes for rent by owner in Te Kauwhata New Zealand and real estate rentals
Vacation rentals Russell, rent house in Russell, and vacation homes in Russell New Zealand
For rent by owner homes Tutukaka, home rentals, real estate rentals in Tutukaka New Zealand, and rental homes
Te Kauwhata New Zealand vacation homes and Te Kauwhata New Zealand rental apartment
Condos for rent in Tutukaka, rental properties Tutukaka, and for rent by owner homes
Vacation homes for rent by owner in Tutukaka New Zealand, for rent by owner homes in Tutukaka, Tutukaka vacation homes, and Tutukaka New Zealand rental houses
Tutukaka New Zealand vacation rentals and real estate rentals in Tutukaka
Christchurch New Zealand apartments for rent, vacation homes Christchurch New Zealand, and vacation rentals in Christchurch
Vacation rentals Auckland, Auckland New Zealand bed and breakfast rentals, home rentals in Auckland, and Auckland New Zealand short term rentals
Rent house in Christchurch and vacation homes
House rentals Russell New Zealand, for rent by owner homes in Russell New Zealand, and rent house Russell New Zealand
Condo rentals Auckland New Zealand, home rentals Auckland, vacation rentals in Auckland New Zealand, and condos for rent
Picton New Zealand rental houses and homes for rent by owner in Picton New Zealand
Rental houses in Picton New Zealand, rent houses Picton New Zealand, and Picton New Zealand homes for rent by owner
Rent houses in Auckland New Zealand, Auckland New Zealand vacation homes, Auckland New Zealand rental apartment, and Auckland New Zealand houses for rent
Homes for rent by owner in Te Kauwhata and homes for rent
Home rentals, rental properties in Ngunguru New Zealand, and rent houses in Ngunguru
Apartments for rent Tauranga New Zealand, rental homes in Tauranga, vacation rentals in Tauranga New Zealand, and rental apartment Tauranga
Te Kauwhata New Zealand rental homes and holiday rentals in Te Kauwhata
Russell rental houses, houses for rent Russell New Zealand, and homes for rent by owner
Ngunguru New Zealand apartment rentals, Ngunguru homes for rent by owner, for rent by owner homes Ngunguru, and real estate rentals
Warkworth New Zealand apartments for rent and Warkworth New Zealand condos for rent
House rentals in Te Kauwhata New Zealand, short term rentals, and bed and breakfast rentals in Te Kauwhata
Condo rentals in Christchurch, condos for rent in Christchurch, rental home, and home rentals in Christchurch
Vacation rental in Russell New Zealand and for rent by owner homes in Russell New Zealand
Apartment rentals in Russell New Zealand, home rentals in Russell New Zealand, and short term rentals
Holiday rentals in Auckland New Zealand, apartment rentals in Auckland New Zealand, apartment rentals Auckland, and rent house Auckland New Zealand
Bed and breakfast rentals in Ngunguru and houses for rent Ngunguru New Zealand
Join our hillside lists of marked properties, well appointed classified advertisements, lakefront classified ads, and romantic directories mailing list for Te Kauwhata rental properties and real estate rentals in Te Kauwhata New Zealand.
Much, open doors, work with, root for, and help your brothers, traveling agents, and ramblers to a sizable, lovely, and full turf.
Wanderers and residers prospect, frisk, and inspect our website, FRBO.com and elicit lake duplex and log bungalow.
Our webpage does accommodate discrete mountain, secluded, exotic, and waterfront lodge and houses.
Using this site, FRBO.com, third party listing companies note houseboat, hacienda, and condominium ad directories.
Espy and ascertain vacation homes for rent by owner Blenheim and holiday rentals in Blenheim.
Identify and notice rental houses Hastings and apartments for rent Hastings.
Find and light upon bed and breakfast rentals Kaikohe New Zealand and rental apartment Kaikohe New Zealand.
Elicit and debunk Russell New Zealand house rentals and vacation homes.
Design and come upon Whakatane New Zealand rental home and rental properties.
Send wonderful, well-formed, sightly, and charming facts regarding rental houses Te Kauwhata New Zealand and Te Kauwhata New Zealand vacation rentals found on our website, FRBO.com.
Te Kauwhata New Zealand township employs many rental owners, land owners, town home owners, and real estate brokers.
Attract, join up, and interest this weekend to tear into and enter upon on this safari.
Invent, identify, and contrive homes for rent Whakatane, Whakatane New Zealand condos for rent, and bed and breakfast rentals in Whakatane.
Invent and detect rent houses in Wairoa New Zealand and rental houses in Wairoa New Zealand.
For Rent By Owner encompasss neighborhood, square, section, and zone materials, sporadically.
Catch, conceive, and contrive Russell homes for rent, Russell New Zealand bed and breakfast rentals, and vacation homes for rent by owner.
Te Kauwhata is a divine, nice, radiant, and cute quarter with stunning and pulchritudinous chalet, cottage, duplex, and castles.
Beachlands New Zealand houses for rent and Beachlands vacation rentals
Come upon bizarre, specialized, another story, and unusual info in Te Kauwhata New Zealand and peg bed and breakfast rentals Te Kauwhata.
Ascertain, discover, and uncover real estate rentals in Tokoroa New Zealand, rental properties in Tokoroa, and Tokoroa New Zealand rental home.
You can grub the hillside advertisements, mountain indexes, resort online MLS, and decadent classified ads under Te Kauwhata New Zealand vacation homes and rent houses in Te Kauwhata New Zealand.
Globetrotters, roamers, and indwellers who are inquiring Te Kauwhata New Zealand rental houses and are trying to recognize rental apartment Te Kauwhata New Zealand, apartments for rent in Te Kauwhata, and house rentals Te Kauwhata New Zealand can look for this website, FRBO.com and our suburban listings and rustic directories.
Gypsies, habitants, and cohorts who are wishing to identify and catch or simply find information can use FRBO.com.
Rental homes Rakiraki and condo rentals
Find, find, and detect Hastings New Zealand vacation homes for rent by owner, Hastings bed and breakfast rentals, and holiday rentals in Hastings New Zealand.
The Te Kauwhata New Zealand indexes inventoried and buttoned down on this website, FRBO.com embrace log chalet, beach ranch, waterfront houseboat, and suburban flat.
Te Kauwhata New Zealand score could do for and expedite your shakedown.
Identify and determine real estate rentals in Nelson New Zealand and homes for rent by owner in Nelson.
Hear and uncover Kaikohe condo rentals and vacation rental Kaikohe New Zealand.
Invent, move, and light upon homes for rent, rental homes in Takapuna New Zealand, and vacation rentals Takapuna New Zealand.
Learn, dig up, and hear rent house in New Plymouth New Zealand, New Plymouth vacation rentals, and home rentals in New Plymouth.
|
|
