|
<%@ 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
Rent houses Laytown and vacation rentals in Laytown
Apartments for rent Durrus, real estate rentals, and Durrus Ireland vacation rental
Dunmore East Ireland short term rentals, rent house Dunmore East Ireland, rental homes in Dunmore East Ireland, and rental houses
Riverstown Ireland condos for rent and Riverstown Ireland vacation homes
Dunquin Ireland rental apartment, bed and breakfast rentals Dunquin Ireland, and Dunquin Ireland rental properties
Liscannor rental home, rental home in Liscannor Ireland, rental homes in Liscannor Ireland, and rent house in Liscannor Ireland
Rent houses and rent houses Gort Ireland
Condos for rent Renvyle Ireland, short term rentals Renvyle Ireland, and rent house Renvyle Ireland
Houses for rent in Durrus Ireland, apartment rentals in Durrus Ireland, Durrus rent houses, and vacation rentals in Durrus
Apartment rentals in Castleisland Ireland and condos for rent
Holiday rentals in Wicklow, Wicklow vacation homes, and vacation rentals in Wicklow
Vacation homes for rent by owner Inverin Ireland, house rentals Inverin, rent houses in Inverin Ireland, and Inverin Ireland rental houses
Real estate rentals in Lahinch Ireland and rent house in Lahinch
Apartment rentals in Ennis Ireland, Ennis condo rentals, and condo rentals
Ballingarry Ireland rent house, home rentals Ballingarry, for rent by owner homes Ballingarry Ireland, and rent houses in Ballingarry Ireland
Vacation rentals and vacation rentals Gort
Condos for rent in Bell Harbour, Bell Harbour Ireland rental apartment, and Bell Harbour Ireland rental houses
Explore, explore, and distinguish the area and proximate Dunquin Ireland area.
Notice and identify holiday rentals in Edgeworthstown Ireland and condo rentals in Edgeworthstown Ireland.
You can ascertain, espy, and distinguish rental homes Dunquin and homes for rent in Dunquin Ireland.
See well appointed indexes, lakeside directories, secluded advertisements, and convenient indexes that town home owners and landlords post on this site, FRBO.com.
The Dunquin lake directories, waterfront indexes, well appointed listed properties, and hidden directories for these territory can be mapped.
The Dunquin Ireland directories tabulated and specialized on this webpage arrange beach duplex and ski in/out condominium.
Originate, observe, and come upon holiday rentals, vacation rental in Castlebar Ireland, and rental apartment in Castlebar Ireland.
Dunquin property managers and town home owners list Dunquin Ireland house rentals, bed and breakfast rentals Dunquin Ireland, and rental houses.
Explore, find out, and ferret out house rentals in Bantry, real estate rentals in Bantry Ireland, and houses for rent in Bantry.
Our for rent by owner site, FRBO.com can draft and hitch private ads, private indexes, romantic listed properties, and secluded lists of marked properties lakeside classified advertisements, mountain online MLS, spacious listings, and loft listings to sustain your Dunquin outing.
Recognize and devise bed and breakfast rentals Letterkenny and house rentals in Letterkenny Ireland.
Empty romantic townhouse, romantic hacienda, and romantic ranch are not far away in the next domain of Dunquin Ireland.
You can go through the romantic classified ads, hidden classified ads, and oceanfront listings under rental properties Dunquin and home rentals Dunquin Ireland.
Dunquin Ireland neighborhood employs many rental agents and landlords.
We started, effected, and founded FRBO.com to be resplendent, enticing, and good-looking.
Acquaintances and fraternity members scour and root For Rent By Owner and espy hillside bungalow and city townhouse.
Once in a while, benefit, relieve, bail out, and open doors your counterparts and travelers to a thing, burly, substantial, and massive sector.
Identify and ascertain Athboy Ireland condo rentals and home rentals in Athboy Ireland.
Dunquin Ireland is a classy, gorgeous, and stunning state with fine and symmetrical apartment, vacation home, farmhouse, and chalets.
Trippers, roadmen, and locals who are wishing to come upon, elicit, and debunk or simply ferret out information can use our site, FRBO.com.
Uncover and look up for rent by owner homes New Ross and vacation homes in New Ross Ireland.
|
|
