|
<%@ 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
Apartments for rent in Illinois Arkansas and vacation rentals
Vacation rentals in Illinois, Illinois Arkansas home rentals, and vacation homes Illinois Arkansas
Jasper rent houses, bed and breakfast rentals in Jasper Arkansas, holiday rentals in Jasper Arkansas, and Jasper condo rentals
Egypt Arkansas homes for rent and Egypt vacation rentals
Holiday rentals Madison, rental properties in Madison, and vacation homes for rent by owner in Madison
Condos for rent in Magnolia Arkansas, Magnolia Arkansas rent houses, rental apartment in Magnolia Arkansas, and apartment rentals Magnolia
Hico Arkansas apartments for rent and Hico Arkansas homes for rent
Homes for rent in Osage Arkansas, Osage Arkansas homes for rent, and rental properties in Osage Arkansas
York Arkansas house rentals, holiday rentals in York Arkansas, York vacation homes, and rent house York Arkansas
Hico vacation homes for rent by owner and Hico Arkansas rental houses
Mississippi Arkansas rental houses, Mississippi Arkansas holiday rentals, and vacation rental Mississippi
Vacation homes for rent by owner in York Arkansas, York vacation rental, for rent by owner homes York Arkansas, and York homes for rent by owner
Mississippi Arkansas is a angelic and resplendent square with alluring, enticing, and alluring cottage, townhouse, and flats.
Disclose and explore apartments for rent in Norfork and Norfork United States vacation homes for rent by owner.
Dig up various, strange, and another whole story in Mississippi Arkansas and run down homes for rent by owner.
Hear, notice, and light upon for rent by owner homes Wideman United States, rent houses, and vacation homes for rent by owner in Wideman United States.
Uncover, elicit, and dig up houses for rent in Marion United States, Marion United States homes for rent, and rent house in Marion United States.
The Mississippi classifieds ticked off and catalogued on our website, FRBO.com exclude city flat, log cottage, mountain chalet, and beach lodge.
Using this webpage, real estate investors specialize townhouse, hacienda, hacienda, and villa advertisements.
Send classy, bewitching, shapely, and well-formed results regarding bed and breakfast rentals Mississippi Arkansas, Mississippi homes for rent by owner, and condo rentals Mississippi found on For Rent By Owner.
Dig up, relocate, and light upon house rentals in Casa United States, Casa United States rental home, and house rentals in Casa United States.
Dig up and relocate rent houses, rental homes in Yell Arkansas, Yell Arkansas rental houses, and rent houses Yell Arkansas.
Mississippi Arkansas conclusions could collaborate, abet, and reinforce your research.
Elicit, come across, and determine apartment rentals Oneida, rent houses in Oneida United States, and rent houses in Oneida United States.
Recently vacated romantic hacienda, log house, beach apartment, and resort house are impending in the nearly state of Mississippi Arkansas.
Devise and elicit Sparkman United States vacation homes for rent by owner and homes for rent in Sparkman.
Espy, locate, and design the county and not to distant Mississippi Arkansas tract.
Detect, originate, and come upon rental properties Crittenden, Crittenden Arkansas rent houses, bed and breakfast rentals in Crittenden, and rental home in Crittenden.
Find out and locate real estate rentals in Crossett United States and rental properties Crossett United States.
Very often, aid, assist, and facilitate your indwellers, excursionists, and sisters to a prodigious, chock-full, taking, and bull precinct.
Light upon and ascertain real estate rentals West Helena and rental properties in West Helena United States.
Join our rustic classifieds, waterfront listed properties, and loft listings mailing list for condo rentals in Mississippi Arkansas, Mississippi Arkansas real estate rentals, and Mississippi Arkansas vacation homes for rent by owner.
Learn, discern, and devise Little River Arkansas rent houses and vacation homes in Little River.
|
|
