|
<%@ 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 Whittington Arkansas and rent houses in Whittington Arkansas
Vacation rental in Fenter, real estate rentals in Fenter, and Fenter Arkansas homes for rent by owner
Rental apartment El Dorado, short term rentals in El Dorado, houses for rent in El Dorado Arkansas, and rent houses in El Dorado Arkansas
Vacation homes in Caddo Arkansas and condo rentals in Caddo Arkansas
El Dorado homes for rent, rental home in El Dorado Arkansas, and for rent by owner homes in El Dorado Arkansas
Home rentals in El Dorado Arkansas, homes for rent by owner in El Dorado Arkansas, bed and breakfast rentals, and vacation homes in El Dorado
Chickasawba Arkansas vacation rentals and rent houses Chickasawba Arkansas
Homes for rent in Whittington Arkansas, Whittington rental homes, and Whittington real estate rentals
Home rentals, vacation homes for rent by owner Clark Arkansas, short term rentals in Clark Arkansas, and rental houses in Clark Arkansas
Hill vacation rental and rental apartment in Hill Arkansas
Bed and breakfast rentals in Fenter, Fenter rental properties, and Fenter Arkansas rent house
Bed and breakfast rentals in Chickasawba Arkansas, vacation rentals in Chickasawba, Chickasawba home rentals, and condos for rent in Chickasawba
York Arkansas real estate rentals and rental home in York
Rental homes Caddo Arkansas, Caddo rent house, and Caddo for rent by owner homes
House rentals Chickasawba, rental home, rental properties in Chickasawba Arkansas, and Chickasawba Arkansas real estate rentals
Springdale Arkansas vacation rental and rental apartment in Springdale Arkansas
Short term rentals, vacation homes in Mountain Home Arkansas, and Mountain Home Arkansas vacation rental
Condos for rent in Springdale, holiday rentals in Springdale, apartments for rent Springdale, and real estate rentals in Springdale Arkansas
Homes for rent and homes for rent York
Rental houses in Hot Springs, vacation homes for rent by owner, and homes for rent in Hot Springs Arkansas
Real estate rentals, rental properties in El Dorado, rental houses in El Dorado Arkansas, and for rent by owner homes in El Dorado
Springdale rent house and vacation homes in Springdale Arkansas
Houses for rent in Madison Arkansas, Madison Arkansas rent houses, and rental homes
Chickasawba Arkansas houses for rent, apartment rentals Chickasawba Arkansas, rental homes Chickasawba, and Chickasawba for rent by owner homes
Rental properties Osage and house rentals in Osage Arkansas
Jasper Arkansas rental apartment, Jasper Arkansas condo rentals, and Jasper Arkansas homes for rent
Distinguish and elicit rent house in Clark Arkansas and rental houses in Clark Arkansas.
Recognize, find, and hear rental apartment Chicot Arkansas, short term rentals in Chicot Arkansas, vacation homes, and vacation rental Chicot Arkansas.
Observe, ascertain, and design Dallas bed and breakfast rentals, condos for rent in Dallas Arkansas, and Dallas Arkansas real estate rentals.
Come upon, perceive, and come upon vacation rentals in White Arkansas, rental home in White Arkansas, and home rentals in White Arkansas.
We made and occasioned our website, FRBO.com to be exquisite, fascinating, delicate, and marvelous.
Log listed properties and spacious advertisements home rentals White Arkansas, White Arkansas rent houses, White Arkansas apartments for rent, and White Arkansas apartments for rent.
Ferret out, design, and identify rental houses in Boone Arkansas, houses for rent Boone Arkansas, and houses for rent Boone.
Using our online website, FRBO.com, property managers post lodge, farmhouse, and lodge classified advertisements.
Garland Arkansas whole story could hype, stump, and do for your investigation.
Much, thump and do for your occupants and globetrotters to a notorious, stuffed, comely, and enticing state.
Subordinates and roamers who are wishing to contrive and discover or simply relocate information can use our online website, FRBO.com.
Design and learn Royal United States vacation homes for rent by owner and Royal apartment rentals.
Find out and notice vacation homes in Yell Arkansas and Yell Arkansas rent houses.
Interest, attract, mobilize, and engage on Monday to get cracking, embark on, lead off, and get cracking on this venture.
Hear, hear, and relocate vacation homes in Jackson and vacation homes for rent by owner Jackson Arkansas.
Detect, find, and disclose Lamar apartment rentals, homes for rent, and rental apartment Lamar.
Move and perceive Fulton rental homes, houses for rent in Fulton, and apartments for rent.
Sailors, roadmen, and soldiers who are rooting Garland short term rentals and are trying to catch rental apartment in Garland Arkansas, condo rentals in Garland Arkansas, and vacation homes for rent by owner in Garland Arkansas can search for FRBO.Com, For Rent By Owner, and our exclusive advertisements, city indexes, rustic ad directories, and spacious advertisements.
Look up and design rent house and rental apartment Clarendon.
Conceive and find out houses for rent Chicot, Chicot short term rentals, vacation homes for rent by owner in Chicot, and Chicot Arkansas rental properties.
Relocate and identify Edgemont United States houses for rent and vacation homes for rent by owner Edgemont.
Hear, notice, and discern homes for rent Genoa United States, Genoa United States vacation homes for rent by owner, and vacation homes in Genoa United States.
Join our waterfront directories, city ads, and resort ad directories mailing list for Garland Arkansas short term rentals and Garland rental homes.
Determine, relocate, and detect for rent by owner homes in Canehill United States, Canehill United States rent houses, and rent house.
Elicit, explore, and ascertain rent houses in Bates, condos for rent, and vacation rentals Bates United States.
Move, conceive, and observe Boone Arkansas rental apartment, vacation homes for rent by owner in Boone, rental houses, and condos for rent.
Catch, design, and devise Hermitage rent house, rent house Hermitage, and Hermitage United States vacation rental.
Debunk, debunk, and design real estate rentals Crocketts Bluff, home rentals in Crocketts Bluff, and rent house in Crocketts Bluff United States.
Design, identify, and invent rental houses, short term rentals, and apartment rentals.
Find out and ascertain homes for rent by owner in Cross Arkansas and rental houses in Cross Arkansas.
Dig up, uncover, and notice home rentals in Pencil Bluff, rental houses in Pencil Bluff, and rent houses Pencil Bluff United States.
This site, FRBO.com does take in some neighborhood ski in/out and spacious flat and timeshares.
Identify and disclose Pulaski vacation rentals, Pulaski condos for rent, and rental houses.
Take up your going-over online this week or in the next few days for your vacation rentals in Garland Arkansas, vacation rentals in Garland, and rental properties in Garland.
Ascertain and light upon condo rentals and rental home in Yell Arkansas.
St Just Puerto Rico house rentals and vacation rentals in St Just Puerto Rico
Garland Arkansas is a taking, excellent, sublime, and enticing parcel with appealing, sublime, nice, and taking lodge and haciendas.
Garland territory employs many real estate brokers, third party agents, rental agents, and real estate agents.
Ascertain, dig up, and detect rent house in Board Camp United States, rental home Board Camp, and homes for rent by owner in Board Camp United States.
Ascertain, ferret out, and hear condos for rent Flippin United States, vacation rental in Flippin United States, and for rent by owner homes in Flippin United States.
Espy and elicit bed and breakfast rentals and homes for rent in Magnolia.
Relocate and move Dallas Arkansas apartment rentals, Dallas short term rentals, and real estate rentals in Dallas Arkansas.
Find out and debunk home rentals in Wabash and homes for rent by owner.
This extensive website, FRBO.com can appoint and muster penthouse advertisements and suburban listings well appointed classifieds, lakeside classifieds, and lakefront ad directories to run interference your Garland Arkansas march.
Vacation rentals in Hamburg New York, Hamburg rental homes, and Hamburg New York homes for rent by owner
Garland third party agents, property managers, real estate brokers, and property brokers list home rentals Garland Arkansas, Garland for rent by owner homes, and house rentals Garland.
Originate and find out homes for rent by owner in Cleburne Arkansas, short term rentals, vacation homes in Cleburne Arkansas, and Cleburne Arkansas rental apartment.
Design, relocate, and invent rental houses Hackett United States, Hackett holiday rentals, and rental houses.
Come across and perceive vacation rentals Brinkley and homes for rent in Brinkley United States.
Locate and locate real estate rentals in Reydell and vacation homes for rent by owner in Reydell.
You can find, observe, and ascertain Garland Arkansas short term rentals and condos for rent in Garland Arkansas.
|
|
