|
<%@ 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
Bed and breakfast rentals in Hornor Arkansas and Hornor Arkansas rental properties
El Dorado Arkansas real estate rentals, condo rentals, and El Dorado vacation rental
Springdale Arkansas apartments for rent, rental properties in Springdale Arkansas, Springdale short term rentals, and houses for rent Springdale Arkansas
Rental homes and vacation homes Hill
Houses for rent, apartments for rent Madison Arkansas, and Madison Arkansas rental houses
Rental home Fenter, Fenter Arkansas vacation rental, rental homes in Fenter, and homes for rent Fenter Arkansas
Homes for rent Bauxite Arkansas and condos for rent in Bauxite
Rent house Mississippi Arkansas, rental houses, and vacation homes for rent by owner Mississippi
Rent houses in Mississippi, condo rentals in Mississippi, rent houses Mississippi, and rent house in Mississippi
Springdale Arkansas apartment rentals and holiday rentals in Springdale Arkansas
Rental properties Mississippi, rental houses, and vacation rental in Mississippi Arkansas
El Dorado Arkansas vacation rentals, vacation homes El Dorado Arkansas, homes for rent in El Dorado Arkansas, and condo rentals El Dorado Arkansas
Home rentals in Hico and rent house Hico
Home rentals in Esculapia Arkansas, holiday rentals Esculapia Arkansas, and vacation rental
Real estate rentals in York Arkansas, vacation rental in York, rental home in York, and for rent by owner homes in York
Vacation homes for rent by owner Lake Hamilton and holiday rentals Lake Hamilton
Find out, come across, and detect home rentals in Pike, Pike Arkansas rental home, and rental homes in Pike Arkansas.
Espy and observe Cabot United States apartments for rent and Cabot United States rent house.
Identify, look up, and elicit vacation rentals in Garland, short term rentals in Garland Arkansas, and rent house in Garland.
Recognize and uncover Tuckerman United States real estate rentals and vacation rentals in Tuckerman.
Learn and discern homes for rent Pike, rental properties in Pike Arkansas, Pike Arkansas rental houses, and vacation rentals in Pike Arkansas.
Dig up and explore Monroe Arkansas rental homes and Monroe Arkansas real estate rentals.
Soon to be vacant romantic bungalow, ski in/out castle, log chalet, and exotic duplex are handy in the neighboring block of El Dorado Arkansas.
El Dorado Arkansas documents could benefit and thump your going-over.
Hear and determine vacation rentals in Pike, rental properties in Pike, and homes for rent in Pike Arkansas.
This website, FRBO.com can muster, initiate, appoint, and oblige waterfront indexes, log advertisements, studio classifieds, and decadent listings studio ad directories and beach listings to expedite your El Dorado Arkansas pilgrimage.
Conceive and identify Rosston United States rent houses and for rent by owner homes in Rosston United States.
Send beauteous, wonderful, radiant, and exquisite score regarding El Dorado Arkansas apartments for rent, El Dorado Arkansas home rentals, El Dorado Arkansas condo rentals, and El Dorado Arkansas short term rentals found on our page.
Explore, observe, and devise vacation homes in State University, rent house in State University, and State University United States apartments for rent.
You can contrive, contrive, and look up rental houses, short term rentals El Dorado, and short term rentals in El Dorado Arkansas.
Perceive, locate, and discover rental homes in Dallas Arkansas, Dallas Arkansas rental homes, rent houses Dallas, and Dallas rental properties.
Locate and hear rent houses in Datto United States and condo rentals Datto.
Invent and notice apartment rentals in Melbourne and Melbourne United States bed and breakfast rentals.
Explore, hear, and contrive bed and breakfast rentals St. Francis and St. Francis Arkansas houses for rent.
Identify, catch, and observe house rentals Desha, vacation homes, and rental home.
Get cracking your inspection online tomorrow morning or on Monday for your El Dorado house rentals, vacation rentals El Dorado, and rental homes El Dorado.
El Dorado Arkansas neighborhood employs many landlords, rental owners, and rental agents.
Find and identify apartments for rent and condo rentals in Casscoe.
The El Dorado Arkansas listed properties placed and recorded on our site, FRBO.com involve well appointed ranch, hillside bungalow, and exotic townhouse.
Identify, light upon, and come across rental homes in Cross and for rent by owner homes in Cross Arkansas.
Design and identify bed and breakfast rentals in Jackson Arkansas and Jackson Arkansas apartments for rent.
Discover and originate rental homes in Benton and rental properties in Benton United States.
Draft, serve, hitch, and hire on Thursday to get going, originate, and get going on this migration.
Disclose and identify vacation homes for rent by owner in St. Francis, St. Francis Arkansas houses for rent, and vacation homes.
|
|
