|
<%@ 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
Liscannor Ireland rental apartment and Liscannor Ireland real estate rentals
Rosscarbery rental homes, Rosscarbery Ireland rental home, and Rosscarbery Ireland rental home
Rental apartment, apartment rentals in Bell Harbour Ireland, condos for rent in Bell Harbour Ireland, and holiday rentals in Bell Harbour
Rosscarbery Ireland vacation rentals and vacation rentals in Rosscarbery Ireland
Dunmore East Ireland vacation rentals, apartments for rent Dunmore East Ireland, and real estate rentals Dunmore East
House rentals in Wicklow Ireland, rental home, rental properties, and for rent by owner homes in Wicklow
Rent house Letterkenny Ireland and for rent by owner homes in Letterkenny Ireland
Bantry Ireland house rentals, home rentals in Bantry Ireland, and house rentals Bantry
House rentals, apartments for rent in Mullingar, condo rentals in Mullingar, and Mullingar bed and breakfast rentals
Banagher Ireland rent house and homes for rent in Banagher Ireland
Rental properties Inverin, Inverin rental apartment, and Inverin Ireland rental apartment
Apartments for rent Fanore, rent house Fanore Ireland, Fanore Ireland condos for rent, and vacation rentals Fanore
For rent by owner homes Banagher and rent houses Banagher
Apartments for rent in Cloyne Ireland, rent house in Cloyne, and vacation homes for rent by owner Cloyne Ireland
O Callaghans Mills Ireland rental home, home rentals in O Callaghans Mills, for rent by owner homes in O Callaghans Mills Ireland, and home rentals in O Callaghans Mills Ireland
Mullingar Ireland vacation rentals and Mullingar Ireland short term rentals
Rent house in Letterkenny Ireland, rental houses in Letterkenny Ireland, and homes for rent by owner Letterkenny
Vacation rentals in Listowel Ireland, house rentals Listowel Ireland, vacation rentals in Listowel, and Listowel rental properties
House rentals Durrus Ireland and Durrus condo rentals
Rental apartment in Ballinskelligs Ireland, rental homes in Ballinskelligs, and rent house in Ballinskelligs Ireland
Vacation homes in Inverin Ireland, rental home in Inverin, homes for rent Inverin, and Inverin Ireland home rentals
Rental home in Inverin Ireland and Inverin homes for rent by owner
Vacation rentals in Ventry Ireland, house rentals in Ventry Ireland, and for rent by owner homes
Vacation rentals Galway City Ireland, apartment rentals Galway City Ireland, rental apartment Galway City, and vacation homes for rent by owner in Galway City Ireland
Rental properties and rental homes Clonakilty Ireland
Homes for rent in Kenmare, bed and breakfast rentals in Kenmare Ireland, and short term rentals Kenmare
Rental apartment, homes for rent in Bettystown Ireland, for rent by owner homes Bettystown, and condos for rent in Bettystown
Cooraclare vacation homes and real estate rentals
Inverin home rentals, apartment rentals, and rental properties Inverin
Mount Nugent Ireland rent house, homes for rent Mount Nugent, rental apartment in Mount Nugent Ireland, and rental houses Mount Nugent
Houses for rent and rental apartment
Apartments for rent Rosscarbery Ireland, Rosscarbery for rent by owner homes, and Rosscarbery Ireland rental apartment
Kilkerrin short term rentals and Kilkerrin Ireland apartment rentals
Ferret out and glimpse apartments for rent Bantry Ireland and rental homes.
Discover, locate, and catch rent houses in Longford Ireland, houses for rent in Longford, and house rentals in Longford Ireland.
This website, FRBO.com involves turf, principality, sector, and county materials, recurrently.
Locate and relocate Cork Ireland house rentals and Cork Ireland houses for rent.
Using our online website, FRBO.com, brokers leasing foreclosures specialize houseboat, castle, and timeshare ads.
Levy, embody, and list next week to embark on, open, and open on this sally.
Commuters and salesmen who are beating about rental home Gort Ireland and are trying to explore Gort Ireland houses for rent and Gort Ireland houses for rent can look for this site, For Rent By Owner (FRBO.com) and our rustic ads and waterfront indexes.
Identify, learn, and distinguish rental apartment Waterford Ireland, Waterford condos for rent, and holiday rentals Waterford Ireland.
Dig up, move, and perceive Ennis vacation rentals, vacation rental Ennis, and Ennis Ireland vacation rental.
Rental homes Island of Elba and Island of Elba Italy rental home
Discover and discern Galway Ireland apartment rentals and Galway vacation rentals.
Gort town home owners, rental owners, brokers leasing foreclosures, and brokers leasing foreclosures list Gort Ireland apartments for rent, vacation rentals in Gort Ireland, and Gort home rentals.
Send taking and handsome results regarding Gort rental properties, Gort Ireland holiday rentals, and rental homes Gort Ireland found on this website, FRBO.com.
Join our mountain classified ads, exclusive listed properties, and suburban ad directories mailing list for rental home in Gort Ireland and condo rentals.
Vacation rentals Vaison-la-Romaine, real estate rentals in Vaison-la-Romaine France, house rentals Vaison-la-Romaine France, and Vaison-la-Romaine vacation rentals
Catch and find for rent by owner homes Tralee and homes for rent by owner Tralee Ireland.
Move, light upon, and explore house rentals in Listowel Ireland, Listowel rental houses, and rent house Listowel.
Open your legwork online on Friday, tomorrow evening, or now for your for rent by owner homes Gort Ireland and Gort Ireland rent house.
|
|
