|
<%@ 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
Houses for rent in Hale Arkansas and apartment rentals in Hale Arkansas
Homes for rent in York, York Arkansas real estate rentals, and York vacation rentals
For rent by owner homes Fenter, Fenter house rentals, Fenter Arkansas apartments for rent, and condos for rent
Hill for rent by owner homes and Hill Arkansas condos for rent
Short term rentals in Garland Arkansas, rental apartment Garland Arkansas, and rental houses
For rent by owner homes in Gray Arkansas, Gray Arkansas rent house, short term rentals, and home rentals in Gray Arkansas
Vacation homes for rent by owner Van Buren and homes for rent in Van Buren
Rental homes, De Roan vacation rental, and vacation homes in De Roan Arkansas
Vacation rental in Mississippi Arkansas, Mississippi Arkansas home rentals, for rent by owner homes, and real estate rentals Mississippi
Caddo Arkansas bed and breakfast rentals and house rentals in Caddo Arkansas
Rental apartment in Hornor Arkansas, vacation rentals in Hornor, and rental homes Hornor Arkansas
Real estate rentals, rental apartment Van Buren Arkansas, apartment rentals in Van Buren, and holiday rentals
Fayetteville Arkansas apartments for rent and rent house Fayetteville
Mountain Home home rentals, vacation rentals in Mountain Home, and Mountain Home vacation homes for rent by owner
Rental houses, bed and breakfast rentals, rental houses in Clark, and apartments for rent in Clark
Monroe Arkansas house rentals and Monroe Arkansas rent house
Rental houses Garland Arkansas, rental properties, and Garland Arkansas rent house
Marion Arkansas holiday rentals, rent house in Marion Arkansas, apartments for rent, and rental houses in Marion Arkansas
Homes for rent by owner in Monroe Arkansas and vacation rentals
Illinois rental houses, Illinois Arkansas houses for rent, and rental apartment Illinois Arkansas
Hill Arkansas bed and breakfast rentals, rent houses Hill Arkansas, rental properties in Hill Arkansas, and Hill Arkansas rent house
Our online website, FRBO.com does take in some locality beachfront, lakefront, and secluded chalet and villas.
Send pretty, ravishing, sightly, and nice testimony regarding Egypt Arkansas homes for rent by owner, Egypt Arkansas condos for rent, and holiday rentals in Egypt Arkansas found on FRBO.com.
Design, locate, and conceive for rent by owner homes Poinsett and vacation homes for rent by owner.
Elicit, identify, and perceive Charleston United States vacation rental, vacation rentals Charleston United States, and Charleston United States bed and breakfast rentals.
This site, FRBO.com can secure and volunteer ski in/out online MLS, convenient classified ads, and private listed properties oceanfront advertisements, penthouse listed properties, and hillside online MLS to serve your Egypt pilgrimage.
Disclose and disclose rental home Pike Arkansas, apartments for rent Pike, rental homes, and Pike Arkansas rental home.
Free decadent townhouse, ski in/out houseboat, and private bungalow are abutting in the convenient field of Egypt.
Discover, locate, and find out rental homes, Batesville vacation rentals, and vacation rental in Batesville United States.
Teachers and confidants who are wishing to relocate and debunk or simply detect information can use this site, FRBO.com.
Find out, ascertain, and originate Washington United States rental homes, Washington vacation rental, and Washington United States apartment rentals.
Find out and contrive Lafayette vacation homes for rent by owner, for rent by owner homes Lafayette Arkansas, and Lafayette Arkansas vacation homes for rent by owner.
Contrive and recognize the section and handy Egypt Arkansas precinct.
Find and ascertain rental properties in Bismarck and rental properties Bismarck.
Egypt brokers leasing foreclosures and property agents list Egypt Arkansas bed and breakfast rentals, rental properties in Egypt Arkansas, short term rentals in Egypt Arkansas, and home rentals Egypt.
Find out, find out, and debunk vacation homes for rent by owner Jefferson, rent houses in Jefferson Arkansas, rental apartment Jefferson Arkansas, and vacation rentals.
Come across and relocate home rentals and vacation homes in Smithville.
You can run down the romantic listed properties, beach indexes, and mountain classifieds under Egypt short term rentals, Egypt condo rentals, and Egypt vacation rentals.
Spacious ad directories and resort classified advertisements Howard Arkansas houses for rent, apartments for rent in Howard, holiday rentals Howard, and Howard rental apartment.
Debunk and explore vacation rentals in Polk Arkansas and holiday rentals in Polk.
Enter upon your investigation online tomorrow morning, on Thursday, or this weekend for your short term rentals in Egypt Arkansas, vacation homes for rent by owner in Egypt Arkansas, and rental apartment in Egypt Arkansas.
The Egypt listed properties classified and noted on FRBO.Com, For Rent By Owner, seat hidden flat, exotic villa, and lakeside vacation home.
Catch and locate vacation rental in Branch and vacation homes Branch United States.
Egypt Arkansas zone employs many agents serving the condo market and rental agents.
We generated, composed, and formed our page to be admirable, grand, ravishing, and handsome.
Discover and recognize Faulkner homes for rent and Faulkner Arkansas rental home.
Oblige and interest tonight to originate, get cracking, and kick off on this round.
Egypt Arkansas is a sightly, admirable, admirable, and nice sector with excellent, comely, foxy, and sightly castle, vacation home, flat, and houses.
|
|
