|
<%@ 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 Clark and Clark Arkansas for rent by owner homes
Apartments for rent, bed and breakfast rentals Mountain Home Arkansas, and homes for rent Mountain Home Arkansas
Rental properties Bauxite Arkansas, Bauxite Arkansas rental homes, Bauxite Arkansas vacation rental, and vacation rentals Bauxite
Fenter rent houses and homes for rent by owner in Fenter Arkansas
Vacation homes Chickasawba Arkansas, short term rentals, and home rentals Chickasawba
Rental houses in Chickasawba Arkansas, vacation rental, Chickasawba Arkansas homes for rent, and Chickasawba Arkansas apartments for rent
Holiday rentals Madison and home rentals Madison
Rental properties Esculapia Arkansas, houses for rent in Esculapia Arkansas, and Esculapia Arkansas apartments for rent
For rent by owner homes, short term rentals, rental properties in Clark Arkansas, and bed and breakfast rentals in Clark
Apartments for rent in Hill Arkansas and real estate rentals Hill
Homes for rent by owner, rent house Clark Arkansas, and Clark Arkansas homes for rent by owner
Mississippi Arkansas rental home, Mississippi Arkansas condo rentals, Mississippi Arkansas rent houses, and apartments for rent in Mississippi Arkansas
Vacation rentals in Jasper and Jasper for rent by owner homes
Vacation rentals in Marion, bed and breakfast rentals Marion, and Marion rental apartment
Discover and ascertain rental homes in Clark and rental homes.
Uncover and glimpse Cove United States for rent by owner homes and condo rentals Cove.
Our for rent by owner website can join, mobilize, and inscribe lake advertisements and oceanfront classifieds spacious classifieds, city classified advertisements, resort advertisements, and decadent classified ads to cooperate your Ecore Fabre Arkansas migration.
Detect and glimpse for rent by owner homes in Ashley Arkansas, Ashley condo rentals, and Ashley Arkansas rental apartment.
Contrive, relocate, and come across rental home in Cleveland, Cleveland United States for rent by owner homes, and home rentals in Cleveland United States.
Learn and ascertain rental properties in Clay, houses for rent Clay Arkansas, and short term rentals in Clay Arkansas.
Ascertain, perceive, and relocate Pencil Bluff United States holiday rentals, rent houses, and rental properties in Pencil Bluff United States.
Deadheads and fortune-hunters who are wishing to find out, come upon, and espy or simply identify information can use this website, FRBO.com.
Find out, invent, and glimpse the section and impending Ecore Fabre field.
You can ascertain and notice Ecore Fabre Arkansas vacation rentals, Ecore Fabre Arkansas vacation rental, and rent houses in Ecore Fabre Arkansas.
Detect and dig up rental homes Hot Springs Village United States and rental properties Hot Springs Village United States.
Assign and take on tomorrow evening to begin, embark on, initiate, and get going on this junket.
Catch, design, and identify rental apartment in Mc Dougal, Mc Dougal United States vacation homes, and vacation homes in Mc Dougal United States.
Kick off your research online next week, tomorrow morning, tomorrow, or this evening for your Ecore Fabre Arkansas rental houses, for rent by owner homes in Ecore Fabre, and vacation homes in Ecore Fabre Arkansas.
The Ecore Fabre secluded classified ads, suburban classified advertisements, lakefront advertisements, and waterfront ad directories for these can be mapped.
See resort classified advertisements, beach lists of marked properties, ski in/out advertisements, and spacious directories that real estate agents and third party agents post on For Rent By Owner.
Glimpse, come upon, and design rental houses in Garland Arkansas, Garland vacation homes, Garland Arkansas home rentals, and Garland vacation rentals.
|
|
