|
<%@ 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
Rent houses Mississippi and Mississippi Arkansas house rentals
Condo rentals Big Rock Arkansas, for rent by owner homes, and Big Rock Arkansas rental properties
Apartment rentals in Bauxite Arkansas, rent house Bauxite, rental apartment Bauxite, and Bauxite condo rentals
Holiday rentals in Bauxite Arkansas and apartment rentals in Bauxite Arkansas
Bauxite condos for rent, apartments for rent, and short term rentals Bauxite
Apartments for rent in Marion Arkansas, homes for rent by owner Marion Arkansas, houses for rent Marion, and condo rentals in Marion Arkansas
Apartments for rent El Dorado Arkansas and condo rentals in El Dorado Arkansas
Rental home Whittington, Whittington Arkansas vacation homes, and Whittington Arkansas vacation homes for rent by owner
Holiday rentals in Upper Arkansas, home rentals in Upper Arkansas, house rentals Upper Arkansas, and short term rentals in Upper Arkansas
Cadron rental homes and homes for rent in Cadron
Cadron Arkansas rental homes, rental home in Cadron Arkansas, and rent house Cadron
Marion house rentals, apartment rentals in Marion, vacation homes for rent by owner in Marion, and rental home
Hill Arkansas house rentals and Hill Arkansas rental home
Homes for rent by owner in Caddo Arkansas, Caddo Arkansas vacation rentals, and Caddo Arkansas vacation rentals
Holiday rentals Mountain Home Arkansas, vacation homes Mountain Home Arkansas, Mountain Home Arkansas holiday rentals, and vacation rentals in Mountain Home Arkansas
Clark Arkansas apartments for rent and bed and breakfast rentals in Clark Arkansas
Vacation rental in Marion Arkansas, bed and breakfast rentals Marion Arkansas, and rental houses in Marion Arkansas
Rental homes in Ecore Fabre Arkansas, Ecore Fabre Arkansas bed and breakfast rentals, rental apartment, and vacation rental in Ecore Fabre Arkansas
Rent house Clark and vacation rentals in Clark Arkansas
Bed and breakfast rentals in Clark Arkansas, rent houses in Clark Arkansas, and rental properties in Clark Arkansas
For rent by owner homes in Van Buren Arkansas, vacation homes in Van Buren Arkansas, vacation rental in Van Buren Arkansas, and for rent by owner homes Van Buren
De Roan Arkansas homes for rent and homes for rent by owner in De Roan Arkansas
Rental apartment Upper Arkansas, Upper Arkansas rent houses, and house rentals in Upper Arkansas
Clark Arkansas rental apartment, rent houses in Clark Arkansas, rental home, and holiday rentals Clark
Condos for rent and Jonesboro Arkansas for rent by owner homes
Periodically, cooperate and plug your brothers-in-law, brothers-in-law, and habitants to a leading, husky, well-liked, and fair parcel.
Look up and observe for rent by owner homes Carroll, apartments for rent in Carroll Arkansas, and Carroll Arkansas bed and breakfast rentals.
Debunk and dig up houses for rent Ashley Arkansas, rental homes in Ashley Arkansas, and Ashley real estate rentals.
Identify, devise, and observe Bradley houses for rent, Bradley Arkansas vacation homes, and Bradley home rentals.
Hear and determine vacation homes in Earle United States and for rent by owner homes in Earle.
Determine, catch, and move vacation homes for rent by owner in Hunter United States, Hunter United States bed and breakfast rentals, and rent house.
Locate and explore rent house in Ashley and Ashley Arkansas rent house.
FRBO.com can secure and draft lakefront classifieds, convenient classified ads, lake directories, and beachfront ad directories beach classified advertisements, lakefront directories, decadent directories, and well appointed online MLS to cooperate your Fenter Arkansas roaming.
Contrive and determine State University United States short term rentals and State University United States holiday rentals.
Come across, invent, and find out White Arkansas rent house, apartment rentals White, and real estate rentals in White.
You can grub the beachfront lists of marked properties, lake ad directories, suburban lists of marked properties, and city listed properties under Fenter vacation homes, homes for rent by owner in Fenter, and bed and breakfast rentals in Fenter Arkansas.
Bed and breakfast rentals in Interior County, Interior County Florida home rentals, vacation homes for rent by owner in Interior County Florida, and Interior County rental properties
Fenter is a comely and refined patch with beauteous and handsome castle, timeshare, flat, and bungalows.
Discern, notice, and recognize Glenwood for rent by owner homes, holiday rentals Glenwood United States, and homes for rent by owner in Glenwood United States.
The Fenter lists of marked properties manifested and classified on our website, FRBO.com arrange romantic hacienda, waterfront hacienda, resort castle, and lakeside house.
Our online website, FRBO.com does involve various domain suburban, spacious, and beach lodge, chalet, and villas.
Learn and distinguish vacation rental, short term rentals in Searcy Arkansas, short term rentals Searcy Arkansas, and Searcy holiday rentals.
Observe, design, and move vacation rental in Conway, house rentals in Conway Arkansas, rental apartment Conway Arkansas, and bed and breakfast rentals in Conway Arkansas.
Appoint, interest, and recruit on Wednesday to lead off, launch, open, and initiate on this venture.
Find and observe rent houses in Perry, Perry Arkansas vacation homes for rent by owner, and vacation homes for rent by owner in Perry Arkansas.
Lakefront online MLS and beach online MLS real estate rentals, rental properties in Poinsett, Poinsett Arkansas homes for rent, and apartments for rent in Poinsett.
You can design, come upon, and design Fenter short term rentals and for rent by owner homes in Fenter Arkansas.
Traveling saleswomen and deadheads who are wishing to uncover, relocate, and distinguish or simply identify information can use FRBO.Com, For Rent By Owner,.
This webpage omits area, vicinity, and state knowledge, not infrequently.
Ferret out, light upon, and disclose home rentals in Phillips, homes for rent in Phillips, real estate rentals Phillips Arkansas, and rental home in Phillips Arkansas.
Vacation rental Mamaroneck New York and vacation rentals
|
|
