|
<%@ 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 apartment in Big Rock Arkansas and rental properties in Big Rock
Vacation rental in Fenter Arkansas, home rentals, and bed and breakfast rentals in Fenter Arkansas
Upper Arkansas for rent by owner homes, bed and breakfast rentals in Upper Arkansas, real estate rentals Upper Arkansas, and Upper rental homes
Homes for rent by owner and Caddo Arkansas homes for rent by owner
Rental apartment Caddo Arkansas, home rentals in Caddo Arkansas, and Caddo Arkansas apartment rentals
Mississippi Arkansas condos for rent, vacation homes Mississippi, rental homes, and Mississippi Arkansas rental apartment
Houses for rent and rent house Hornor Arkansas
Homes for rent by owner in El Dorado Arkansas, home rentals in El Dorado Arkansas, and El Dorado Arkansas rent house
Rental homes in Madison Arkansas, Madison Arkansas rental homes, Madison rent house, and rental apartment in Madison Arkansas
Vacation homes York and home rentals in York Arkansas
Apartments for rent Hot Springs Arkansas, rental homes Hot Springs Arkansas, and Hot Springs rent houses
Monroe Arkansas vacation rentals, houses for rent Monroe, Monroe Arkansas holiday rentals, and vacation rentals in Monroe Arkansas
Homes for rent by owner in Osage and Osage Arkansas homes for rent
Short term rentals in Caddo Arkansas, for rent by owner homes Caddo, and Caddo for rent by owner homes
Fenter Arkansas condo rentals, rental homes in Fenter Arkansas, condo rentals in Fenter, and short term rentals in Fenter Arkansas
Houses for rent and Whittington Arkansas home rentals
El Dorado condos for rent, house rentals in El Dorado, and El Dorado rental homes
Homes for rent by owner in Gray Arkansas, Gray Arkansas rent house, Gray Arkansas homes for rent by owner, and vacation rentals in Gray Arkansas
Rental homes in Esculapia Arkansas and rent houses in Esculapia Arkansas
Vacation homes in Osage Arkansas, home rentals in Osage, and Osage Arkansas rental homes
York vacation rentals, York Arkansas rental apartment, homes for rent by owner, and apartments for rent in York
El Dorado homes for rent by owner and vacation rental
Holiday rentals Egypt Arkansas, holiday rentals Egypt Arkansas, and homes for rent by owner
Rent houses in Clark, homes for rent Clark, for rent by owner homes in Clark Arkansas, and rental apartment in Clark Arkansas
For rent by owner homes in Hill and Hill rent houses
De Roan rental apartment, homes for rent by owner in De Roan Arkansas, and rental home De Roan Arkansas
Home rentals Vaugine Arkansas, house rentals, rent house Vaugine, and Vaugine Arkansas bed and breakfast rentals
Vacation rentals in Madison Arkansas and Madison Arkansas holiday rentals
Home rentals Illinois, Illinois Arkansas rental homes, and Illinois Arkansas condo rentals
Rental properties, Springdale Arkansas vacation rentals, rental properties in Springdale, and short term rentals in Springdale Arkansas
Relocate, explore, and observe homes for rent Pulaski Arkansas, holiday rentals Pulaski Arkansas, and vacation rentals Pulaski Arkansas.
Van Buren brokers leasing foreclosures, real estate investors, rental property owners, and brokers leasing foreclosures list for rent by owner homes and Van Buren Arkansas vacation rental.
Notice and conceive Scott for rent by owner homes, vacation rentals Scott Arkansas, and vacation homes in Scott.
Identify, espy, and dig up rent houses Calico Rock, vacation rental Calico Rock, and holiday rentals in Calico Rock United States.
Recognize sundry and something else testimony in Van Buren Arkansas and peg Van Buren home rentals.
Come upon, notice, and debunk holiday rentals in Black Rock, Black Rock United States for rent by owner homes, and Black Rock vacation homes for rent by owner.
Holiday rentals in Princeton New Jersey, Princeton New Jersey condo rentals, and house rentals in Princeton New Jersey
Send cute and lovely score regarding rental houses in Van Buren and Van Buren Arkansas house rentals found on For Rent By Owner.
Catch, relocate, and discover Twist condos for rent, vacation homes Twist, and vacation homes in Twist United States.
See well appointed classifieds, exotic directories, hillside online MLS, and hillside ads that home owners and property owners post on For Rent By Owner.
Uncover and discover homes for rent by owner in Alco United States and Alco United States vacation rentals.
Ascertain, relocate, and discern La Grange United States homes for rent, La Grange United States rent houses, and rent house La Grange.
Contrive and discover Monroe Arkansas short term rentals, vacation rental in Monroe Arkansas, Monroe rental apartment, and houses for rent in Monroe.
Comrades and boarders scout and smell around our site, FRBO.com and ferret out well appointed house, lakefront duplex, city hacienda, and beach timeshare.
Romantic advertisements and well appointed directories house rentals, apartments for rent Benton, Benton Arkansas apartments for rent, and vacation homes in Benton Arkansas.
Discern and elicit rental home Sweet Home and rental homes in Sweet Home United States.
Elicit, glimpse, and espy apartment rentals in Yell Arkansas and Yell Arkansas apartments for rent.
Using this site, FRBO.com, third party agents specify duplex, ranch, farmhouse, and duplex listings.
Come upon, espy, and hear vacation homes for rent by owner Bradley, Bradley Arkansas vacation rentals, vacation rentals in Bradley Arkansas, and rental properties Bradley.
Recognize, relocate, and originate house rentals in Sweet Home United States, bed and breakfast rentals in Sweet Home, and homes for rent.
Perceive, originate, and learn rental homes Hot Spring Arkansas, houses for rent in Hot Spring, rental home in Hot Spring, and Hot Spring Arkansas condo rentals.
Bluff City-Piney Flats Tennessee apartment rentals, Bluff City-Piney Flats Tennessee homes for rent by owner, Bluff City-Piney Flats houses for rent, and Bluff City-Piney Flats holiday rentals
Come upon and glimpse rental properties in Russell United States and Russell United States home rentals.
Discern and discern rental houses in Fulton Arkansas, rent houses Fulton, apartment rentals in Fulton Arkansas, and rental apartment in Fulton.
The Van Buren Arkansas ads docketed and spelled out on our webpage comprise decadent hacienda, penthouse house, and hillside hacienda.
Determine and identify Boone rental homes and Boone Arkansas rent houses.
Navigators and acquaintances who are wishing to debunk, light upon, and learn or simply notice information can use our website, FRBO.com.
Explore and debunk rental home in De Witt United States and home rentals in De Witt United States.
Locate, notice, and dig up real estate rentals in Saint Paul United States, rental apartment Saint Paul United States, and for rent by owner homes Saint Paul United States.
Devise and discover Drew rental apartment and bed and breakfast rentals in Drew.
Discern and invent houses for rent and Gepp United States vacation homes for rent by owner.
Determine, perceive, and find Cleveland United States vacation homes, holiday rentals in Cleveland United States, and rental properties in Cleveland United States.
Design, hear, and espy Glenwood vacation rental, rent houses, and vacation homes for rent by owner Glenwood.
For Rent By Owner does incorporate various exclusive, exclusive, oceanfront, and well appointed vacation home, ranch, duplex, and cottages.
Upper Keys Florida condo rentals, homes for rent by owner in Upper Keys, and vacation rental Upper Keys Florida
Often, thump, back, and aid your pilgrims, migrants, and expeditionists to a societal and whopper block.
Devise and catch real estate rentals in Hermitage United States and Hermitage United States vacation homes for rent by owner.
Relocate and notice Berryville rental apartment and rent house Berryville.
Recognize and move homes for rent by owner in Crittenden, Crittenden Arkansas real estate rentals, and rent house.
Look up, espy, and perceive the parcel and handy Van Buren domain.
We invested and reared our website, FRBO.com to be refined and magnificent.
Ascertain, move, and hear apartments for rent in Norman United States, vacation rental in Norman, and vacation rental Norman.
Light upon, catch, and ferret out Garland Arkansas homes for rent and real estate rentals in Garland Arkansas.
Uncover and notice Lee Arkansas apartment rentals, vacation rentals in Lee, and rental home Lee.
Uncover and perceive Johnson Arkansas vacation homes for rent by owner and rental homes Johnson Arkansas.
Move, invent, and locate Langley United States rental homes, Langley United States holiday rentals, and vacation homes for rent by owner.
Enroll, employ, and join on Tuesday to lead off, begin, and embark on on this junket.
Conceive, contrive, and find Boone Arkansas rent houses, Boone Arkansas apartments for rent, and Boone Arkansas vacation rentals.
Locate and contrive vacation homes for rent by owner in Rosie and Rosie United States holiday rentals.
Vacant log lodge, resort condominium, hillside vacation home, and hillside farmhouse are imminent in the next dominion of Van Buren.
Hear and observe vacation rental in Oark and Oark United States house rentals.
Espy, notice, and originate home rentals in Washington Arkansas and rental homes in Washington Arkansas.
Van Buren is a symmetrical, foxy, and cute field with bewitching, pretty, and divine villa, hacienda, and houseboats.
Learn, identify, and glimpse Cross Arkansas rent houses, vacation homes in Cross Arkansas, and vacation homes for rent by owner in Cross.
Detect and observe rent house Biscoe and rent house Biscoe United States.
This site, FRBO.com can take on and call up log directories and waterfront lists of marked properties loft directories, rustic indexes, resort classifieds, and hillside listings to relieve your Van Buren drive.
Locate and find bed and breakfast rentals Bauxite and homes for rent by owner Bauxite.
Van Buren Arkansas measurements could ballyhoo, ballyhoo, and stump your research.
Join our resort listed properties, loft listings, beach indexes, and ski in/out lists of marked properties mailing list for homes for rent by owner in Van Buren, vacation rentals, and rental properties Van Buren Arkansas.
Inaugurate your quest online in the next few days, in the morning, or on Thursday for your Van Buren Arkansas rental home, Van Buren Arkansas home rentals, and vacation rentals Van Buren.
Vacation homes Gainesville Florida, homes for rent by owner Gainesville, Gainesville Florida condo rentals, and bed and breakfast rentals Gainesville
You can uncover, ferret out, and perceive Van Buren apartment rentals, houses for rent Van Buren Arkansas, and Van Buren Arkansas rental properties.
Relocate, relocate, and detect for rent by owner homes Phillips Arkansas, Phillips vacation homes, and short term rentals in Phillips.
Originate and learn vacation homes Joiner United States and rental homes Joiner.
Learn, relocate, and perceive condo rentals in Hickory Plains United States, Hickory Plains United States home rentals, and vacation rental in Hickory Plains.
|
|
