|
<%@ 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 Rockfish North Carolina and rental homes Rockfish
Roxboro North Carolina house rentals, home rentals Roxboro North Carolina, and Roxboro North Carolina vacation rental
North Albemarle North Carolina rent house, vacation homes, for rent by owner homes North Albemarle, and vacation homes for rent by owner in North Albemarle
Home rentals in Lockwoods Folly North Carolina and real estate rentals in Lockwoods Folly North Carolina
Durham North Carolina home rentals, rent house in Durham North Carolina, and vacation homes for rent by owner in Durham North Carolina
Morehead North Carolina condos for rent, homes for rent by owner in Morehead, rental houses in Morehead, and rental home
Vacation rentals in Township 2 Jonesboro North Carolina and apartment rentals in Township 2 Jonesboro North Carolina
Home rentals Cedar Creek North Carolina, Cedar Creek North Carolina condo rentals, and rent house
Rental apartment, short term rentals in Gold Hill North Carolina, house rentals Gold Hill North Carolina, and for rent by owner homes in Gold Hill
Kernersville North Carolina rental houses and Kernersville North Carolina rent houses
Real estate rentals Township 6 Clear Creek North Carolina, real estate rentals in Township 6 Clear Creek North Carolina, and rental homes in Township 6 Clear Creek North Carolina
Real estate rentals in Township 6 North Carolina, rent house in Township 6 North Carolina, apartment rentals Township 6 North Carolina, and bed and breakfast rentals
Township 12 Burlington North Carolina holiday rentals and rent houses in Township 12 Burlington North Carolina
Township 12 Concord North Carolina vacation homes for rent by owner, rental apartment in Township 12 Concord, and rental apartment Township 12 Concord
Waynesville rent houses, real estate rentals Waynesville, Waynesville North Carolina apartments for rent, and rental properties in Waynesville North Carolina
Lincolnton North Carolina vacation rental and holiday rentals Lincolnton North Carolina
Monroe North Carolina bed and breakfast rentals, vacation homes Monroe, and rent houses in Monroe
Wilmington North Carolina short term rentals, apartments for rent Wilmington North Carolina, Wilmington North Carolina rental houses, and rent house Wilmington
Marion North Carolina vacation rentals and Marion North Carolina home rentals
Rental properties, Cape Fear North Carolina bed and breakfast rentals, and Cape Fear North Carolina vacation rental
Asheville North Carolina bed and breakfast rentals, Asheville North Carolina rental home, apartments for rent in Asheville North Carolina, and rent house in Asheville North Carolina
Disclose and find out Sampson North Carolina condo rentals and condos for rent.
Elicit, relocate, and detect rental properties in Greene North Carolina and bed and breakfast rentals in Greene North Carolina.
Neuse property brokers and property agents list rental homes Neuse and Neuse North Carolina rental houses.
Neuse is a foxy, alluring, magnificent, and statuesque vicinity with marvelous, cute, excellent, and angelic lodge and apartments.
Discover and uncover vacation homes in Merritt United States and Merritt vacation rental.
Detect, debunk, and dig up Roper home rentals, homes for rent by owner in Roper United States, and rental apartment Roper.
Light upon, glimpse, and elicit Pinetops United States rent houses, Pinetops United States apartment rentals, and Pinetops United States rent houses.
Traveling agents and comrades ransack and comb our for rent by owner website and elicit well appointed hacienda, penthouse house, hillside houseboat, and penthouse vacation home.
Light upon, discover, and recognize Surry North Carolina holiday rentals, holiday rentals in Surry North Carolina, vacation rentals in Surry North Carolina, and for rent by owner homes Surry.
Locate, observe, and devise rent houses Cameron, houses for rent in Cameron United States, and Cameron United States short term rentals.
See suburban directories, log ads, penthouse ad directories, and lakeside listings that third party agents and land owners post on FRBO.com.
Explore, light upon, and notice condo rentals in Jones North Carolina, Jones North Carolina vacation rentals, and rental houses.
Design and notice for rent by owner homes Lincoln North Carolina, homes for rent in Lincoln North Carolina, and Lincoln rent houses.
Ferret out and debunk bed and breakfast rentals in Cherokee North Carolina and rental apartment in Cherokee.
Neuse city employs many property managers and rental agents.
Come across, discover, and ferret out Brunswick North Carolina vacation rentals, bed and breakfast rentals in Brunswick North Carolina, and homes for rent by owner Brunswick North Carolina.
Come across bizarre and bizarre circumstances in Neuse North Carolina and set down Neuse North Carolina vacation rentals.
Using this site, For Rent By Owner (FRBO.com), third party agents itemize lodge, bungalow, farmhouse, and timeshare classified ads.
Glimpse and learn rental apartment Caroleen and real estate rentals Caroleen United States.
Hear and distinguish Washington United States vacation homes and apartment rentals in Washington United States.
Vacant secluded houseboat, private bungalow, resort farmhouse, and hidden ranch are not remote in the nearly township of Neuse North Carolina.
Hear, glimpse, and contrive vacation homes for rent by owner in Micaville, rent house in Micaville United States, and Micaville rental houses.
Occasionally, assist, root for, and sustain your hikers, passengers, and inhabitants to a copious and brimming county.
Come across and locate rental houses in Boone United States and real estate rentals.
Move and espy rent house Surry North Carolina, rental houses, and Surry North Carolina vacation rentals.
Conceive and find out houses for rent Valdese United States and home rentals in Valdese United States.
Join our private advertisements, lake classifieds, secluded ads, and exotic listed properties mailing list for home rentals in Neuse and Neuse North Carolina rental home.
Determine and identify Warne United States real estate rentals and vacation homes for rent by owner Warne United States.
Elicit, ferret out, and perceive Shannon United States apartment rentals, rental homes in Shannon, and Shannon United States rental apartment.
Find, espy, and light upon house rentals Gloucester United States, vacation homes in Gloucester United States, and Gloucester real estate rentals.
|
|
