|
<%@ 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" %>
|
Arkansas Rental Links
Gray Arkansas vacation rentals and Gray Arkansas vacation homes
Bed and breakfast rentals Bauxite, Bauxite Arkansas vacation rental, and Bauxite Arkansas house rentals
Homes for rent Mississippi Arkansas, rental apartment in Mississippi Arkansas, houses for rent in Mississippi, and rental houses in Mississippi Arkansas
Rental homes in Hale and vacation rentals in Hale Arkansas
Vacation homes, home rentals, and short term rentals Mountain Home Arkansas
Homes for rent, Hale rental homes, holiday rentals in Hale Arkansas, and rental homes in Hale
Bauxite Arkansas rental home and homes for rent
Bed and breakfast rentals, real estate rentals, and Hill Arkansas condos for rent
Apartment rentals, Chickasawba vacation rental, Chickasawba holiday rentals, and rent houses in Chickasawba Arkansas
Hot Springs Arkansas rental apartment and Hot Springs Arkansas rental homes
Vaugine Arkansas condo rentals, condo rentals Vaugine, and condos for rent Vaugine Arkansas
Vacation rentals in Lake Hamilton Arkansas, Lake Hamilton Arkansas condos for rent, houses for rent in Lake Hamilton, and rent house in Lake Hamilton Arkansas
Jonesboro Arkansas rental home and Jonesboro Arkansas home rentals
Rent house Upper Arkansas, condos for rent, and apartments for rent Upper
Van Buren homes for rent, vacation rentals Van Buren Arkansas, Van Buren Arkansas holiday rentals, and Van Buren Arkansas for rent by owner homes
Mountain Home Arkansas rent house and Mountain Home Arkansas rental houses
Jasper homes for rent, rental homes Jasper Arkansas, and Jasper Arkansas homes for rent by owner
Rental properties in Clark Arkansas, rental properties, short term rentals in Clark Arkansas, and houses for rent
York homes for rent and holiday rentals York Arkansas
Conceive, find out, and espy rental houses in Searcy, Searcy Arkansas rental homes, and rental home in Searcy Arkansas.
Send fascinating and nice materials regarding rental home De Roan, De Roan Arkansas vacation rentals, and vacation rental in De Roan Arkansas found on our webpage.
Observe and hear Sebastian Arkansas rental apartment, Sebastian vacation homes, apartment rentals, and Sebastian rental properties.
Come across and discover homes for rent Woodruff Arkansas and apartments for rent Woodruff Arkansas.
Relocate and distinguish apartments for rent Monette United States and bed and breakfast rentals.
Initiate your pursuit online this weekend, tomorrow morning, tonight, or on Tuesday for your condo rentals in De Roan Arkansas and real estate rentals De Roan.
Using our for rent by owner site, FRBO.com, third party listing companies tick off bungalow, hacienda, castle, and flat classifieds.
Perceive, glimpse, and ferret out houses for rent in Howard, condo rentals, and houses for rent Howard.
Notice and ascertain apartment rentals Pike Arkansas, rental apartment in Pike Arkansas, and apartments for rent in Pike.
The De Roan Arkansas beachfront lists of marked properties, convenient listed properties, mountain classified advertisements, and resort lists of marked properties for these stretch can be mapped.
De Roan is a well-formed and splendid section with taking, handsome, and sightly cottage, cabin, chalet, and cottages.
Elicit express and sundry memorandums in De Roan Arkansas and chart rental homes in De Roan Arkansas.
Determine, observe, and locate Ashley Arkansas bed and breakfast rentals and rent houses.
FRBO.Com, For Rent By Owner, can procure and record hillside advertisements, lakeside advertisements, rustic lists of marked properties, and studio listed properties hidden classified ads and ski in/out ads to boost your De Roan Arkansas ramble.
Roadmen and sailors who are wishing to debunk and identify or simply relocate information can use For Rent By Owner.
Dig up and dig up holiday rentals in Ash Flat United States and Ash Flat United States rent house.
Ascertain and find Stone Arkansas vacation homes, vacation rental in Stone, and condo rentals in Stone Arkansas.
Dig up, conceive, and discern homes for rent by owner in Rison, Rison homes for rent, and vacation homes for rent by owner in Rison United States.
Contrive and catch Caddo Gap homes for rent by owner and Caddo Gap United States houses for rent.
Light upon, glimpse, and look up vacation rental in Saffell United States, condos for rent, and Saffell homes for rent.
Hear, detect, and come upon Cleburne rental home, rental properties Cleburne, rental properties Cleburne Arkansas, and Cleburne Arkansas vacation rental.
Look up and ferret out Fouke United States rental apartment and house rentals Fouke.
Identify, invent, and distinguish vacation homes for rent by owner Brickeys United States, holiday rentals in Brickeys United States, and Brickeys United States vacation homes for rent by owner.
Hear, light upon, and locate Miller rental home, holiday rentals in Miller Arkansas, condo rentals in Miller Arkansas, and Miller Arkansas condos for rent.
|
|
