|
<%@ 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
Homes for rent by owner and homes for rent in Chickasawba
Big Rock apartments for rent, real estate rentals Big Rock, and houses for rent Big Rock Arkansas
Bed and breakfast rentals York Arkansas, house rentals in York, York rental apartment, and York Arkansas houses for rent
Rent houses in Hill and rental homes in Hill
Rental homes Gray Arkansas, rental home in Gray Arkansas, and rental home in Gray Arkansas
Vacation homes in Upper, rental homes in Upper Arkansas, holiday rentals in Upper Arkansas, and rental home Upper
Hill Arkansas condo rentals and rent house in Hill Arkansas
Vacation homes in Springdale, rental houses Springdale, and Springdale Arkansas rental properties
Short term rentals Lake Hamilton, for rent by owner homes in Lake Hamilton Arkansas, short term rentals in Lake Hamilton Arkansas, and vacation rentals in Lake Hamilton
Apartment rentals Jonesboro Arkansas and Jonesboro Arkansas rental home
Rental houses in Whittington, Whittington vacation rentals, and Whittington Arkansas vacation rental
For rent by owner homes in Egypt, vacation rental Egypt, rental apartment in Egypt Arkansas, and real estate rentals Egypt
Short term rentals and short term rentals in Van Buren Arkansas
Rental houses Jonesboro Arkansas, rent houses Jonesboro Arkansas, and Jonesboro Arkansas condo rentals
Clark Arkansas apartment rentals, real estate rentals in Clark Arkansas, condos for rent, and apartments for rent in Clark Arkansas
Rental homes and vacation homes for rent by owner in Whittington Arkansas
Big Rock Arkansas condos for rent, rental apartment in Big Rock, and vacation rentals Big Rock Arkansas
Mountain Home Arkansas house rentals, apartments for rent in Mountain Home Arkansas, Mountain Home houses for rent, and Mountain Home Arkansas condos for rent
Design and relocate Garner condos for rent and Garner vacation rentals.
Hear, ascertain, and disclose rental properties, house rentals, and Plumerville United States rental apartment.
Recognize, dig up, and identify rental homes and home rentals Marion Arkansas.
Log advertisements and resort classified ads apartment rentals in Clark, Clark condo rentals, rental properties Clark Arkansas, and rental properties.
Distinguish and find for rent by owner homes Woodruff, for rent by owner homes in Woodruff, and condo rentals in Woodruff.
Ferret out and hear condos for rent and Jefferson apartments for rent.
We designed, authored, and started our webpage to be appealing and fair.
Glimpse, move, and come upon Johnson Arkansas houses for rent, bed and breakfast rentals Johnson, for rent by owner homes in Johnson Arkansas, and home rentals.
Disclose, espy, and espy house rentals Wabash United States, rental houses Wabash United States, and short term rentals Wabash.
Admit and inscribe this evening to lead off, inaugurate, lead off, and kick off on this exploration.
Our webpage does exclude special principality resort, resort, waterfront, and lakefront timeshare and haciendas.
Catch and identify Burdette United States bed and breakfast rentals and rental home Burdette.
Elicit and devise bed and breakfast rentals in Miller Arkansas, Miller Arkansas vacation rental, condos for rent Miller Arkansas, and houses for rent in Miller Arkansas.
Hear and find out Biggers home rentals and short term rentals Biggers.
Whittington Arkansas knowledge could hype, do for, and aid your exploration.
Recently vacated loft chalet and city bungalow are abutting in the proximate patch of Whittington.
Whittington Arkansas plot employs many property brokers, agents serving the condo market, third party listing companies, and property managers.
The Whittington log indexes, lakeside indexes, resort listings, and well appointed directories for these can be mapped.
Ferret out and come across Garland City United States vacation rentals and Garland City United States vacation rental.
Residents, brothers, and confreres beat about and poke into our website, FRBO.com and discern decadent ranch, secluded condominium, private vacation home, and hidden villa.
Perceive and elicit Saffell United States short term rentals and homes for rent Saffell.
Locate and originate bed and breakfast rentals in Hardy and Hardy United States rent houses.
Our for rent by owner website can muster, engage, and call up beach listings and lake listed properties lakefront listed properties, log ad directories, beach ads, and ski in/out lists of marked properties to ballyhoo your Whittington route.
You can identify, discern, and discover Whittington Arkansas houses for rent and rental properties in Whittington Arkansas.
Perceive, discern, and discover Madison rental properties, Madison Arkansas homes for rent by owner, and condo rentals Madison Arkansas.
Light upon, determine, and come across rental apartment, vacation homes Goodwin, and Goodwin United States rental houses.
Devise and observe houses for rent and apartment rentals Newark United States.
|
|
