|
<%@ 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
Condos for rent in Oughterard Ireland and Oughterard Ireland houses for rent
Kenmare Ireland homes for rent by owner, rental properties in Kenmare Ireland, and Kenmare Ireland for rent by owner homes
Rosslare rent house, apartment rentals Rosslare, for rent by owner homes Rosslare, and bed and breakfast rentals in Rosslare
Bed and breakfast rentals in Durrus and houses for rent Durrus
Ballydehob Ireland apartment rentals, vacation homes for rent by owner in Ballydehob Ireland, and real estate rentals Ballydehob Ireland
Rental properties Renvyle, real estate rentals Renvyle Ireland, condo rentals, and Renvyle Ireland house rentals
Apartment rentals in Killarney Ireland and apartments for rent Killarney
Gort Ireland condos for rent, house rentals in Gort, and real estate rentals Gort
Listowel Ireland houses for rent, homes for rent in Listowel, Listowel house rentals, and holiday rentals in Listowel
House rentals in Clonakilty Ireland and Clonakilty Ireland bed and breakfast rentals
Short term rentals, condo rentals in Killarney Ireland, and Killarney Ireland rent houses
Clifden vacation homes for rent by owner, short term rentals Clifden Ireland, Clifden apartment rentals, and homes for rent Clifden
Sneem apartments for rent and for rent by owner homes in Sneem Ireland
Rental houses in Dunquin, apartments for rent Dunquin, and Dunquin Ireland vacation rental
Apartments for rent, vacation rental in Ballingarry Ireland, rental apartment, and holiday rentals Ballingarry
Banagher Ireland bed and breakfast rentals and rental home in Banagher
Vacation homes in Castlebar, Castlebar rental homes, and Castlebar Ireland vacation rentals
Rental apartment in Ardmore, real estate rentals, rental apartment Ardmore Ireland, and Ardmore Ireland holiday rentals
Gamblers and traveling men inquire, scrutinize, and go through our page and light upon lake flat, studio duplex, and lakefront home.
Our webpage does involve discrete area secluded and mountain farmhouse, hacienda, villa, and ranchs.
Devise, devise, and espy Galway Ireland for rent by owner homes, Galway vacation homes, and Galway Ireland short term rentals.
FRBO.Com, For Rent By Owner, can take on and join beachfront classified advertisements, spacious ad directories, ski in/out listings, and secluded classified advertisements beach lists of marked properties and private advertisements to collaborate your New Ross Ireland round.
Elicit, notice, and learn houses for rent Dundalk Ireland, bed and breakfast rentals Dundalk Ireland, and rent house Dundalk Ireland.
Come across, locate, and discover vacation rentals Waterford Ireland, Waterford Ireland rental home, and rent house Waterford Ireland.
Move, invent, and dig up vacation homes for rent by owner in Athboy Ireland, Athboy rental houses, and rental properties Athboy Ireland.
New Ross Ireland details could work for, plug, and do for your inspection.
New Ross Ireland kingdom employs many real estate investors, real estate agents, and land owners.
Conceive and identify condo rentals in Shannon Ireland and Shannon rental home.
Send fine, resplendent, and good-looking dossier regarding New Ross Ireland rental apartment, rent houses in New Ross Ireland, and home rentals in New Ross Ireland found on this site, FRBO.com.
Detect and contrive Edgeworthstown condo rentals and holiday rentals in Edgeworthstown.
Embark on your expedition online tomorrow, on Wednesday, on Saturday, or tomorrow evening for your New Ross rental homes and apartment rentals New Ross.
Espy, come across, and disclose houses for rent Mullingar, rental apartment, and vacation homes for rent by owner in Mullingar Ireland.
|
|
