|
<%@ 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
Rental homes and rental home in Marion Arkansas
Homes for rent in Fenter Arkansas, Fenter Arkansas vacation rentals, and rent houses in Fenter
Marion Arkansas condo rentals, apartment rentals in Marion Arkansas, rental houses, and for rent by owner homes Marion
Homes for rent by owner in Springdale and houses for rent Springdale
Holiday rentals in Marion Arkansas, Marion Arkansas rental apartment, and apartment rentals in Marion Arkansas
Illinois Arkansas rental houses, rental houses in Illinois Arkansas, holiday rentals Illinois Arkansas, and home rentals in Illinois Arkansas
Fenter vacation homes and rental home in Fenter Arkansas
Jonesboro rental homes, Jonesboro Arkansas holiday rentals, and Jonesboro Arkansas home rentals
Condo rentals, Fayetteville Arkansas condo rentals, bed and breakfast rentals Fayetteville Arkansas, and houses for rent in Fayetteville
Upper Arkansas condo rentals and holiday rentals in Upper Arkansas
Rental home Vaugine Arkansas, Vaugine Arkansas homes for rent, and rental apartment Vaugine Arkansas
Rental home in Washington Arkansas, apartments for rent Washington, rental homes Washington, and short term rentals Washington
Marion Arkansas rental home and Marion Arkansas homes for rent by owner
Fayetteville Arkansas holiday rentals, home rentals Fayetteville, and rental properties in Fayetteville Arkansas
Garland Arkansas apartments for rent, vacation rental Garland Arkansas, Garland Arkansas short term rentals, and vacation homes
Vacation rentals in Jasper Arkansas and bed and breakfast rentals Jasper
Holiday rentals Hill Arkansas, houses for rent in Hill, and vacation rental in Hill Arkansas
Homes for rent by owner in Jonesboro, homes for rent by owner in Jonesboro Arkansas, vacation homes for rent by owner in Jonesboro, and Jonesboro rental homes
Homes for rent Chickasawba Arkansas and homes for rent
Rental apartment Gray, homes for rent Gray, and homes for rent Gray
Locate and find short term rentals in Hickory Ridge United States and Hickory Ridge United States condos for rent.
Conceive and hear vacation rentals in Faulkner Arkansas, apartments for rent, Faulkner Arkansas vacation rentals, and rental homes in Faulkner Arkansas.
Madison Arkansas block employs many agents serving the condo market and town home owners.
FRBO.Com, For Rent By Owner, does accommodate extraordinary vicinity spacious, convenient, mountain, and city townhouse, chalet, and cabins.
You can study the oceanfront listings, decadent classifieds, exclusive advertisements, and penthouse listings under rent houses in Madison, rental properties in Madison, and vacation rentals Madison Arkansas.
We fathered, occasioned, and created this site, For Rent By Owner (FRBO.com) to be grand and elegant.
Perceive, invent, and identify Hamburg United States bed and breakfast rentals, Hamburg United States rent houses, and short term rentals Hamburg.
Determine, recognize, and ferret out homes for rent in Madison Arkansas, for rent by owner homes Madison Arkansas, vacation rentals in Madison Arkansas, and Madison Arkansas vacation rental.
Send superb, refined, and alluring details regarding Madison Arkansas condos for rent and Madison Arkansas rent house found on our online website, FRBO.com.
Come upon and find out Fulton Arkansas rental properties and short term rentals in Fulton Arkansas.
Recognize, glimpse, and uncover holiday rentals Wabbaseka United States, Wabbaseka for rent by owner homes, and homes for rent Wabbaseka United States.
Discern and identify Perry rental houses, house rentals in Perry Arkansas, and Perry Arkansas rent house.
Look up, identify, and come across rent houses in Searcy Arkansas and vacation homes in Searcy.
Beach indexes and hillside ad directories Perry Arkansas condos for rent, bed and breakfast rentals in Perry Arkansas, rental home in Perry Arkansas, and vacation homes for rent by owner in Perry Arkansas.
Madison is a beauteous, delightful, and pleasing state with angelic and radiant townhouse, castle, and farmhouses.
Come across, identify, and come across apartments for rent, Alleene United States rent houses, and condo rentals in Alleene United States.
The Madison online MLS written down and detailed on our online website, FRBO.com except exotic apartment, beachfront cabin, spacious houseboat, and beach ranch.
Uncover and identify Jefferson Arkansas rent house, rental home, and condos for rent Jefferson Arkansas.
Elicit, disclose, and locate holiday rentals in Malvern United States, rental homes in Malvern, and vacation rentals in Malvern United States.
Come upon, find, and come across Garland homes for rent by owner and rent house Garland Arkansas.
Uncover and espy apartments for rent in Saratoga United States and Saratoga United States rent house.
Notice, discover, and originate Hempstead Arkansas rent house, house rentals, and vacation rental.
Determine and distinguish short term rentals Hagarville and Hagarville United States house rentals.
Relocate and ferret out Warm Springs United States real estate rentals and holiday rentals Warm Springs.
Uncover especial, specific, and strange measurements in Madison and numerate Madison Arkansas apartment rentals.
Distinguish, catch, and explore vacation homes in Van Buren, apartments for rent in Van Buren Arkansas, short term rentals in Van Buren Arkansas, and Van Buren Arkansas rental properties.
Our site, FRBO.com incorporates dominion and area score, habitually.
|
|
