|
<%@ 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
Jonesboro houses for rent and condo rentals Jonesboro Arkansas
Short term rentals Osage Arkansas, rental homes in Osage Arkansas, and apartments for rent Osage
Rental properties Monroe Arkansas, rental houses, bed and breakfast rentals Monroe, and rental properties Monroe
Mountain Home Arkansas rental houses and vacation homes for rent by owner Mountain Home
Magnolia Arkansas vacation homes, Magnolia rental apartment, and homes for rent in Magnolia Arkansas
Home rentals in Marion Arkansas, rental properties Marion, rental houses in Marion Arkansas, and Marion Arkansas rent houses
Houses for rent Hale Arkansas and Hale rental properties
Van Buren vacation homes for rent by owner, vacation homes for rent by owner in Van Buren, and condo rentals in Van Buren Arkansas
Rent houses in Monroe Arkansas, vacation rental Monroe, apartments for rent in Monroe Arkansas, and vacation homes in Monroe
Magnolia Arkansas home rentals and Magnolia Arkansas houses for rent
Cadron Arkansas short term rentals, Cadron Arkansas home rentals, and Cadron Arkansas condos for rent
House rentals in Monroe, Monroe Arkansas rent house, for rent by owner homes Monroe, and Monroe Arkansas home rentals
Vacation homes Jonesboro and house rentals Jonesboro Arkansas
Home rentals in Monroe Arkansas, short term rentals in Monroe Arkansas, and Monroe Arkansas real estate rentals
Rent house in Van Buren Arkansas, real estate rentals in Van Buren, Van Buren Arkansas rental houses, and homes for rent
Hico Arkansas rent houses and Hico rental homes
Condo rentals in Jasper Arkansas, rental homes in Jasper Arkansas, and vacation homes for rent by owner
Vacation rentals in Garland, for rent by owner homes Garland, Garland Arkansas rent house, and Garland Arkansas rental houses
Hill Arkansas vacation homes for rent by owner and rental properties in Hill
Rent house in El Dorado Arkansas, El Dorado Arkansas rental properties, and El Dorado vacation homes for rent by owner
Monroe Arkansas rental homes, house rentals, Monroe Arkansas house rentals, and home rentals in Monroe
Rental properties Cadron and Cadron homes for rent
Rent house Fenter, rental properties in Fenter Arkansas, and Fenter rent houses
House rentals Hale, rent houses in Hale, apartments for rent in Hale Arkansas, and Hale condos for rent
Gray house rentals and vacation homes Gray Arkansas
Home rentals Whittington, Whittington Arkansas apartment rentals, and real estate rentals Whittington
Cadron Arkansas real estate rentals, real estate rentals Cadron, Cadron condos for rent, and rental houses in Cadron
Vacation rental in Monroe and holiday rentals Monroe
Vacation homes for rent by owner, Hico homes for rent, and Hico Arkansas apartments for rent
Jonesboro apartment rentals, Jonesboro Arkansas vacation homes for rent by owner, vacation rentals, and Jonesboro Arkansas apartment rentals
Homes for rent Madison Arkansas and rent house
Homes for rent in Jonesboro, rental properties in Jonesboro, and vacation rental in Jonesboro Arkansas
Cadron Arkansas rental houses and vacation rental in Cadron Arkansas
Real estate rentals in Whittington Arkansas, Whittington condo rentals, and for rent by owner homes Whittington
Originate and ascertain Hindsville United States homes for rent and for rent by owner homes in Hindsville.
Jump into your investigation online on Wednesday, tomorrow evening, or this weekend for your vacation rental in Caddo and rental home.
Espy and explore Logan rental homes, condo rentals in Logan Arkansas, and rental houses Logan.
Short term rentals Troy New York, Troy New York rental homes, and Troy New York real estate rentals
Invent and identify vacation homes for rent by owner Hasty United States and vacation homes for rent by owner Hasty.
Come upon, notice, and devise Sevier vacation rentals, Sevier Arkansas vacation homes, and homes for rent by owner.
Notice and relocate rental homes in Newton Arkansas and houses for rent Newton Arkansas.
Discern and debunk Caddo Gap bed and breakfast rentals and short term rentals in Caddo Gap United States.
Often, open doors and back your voyagers and wanderers to a approved, packed, and tempting area.
Conceive, find, and elicit short term rentals in Atkins United States, holiday rentals in Atkins, and homes for rent by owner Atkins United States.
Glimpse and identify Tillar vacation homes and short term rentals Tillar United States.
Vacation homes for rent by owner in St Clair Shores, rental homes St Clair Shores, and vacation rental
Apartment rentals in Woodland, homes for rent in Woodland, holiday rentals Woodland California, and for rent by owner homes Woodland
Vacation homes for rent by owner Dover and Dover Pennsylvania homes for rent by owner
We authored, sired, and spawned our page to be enticing, graceful, and dazzling.
Design, glimpse, and devise rental homes Marble Falls, house rentals in Marble Falls United States, and rent house Marble Falls.
Locate and elicit vacation rentals Paron United States and homes for rent by owner.
Join our log directories and private lists of marked properties mailing list for Caddo Arkansas rental apartment, Caddo Arkansas rental houses, and apartments for rent Caddo Arkansas.
Debunk and invent Aubrey United States rental houses and condo rentals in Aubrey United States.
Identify, look up, and discover rental properties in Pope, vacation homes Pope Arkansas, rent houses Pope, and real estate rentals Pope.
Invent, ascertain, and elicit apartment rentals and vacation rentals Newton Arkansas.
Send graceful, comely, sublime, and pretty dossier regarding Caddo vacation rental and Caddo rental homes found on this site, For Rent By Owner (FRBO.com).
Dig up and observe Hot Spring Arkansas short term rentals and Hot Spring Arkansas homes for rent.
The Caddo Arkansas classified advertisements numerated and catalogued on this extensive website, FRBO.com encompass romantic bungalow, log condominium, well appointed villa, and resort cottage.
Locate, explore, and ferret out Jackson Arkansas rent house and rent houses.
Invent, explore, and look up houses for rent in Casa United States, Casa United States apartments for rent, and bed and breakfast rentals Casa.
Spacious ads and penthouse listings vacation homes for rent by owner Marion, homes for rent Marion Arkansas, apartment rentals Marion, and Marion condos for rent.
Tourists, transmigrants, and roadmen who are shaking down condos for rent in Caddo and are trying to uncover Caddo Arkansas rental apartment, home rentals, and house rentals in Caddo can rummage our page and our beach listed properties and log directories.
Locate, identify, and contrive Nashville United States homes for rent, vacation rentals Nashville United States, and homes for rent by owner in Nashville.
See lakeside indexes, resort online MLS, and city listings that property owners and land owners post on For Rent By Owner.
Traveling sales representatives and acquaintances look over and inquire our page and ferret out beachfront condominium, lakeside flat, penthouse condominium, and ski in/out home.
Disclose, locate, and light upon for rent by owner homes in Boles United States, Boles United States rental houses, and Boles home rentals.
Learn and glimpse condo rentals in Tontitown United States and for rent by owner homes in Tontitown.
Learn, ascertain, and originate homes for rent by owner Fountain Hill United States, holiday rentals in Fountain Hill United States, and home rentals Fountain Hill United States.
Ascertain and distinguish short term rentals Madison Arkansas and vacation rental in Madison.
Contrive, elicit, and light upon vacation homes Pulaski and bed and breakfast rentals in Pulaski.
Catch, ascertain, and dig up rental home in Jersey United States, Jersey apartment rentals, and Jersey homes for rent by owner.
Look up and recognize Polk bed and breakfast rentals, home rentals in Polk, Polk Arkansas home rentals, and Polk Arkansas vacation homes for rent by owner.
Using our site, FRBO.com, agents chart home, cabin, and houseboat classifieds.
Notice and design Camden United States rental homes and rental homes Camden United States.
Design, originate, and relocate Grant Arkansas rental properties, Grant Arkansas for rent by owner homes, vacation homes in Grant Arkansas, and Grant Arkansas house rentals.
You can disclose, ascertain, and design homes for rent Caddo and Caddo Arkansas vacation rental.
Locate and invent for rent by owner homes in Jefferson and Jefferson Arkansas bed and breakfast rentals.
Determine, devise, and find out vacation rentals Pea Ridge United States, Pea Ridge United States homes for rent by owner, and Pea Ridge United States holiday rentals.
Observe, light upon, and move Delight United States rental houses, vacation rentals Delight United States, and Delight United States houses for rent.
Devise and conceive Sebastian Arkansas for rent by owner homes, homes for rent by owner in Sebastian Arkansas, vacation rentals Sebastian, and rent house in Sebastian.
Look up and notice rent houses in Gurdon and houses for rent.
Identify, catch, and uncover homes for rent in Perry Arkansas, Perry rental properties, and holiday rentals in Perry.
Find out, explore, and notice Salado United States rental homes, Salado rent houses, and houses for rent Salado.
For Rent By Owner does hold specialized penthouse, loft, and mountain hacienda, townhouse, houseboat, and houseboats.
Lansing houses for rent, Lansing New York rent houses, condo rentals in Lansing, and Lansing rental homes
Perceive, move, and identify for rent by owner homes in Prairie Arkansas, rent house in Prairie Arkansas, Prairie Arkansas short term rentals, and holiday rentals in Prairie Arkansas.
Ascertain and recognize rental homes Houston and for rent by owner homes Houston.
Uncover, ferret out, and debunk Sturkie United States house rentals, rental home in Sturkie, and houses for rent Sturkie United States.
Vacated mountain flat, suburban lodge, and resort villa are abutting in the not far away area of Caddo Arkansas.
Glimpse and find the vicinity and nearby Caddo Arkansas stretch.
The Caddo convenient ad directories, well appointed classifieds, and decadent classifieds for these city can be mapped.
Dig up and conceive De Valls Bluff United States for rent by owner homes and vacation rental in De Valls Bluff United States.
Middleborough Massachusetts holiday rentals and Middleborough vacation homes
Design, design, and disclose Barling United States vacation homes, Barling homes for rent by owner, and rental apartment.
Identify and hear Harrisburg United States apartment rentals and homes for rent Harrisburg United States.
Distinguish specific, express, and unconventional details in Caddo and classify vacation rental in Caddo.
Real estate rentals and condo rentals in Shallotte North Carolina
Condos for rent and apartments for rent in Vinton Virginia
Invent, find out, and conceive house rentals, apartment rentals in Mayflower United States, and house rentals Mayflower United States.
Vacation rentals in Lubeck West Virginia, rent houses Lubeck, and house rentals Lubeck
Explore and catch Magazine rental apartment and Magazine holiday rentals.
|
|
