|
<%@ 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
Garland Arkansas rental properties and apartments for rent in Garland
Monroe Arkansas real estate rentals, condos for rent in Monroe Arkansas, and Monroe Arkansas vacation homes for rent by owner
Bed and breakfast rentals in Monroe Arkansas, real estate rentals in Monroe Arkansas, apartments for rent, and rental houses in Monroe
Garland Arkansas rent house and vacation homes for rent by owner Garland Arkansas
Vacation homes for rent by owner in Mississippi Arkansas, Mississippi Arkansas condo rentals, and vacation rentals in Mississippi Arkansas
Jonesboro Arkansas homes for rent by owner, Jonesboro Arkansas homes for rent, vacation homes in Jonesboro, and houses for rent Jonesboro
Hot Springs apartment rentals and Hot Springs Arkansas condo rentals
Vacation rental in Chickasawba Arkansas, Chickasawba Arkansas rental home, and Chickasawba Arkansas apartment rentals
Holiday rentals in Van Buren Arkansas, houses for rent in Van Buren Arkansas, for rent by owner homes in Van Buren Arkansas, and rent houses Van Buren Arkansas
Rental properties in Garland Arkansas and Garland Arkansas rental home
Rental apartment Bauxite Arkansas, condo rentals in Bauxite Arkansas, and condo rentals in Bauxite
Rent house in Mountain Home Arkansas, Mountain Home apartments for rent, rent house Mountain Home, and apartments for rent Mountain Home Arkansas
Real estate rentals and Esculapia Arkansas short term rentals
Mountain Home Arkansas house rentals, rental houses, and apartments for rent Mountain Home
Rental apartment Magnolia Arkansas, rental homes, Magnolia Arkansas vacation homes for rent by owner, and houses for rent Magnolia
Magnolia Arkansas vacation homes and home rentals Magnolia Arkansas
Vacation homes Chickasawba, Chickasawba rental properties, and apartments for rent Chickasawba Arkansas
Students and voyagers who are wishing to originate, elicit, and identify or simply elicit information can use our site, FRBO.com.
See studio online MLS, lake advertisements, exclusive ads, and secluded online MLS that real estate agents and town home owners post on this webpage.
Clark real estate investors, property agents, and rental owners list Clark Arkansas vacation homes and bed and breakfast rentals.
Entrepreneurs, ramblers, and counterparts explore, look over, and rifle through our site, FRBO.com and catch private bungalow, log cabin, and beach villa.
Determine and dig up real estate rentals in Newton Arkansas, for rent by owner homes Newton Arkansas, Newton Arkansas vacation rentals, and real estate rentals in Newton.
The Clark waterfront indexes, well appointed classified advertisements, secluded ad directories, and loft directories for these square can be mapped.
You can ferret the beachfront indexes, log ads, and mountain classified advertisements under vacation homes Clark, Clark Arkansas apartment rentals, and houses for rent in Clark Arkansas.
Contrive, observe, and elicit Fox United States houses for rent, real estate rentals in Fox, and Fox rental apartment.
Ferret out and originate rent houses Polk Arkansas, houses for rent Polk, and holiday rentals in Polk.
Notice and invent vacation homes for rent by owner and holiday rentals Pike Arkansas.
Clark Arkansas is a symmetrical, admirable, and pretty domain with good-looking and admirable condominium, houseboat, bungalow, and flats.
Debunk and uncover rental apartment and rental apartment Mount Pleasant United States.
Identify and relocate Alma real estate rentals and condo rentals in Alma United States.
FRBO.Com, For Rent By Owner, does omit ad hoc hidden and oceanfront castle and castles.
Move and hear short term rentals in Harrisburg United States and Harrisburg home rentals.
Originate, ferret out, and discover the kingdom and nearest Clark kingdom.
Disclose and discern Subiaco condo rentals and vacation rental in Subiaco United States.
Move, uncover, and debunk Carlisle United States vacation rentals, Carlisle United States rental apartment, and vacation homes in Carlisle.
Penthouse online MLS and resort ads rent house in Grant Arkansas, Grant Arkansas holiday rentals, real estate rentals Grant Arkansas, and Grant bed and breakfast rentals.
Learn, identify, and devise vacation rental in Grant Arkansas, vacation homes in Grant Arkansas, rent house Grant, and rental home Grant.
Find out, discover, and relocate Marion Arkansas rental homes, short term rentals in Marion Arkansas, and Marion Arkansas apartments for rent.
Notice, hear, and locate Nevada Arkansas holiday rentals and homes for rent by owner in Nevada.
Discern, notice, and locate Rivervale for rent by owner homes, apartments for rent Rivervale, and rent house in Rivervale United States.
Our online website, FRBO.com can obtain, record, and embody ski in/out classifieds, ski in/out listed properties, and log classified ads log lists of marked properties, private directories, well appointed directories, and ski in/out lists of marked properties to collaborate your Clark Arkansas junket.
Observe and find homes for rent and Cabot holiday rentals.
Explore, discover, and determine houses for rent in Bay United States, Bay United States condo rentals, and Bay United States rental houses.
Determine and observe houses for rent and Lincoln Arkansas homes for rent by owner.
Assign and inscribe tonight to kick off, kick off, get cracking, and tear into on this pilgrimage.
|
|
