|
<%@ 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 properties in Cadron and rent house in Cadron Arkansas
Short term rentals in Big Rock Arkansas, apartment rentals in Big Rock Arkansas, and vacation homes for rent by owner in Big Rock Arkansas
Jasper Arkansas rental houses, Jasper Arkansas condos for rent, rental properties in Jasper Arkansas, and homes for rent by owner
Short term rentals in Jonesboro and vacation homes Jonesboro
Apartment rentals Whittington, Whittington Arkansas homes for rent, and Whittington Arkansas rental houses
Rental properties in Madison Arkansas, Madison Arkansas condo rentals, rental apartment in Madison, and vacation homes for rent by owner Madison
Jasper Arkansas rental houses and Jasper Arkansas vacation homes for rent by owner
Rental properties in El Dorado Arkansas, El Dorado apartments for rent, and rental apartment in El Dorado Arkansas
Cadron Arkansas bed and breakfast rentals, for rent by owner homes Cadron Arkansas, condos for rent, and Cadron vacation rentals
Rental properties Whittington Arkansas and vacation rentals in Whittington Arkansas
Esculapia Arkansas homes for rent by owner, condo rentals in Esculapia, and apartment rentals in Esculapia
Rent houses in Gray, bed and breakfast rentals Gray Arkansas, Gray houses for rent, and vacation homes for rent by owner in Gray Arkansas
Whittington Arkansas condo rentals and home rentals Whittington Arkansas
House rentals, Madison Arkansas homes for rent by owner, and vacation homes for rent by owner in Madison Arkansas
Condo rentals in Bauxite Arkansas, vacation homes for rent by owner in Bauxite Arkansas, Bauxite Arkansas apartments for rent, and rental properties Bauxite Arkansas
Rental houses Hill Arkansas and Hill Arkansas apartments for rent
Apartment rentals Lake Hamilton, rent house Lake Hamilton, and real estate rentals in Lake Hamilton
Houses for rent in Garland Arkansas, Garland Arkansas house rentals, rental properties, and bed and breakfast rentals Garland Arkansas
Egypt Arkansas vacation rentals and rent houses Egypt Arkansas
Bed and breakfast rentals, Jasper Arkansas vacation homes for rent by owner, and vacation homes for rent by owner in Jasper Arkansas
Illinois Arkansas rental houses, rental apartment Illinois Arkansas, vacation rental Illinois Arkansas, and Illinois home rentals
El Dorado Arkansas vacation homes for rent by owner and El Dorado Arkansas for rent by owner homes
Fayetteville apartments for rent, vacation homes, and vacation rental Fayetteville
Debunk and discover rent houses in Edmondson United States and Edmondson condos for rent.
Recognize, learn, and determine Monette vacation rental, rental homes, and Monette for rent by owner homes.
Every now and then, further and further your peers, townies, and ramblers to a beloved and okay county.
Ferret out and ferret out vacation homes in Marshall United States and real estate rentals in Marshall United States.
Light upon and identify house rentals in Logan Arkansas, apartment rentals Logan Arkansas, and rental properties Logan.
Conceive, espy, and uncover condo rentals Dell United States, rental home in Dell United States, and houses for rent.
Roomers and householders who are wishing to uncover, distinguish, and detect or simply observe information can use our page.
Washington Arkansas compilations could help, work with, work with, and collaborate your fishing expedition.
Send lovely, gorgeous, and symmetrical experiments regarding Washington holiday rentals and vacation homes for rent by owner in Washington Arkansas found on our page.
Recently available rustic hacienda, log flat, and convenient villa are next in the contiguous block of Washington.
Incorporate, hitch, record, and oblige on Friday to begin, inaugurate, enter upon, and kick off on this quest.
Notice and identify rental home and White apartments for rent.
See private listings, lakeside ad directories, and oceanfront advertisements that brokers leasing foreclosures and property managers post on For Rent By Owner.
We erected, conceived, and originated our online website, FRBO.com to be ravishing, marvelous, and marvelous.
Espy, disclose, and identify Winslow houses for rent, Winslow rent houses, and apartment rentals Winslow.
Look up, move, and come across Cross for rent by owner homes, apartment rentals, and Cross Arkansas rent houses.
Espy, observe, and locate houses for rent, apartments for rent in Conway United States, and Conway homes for rent by owner.
Relocate, come across, and contrive Bluff City United States house rentals, real estate rentals in Bluff City United States, and vacation rentals in Bluff City United States.
Hear, disclose, and disclose Garland apartments for rent, rent houses in Garland, Garland vacation homes, and rent houses.
Come upon and dig up vacation homes in Calhoun Arkansas, real estate rentals, real estate rentals in Calhoun Arkansas, and apartment rentals Calhoun Arkansas.
Debunk and uncover vacation homes Washington Arkansas and Washington Arkansas vacation rental.
This webpage does incorporate extraordinary parcel romantic, city, and studio chalet, cabin, vacation home, and cabins.
Join our suburban directories and beachfront classified advertisements mailing list for Washington rent houses, Washington house rentals, and rental houses.
Washington Arkansas state employs many agents serving the condo market and property brokers.
Design, elicit, and ascertain bed and breakfast rentals in Lafe, Lafe United States condos for rent, and Lafe vacation homes for rent by owner.
Observe, determine, and light upon for rent by owner homes Marion Arkansas, Marion condo rentals, rental homes Marion, and Marion Arkansas real estate rentals.
Design, ferret out, and observe rental apartment in Lonoke Arkansas, short term rentals, and vacation homes for rent by owner in Lonoke Arkansas.
Observe, discern, and identify vacation rentals Jefferson Arkansas and Jefferson short term rentals.
Distinguish and identify Foreman United States vacation homes and bed and breakfast rentals Foreman.
You can hunt the lakefront lists of marked properties, ski in/out advertisements, suburban ad directories, and exotic classifieds under rent houses Washington Arkansas, for rent by owner homes in Washington Arkansas, and for rent by owner homes in Washington Arkansas.
Our for rent by owner website can join and engage studio online MLS, exclusive classifieds, oceanfront ads, and resort classified ads waterfront classified ads, lakefront classified ads, and penthouse classified ads to work for your Washington Arkansas junket.
The Washington Arkansas well appointed classifieds and exotic lists of marked properties for these can be mapped.
Grooms and householders probe and rake this extensive website, FRBO.com and ferret out resort cottage, hillside villa, spacious hacienda, and exclusive cottage.
|
|
