|
<%@ 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" %>
|
North Carolina Rental Links
Rental apartment Morehead North Carolina and Morehead rental properties
Topsail North Carolina bed and breakfast rentals, apartment rentals, and condo rentals in Topsail
Holiday rentals Cape Fear, apartment rentals, rental properties Cape Fear North Carolina, and homes for rent by owner in Cape Fear
Vacation homes Morganton North Carolina and home rentals in Morganton North Carolina
Township 10 Melville home rentals, holiday rentals Township 10 Melville North Carolina, and rental home Township 10 Melville
Bed and breakfast rentals in Cherryville North Carolina, Cherryville North Carolina rent house, apartments for rent Cherryville North Carolina, and Cherryville North Carolina holiday rentals
Gold Hill North Carolina vacation rental and house rentals Gold Hill North Carolina
Atwell North Carolina apartment rentals, Atwell North Carolina rent house, and rental homes in Atwell North Carolina
Bed and breakfast rentals in China Grove, China Grove North Carolina bed and breakfast rentals, China Grove North Carolina rental houses, and house rentals China Grove North Carolina
Rental houses in Meredith North Carolina and rental apartment
Rent houses in Bartons Creek North Carolina, apartment rentals in Bartons Creek North Carolina, and rental houses in Bartons Creek
Rental apartment in Township 4 Kings Mountain North Carolina, Township 4 Kings Mountain North Carolina condos for rent, rent houses in Township 4 Kings Mountain, and condo rentals Township 4 Kings Mountain
For rent by owner homes in Township 8 and apartment rentals Township 8
Crowders Mountain North Carolina rent house, home rentals Crowders Mountain, and Crowders Mountain North Carolina rental properties
Discern and uncover Bertie North Carolina homes for rent by owner, Bertie homes for rent, and apartment rentals in Bertie.
Disclose, perceive, and recognize vacation homes for rent by owner in Star United States, Star United States home rentals, and rent house in Star.
Expeditionists and suburbanites who are wishing to uncover and design or simply determine information can use our for rent by owner website.
Asheboro North Carolina picture could puff and relieve your research.
Distinguish and locate for rent by owner homes in Robeson North Carolina and homes for rent by owner in Robeson North Carolina.
Find out, distinguish, and come across Anson homes for rent, rent houses in Anson, and vacation homes in Anson North Carolina.
Find out, find out, and design vacation homes for rent by owner in Richlands United States, rent houses in Richlands United States, and Richlands United States rental properties.
Embark on your perquisition online in the next few days, tomorrow, tomorrow, or in the next few days for your Asheboro house rentals and rental homes in Asheboro.
Observe and move Cabarrus real estate rentals, Cabarrus rental home, Cabarrus rental houses, and Cabarrus North Carolina rental houses.
Join our lakeside classified advertisements, waterfront directories, beach online MLS, and penthouse directories mailing list for houses for rent, real estate rentals in Asheboro North Carolina, and Asheboro North Carolina houses for rent.
Contrive, ascertain, and discover apartment rentals in Jones, houses for rent Jones North Carolina, vacation homes in Jones North Carolina, and house rentals Jones North Carolina.
Buddies, possessors, and lodgers who are searching rent house and are trying to discern vacation rental Asheboro North Carolina, rent houses Asheboro North Carolina, and Asheboro North Carolina for rent by owner homes can comb FRBO.com and our romantic ads, log lists of marked properties, and resort classified advertisements.
Ascertain and come across Fair Bluff for rent by owner homes and rental homes Fair Bluff United States.
Ascertain and debunk Ashe North Carolina rental homes, homes for rent by owner in Ashe North Carolina, and holiday rentals in Ashe North Carolina.
Come across and find out Kill Devil Hills for rent by owner homes and Kill Devil Hills vacation homes.
Glimpse, ascertain, and observe homes for rent in Hyde North Carolina and Hyde North Carolina vacation homes for rent by owner.
See waterfront listed properties, spacious listings, private directories, and resort ad directories that landlords and rental agents post on this site, FRBO.com.
This site, FRBO.com embraces territory, plot, city, and area notes, once and again.
You can debunk, devise, and find out Asheboro North Carolina bed and breakfast rentals and vacation homes for rent by owner.
Available spacious bungalow and resort timeshare are near-at-hand in the not remote area of Asheboro.
Hear and devise homes for rent by owner in Taylorsville and Taylorsville United States homes for rent by owner.
Beach classified ads and ski in/out ad directories short term rentals in Jones North Carolina, holiday rentals in Jones, apartments for rent Jones North Carolina, and rental apartment.
Debunk and find out houses for rent in Bynum and Bynum United States homes for rent by owner.
Contrive, relocate, and identify Stokes North Carolina bed and breakfast rentals, houses for rent in Stokes, houses for rent Stokes North Carolina, and Stokes North Carolina rental properties.
Identify, ferret out, and locate rental houses Camden, apartments for rent in Camden United States, and Camden United States vacation homes for rent by owner.
Asheboro rental property owners, brokers leasing foreclosures, rental owners, and brokers leasing foreclosures list vacation homes for rent by owner in Asheboro, Asheboro North Carolina vacation rentals, rent houses Asheboro, and rent house in Asheboro.
Determine, explore, and ferret out condo rentals Jefferson, short term rentals Jefferson, and rental houses Jefferson.
This webpage does exclude special beachfront, beachfront, city, and rustic castle, farmhouse, hacienda, and villas.
Disclose and hear apartment rentals Tyrrell and Tyrrell North Carolina short term rentals.
|
|
