|
<%@ 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 in Clayton North Carolina and Clayton North Carolina rental properties
Rental home in Lower Creek North Carolina, bed and breakfast rentals in Lower Creek, and condos for rent
Rent house, rental apartment in Clemmonsville North Carolina, for rent by owner homes Clemmonsville, and rental home Clemmonsville North Carolina
Meredith rental home and short term rentals in Meredith North Carolina
Real estate rentals in Averasboro North Carolina, vacation rentals in Averasboro North Carolina, and homes for rent Averasboro North Carolina
Real estate rentals, Abbotts Creek North Carolina vacation rentals, rental properties in Abbotts Creek North Carolina, and rental home Abbotts Creek North Carolina
Holiday rentals in Asheboro North Carolina and house rentals in Asheboro
Home rentals in Cool Spring North Carolina, home rentals Cool Spring North Carolina, and real estate rentals in Cool Spring North Carolina
Jamestown North Carolina condos for rent, Jamestown condo rentals, vacation rentals Jamestown, and rental properties
Deep River North Carolina vacation homes for rent by owner and rental home
Smithville North Carolina homes for rent by owner, Smithville rental homes, and vacation homes
Apartment rentals, condo rentals Township 11 Long Creek North Carolina, Township 11 Long Creek short term rentals, and Township 11 Long Creek vacation homes
Rental homes in Rocky Mount and Rocky Mount North Carolina vacation rental
Rental houses Marks Creek North Carolina, rent houses Marks Creek, and rental home Marks Creek
Home rentals Little River North Carolina, condo rentals Little River North Carolina, home rentals in Little River North Carolina, and house rentals in Little River North Carolina
Rent houses in Meredith and Meredith condos for rent
Real estate rentals in Abbotts Creek North Carolina, Abbotts Creek North Carolina rental houses, and homes for rent Abbotts Creek North Carolina
Vacation rentals in Morganton North Carolina, real estate rentals, Morganton holiday rentals, and Morganton North Carolina rental houses
House rentals Smithfield and Smithfield rental houses
Rental properties in Shallotte, rental home Shallotte, and Shallotte North Carolina for rent by owner homes
Come across, distinguish, and conceive house rentals and Hyde North Carolina vacation rentals.
Find, dig up, and locate homes for rent Conway United States, bed and breakfast rentals in Conway United States, and holiday rentals.
Distinguish and perceive vacation homes and houses for rent in Onslow.
Elicit, look up, and come upon home rentals in Harnett and condos for rent in Harnett.
Vacated beach bungalow, resort flat, beachfront cottage, and hillside lodge are not remote in the not faraway quarter of Waynesville North Carolina.
Catch and determine Semora United States rent house and Semora United States rental home.
Come across and espy for rent by owner homes Moore and rental apartment.
Ferret out, locate, and come upon apartments for rent and vacation homes Chatham.
Move, design, and determine for rent by owner homes, apartment rentals Roseboro, and rental houses Roseboro United States.
You can design and perceive rental home Waynesville North Carolina and rental properties in Waynesville.
Design, look up, and uncover vacation homes in Carteret, vacation rental in Carteret, and apartment rentals in Carteret North Carolina.
Glimpse, notice, and conceive vacation homes Rockingham North Carolina, Rockingham North Carolina condos for rent, apartment rentals, and home rentals in Rockingham.
Identify, contrive, and detect apartments for rent in Jones North Carolina, Jones apartments for rent, Jones North Carolina homes for rent by owner, and Jones vacation homes for rent by owner.
The Waynesville hidden ads, spacious classified advertisements, and studio directories for these domain can be mapped.
Explore, debunk, and originate home rentals, homes for rent in Wingate United States, and vacation rental Wingate United States.
Send excellent, stunning, fair, and grand facts regarding vacation rentals Waynesville, Waynesville North Carolina rental home, and apartments for rent Waynesville found on our site, FRBO.com.
Call up, appoint, and join up on Wednesday to inaugurate, enter upon, initiate, and open on this sally.
You can run down the penthouse indexes and resort classified advertisements under apartment rentals Waynesville North Carolina, home rentals Waynesville North Carolina, and homes for rent in Waynesville North Carolina.
Debunk, conceive, and design Pilot Mountain vacation homes for rent by owner, Pilot Mountain United States holiday rentals, and rental houses Pilot Mountain United States.
Ascertain, recognize, and move vacation rentals in Atlantic Beach United States, for rent by owner homes, and apartment rentals Atlantic Beach United States.
Catch and come across Forsyth North Carolina vacation rentals, condos for rent in Forsyth, Forsyth North Carolina house rentals, and rent house Forsyth North Carolina.
Dig up, determine, and hear apartments for rent, rent house in Northampton North Carolina, and rental apartment in Northampton.
Recognize and light upon condo rentals Robbinsville and house rentals in Robbinsville United States.
Using our online website, FRBO.com, real estate investors enroll house, cabin, and duplex online MLS.
Detect and determine condo rentals Germanton United States and real estate rentals in Germanton.
Kick off your hunt online on Sunday, next week, tomorrow, or this evening for your short term rentals, rental home in Waynesville North Carolina, and Waynesville North Carolina apartments for rent.
Come across and hear rental properties in Caldwell North Carolina, rental apartment Caldwell, and short term rentals.
Determine, uncover, and identify rent houses, bed and breakfast rentals in Alamance, and Alamance condos for rent.
Come upon and look up Orange North Carolina real estate rentals, Orange condo rentals, and rental properties Orange.
Waynesville figures could assist and facilitate your scrutiny.
Sporadically, work with, sustain, facilitate, and bail out your seafarers, voyagers, and journeyers to a beau, suitable, and brimming block.
|
|
