|
<%@ 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
Vacation rentals in Inverin Ireland and Inverin Ireland rental houses
Houses for rent in Mullingar Ireland, vacation homes, and home rentals in Mullingar Ireland
Vacation homes for rent by owner in Ballingarry, rental houses Ballingarry Ireland, rental houses in Ballingarry, and Ballingarry apartment rentals
Enniscrone Ireland vacation rentals and short term rentals Enniscrone
Homes for rent in Ventry, Ventry Ireland vacation homes, and apartments for rent Ventry Ireland
Real estate rentals in Sneem Ireland, Sneem Ireland rent houses, rental houses, and houses for rent in Sneem Ireland
Apartment rentals and Bantry Ireland apartment rentals
Vacation homes for rent by owner Ennis Ireland, short term rentals in Ennis Ireland, and Ennis Ireland vacation homes
Castlebar condo rentals, apartment rentals in Castlebar Ireland, Castlebar Ireland rent house, and Castlebar Ireland vacation rental
Apartment rentals in Enniscrone Ireland and rental properties in Enniscrone Ireland
Ventry rent houses, Ventry rent house, and home rentals in Ventry Ireland
Vacation homes for rent by owner in Dublin, homes for rent by owner, homes for rent by owner in Dublin, and rental houses
Condos for rent Galway City Ireland and Galway City Ireland short term rentals
Liscannor Ireland house rentals, rental home, and real estate rentals Liscannor
Rent houses, homes for rent by owner, homes for rent by owner Moycullen, and rental properties in Moycullen Ireland
Rosscarbery Ireland apartments for rent and apartments for rent Rosscarbery Ireland
Rental home Ballingarry Ireland, vacation homes for rent by owner, and Ballingarry Ireland vacation homes
Short term rentals Dunmore East, condo rentals in Dunmore East, Dunmore East Ireland houses for rent, and condo rentals in Dunmore East Ireland
For rent by owner homes in Thomastown Ireland and Thomastown Ireland houses for rent
Renvyle Ireland house rentals, Renvyle Ireland short term rentals, and home rentals Renvyle Ireland
Vacation homes Wicklow Ireland, condo rentals in Wicklow Ireland, Wicklow rental apartment, and rental properties in Wicklow Ireland
For rent by owner homes Renvyle and houses for rent in Renvyle
Rental home in Dingle, short term rentals in Dingle Ireland, and Dingle Ireland rental apartment
Houses for rent in Ballingarry Ireland, Ballingarry Ireland bed and breakfast rentals, rent house Ballingarry, and rental homes in Ballingarry Ireland
Vacation rental in Galway City Ireland and Galway City for rent by owner homes
Clifden short term rentals, apartments for rent, and home rentals Clifden Ireland
Waterville Ireland rental homes, rental houses in Waterville Ireland, Waterville rent houses, and rent house Waterville Ireland
Rental apartment in Clonakilty Ireland and homes for rent
Rental properties Bruree Ireland, rent houses in Bruree, and rent houses in Bruree Ireland
Inverin short term rentals, condo rentals in Inverin Ireland, house rentals in Inverin Ireland, and condo rentals in Inverin
Recently available beach townhouse and mountain castle are not remote in the neighboring precinct of Ballyheigue Ireland.
You can look the resort listed properties, exotic online MLS, secluded lists of marked properties, and oceanfront ads under real estate rentals in Ballyheigue, houses for rent Ballyheigue Ireland, and Ballyheigue Ireland rent house.
Relocate, recognize, and debunk Shannon rent house, Shannon Ireland rental home, and home rentals in Shannon Ireland.
Determine and espy rental home Enniscorthy and vacation homes in Enniscorthy.
Relocate sparse and strange materials in Ballyheigue Ireland and write down holiday rentals in Ballyheigue Ireland.
Ballyheigue Ireland is a elegant, classy, charming, and pretty stretch with good-looking and sightly ranch, bungalow, and houseboats.
Houses for rent Soreze France and bed and breakfast rentals Soreze
You can identify and glimpse homes for rent Ballyheigue Ireland, rental home, and Ballyheigue vacation rental.
Find out, come upon, and originate Mullingar Ireland vacation rental, Mullingar Ireland short term rentals, and apartments for rent Mullingar.
This webpage can join and serve log classified advertisements, log ad directories, and studio classified ads romantic indexes, private ad directories, secluded advertisements, and waterfront listings to bail out your Ballyheigue stroll.
Hear and devise Tralee apartment rentals and for rent by owner homes.
Homes for rent in Allesino Italy, Allesino Italy rental homes, homes for rent by owner in Allesino Italy, and house rentals in Allesino Italy
Catch, contrive, and ascertain houses for rent in Longford Ireland, Longford Ireland holiday rentals, and rental properties in Longford Ireland.
Uncover, recognize, and ascertain Leixlip Ireland for rent by owner homes, Leixlip rent house, and house rentals.
Possessors, fortune-hunters, and buddies who are beating about vacation rentals in Ballyheigue Ireland and are trying to distinguish vacation rental in Ballyheigue Ireland, rental properties Ballyheigue, and for rent by owner homes can rummage our online website, FRBO.com and our waterfront online MLS and hillside listings.
Discover and look up houses for rent New Ross and New Ross vacation rental.
We fathered, formed, and started our site, FRBO.com to be pulchritudinous, marvelous, splendid, and magnificent.
Catch and find out rental houses in Killarney and rental houses in Killarney.
Catch and find Edgeworthstown apartments for rent and Edgeworthstown Ireland rental homes.
Grooms, possessors, and salesmen who are wishing to discern, find out, and come upon or simply ferret out information can use our for rent by owner site, FRBO.com.
Explore and discover New Ross Ireland rental home and homes for rent in New Ross Ireland.
Ramblers, honeymooners, and friends look and ferret our site, FRBO.com and discern loft flat and beachfront villa.
Explore, elicit, and ascertain Galway Ireland vacation rentals, Galway Ireland vacation rentals, and short term rentals Galway Ireland.
Apollonia Greece house rentals, apartment rentals Apollonia, vacation rentals Apollonia Greece, and condo rentals Apollonia
Look up and ferret out Tallaght vacation rentals and Tallaght Ireland for rent by owner homes.
See exotic advertisements, log indexes, lakefront indexes, and oceanfront online MLS that third party agents and agents post on our for rent by owner website.
Originate, contrive, and dig up Mullingar Ireland rent house, real estate rentals, and vacation rental Mullingar.
Locate and hear apartment rentals in Shannon and rent house Shannon.
Rental home St Didier France, apartment rentals St Didier, and for rent by owner homes St Didier France
Rental apartment in St Vincent de Gras France and vacation homes for rent by owner
|
|
