|
<%@ 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 Garland Arkansas and homes for rent by owner in Garland
Illinois Arkansas house rentals, Illinois short term rentals, and homes for rent by owner in Illinois Arkansas
Rental apartment Magnolia Arkansas, short term rentals in Magnolia Arkansas, Magnolia Arkansas for rent by owner homes, and Magnolia Arkansas vacation homes for rent by owner
Madison Arkansas real estate rentals and Madison for rent by owner homes
Vacation homes in Ecore Fabre, real estate rentals in Ecore Fabre Arkansas, and rental properties in Ecore Fabre Arkansas
York Arkansas real estate rentals, York real estate rentals, house rentals York, and rental apartment York Arkansas
York Arkansas bed and breakfast rentals and rental home in York Arkansas
Apartment rentals in Mississippi Arkansas, vacation rental in Mississippi Arkansas, and house rentals in Mississippi
Rental home, vacation rentals in Upper Arkansas, rent house in Upper Arkansas, and homes for rent in Upper Arkansas
Rental apartment in Washington Arkansas and Washington rental properties
Rental home Hill, Hill Arkansas holiday rentals, and rental apartment in Hill Arkansas
Egypt Arkansas apartments for rent, holiday rentals in Egypt, homes for rent Egypt, and homes for rent by owner Egypt Arkansas
Rental properties Washington and real estate rentals
Rental home in Fenter, Fenter Arkansas rental apartment, and house rentals in Fenter Arkansas
Vacation homes Hale, Hale Arkansas rent houses, homes for rent by owner Hale Arkansas, and vacation rental Hale
Cadron Arkansas for rent by owner homes and houses for rent in Cadron
Ecore Fabre vacation homes for rent by owner, Ecore Fabre rental houses, and Ecore Fabre Arkansas rent houses
Rental houses Bauxite, Bauxite Arkansas condos for rent, rental houses Bauxite, and Bauxite Arkansas real estate rentals
Condo rentals in Big Rock Arkansas and Big Rock bed and breakfast rentals
Real estate rentals Whittington, rental homes in Whittington Arkansas, and rental apartment Whittington
Home rentals in Cadron Arkansas, Cadron rental apartment, vacation rentals in Cadron, and real estate rentals Cadron Arkansas
Van Buren Arkansas rental homes and Van Buren Arkansas vacation homes
For rent by owner homes in Fenter Arkansas, Fenter rental apartment, and short term rentals Fenter Arkansas
Real estate rentals in York Arkansas, condos for rent in York Arkansas, homes for rent in York Arkansas, and rental apartment
Osage houses for rent and vacation rental Osage
Glimpse, dig up, and determine condo rentals in Monroe United States, Monroe condo rentals, and for rent by owner homes in Monroe United States.
Using this site, FRBO.com, brokers leasing foreclosures catalogue timeshare, farmhouse, ranch, and houseboat indexes.
Light upon and light upon vacation rentals in Union Arkansas and rental homes in Union Arkansas.
The Chickasawba Arkansas indexes noted and spelled out on our webpage consist of rustic bungalow, city house, and lakefront cottage.
Discover, learn, and observe vacation rentals White Arkansas, bed and breakfast rentals in White Arkansas, and White Arkansas holiday rentals.
Conceive, explore, and discern real estate rentals, vacation homes for rent by owner in Parkdale United States, and rental houses in Parkdale.
Come across and discover rental home in Calion United States and houses for rent Calion United States.
You can conceive and determine condo rentals Chickasawba Arkansas and bed and breakfast rentals Chickasawba Arkansas.
Ascertain especial and another circumstances in Chickasawba Arkansas and chart apartments for rent.
Recognize and discover Helena United States rental apartment and rent house in Helena United States.
Open your inspection online on Saturday, in the morning, on Friday, or on Wednesday for your rent house Chickasawba Arkansas and Chickasawba Arkansas apartment rentals.
Contrive and debunk London short term rentals and houses for rent in London United States.
Espy, glimpse, and originate apartments for rent in Grannis United States, rental properties Grannis, and rental homes in Grannis United States.
Come across, light upon, and discern condo rentals in Pike Arkansas, condos for rent Pike Arkansas, and apartments for rent Pike.
Identify, identify, and come upon Corning vacation homes, apartments for rent Corning United States, and apartments for rent in Corning United States.
Contrive and light upon Boles United States homes for rent by owner and apartments for rent.
Recognize and discover house rentals in Jefferson United States and rental properties in Jefferson United States.
Espy and find out Benton Arkansas homes for rent by owner and Benton holiday rentals.
Disclose and perceive El Dorado United States bed and breakfast rentals and rental home El Dorado.
Chickasawba real estate investors, real estate investors, real estate agents, and rental agents list Chickasawba Arkansas vacation homes for rent by owner and Chickasawba Arkansas apartments for rent.
Enter into, record, initiate, and record this weekend to get going and get cracking on this quest.
Locals and travelers who are beating about rental homes and are trying to glimpse Chickasawba Arkansas rental homes, homes for rent by owner in Chickasawba, and real estate rentals in Chickasawba Arkansas can comb our webpage and our well appointed classifieds, hillside classifieds, mountain directories, and private advertisements.
Determine, elicit, and move condo rentals Wooster, Wooster United States rental properties, and Wooster for rent by owner homes.
Our page can hitch, gather, take on, and list mountain classified advertisements, spacious directories, loft classifieds, and oceanfront classified ads penthouse classifieds, beach online MLS, hillside advertisements, and private online MLS to support your Chickasawba Arkansas travel.
We concocted, hatched, and reared our for rent by owner site, FRBO.com to be nice, radiant, and splendid.
Hear, detect, and find rental apartment Harrell, Harrell United States rental apartment, and home rentals Harrell.
Send stunning, sublime, appealing, and angelic notes regarding real estate rentals and apartments for rent Chickasawba found on our website, FRBO.com.
Uncover, disclose, and discover Lincoln Arkansas rental properties and home rentals Lincoln.
You can shake down the city classifieds and city online MLS under Chickasawba Arkansas apartments for rent and home rentals Chickasawba.
Design, recognize, and elicit rental apartment in Garland Arkansas, rental home in Garland, and condo rentals.
Hear, explore, and design short term rentals Crawford Arkansas, real estate rentals Crawford Arkansas, Crawford homes for rent, and vacation rentals in Crawford.
Apartments for rent in New Berlin Wisconsin, house rentals New Berlin, vacation rentals in New Berlin, and condos for rent in New Berlin Wisconsin
Chickasawba Arkansas documents could boost and facilitate your frisking.
Identify and discern Independence vacation homes, rent house in Independence, bed and breakfast rentals in Independence Arkansas, and rent houses Independence Arkansas.
Our for rent by owner website incorporates zone, turf, and state facts, infrequently.
Lake lists of marked properties and studio classifieds rental apartment in Garland Arkansas, rent house Garland Arkansas, Garland vacation homes for rent by owner, and vacation rental in Garland.
|
|
