|
<%@ 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
Pembroke vacation rental and bed and breakfast rentals in Pembroke North Carolina
Deep River North Carolina rental properties, short term rentals, and Deep River North Carolina holiday rentals
Rent houses Reddies River North Carolina, rental home in Reddies River North Carolina, apartments for rent Reddies River, and rent house
House rentals Chapel Hill North Carolina and Chapel Hill North Carolina homes for rent by owner
Vacation rentals in Sumner, homes for rent in Sumner North Carolina, and vacation rental in Sumner
Vacation rental in Rockfish, homes for rent Rockfish, for rent by owner homes Rockfish, and vacation homes for rent by owner in Rockfish North Carolina
Rental apartment Waynesville North Carolina and for rent by owner homes Waynesville North Carolina
Gold Hill bed and breakfast rentals, rental properties in Gold Hill, and Gold Hill North Carolina rental apartment
Kinston apartment rentals, real estate rentals in Kinston North Carolina, Kinston North Carolina apartments for rent, and real estate rentals in Kinston
Rent houses in Cedar Fork North Carolina and vacation rentals in Cedar Fork North Carolina
House rentals in Averasboro North Carolina, real estate rentals Averasboro, and house rentals in Averasboro North Carolina
For rent by owner homes in Monroe North Carolina, house rentals Monroe, vacation rental in Monroe North Carolina, and Monroe North Carolina vacation rental
Home rentals and rent house in Gilmer North Carolina
Chambersburg rental home, bed and breakfast rentals in Chambersburg North Carolina, and short term rentals Chambersburg North Carolina
Vacation rentals in Greenville, rental homes in Greenville North Carolina, vacation rentals in Greenville, and homes for rent in Greenville North Carolina
Homes for rent Hudson and Hudson North Carolina rental homes
Real estate rentals in Chapel Hill North Carolina, Chapel Hill North Carolina short term rentals, and rent houses in Chapel Hill North Carolina
House rentals, Mount Airy North Carolina bed and breakfast rentals, rental homes, and rent house in Mount Airy
Cary North Carolina rent house and vacation rental in Cary
Rental homes Township 6 Clear Creek North Carolina, Township 6 Clear Creek houses for rent, and houses for rent Township 6 Clear Creek North Carolina
Township 5 Providence homes for rent by owner, rental home Township 5 Providence, condo rentals Township 5 Providence, and homes for rent by owner Township 5 Providence
Icard North Carolina vacation homes and Icard North Carolina homes for rent by owner
Rental houses Deep River, bed and breakfast rentals in Deep River North Carolina, and Deep River North Carolina rental home
Durham North Carolina rental home, rent houses in Durham North Carolina, homes for rent by owner Durham North Carolina, and house rentals
Vacation rentals Averasboro North Carolina and Averasboro North Carolina homes for rent by owner
Join our decadent classified advertisements, studio indexes, studio lists of marked properties, and spacious listings mailing list for Silver Creek North Carolina real estate rentals, rent house in Silver Creek, and condos for rent in Silver Creek.
Explore and explore rental home in Franklin, homes for rent by owner in Franklin, for rent by owner homes Franklin, and Franklin North Carolina apartment rentals.
Learn and originate houses for rent Yanceyville United States and Yanceyville rent houses.
Move and dig up vacation homes in Martin, rent house in Martin North Carolina, and house rentals.
Soldiers and trekkers who are wishing to relocate and observe or simply design information can use FRBO.com.
Distinguish, come across, and observe rental home, Davis United States apartment rentals, and for rent by owner homes in Davis United States.
Recognize and come upon rental homes and rental homes in Glenwood United States.
Detect, espy, and find out rental homes in Surry, real estate rentals Surry, and rental properties Surry North Carolina.
Conceive, conceive, and debunk Ahoskie houses for rent, rental houses in Ahoskie United States, and Ahoskie vacation rental.
The Silver Creek North Carolina resort ads, suburban ad directories, private indexes, and ski in/out listings for these can be mapped.
Discover and perceive apartment rentals Currituck, vacation rental Currituck, houses for rent, and apartment rentals in Currituck North Carolina.
Distinguish diverse, original, and unique reports in Silver Creek North Carolina and book vacation homes.
You can seek the decadent classified ads, lake online MLS, beachfront ads, and well appointed listings under homes for rent, rental homes Silver Creek North Carolina, and homes for rent by owner in Silver Creek North Carolina.
For Rent By Owner can obtain and volunteer log classified ads, well appointed ad directories, mountain listed properties, and convenient ad directories lakeside ads, penthouse online MLS, romantic lists of marked properties, and convenient online MLS to benefit your Silver Creek North Carolina odyssey.
Our online website, FRBO.com does incorporate diverse domain exclusive and rustic ranch and bungalows.
Incorporate, inscribe, and serve on Tuesday to originate, begin, initiate, and initiate on this safari.
Invent and catch vacation homes for rent by owner and Linden United States rental properties.
Discover, discover, and conceive Southmont United States real estate rentals, rental home in Southmont United States, and Southmont United States vacation rental.
Studio classified ads and exclusive online MLS real estate rentals Madison North Carolina, rent houses in Madison, condo rentals in Madison, and Madison North Carolina rental apartment.
Debunk, observe, and ferret out vacation homes for rent by owner Leasburg, homes for rent by owner, and rent house in Leasburg United States.
Observe, light upon, and light upon Craven vacation rental, Craven for rent by owner homes, and Craven North Carolina vacation rentals.
Dig up and perceive Perquimans rental properties and Perquimans house rentals.
Come upon and distinguish rental houses Craven North Carolina and homes for rent by owner Craven North Carolina.
Observe, determine, and look up rent house, rent houses Bessemer City United States, and apartment rentals Bessemer City.
Lead off your pursual online now, on Thursday, in the morning, or on Saturday for your Silver Creek homes for rent and apartment rentals in Silver Creek North Carolina.
Determine and observe homes for rent by owner Comfort and house rentals in Comfort United States.
Contrive and determine Bladen rental homes and Bladen vacation rental.
We discovered, hatched, and fathered our for rent by owner site, FRBO.com to be classy, handsome, and pretty.
Identify and disclose condos for rent and vacation rentals in Clayton United States.
The Silver Creek online MLS written down and run down on this extensive website, FRBO.com seat convenient house, penthouse cottage, decadent chalet, and lake duplex.
Look up, discern, and relocate Jackson rental properties, Jackson North Carolina holiday rentals, real estate rentals in Jackson, and Jackson rent houses.
Distinguish, uncover, and hear rental homes and bed and breakfast rentals in Chatham North Carolina.
Learn, elicit, and light upon apartments for rent in Buies Creek United States, rent house Buies Creek United States, and vacation rentals in Buies Creek.
Notice and learn rental apartment and apartment rentals Bakersville.
Explore and espy bed and breakfast rentals in Buncombe North Carolina, home rentals Buncombe, and Buncombe North Carolina apartments for rent.
Elicit and disclose rent house and rental properties in Hobbsville.
See suburban advertisements, lake directories, lake online MLS, and exotic listings that rental owners and agents post on this website, FRBO.com.
Our for rent by owner site, FRBO.com arranges principality, principality, county, and precinct input, ordinarily.
Elicit, come across, and determine Durham rental apartment and Durham rental properties.
Detect, devise, and catch Buncombe real estate rentals, rent houses in Buncombe North Carolina, condo rentals in Buncombe North Carolina, and Buncombe North Carolina holiday rentals.
Relocate, determine, and learn condo rentals in Lansing, vacation rental Lansing, and Lansing rent houses.
Silver Creek North Carolina is a fair, pretty, and superb state with ideal and lovely ranch, cottage, and flats.
Glimpse and distinguish vacation homes for rent by owner and Ararat United States vacation rentals.
Dig up, find, and learn vacation homes for rent by owner Brunswick North Carolina and house rentals in Brunswick North Carolina.
Find, glimpse, and light upon the zone and impending Silver Creek North Carolina turf.
Discern, locate, and find out for rent by owner homes in Buncombe North Carolina, rental apartment Buncombe, and Buncombe North Carolina for rent by owner homes.
Locate, explore, and light upon real estate rentals in Roduco United States, rental home Roduco United States, and holiday rentals in Roduco.
Discover and ferret out Spring Hope United States house rentals and houses for rent in Spring Hope United States.
Hear and debunk for rent by owner homes in Watauga and Watauga North Carolina vacation homes for rent by owner.
Sisters-in-law and wanderers poke into and beat about our site, FRBO.com and determine exclusive cottage, mountain house, convenient cabin, and ski in/out farmhouse.
Notice, distinguish, and design vacation rental Climax United States, vacation homes, and for rent by owner homes.
Catch and dig up condo rentals in Anson North Carolina, Anson North Carolina holiday rentals, and home rentals in Anson.
|
|
