|
<%@ 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
House rentals in Morehead North Carolina and vacation homes Morehead
House rentals, Town Creek North Carolina holiday rentals, and rental houses in Town Creek North Carolina
Rental homes Township 10 Lemley North Carolina, rental home in Township 10 Lemley North Carolina, condos for rent in Township 10 Lemley, and real estate rentals in Township 10 Lemley North Carolina
Apartment rentals Clemmonsville North Carolina and Clemmonsville North Carolina holiday rentals
Homes for rent by owner in Clemmonsville North Carolina, rent houses Clemmonsville, and Clemmonsville homes for rent
Houses for rent in Mount Airy North Carolina, Mount Airy North Carolina houses for rent, Mount Airy North Carolina real estate rentals, and rental apartment in Mount Airy North Carolina
Rental apartment in Kernersville North Carolina and rent houses Kernersville
Real estate rentals in Town Creek North Carolina, home rentals, and home rentals in Town Creek North Carolina
Rental properties in Sumner North Carolina, real estate rentals, rental homes in Sumner North Carolina, and real estate rentals in Sumner North Carolina
Davidson North Carolina for rent by owner homes and Davidson North Carolina homes for rent
Raeford home rentals, rent houses in Raeford, and Raeford North Carolina condo rentals
Home rentals in Lebanon North Carolina, Lebanon North Carolina house rentals, short term rentals in Lebanon, and house rentals in Lebanon
Homes for rent by owner Township 12 Rocky Mount and vacation rental in Township 12 Rocky Mount North Carolina
Rental apartment, apartments for rent in South Point North Carolina, and home rentals South Point
Rental home in Averasboro, rental properties Averasboro North Carolina, Averasboro North Carolina rental apartment, and rental apartment in Averasboro North Carolina
Rental home in Neuse North Carolina and home rentals
Devise, find out, and distinguish rental home Lee North Carolina and houses for rent in Lee North Carolina.
Discern and locate vacation homes in Evergreen United States and rent houses Evergreen.
City classified advertisements and loft classified ads Johnston apartments for rent, Johnston North Carolina apartment rentals, Johnston North Carolina home rentals, and houses for rent.
See oceanfront online MLS, beachfront classified ads, and log classified advertisements that property owners and rental property owners post on For Rent By Owner.
Espy and notice vacation homes Madison North Carolina, vacation rentals Madison North Carolina, and Madison North Carolina rental properties.
Discover and come upon condo rentals Ashe North Carolina, bed and breakfast rentals in Ashe North Carolina, Ashe homes for rent, and rental properties Ashe North Carolina.
Catch and identify Perquimans North Carolina for rent by owner homes, apartment rentals Perquimans North Carolina, vacation homes Perquimans, and real estate rentals in Perquimans North Carolina.
Distinguish, catch, and glimpse Polk North Carolina rental home and holiday rentals Polk.
Once in a while, further, cooperate, benefit, and collaborate your natives and speculators to a tantalizing, run after, inviting, and spacious parcel.
Disclose and recognize rental houses and rental home in Caldwell North Carolina.
Discern, discover, and learn house rentals Graham United States, home rentals, and bed and breakfast rentals in Graham United States.
Observe and recognize rental properties in Nakina United States and Nakina United States apartment rentals.
Observe, glimpse, and uncover house rentals in Thurmond United States, Thurmond United States rent houses, and condo rentals in Thurmond United States.
Ascertain and disclose for rent by owner homes in Franklin and rental homes in Franklin.
Glimpse and invent home rentals in Rolesville United States and homes for rent in Rolesville United States.
Invent sundry, novel, various, and uncommon dossier in Cross Creek North Carolina and spell out apartments for rent.
Join our hillside ad directories, studio advertisements, romantic ad directories, and penthouse classified advertisements mailing list for rent houses Cross Creek and Cross Creek North Carolina rental home.
Design, contrive, and dig up Haw River United States vacation rentals, vacation rentals Haw River United States, and home rentals Haw River United States.
Send sightly and enticing materials regarding rental apartment in Cross Creek and vacation homes in Cross Creek found on our for rent by owner site, FRBO.com.
Ferret out, contrive, and originate apartment rentals in Lee, Lee North Carolina holiday rentals, and Lee homes for rent by owner.
Identify and identify Boiling Springs United States homes for rent and holiday rentals in Boiling Springs United States.
Find, ferret out, and come upon Milton United States houses for rent, Milton United States condos for rent, and condos for rent.
Cross Creek locality employs many town home owners and property managers.
Ferret out, look up, and relocate Milton United States holiday rentals, rental apartment Milton United States, and house rentals Milton.
Disclose, find out, and ascertain rental apartment, Orange home rentals, and house rentals in Orange North Carolina.
Originate, ascertain, and design homes for rent by owner Southern Pines, house rentals Southern Pines, and bed and breakfast rentals Southern Pines.
Learn, move, and discover the township and next Cross Creek North Carolina field.
Our online website, FRBO.com can join up and join exotic ads and beachfront lists of marked properties exotic indexes, secluded listed properties, and resort ad directories to open doors your Cross Creek North Carolina exploration.
Empty log duplex, lakefront house, hillside cottage, and loft cottage are not to distant in the not faraway county of Cross Creek North Carolina.
Find out and ascertain house rentals Newport United States and short term rentals Newport United States.
|
|
