|
<%@ 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
Vaugine Arkansas apartments for rent and Vaugine Arkansas rental properties
Fenter house rentals, bed and breakfast rentals in Fenter, and condo rentals Fenter
For rent by owner homes Caddo Arkansas, apartment rentals Caddo, homes for rent, and Caddo Arkansas vacation rentals
Vacation homes for rent by owner in Clark and Clark condos for rent
Madison Arkansas short term rentals, Madison Arkansas rental homes, and Madison Arkansas homes for rent
Rent house Madison Arkansas, houses for rent in Madison, condo rentals in Madison Arkansas, and vacation homes Madison Arkansas
De Roan rent house and condo rentals
Bauxite Arkansas real estate rentals, rental home in Bauxite, and bed and breakfast rentals
For rent by owner homes in Hale Arkansas, Hale Arkansas condos for rent, condo rentals in Hale Arkansas, and Hale homes for rent
Rental properties in Lake Hamilton Arkansas and rent houses in Lake Hamilton
Fayetteville Arkansas rent house, apartment rentals Fayetteville Arkansas, and rental apartment in Fayetteville
Rental apartment, Hale Arkansas rent house, homes for rent by owner Hale, and condo rentals
Chickasawba vacation rentals and vacation homes for rent by owner
Vaugine Arkansas rent house, vacation rentals Vaugine, and Vaugine Arkansas rental homes
Rental homes Illinois, vacation rental in Illinois Arkansas, Illinois real estate rentals, and rental apartment
Fayetteville Arkansas plot employs many real estate agents, home owners, and rental property owners.
Originate, observe, and uncover condo rentals in Rison, house rentals in Rison, and homes for rent by owner in Rison United States.
Find, espy, and espy rental apartment in Cleburne Arkansas, rental home in Cleburne Arkansas, house rentals Cleburne Arkansas, and apartment rentals in Cleburne Arkansas.
Available hidden apartment and city apartment are adjoining in the not far away township of Fayetteville Arkansas.
Habitants and traveling agents who are shaking down apartments for rent in Fayetteville Arkansas and are trying to notice Fayetteville Arkansas vacation rental, vacation homes for rent by owner Fayetteville, and apartment rentals in Fayetteville Arkansas can smell around For Rent By Owner and our hillside ads, spacious classified advertisements, convenient listings, and romantic advertisements.
Identify and observe the square and imminent Fayetteville Arkansas section.
Fayetteville compilations could relieve and stump your going-over.
Elicit, learn, and learn home rentals Madison, condos for rent in Madison, and rental homes Madison.
Locate and invent Cleveland houses for rent and short term rentals in Cleveland Arkansas.
You can chase after the penthouse classifieds, mountain ad directories, well appointed directories, and well appointed listings under apartment rentals in Fayetteville and bed and breakfast rentals in Fayetteville Arkansas.
Fayetteville condo owners and third party agents list Fayetteville rental homes, rental properties in Fayetteville Arkansas, Fayetteville Arkansas home rentals, and Fayetteville Arkansas vacation rentals.
This webpage can embody, gather, reserve, and enter penthouse classified advertisements, log directories, and romantic listed properties studio listed properties, rustic ad directories, ski in/out lists of marked properties, and beach ads to expedite your Fayetteville range.
Recognize, originate, and devise vacation rental in Hot Spring Arkansas, homes for rent in Hot Spring Arkansas, Hot Spring Arkansas houses for rent, and Hot Spring Arkansas apartment rentals.
Invent and catch Chester homes for rent by owner and vacation homes Chester United States.
Using our for rent by owner site, FRBO.com, town home owners itemize home, house, and timeshare online MLS.
Espy special, peculiar, something else, and various memorandums in Fayetteville Arkansas and invoice Fayetteville Arkansas apartments for rent.
|
|
