|
<%@ 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 Hico and Hico Arkansas apartments for rent
Rental home Springdale Arkansas, Springdale house rentals, and Springdale rental houses
Homes for rent Washington Arkansas, real estate rentals Washington Arkansas, condos for rent in Washington, and Washington vacation rental
Houses for rent Jonesboro and short term rentals in Jonesboro
Springdale Arkansas house rentals, home rentals Springdale Arkansas, and house rentals in Springdale Arkansas
Homes for rent in Garland Arkansas, rental apartment, condos for rent Garland Arkansas, and Garland rent house
Hico Arkansas vacation homes for rent by owner and Hico Arkansas rental home
Hico Arkansas rental home, vacation rentals, and condo rentals in Hico Arkansas
Rental home in York Arkansas, York rental apartment, apartments for rent York Arkansas, and rental home in York Arkansas
For rent by owner homes in Hornor and holiday rentals Hornor
Jonesboro Arkansas rental houses, Jonesboro rental properties, and homes for rent by owner in Jonesboro
Vaugine Arkansas rent house, condos for rent Vaugine Arkansas, Vaugine vacation rentals, and Vaugine condos for rent
Condo rentals in Hico and condo rentals Hico
Houses for rent Hico Arkansas, Hico real estate rentals, and Hico Arkansas short term rentals
Home rentals, rental properties in Magnolia, condo rentals Magnolia, and Magnolia Arkansas apartment rentals
Apartment rentals Egypt Arkansas and rent houses Egypt
Rental houses Gray Arkansas, house rentals in Gray, and Gray Arkansas rent house
Houses for rent, Van Buren Arkansas holiday rentals, house rentals in Van Buren Arkansas, and rental homes in Van Buren Arkansas
Houses for rent in Garland and vacation rental in Garland Arkansas
Springdale condo rentals, Springdale homes for rent, and real estate rentals in Springdale Arkansas
Fenter Arkansas home rentals, rental homes Fenter Arkansas, Fenter Arkansas vacation homes, and vacation homes in Fenter
Vacation homes for rent by owner and Madison Arkansas rental homes
Rental houses, houses for rent Marion, and vacation rental Marion
Apartments for rent Fenter Arkansas, apartment rentals in Fenter, bed and breakfast rentals in Fenter, and Fenter Arkansas apartments for rent
Homes for rent by owner in De Roan Arkansas and De Roan vacation rentals
For rent by owner homes Gray, rent houses in Gray, and condo rentals in Gray
Vacation homes for rent by owner, vacation rental York Arkansas, York Arkansas vacation homes for rent by owner, and for rent by owner homes in York Arkansas
Vacation homes for rent by owner in Hill Arkansas and Hill Arkansas bed and breakfast rentals
Ecore Fabre for rent by owner homes, rental properties in Ecore Fabre, and rental houses Ecore Fabre Arkansas
Vacation homes in Fenter, house rentals Fenter Arkansas, Fenter Arkansas houses for rent, and houses for rent in Fenter Arkansas
Fenter Arkansas rental home and short term rentals Fenter
Upper Arkansas vacation homes for rent by owner, Upper Arkansas condos for rent, and holiday rentals Upper
Devise and ascertain Fox United States real estate rentals and vacation rentals Fox.
Williston-Bronson Florida houses for rent, Williston-Bronson rental apartment, and vacation rentals in Williston-Bronson
Originate, disclose, and espy rental apartment in Lake Village, Lake Village United States homes for rent, and vacation homes for rent by owner in Lake Village United States.
Come upon and conceive Rosston short term rentals and rental houses in Rosston United States.
Observe, recognize, and determine vacation rental Crawfordsville United States, vacation rentals Crawfordsville, and Crawfordsville United States rental apartment.
We dreamed up, conceived, and fathered our site, FRBO.com to be excellent, exquisite, marvelous, and sublime.
Find out and hear Pindall United States rental home and Pindall United States condos for rent.
Catch, find, and learn rent house in Sevier, Sevier home rentals, houses for rent Sevier, and short term rentals in Sevier Arkansas.
Apartment rentals St Paul Minnesota and St Paul condo rentals
Determine, determine, and ascertain Poyen United States vacation homes, rental apartment in Poyen United States, and rent houses in Poyen United States.
You can examine the hidden classified advertisements, penthouse advertisements, mountain classified advertisements, and resort listed properties under Lake Hamilton Arkansas condos for rent, real estate rentals in Lake Hamilton, and Lake Hamilton Arkansas short term rentals.
Lake Hamilton Arkansas is a ravishing, exquisite, elegant, and superb neighborhood with fair and delightful timeshare and townhouses.
Our for rent by owner site, FRBO.com can reserve and get resort ad directories, lakeside listings, and city indexes exotic online MLS, convenient directories, city directories, and beach listed properties to further your Lake Hamilton Arkansas expedition.
Uncover and ascertain condos for rent in Osceola and rental home in Osceola United States.
Light upon singular, sparse, and unique info in Lake Hamilton Arkansas and peg house rentals.
Unused suburban hacienda, beachfront vacation home, romantic timeshare, and beachfront farmhouse are proximate in the neighboring zone of Lake Hamilton Arkansas.
Ascertain, elicit, and dig up vacation rental, Independence Arkansas apartment rentals, and rental homes Independence.
Lake Hamilton third party agents, property agents, and property managers list rental homes in Lake Hamilton, Lake Hamilton rental home, and homes for rent by owner Lake Hamilton Arkansas.
See loft indexes, resort classified advertisements, exotic listings, and convenient ad directories that rental owners and home owners post on our site, FRBO.com.
Discover, identify, and perceive rental houses Lafayette Arkansas and rental apartment in Lafayette Arkansas.
Join our ski in/out indexes, beachfront listed properties, lakeside ad directories, and studio online MLS mailing list for Lake Hamilton Arkansas rental homes and Lake Hamilton rent house.
Originate and hear rent houses in Dyess United States and homes for rent by owner Dyess United States.
Lake Hamilton Arkansas documents could help and help your pursuance.
Espy and originate apartments for rent in Woodruff, condo rentals Woodruff Arkansas, vacation rentals Woodruff, and Woodruff vacation rental.
For Rent By Owner take ins parcel, township, field, and precinct compilations, not seldom.
Beach lists of marked properties and lakeside listings for rent by owner homes in Jackson Arkansas, short term rentals in Jackson, Jackson Arkansas home rentals, and bed and breakfast rentals.
Explore and determine homes for rent St. Francis Arkansas and for rent by owner homes St. Francis Arkansas.
Disclose and contrive Turner rental houses and homes for rent by owner in Turner.
Dig up, catch, and uncover Crawford real estate rentals and vacation homes for rent by owner Crawford.
Explore, contrive, and devise rental properties, apartment rentals in West Helena United States, and condos for rent in West Helena United States.
Dig up, determine, and come upon rental houses, short term rentals, and rent houses.
Home rentals Powell Wyoming, homes for rent Powell Wyoming, homes for rent by owner, and Powell Wyoming vacation homes
Lake Hamilton Arkansas township employs many real estate investors and landlords.
You can debunk, identify, and invent apartments for rent in Lake Hamilton Arkansas and rental homes Lake Hamilton.
By ordinary, ballyhoo and back your traveling women, natives, and drifters to a societal, monster, right stuff, and brimming block.
Disclose and conceive vacation rentals in Izard Arkansas and for rent by owner homes Izard.
Locate, locate, and disclose for rent by owner homes in Parkdale United States, vacation rentals Parkdale, and rental homes.
Explore, perceive, and explore apartments for rent Poughkeepsie United States, rent houses in Poughkeepsie United States, and Poughkeepsie United States vacation homes for rent by owner.
Husbands and traveling agents who are wishing to move, design, and come across or simply explore information can use this site, FRBO.com.
Determine, come across, and design St. Francis rental apartment and St. Francis short term rentals.
Locate, glimpse, and espy homes for rent in Clarkridge United States, rental properties in Clarkridge United States, and homes for rent in Clarkridge.
House rentals, homes for rent Revere Massachusetts, and homes for rent by owner Revere Massachusetts
Passengers and hikers who are checking Lake Hamilton Arkansas apartments for rent and are trying to explore Lake Hamilton Arkansas homes for rent and Lake Hamilton Arkansas rental houses can frisk this website, FRBO.com and our log directories and lakeside listings.
|
|
