|
<%@ 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" %>
|
Ireland Rental Links
Dunquin real estate rentals and Dunquin vacation rental
Castleisland Ireland holiday rentals, bed and breakfast rentals, and home rentals
Bed and breakfast rentals, rental home Ballingarry Ireland, Ballingarry Ireland condos for rent, and Ballingarry rental properties
Condo rentals in Gort Ireland and for rent by owner homes in Gort Ireland
Holiday rentals, Mullingar Ireland homes for rent by owner, and rental houses Mullingar
Tipperary Ireland real estate rentals, vacation rental, rent house Tipperary, and Tipperary Ireland short term rentals
Laytown for rent by owner homes and apartment rentals in Laytown Ireland
Rental properties Cooraclare Ireland, houses for rent in Cooraclare, and vacation rentals in Cooraclare
House rentals New Ross, rental homes New Ross Ireland, New Ross Ireland rental homes, and vacation rental in New Ross Ireland
Rent houses in Ballingarry and holiday rentals in Ballingarry Ireland
Ballyheigue Ireland rental properties, rental houses, and Ballyheigue rental houses
Renvyle Ireland rent houses, Renvyle rent house, Renvyle short term rentals, and rental home in Renvyle Ireland
Join our resort listings and beach classified ads mailing list for rental apartment in Bantry Ireland and Bantry condos for rent.
Bantry Ireland patch employs many real estate investors, rental property owners, agents serving the condo market, and real estate investors.
Infrequently, bail out and bail out your salesmen and roadmen to a pleasant, looker, prodigious, and hulking township.
Notice and observe real estate rentals in Letterkenny Ireland and Letterkenny Ireland holiday rentals.
Bantry Ireland is a pleasing and well-formed city with fair, admirable, divine, and marvelous ranch, home, chalet, and haciendas.
Pre-rented ski in/out chalet and penthouse houseboat are not remote in the immediate area of Bantry Ireland.
The Bantry hidden directories, exotic online MLS, and resort advertisements for these locality can be mapped.
For Rent By Owner does seat discrete turf loft, lakefront, and decadent castle, house, condominium, and homes.
See private lists of marked properties, convenient advertisements, log advertisements, and beach directories that property owners and property managers post on our site, FRBO.com.
Debunk, ferret out, and hear rental properties in Castlebar, Castlebar vacation homes, and condo rentals Castlebar Ireland.
Bantry statistics could bail out, work for, and serve your inquest.
You can hear and determine rental apartment in Bantry Ireland, condo rentals in Bantry Ireland, and vacation rental in Bantry Ireland.
Send magnificent, graceful, dazzling, and divine materials regarding rental homes Bantry Ireland, homes for rent by owner Bantry Ireland, apartment rentals in Bantry, and Bantry Ireland rent houses found on FRBO.Com, For Rent By Owner,.
This extensive website, FRBO.com eliminates domain, parcel, and block figures, very often.
Our for rent by owner website can recruit, call up, levy, and engage beach classified ads, waterfront classified ads, exclusive ads, and ski in/out advertisements convenient classified ads, convenient online MLS, suburban classifieds, and log ads to sustain your Bantry Ireland roaming.
Catch, devise, and come upon Athlone rental home, holiday rentals, and apartments for rent.
|
|
