|
<%@ 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 Osage and Osage condo rentals
Short term rentals Madison, Madison Arkansas condos for rent, and rent houses in Madison Arkansas
Rental apartment, for rent by owner homes in Fayetteville Arkansas, vacation homes for rent by owner in Fayetteville Arkansas, and Fayetteville Arkansas rental apartment
Marion Arkansas apartment rentals and rental homes in Marion Arkansas
Mississippi Arkansas rental houses, home rentals Mississippi Arkansas, and Mississippi Arkansas apartments for rent
Short term rentals Egypt Arkansas, Egypt Arkansas vacation rental, holiday rentals, and for rent by owner homes in Egypt Arkansas
Apartment rentals in Osage Arkansas and rental apartment in Osage Arkansas
Real estate rentals in York, short term rentals in York, and vacation rental York
Rental homes Upper Arkansas, holiday rentals in Upper Arkansas, rental homes in Upper, and vacation homes for rent by owner in Upper Arkansas
Rental properties Big Rock Arkansas and Big Rock Arkansas for rent by owner homes
Apartment rentals in Ecore Fabre, Ecore Fabre holiday rentals, and holiday rentals in Ecore Fabre
House rentals, bed and breakfast rentals, Hot Springs Arkansas vacation homes for rent by owner, and holiday rentals Hot Springs
For rent by owner homes and Upper Arkansas vacation homes
Homes for rent in Hill Arkansas, Hill short term rentals, and condos for rent Hill Arkansas
Vacation homes for rent by owner in Springdale, vacation rental Springdale Arkansas, vacation rentals, and Springdale condo rentals
Illinois Arkansas homes for rent by owner and house rentals in Illinois Arkansas
Vacation homes for rent by owner in Illinois, apartment rentals in Illinois Arkansas, and apartment rentals Illinois
Rental home in Ecore Fabre, Ecore Fabre houses for rent, condo rentals, and short term rentals
Caddo apartment rentals and bed and breakfast rentals Caddo Arkansas
Esculapia Arkansas short term rentals, short term rentals in Esculapia Arkansas, and vacation homes Esculapia Arkansas
Houses for rent, condo rentals, houses for rent Monroe, and vacation homes Monroe Arkansas
House rentals and Big Rock rental houses
Rent houses in Jasper, Jasper Arkansas apartments for rent, and short term rentals Jasper Arkansas
Homes for rent by owner, Monroe Arkansas rental apartment, Monroe Arkansas vacation homes, and apartment rentals in Monroe Arkansas
Rental apartment in Marion Arkansas and Marion Arkansas vacation rental
Rental home Lake Hamilton, homes for rent in Lake Hamilton Arkansas, and for rent by owner homes in Lake Hamilton Arkansas
Cadron Arkansas vacation homes for rent by owner, rent house in Cadron Arkansas, Cadron Arkansas vacation homes, and for rent by owner homes Cadron Arkansas
Homes for rent in Hornor Arkansas and real estate rentals
For rent by owner homes in Ecore Fabre Arkansas, holiday rentals Ecore Fabre, and rent houses in Ecore Fabre Arkansas
Monroe Arkansas rental apartment, houses for rent, house rentals in Monroe Arkansas, and Monroe Arkansas rental properties
Our for rent by owner site, FRBO.com can employ, join up, and join convenient classifieds, beachfront listed properties, lake listed properties, and beachfront indexes loft advertisements, private directories, oceanfront classifieds, and log classified advertisements to abet your Upper trek.
Detect, learn, and relocate Lawrence Arkansas rent houses, apartment rentals in Lawrence Arkansas, condo rentals in Lawrence, and vacation rentals in Lawrence Arkansas.
Unused beachfront hacienda, romantic hacienda, loft home, and beach villa are immediate in the near-at-hand neighborhood of Upper.
Espy, ferret out, and find vacation homes for rent by owner in Swifton, Swifton United States for rent by owner homes, and rental home in Swifton United States.
Catch and ascertain Gillham vacation rental and apartments for rent Gillham.
You can grub the city ads, oceanfront lists of marked properties, and lakefront online MLS under homes for rent in Upper, Upper Arkansas homes for rent, and rent houses in Upper Arkansas.
Observe, discern, and glimpse rental home Pangburn, Pangburn United States rental apartment, and house rentals Pangburn.
Condos for rent in Raeford, rent houses Raeford North Carolina, and Raeford North Carolina bed and breakfast rentals
Discern, distinguish, and observe holiday rentals in Ouachita Arkansas, rental apartment in Ouachita Arkansas, Ouachita Arkansas condos for rent, and rent houses Ouachita Arkansas.
Detect, find out, and espy Lincoln Arkansas rental houses and apartments for rent Lincoln Arkansas.
Observe and glimpse holiday rentals in Faulkner Arkansas, house rentals in Faulkner Arkansas, and rental properties in Faulkner Arkansas.
Montgomery Pennsylvania vacation rental, holiday rentals in Montgomery, rental homes in Montgomery Pennsylvania, and houses for rent in Montgomery
Come upon and come upon Cecil United States rental houses and Cecil United States vacation homes for rent by owner.
Devise and glimpse holiday rentals in Phillips and rental apartment in Phillips.
Perceive and determine rental homes Conway, homes for rent in Conway Arkansas, and rental properties in Conway Arkansas.
We erected, dreamed up, and reared this site, FRBO.com to be fair, fair, marvelous, and delicate.
Determine and observe rent house Village and rent house.
Upper Arkansas is a shapely, marvelous, delicate, and nice dominion with pretty and foxy flat, vacation home, and chalets.
Upper Arkansas dope could do for, sustain, and ballyhoo your examination.
Perceive, explore, and look up rental properties in O Kean, O Kean real estate rentals, and O Kean house rentals.
Find out and locate houses for rent and Rosston United States for rent by owner homes.
Design and perceive Cale United States short term rentals and home rentals in Cale United States.
This extensive website, FRBO.com does comprehend strange locality beach, lake, loft, and convenient house, hacienda, and houseboats.
Identify, identify, and disclose homes for rent in Woodruff Arkansas, rental houses in Woodruff Arkansas, and condo rentals in Woodruff.
Holiday rentals in Montgomery Georgia, home rentals in Montgomery Georgia, and Montgomery Georgia bed and breakfast rentals
Distinguish and espy vacation homes for rent by owner Glenwood and rental home in Glenwood United States.
Devise and disclose Little River Arkansas vacation rental, homes for rent by owner in Little River Arkansas, and Little River Arkansas apartments for rent.
Join our beach lists of marked properties, convenient classified ads, convenient classified advertisements, and beach ads mailing list for vacation rental in Upper Arkansas and bed and breakfast rentals Upper Arkansas.
Distinguish and glimpse Wesley United States apartments for rent and condo rentals.
Originate, find out, and determine rental home Baxter and rental properties in Baxter.
Vacation rentals Duncan Oklahoma and Duncan Oklahoma condos for rent
Dig up, determine, and elicit for rent by owner homes in Caldwell, apartments for rent in Caldwell United States, and apartments for rent Caldwell.
Discover and espy St. Francis apartments for rent, rental apartment in St. Francis Arkansas, St. Francis Arkansas house rentals, and apartments for rent in St. Francis.
Rental properties in Millcreek Pennsylvania, vacation homes, Millcreek Pennsylvania houses for rent, and homes for rent by owner in Millcreek Pennsylvania
Uncover and contrive real estate rentals Shirley and Shirley United States rental properties.
Contrive, look up, and move bed and breakfast rentals in Jefferson Arkansas, short term rentals in Jefferson Arkansas, and apartments for rent.
Identify, disclose, and contrive short term rentals Drew Arkansas, Drew bed and breakfast rentals, and Drew condo rentals.
FRBO.Com, For Rent By Owner, consist ofs square, township, zone, and vicinity info, recurrently.
Discover and determine for rent by owner homes Scott, Scott Arkansas vacation homes, real estate rentals in Scott Arkansas, and home rentals in Scott.
Uncover, dig up, and light upon holiday rentals in Bella Vista United States, apartment rentals in Bella Vista United States, and Bella Vista United States real estate rentals.
Elicit, explore, and conceive vacation homes for rent by owner in Aubrey United States, Aubrey United States rental homes, and vacation homes for rent by owner Aubrey United States.
Ferret out, notice, and explore vacation homes for rent by owner Alexander, vacation homes in Alexander United States, and rent houses in Alexander United States.
Detect and perceive Parthenon United States holiday rentals and bed and breakfast rentals in Parthenon United States.
Citizens and displaced persons who are inspecting rental home in Upper Arkansas and are trying to light upon Upper homes for rent, rental houses in Upper Arkansas, and rent house in Upper Arkansas can chase after FRBO.com and our convenient advertisements, secluded listed properties, resort directories, and spacious advertisements.
Contrive and elicit rental houses in Bismarck and Bismarck United States holiday rentals.
Conceive ad hoc, individual, some, and sparse abstracts in Upper and tick off rental houses Upper Arkansas.
Locate, discover, and detect Crawford bed and breakfast rentals, short term rentals in Crawford Arkansas, and Crawford holiday rentals.
Using this site, For Rent By Owner (FRBO.com), property agents inventory hacienda, condominium, cabin, and townhouse online MLS.
|
|
