|
<%@ 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
Asheboro North Carolina homes for rent and rental homes in Asheboro North Carolina
Brogden North Carolina for rent by owner homes, rental homes Brogden, and Brogden North Carolina apartment rentals
Cary North Carolina rent house, rental houses in Cary North Carolina, rental properties in Cary North Carolina, and Cary North Carolina apartments for rent
Wilmington North Carolina rental properties and Wilmington bed and breakfast rentals
Houses for rent Gold Hill North Carolina, apartments for rent in Gold Hill North Carolina, and Gold Hill North Carolina apartment rentals
Short term rentals, apartments for rent, Township 6 West Sanford North Carolina apartment rentals, and Township 6 West Sanford North Carolina vacation homes for rent by owner
Pembroke bed and breakfast rentals and Pembroke North Carolina house rentals
Vacation rental Deep River, Deep River house rentals, and real estate rentals in Deep River North Carolina
Condo rentals in Thomasville, Thomasville North Carolina apartment rentals, rental apartment in Thomasville North Carolina, and short term rentals in Thomasville
Vacation homes in Township 6 Shelby North Carolina and Township 6 Shelby North Carolina rent house
Oak Grove North Carolina short term rentals, Oak Grove North Carolina bed and breakfast rentals, and condo rentals Oak Grove North Carolina
Vacation rental, home rentals in Township 6 West Sanford North Carolina, Township 6 West Sanford North Carolina vacation homes, and apartments for rent Township 6 West Sanford North Carolina
Panther Branch houses for rent and Panther Branch homes for rent
Homes for rent by owner in Cherryville North Carolina, vacation rental Cherryville North Carolina, and Cherryville vacation rentals
Houses for rent Averasboro, rent houses in Averasboro North Carolina, rental apartment in Averasboro, and vacation rentals in Averasboro
Rental apartment in Winston and apartment rentals in Winston North Carolina
Upper Hominy North Carolina condos for rent, homes for rent in Upper Hominy, and rental home in Upper Hominy
Rent house in Camp Lejeune UT, Camp Lejeune UT North Carolina vacation rental, Camp Lejeune UT North Carolina homes for rent, and Camp Lejeune UT North Carolina apartment rentals
Homes for rent by owner in Meredith North Carolina and vacation rental
Vacation homes for rent by owner in Marion North Carolina, rental homes, and real estate rentals in Marion North Carolina
Our site, FRBO.com does hold bizarre beach, decadent, oceanfront, and convenient castle, bungalow, and flats.
Come upon and detect vacation homes and rent house Craven.
Beach classifieds and private lists of marked properties house rentals in Alexander North Carolina, Alexander North Carolina apartments for rent, homes for rent by owner in Alexander North Carolina, and real estate rentals.
Perceive and uncover Warren North Carolina real estate rentals, condo rentals in Warren North Carolina, and apartments for rent.
Find, invent, and ferret out apartment rentals, houses for rent in Jonesville United States, and holiday rentals in Jonesville United States.
Buddies and fraternity members who are wishing to identify and uncover or simply discover information can use this website, FRBO.com.
Clayton North Carolina is a fine, beauteous, and foxy kingdom with stunning and refined cabin, vacation home, and townhouses.
Suburbanites, brothers-in-law, and inhabitants who are looking Clayton house rentals and are trying to dig up short term rentals in Clayton North Carolina and rent houses Clayton North Carolina can inquire this site, For Rent By Owner (FRBO.com) and our hidden ad directories, resort ads, beachfront lists of marked properties, and well appointed classified advertisements.
Glimpse and debunk Rowland United States vacation homes for rent by owner and Rowland United States home rentals.
Devise, hear, and contrive bed and breakfast rentals, rental properties in Middlesex United States, and Middlesex United States rental apartment.
Espy and distinguish Macon North Carolina apartment rentals and short term rentals in Macon.
Using our online website, FRBO.com, agents enroll home, ranch, and townhouse classifieds.
Light upon and determine rental home in Holly Ridge and vacation rentals Holly Ridge.
Invent, perceive, and ferret out rental home Transylvania North Carolina, real estate rentals Transylvania North Carolina, and condos for rent in Transylvania.
Ascertain and determine vacation homes Laurel Springs United States and Laurel Springs bed and breakfast rentals.
Discern, catch, and determine houses for rent Henderson, Henderson condo rentals, and condo rentals in Henderson.
The Clayton North Carolina online MLS numerated and enrolled on our page eliminate decadent duplex, spacious hacienda, secluded cottage, and hidden home.
Launch your legwork online day after tomorrow, on Thursday, on Monday, or tomorrow for your Clayton North Carolina short term rentals, vacation rentals in Clayton North Carolina, and Clayton for rent by owner homes.
Invent, look up, and discover Millers Creek home rentals, rental homes in Millers Creek, and vacation homes for rent by owner in Millers Creek United States.
Originate, discern, and uncover rental home in Burgaw, homes for rent in Burgaw United States, and holiday rentals in Burgaw United States.
You can search for the ski in/out ad directories, romantic advertisements, mountain advertisements, and lake listings under short term rentals, condos for rent in Clayton, and rent house Clayton North Carolina.
Light upon and ferret out vacation homes for rent by owner in Kenansville and real estate rentals.
Devise, invent, and discern Swain bed and breakfast rentals and rental houses Swain.
Observe and conceive rental homes Pitt North Carolina, Pitt homes for rent, rental houses, and rental homes Pitt North Carolina.
Identify, originate, and discern rental home in Yadkin North Carolina and Yadkin North Carolina vacation homes.
Move and ascertain McDowell houses for rent and for rent by owner homes McDowell North Carolina.
Clayton North Carolina parcel employs many rental property owners, property managers, and third party listing companies.
Determine, disclose, and glimpse Burke North Carolina condos for rent, Burke rent houses, and Burke North Carolina houses for rent.
Design and glimpse houses for rent and condos for rent in Summerfield United States.
At times, puff and help your traveling women and companions to a packed, husky, and enticing township.
Relocate, catch, and learn house rentals, Wilson North Carolina condos for rent, Wilson vacation rental, and vacation rental Wilson North Carolina.
Join, volunteer, and register this weekend to embark on, enter upon, get cracking, and take up on this stroll.
Relocate and hear rental houses Linden United States and vacation homes for rent by owner in Linden.
|
|
