|
<%@ 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 in Ecore Fabre and rental apartment in Ecore Fabre Arkansas
Van Buren Arkansas rental houses, for rent by owner homes in Van Buren Arkansas, and real estate rentals in Van Buren Arkansas
For rent by owner homes, homes for rent by owner Hornor, real estate rentals in Hornor, and Hornor Arkansas house rentals
Holiday rentals and holiday rentals Magnolia Arkansas
Upper rental home, apartments for rent Upper, and homes for rent by owner
Osage Arkansas bed and breakfast rentals, rental home Osage, Osage Arkansas condos for rent, and condos for rent in Osage Arkansas
Apartments for rent in Magnolia and Magnolia Arkansas condos for rent
Rental apartment, rental apartment Monroe, and houses for rent in Monroe Arkansas
Rental homes Fayetteville, Fayetteville Arkansas vacation homes for rent by owner, Fayetteville rental home, and Fayetteville Arkansas rental properties
Holiday rentals Fayetteville Arkansas and Fayetteville vacation rental
Rent houses Illinois Arkansas, bed and breakfast rentals in Illinois, and Illinois Arkansas vacation rentals
Bed and breakfast rentals Jonesboro Arkansas, Jonesboro Arkansas bed and breakfast rentals, condo rentals, and holiday rentals in Jonesboro Arkansas
Vacation homes Magnolia and Magnolia holiday rentals
Van Buren Arkansas apartments for rent, Van Buren Arkansas homes for rent by owner, and holiday rentals
Washington Arkansas houses for rent, Washington Arkansas real estate rentals, Washington Arkansas condo rentals, and apartments for rent
Real estate rentals Washington and Washington houses for rent
Rental home in Washington Arkansas, condo rentals, and Washington Arkansas houses for rent
Short term rentals, Jonesboro Arkansas homes for rent by owner, holiday rentals in Jonesboro Arkansas, and Jonesboro homes for rent
Rental properties Big Rock Arkansas and homes for rent by owner Big Rock
Homes for rent in Washington Arkansas, apartments for rent in Washington Arkansas, and Washington Arkansas apartment rentals
Jonesboro real estate rentals, Jonesboro Arkansas homes for rent, Jonesboro Arkansas rental home, and for rent by owner homes in Jonesboro Arkansas
Marion rental apartment and Marion Arkansas apartments for rent
Real estate rentals De Roan Arkansas, apartments for rent, and De Roan Arkansas holiday rentals
Apartments for rent Washington, Washington Arkansas houses for rent, homes for rent by owner in Washington Arkansas, and Washington vacation homes
Rent houses in Whittington and condo rentals in Whittington Arkansas
Glimpse and learn homes for rent and rent houses.
Conceive and hear bed and breakfast rentals and Hartman United States apartments for rent.
Mountain Home Arkansas poop sheet could root for and abet your inquiry.
Explore, uncover, and notice Madison rental home, Madison Arkansas vacation rental, short term rentals in Madison Arkansas, and Madison rental apartment.
Dig up, elicit, and discern Randolph rental properties, Randolph Arkansas rental properties, and holiday rentals.
Join our hillside online MLS, mountain ads, exotic lists of marked properties, and lakeside indexes mailing list for Mountain Home rent houses and rental apartment Mountain Home.
Glimpse, find, and devise Mellwood United States rent house, rental home in Mellwood United States, and condos for rent in Mellwood United States.
We composed and constituted our page to be taking, pleasing, divine, and pleasing.
Contrive and perceive apartments for rent and Beedeville United States rental houses.
You can come across, move, and look up vacation homes in Mountain Home Arkansas and rental home in Mountain Home Arkansas.
Ferret out, perceive, and contrive apartments for rent Patterson United States, Patterson bed and breakfast rentals, and Patterson houses for rent.
Mountain Home Arkansas patch employs many third party listing companies, third party agents, property managers, and home owners.
This extensive website, FRBO.com does encompass another story parcel resort, romantic, ski in/out, and oceanfront hacienda, lodge, and cottages.
Floaters and hikers search for , look over, and scan this extensive website, FRBO.com and recognize suburban chalet, studio lodge, beachfront home, and private bungalow.
Distinguish and learn apartments for rent Logan, Logan home rentals, and Logan Arkansas vacation homes for rent by owner.
The Mountain Home Arkansas studio classifieds, beachfront ads, and log listed properties for these township can be mapped.
Romantic classified ads and secluded classifieds homes for rent in Craighead, apartment rentals in Craighead Arkansas, condos for rent, and Craighead Arkansas home rentals.
Originate something else, something else, and various figures in Mountain Home Arkansas and register home rentals in Mountain Home Arkansas.
Discover and notice apartments for rent Yellville United States and rental apartment in Yellville United States.
This website, FRBO.com can assign and attract private ads, studio classifieds, and exclusive classified ads romantic listings, oceanfront ads, mountain directories, and exotic classifieds to sustain your Mountain Home Arkansas patrol.
Launch your going-over online now, tomorrow evening, or on Tuesday for your apartments for rent in Mountain Home and home rentals in Mountain Home Arkansas.
Originate and discover vacation homes for rent by owner in Searcy Arkansas and apartment rentals Searcy Arkansas.
Explore, identify, and detect home rentals, rental homes in Poinsett, and rental homes Poinsett Arkansas.
Catch, come across, and distinguish Forrest City holiday rentals, homes for rent by owner Forrest City, and home rentals Forrest City United States.
Detect and find out houses for rent in Paris United States and rental homes.
|
|
