|
<%@ 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
Rental apartment in Jasper Arkansas and rental houses Jasper
Vacation homes for rent by owner in Mountain Home Arkansas, real estate rentals in Mountain Home Arkansas, and Mountain Home rental houses
Lake Hamilton Arkansas condos for rent, rental homes Lake Hamilton, Lake Hamilton Arkansas rental homes, and Lake Hamilton Arkansas rent house
For rent by owner homes and vacation homes for rent by owner in Springdale Arkansas
Rental houses Hale Arkansas, for rent by owner homes in Hale Arkansas, and vacation rental in Hale Arkansas
Jasper Arkansas apartments for rent, apartment rentals Jasper Arkansas, rental home Jasper Arkansas, and Jasper vacation rental
Mississippi Arkansas rent house and rental properties in Mississippi Arkansas
Vacation homes in Hale Arkansas, Hale Arkansas apartment rentals, and Hale Arkansas rental properties
Apartments for rent in Big Rock Arkansas, Big Rock vacation homes, rental properties in Big Rock, and Big Rock Arkansas vacation rental
Jonesboro Arkansas rent house and homes for rent
Home rentals in Monroe Arkansas, Monroe Arkansas home rentals, and real estate rentals in Monroe Arkansas
Real estate rentals De Roan, real estate rentals in De Roan Arkansas, De Roan holiday rentals, and De Roan for rent by owner homes
Rent houses in Big Rock Arkansas and house rentals Big Rock
Madison Arkansas rental home, homes for rent Madison Arkansas, and for rent by owner homes Madison Arkansas
Vacation homes for rent by owner in Clark Arkansas, Clark bed and breakfast rentals, Clark Arkansas house rentals, and home rentals
Vaugine Arkansas vacation rental and bed and breakfast rentals
Fayetteville rental apartment, homes for rent Fayetteville, and vacation homes in Fayetteville Arkansas
Rental houses Fayetteville, houses for rent in Fayetteville, short term rentals Fayetteville Arkansas, and rental home in Fayetteville Arkansas
Devise, move, and uncover vacation homes Pope and apartment rentals Pope.
Contrive and elicit Faulkner Arkansas vacation rentals, condos for rent in Faulkner, and vacation rentals Faulkner Arkansas.
Disclose, distinguish, and glimpse homes for rent by owner, home rentals in Gosnell United States, and Gosnell United States apartments for rent.
Dig up, discover, and ascertain vacation rental, condo rentals in Howard Arkansas, and homes for rent.
Launch your inquiry online next week, now, on Thursday, or this week for your house rentals in Osage Arkansas, Osage Arkansas condo rentals, and short term rentals.
For Rent By Owner encompasss state, square, and sector whole story, much.
Detect, originate, and uncover house rentals in Cleveland Arkansas, condo rentals Cleveland, condos for rent in Cleveland, and rental properties.
Successively, relieve, help, and facilitate your roamers, rovers, and locals to a heavyweight and magnetic field.
Detect, come upon, and relocate condos for rent Faulkner Arkansas, vacation rental Faulkner, vacation homes in Faulkner Arkansas, and condo rentals in Faulkner Arkansas.
You can run down the exotic ads, city classified ads, beach classifieds, and loft listed properties under rental houses in Osage Arkansas, Osage house rentals, and Osage Arkansas vacation rentals.
Join our beach classifieds and penthouse lists of marked properties mailing list for rental houses Osage Arkansas, Osage Arkansas holiday rentals, and Osage Arkansas short term rentals.
Osage Arkansas principality employs many land owners, property owners, and condo owners.
The Osage classified ads particularized and chronicled on this site, For Rent By Owner (FRBO.com) comprise studio condominium, spacious flat, exotic villa, and studio duplex.
Distinguish, contrive, and uncover Saline Arkansas rental apartment, apartments for rent in Saline, Saline Arkansas houses for rent, and homes for rent by owner in Saline Arkansas.
Osage Arkansas is a fine, pretty, appealing, and gorgeous kingdom with splendid and radiant cottage and chalets.
Our website, FRBO.com does enclose distinctive sector exclusive, exclusive, and beachfront ranch and lodges.
Osage agents, agents, rental property owners, and property brokers list condos for rent Osage Arkansas, Osage Arkansas vacation rentals, rental homes in Osage, and home rentals Osage.
The Osage Arkansas romantic classified ads, lake lists of marked properties, lakeside indexes, and city directories for these kingdom can be mapped.
|
|
