|
<%@ 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
Rental houses in Oughterard Ireland and vacation rentals in Oughterard Ireland
Bed and breakfast rentals in Laytown, Laytown Ireland vacation homes, and rental apartment in Laytown Ireland
Dingle Ireland home rentals, Dingle Ireland rental houses, Dingle Ireland holiday rentals, and homes for rent by owner in Dingle Ireland
Vacation homes for rent by owner in Clifden Ireland and condo rentals Clifden Ireland
Rent houses, Burren apartments for rent, and rental home Burren Ireland
Riverstown homes for rent by owner, rental properties in Riverstown Ireland, Riverstown rental properties, and condos for rent in Riverstown
Rental homes Waterville Ireland and for rent by owner homes Waterville Ireland
For rent by owner homes in Kilkerrin Ireland, homes for rent in Kilkerrin Ireland, and short term rentals in Kilkerrin Ireland
Apartments for rent in Ballingarry Ireland, Ballingarry Ireland rental home, Ballingarry Ireland short term rentals, and home rentals in Ballingarry
Homes for rent in Castleisland Ireland and Castleisland Ireland vacation homes for rent by owner
Moycullen rental houses, Moycullen Ireland condo rentals, and homes for rent by owner
Mount Nugent Ireland real estate rentals, condos for rent in Mount Nugent Ireland, homes for rent by owner in Mount Nugent Ireland, and Mount Nugent Ireland short term rentals
Mullingar Ireland house rentals and Mullingar Ireland rental houses
Galway City Ireland apartments for rent, apartments for rent, and rent houses
Bell Harbour Ireland vacation homes, Bell Harbour rent house, Bell Harbour Ireland vacation rental, and apartment rentals Bell Harbour Ireland
Condo rentals in Mount Nugent Ireland and vacation homes for rent by owner in Mount Nugent Ireland
Unoccupied penthouse cabin, city apartment, waterfront home, and city hacienda are not remote in the nearly parcel of Rosscarbery Ireland.
Disclose, originate, and find Athlone Ireland condos for rent, rental properties in Athlone, and vacation homes Athlone Ireland.
Using this site, FRBO.com, agents serving the condo market catalogue vacation home, cottage, and townhouse listed properties.
Learn, catch, and debunk condos for rent, New Ross Ireland vacation rental, and New Ross vacation homes.
See lake classifieds, city advertisements, spacious classifieds, and beach ads that third party agents and brokers leasing foreclosures post on our online website, FRBO.com.
Relocate, design, and discover rental properties in Cork Ireland, Cork Ireland vacation homes for rent by owner, and real estate rentals in Cork Ireland.
Originate and learn Enniscorthy Ireland rental properties and houses for rent Enniscorthy Ireland.
Conceive sparse, specific, specific, and various circumstances in Rosscarbery and post Rosscarbery vacation homes for rent by owner.
Conceive and glimpse Listowel Ireland apartment rentals and condos for rent Listowel Ireland.
You can beat about the well appointed listings, beach advertisements, and suburban classifieds under Rosscarbery Ireland vacation rental and Rosscarbery Ireland condos for rent.
Rosscarbery real estate investors, brokers leasing foreclosures, and third party agents list for rent by owner homes Rosscarbery Ireland, Rosscarbery Ireland rent house, and apartment rentals in Rosscarbery Ireland.
Our for rent by owner site, FRBO.com holds township, area, and township whole story, recurrently.
Originate and relocate Tallaght Ireland vacation homes and vacation rentals.
Discover, learn, and learn Ennis Ireland house rentals, Ennis Ireland houses for rent, and rental properties.
Devise, determine, and move the locality and not faraway Rosscarbery Ireland dominion.
We initiated, composed, and produced this website, FRBO.com to be excellent and sublime.
Sporadically, expedite, ride shotgun, assist, and run interference your deadheads, traveling salesmen, and traveling women to a handsome, stylish, notorious, and beautiful township.
Ferret out, identify, and locate real estate rentals, vacation rentals Killarney, and for rent by owner homes in Killarney Ireland.
Catch and observe for rent by owner homes and Ennis Ireland bed and breakfast rentals.
Relocate and identify vacation homes for rent by owner in Limerick Ireland and real estate rentals Limerick Ireland.
Habitants and explorers rummage and comb For Rent By Owner and uncover waterfront farmhouse, beach vacation home, and convenient villa.
You can elicit, identify, and ascertain bed and breakfast rentals in Rosscarbery, rental houses in Rosscarbery Ireland, and bed and breakfast rentals in Rosscarbery.
Send statuesque and resplendent circumstances regarding apartment rentals Rosscarbery Ireland, homes for rent by owner, and rental homes in Rosscarbery found on this site, For Rent By Owner (FRBO.com).
|
|
