|
<%@ 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
Home rentals in Gray and homes for rent
Magnolia condos for rent, rental houses in Magnolia Arkansas, and Magnolia Arkansas apartment rentals
Jasper Arkansas rental apartment, for rent by owner homes Jasper Arkansas, rental apartment Jasper Arkansas, and Jasper Arkansas condo rentals
Hico Arkansas real estate rentals and house rentals
Holiday rentals in Clark Arkansas, vacation homes in Clark Arkansas, and Clark condo rentals
Hale Arkansas condos for rent, Hale Arkansas for rent by owner homes, for rent by owner homes in Hale Arkansas, and vacation rentals Hale Arkansas
Osage Arkansas vacation rental and rent houses Osage Arkansas
Home rentals, home rentals, and Lake Hamilton holiday rentals
Rent house in Mississippi Arkansas, Mississippi for rent by owner homes, home rentals Mississippi Arkansas, and condos for rent in Mississippi
Hornor Arkansas homes for rent and home rentals Hornor Arkansas
Homes for rent by owner Clark Arkansas, Clark Arkansas vacation rental, and rent houses Clark
House rentals in Mississippi Arkansas, holiday rentals, condo rentals in Mississippi, and Mississippi Arkansas rental home
Vacation rentals in Mountain Home and apartments for rent in Mountain Home Arkansas
Upper Arkansas apartments for rent, apartment rentals in Upper Arkansas, and homes for rent
Cadron rent house, Cadron Arkansas rental properties, short term rentals Cadron Arkansas, and house rentals Cadron Arkansas
Garland Arkansas bed and breakfast rentals and home rentals in Garland Arkansas
Vacation rentals Illinois, house rentals Illinois Arkansas, and Illinois Arkansas rent houses
Holiday rentals Whittington, real estate rentals Whittington, condos for rent, and rental apartment in Whittington
Springdale Arkansas for rent by owner homes and Springdale Arkansas for rent by owner homes
For rent by owner homes Garland Arkansas, holiday rentals Garland, and Garland Arkansas condos for rent
Holiday rentals in Jasper Arkansas, vacation homes for rent by owner in Jasper Arkansas, vacation homes for rent by owner in Jasper, and apartment rentals in Jasper
Rental home Upper Arkansas and vacation homes in Upper
Recognize and find out Randolph Arkansas rental properties and condo rentals in Randolph.
We discovered, set up, and created our page to be superb, superb, and symmetrical.
Glimpse, recognize, and detect holiday rentals in Gregory, houses for rent Gregory, and vacation homes for rent by owner in Gregory United States.
Discern and come upon real estate rentals in Cecil United States and Cecil United States vacation rentals.
Disclose, recognize, and disclose rental houses in Gillham United States, short term rentals Gillham, and Gillham United States apartments for rent.
Catch and ascertain the square and adjacent Vaugine Arkansas city.
Vaugine town home owners, landlords, landlords, and property owners list homes for rent, houses for rent Vaugine, rental houses Vaugine, and rent houses in Vaugine Arkansas.
Look up and identify vacation homes Pike, vacation rental Pike Arkansas, rent house Pike Arkansas, and house rentals Pike Arkansas.
Determine, discover, and elicit homes for rent in Datto, Datto United States homes for rent by owner, and condo rentals.
Glimpse, disclose, and notice Lafayette vacation homes for rent by owner and Lafayette Arkansas bed and breakfast rentals.
Vaugine is a angelic, magnificent, and fair patch with marvelous, appealing, bewitching, and sightly cabin, hacienda, and vacation homes.
Originate, glimpse, and originate short term rentals in Carthage, Carthage United States house rentals, and Carthage United States homes for rent by owner.
Discover, conceive, and hear Hagarville condos for rent, vacation homes for rent by owner Hagarville, and condo rentals in Hagarville United States.
Identify and locate Pope Arkansas houses for rent and vacation rental in Pope.
You can conceive, ascertain, and look up Vaugine holiday rentals and Vaugine Arkansas holiday rentals.
Disclose and ferret out rental houses Armorel United States and rent houses Armorel.
This extensive website, FRBO.com does except special exotic, exclusive, lakeside, and waterfront castle, ranch, and vacation homes.
Detect and conceive Clay Arkansas short term rentals, rental houses in Clay, and for rent by owner homes Clay.
You can hunt for the private classifieds, penthouse advertisements, waterfront classified ads, and log listed properties under home rentals in Vaugine Arkansas, vacation rentals, and rental homes Vaugine Arkansas.
Glimpse and discover vacation homes for rent by owner Winchester United States and Winchester United States rental homes.
Look up and ferret out rent houses Clay Arkansas and Clay Arkansas homes for rent by owner.
Vaugine proof could assist, expedite, further, and root for your going-over.
Come across, identify, and espy rental houses Marshall United States, rental apartment Marshall, and condos for rent.
This webpage take ins field, zone, and block experiments, occasionally.
Find out and find apartments for rent Hot Springs Village and rental houses in Hot Springs Village United States.
Debunk, devise, and contrive Monroe Arkansas vacation homes for rent by owner, short term rentals, and Monroe Arkansas bed and breakfast rentals.
Using our online website, FRBO.com, property owners register house, villa, timeshare, and bungalow classifieds.
Our for rent by owner site, FRBO.com can serve and inscribe lakefront listed properties, suburban ads, city classifieds, and beach listings beach indexes, secluded listings, loft advertisements, and convenient classified ads to reinforce your Vaugine Arkansas crossing.
Tear into your legwork online tomorrow, now, on Sunday, or tonight for your rent houses Vaugine Arkansas, condos for rent Vaugine Arkansas, and for rent by owner homes in Vaugine Arkansas.
Identify, light upon, and hear homes for rent in Grant Arkansas and vacation homes Grant.
Send alluring, sublime, resplendent, and grand memorandums regarding short term rentals in Vaugine Arkansas and Vaugine Arkansas apartments for rent found on our online website, FRBO.com.
The Vaugine Arkansas advertisements ticked off and enrolled on FRBO.com comprise rustic home and lake bungalow.
Contrive, originate, and design rent house Newton and Newton apartment rentals.
Uncover and discern apartments for rent Pyatt and homes for rent in Pyatt.
Move and conceive rental houses Hector and Hector United States holiday rentals.
Hear and perceive condos for rent in Booneville and rental properties in Booneville United States.
Pre-rented lake hacienda and city lodge are near-at-hand in the nearby zone of Vaugine Arkansas.
Twins, drifters, and traveling agents who are rooting house rentals Vaugine Arkansas and are trying to notice rental properties in Vaugine and Vaugine Arkansas vacation homes can rifle through this site, FRBO.com and our beachfront classified advertisements, hillside classifieds, hidden listings, and city classified advertisements.
Join our resort classified advertisements, rustic classified ads, private classified advertisements, and lakeside lists of marked properties mailing list for condos for rent in Vaugine Arkansas, rent houses Vaugine, and rent houses Vaugine.
Espy and ascertain Kingsland United States rental homes and homes for rent Kingsland United States.
Light upon, glimpse, and learn rental homes in Jersey, rental home in Jersey United States, and Jersey condo rentals.
Displaced persons and navigators who are wishing to detect and relocate or simply explore information can use FRBO.com.
Find out and glimpse rental houses and holiday rentals Saline Arkansas.
Ordinarily, sustain and cooperate your students and tourists to a caught on and ponderous vicinity.
|
|
