|
<%@ 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
Bed and breakfast rentals China Grove and holiday rentals China Grove North Carolina
Topsail North Carolina for rent by owner homes, homes for rent by owner in Topsail North Carolina, and Topsail North Carolina condo rentals
Holiday rentals Limestone North Carolina, holiday rentals in Limestone North Carolina, real estate rentals in Limestone North Carolina, and Limestone North Carolina rental houses
Condo rentals Newton North Carolina and rental apartment Newton
Township 5 Providence North Carolina rental houses, Township 5 Providence short term rentals, and condos for rent in Township 5 Providence North Carolina
Apartments for rent St Marys North Carolina, rent house in St Marys North Carolina, vacation homes for rent by owner St Marys, and real estate rentals St Marys North Carolina
Condo rentals in Rockfish and real estate rentals Rockfish North Carolina
Apartment rentals Franklin, houses for rent Franklin, and Franklin North Carolina houses for rent
Leicester holiday rentals, bed and breakfast rentals in Leicester, homes for rent in Leicester North Carolina, and bed and breakfast rentals Leicester
Middle Creek North Carolina rental apartment and Middle Creek North Carolina short term rentals
Home rentals in Wilmington North Carolina, short term rentals in Wilmington North Carolina, and rental houses in Wilmington North Carolina
Home rentals in Triangle North Carolina, Triangle vacation rentals, rent houses, and rental houses
Homes for rent by owner Clemmonsville North Carolina and house rentals in Clemmonsville
Vacation rentals, Abbotts Creek North Carolina condo rentals, and apartment rentals in Abbotts Creek North Carolina
Locate and find out vacation homes in Montgomery North Carolina and vacation rental Montgomery.
Learn and debunk houses for rent Gates North Carolina, apartment rentals, house rentals in Gates North Carolina, and vacation rentals Gates.
Disclose, learn, and locate rental properties Cleveland, holiday rentals Cleveland, and rental homes Cleveland North Carolina.
Espy, move, and light upon Poplar Branch real estate rentals, vacation homes for rent by owner in Poplar Branch United States, and rental home in Poplar Branch.
This site, FRBO.com accommodates dominion, area, turf, and patch notes, infrequently.
Join our secluded lists of marked properties, studio classified advertisements, penthouse indexes, and rustic classifieds mailing list for rental homes, vacation rental in Atwell North Carolina, and Atwell rental homes.
Empty hidden house and lakeside duplex are adjacent in the imminent dominion of Atwell North Carolina.
You can determine and dig up rental houses in Atwell North Carolina, Atwell North Carolina rental homes, and bed and breakfast rentals in Atwell.
Atwell North Carolina is a ravishing, classy, magnificent, and refined locality with ideal and shapely flat, chalet, and ranchs.
See rustic classifieds, city ads, and private listed properties that landlords and property managers post on FRBO.Com, For Rent By Owner,.
Move and discern vacation rentals in Stokes North Carolina and Stokes real estate rentals.
Using our site, FRBO.com, agents serving the condo market record ranch, lodge, duplex, and townhouse directories.
Ascertain and ferret out rent houses in Wilson North Carolina, vacation rental in Wilson, and condos for rent in Wilson North Carolina.
Atwell county employs many town home owners, property owners, and brokers leasing foreclosures.
Devise and find vacation homes and condo rentals.
|
|
