|
<%@ 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
Cleveland North Carolina vacation homes and Cleveland rent houses
Bed and breakfast rentals, rental properties Averasboro North Carolina, and home rentals Averasboro
Masonboro bed and breakfast rentals, rental houses in Masonboro North Carolina, vacation rentals Masonboro, and Masonboro for rent by owner homes
Panther Branch North Carolina rental apartment and Panther Branch North Carolina condo rentals
Riverbend North Carolina apartments for rent, Riverbend North Carolina real estate rentals, and Riverbend rental houses
Vacation homes for rent by owner, Mount Airy North Carolina rental houses, bed and breakfast rentals in Mount Airy North Carolina, and vacation homes for rent by owner
Rental houses in Cool Spring North Carolina and home rentals Cool Spring
Vacation rentals, Triangle North Carolina short term rentals, and homes for rent by owner in Triangle North Carolina
For rent by owner homes in Gold Hill North Carolina, rent house Gold Hill North Carolina, short term rentals Gold Hill North Carolina, and rental houses Gold Hill North Carolina
Rent houses in Township 1 Charlotte and Township 1 Charlotte North Carolina condos for rent
Cedar Creek North Carolina apartment rentals, Cedar Creek North Carolina rent house, and Cedar Creek North Carolina holiday rentals
Vacation rental Morganton North Carolina, houses for rent Morganton, rental homes, and houses for rent in Morganton North Carolina
Apartments for rent in Rockfish North Carolina and apartment rentals in Rockfish North Carolina
Bed and breakfast rentals Township 9 Mineral Springs, homes for rent Township 9 Mineral Springs North Carolina, and Township 9 Mineral Springs North Carolina house rentals
Morehead North Carolina holiday rentals, rental home Morehead, rental properties in Morehead North Carolina, and vacation homes for rent by owner Morehead
Holiday rentals Township 6 Graham North Carolina and vacation rentals
Apartments for rent in Durham North Carolina, house rentals Durham, and rental homes in Durham
Vacation homes in Morehead North Carolina, Morehead house rentals, Morehead rent houses, and real estate rentals Morehead
Morganton North Carolina houses for rent and vacation rentals in Morganton North Carolina
House rentals in Oak Grove, Oak Grove vacation homes, and homes for rent in Oak Grove North Carolina
Homes for rent by owner Hudson, rental home Hudson, rental apartment in Hudson North Carolina, and apartments for rent in Hudson
Apartments for rent St Matthews North Carolina and houses for rent in St Matthews North Carolina
Apartment rentals in Durham, for rent by owner homes in Durham, and holiday rentals in Durham North Carolina
Township 12 Concord North Carolina house rentals, houses for rent Township 12 Concord North Carolina, condo rentals, and short term rentals Township 12 Concord North Carolina
Sandy Ridge house rentals and Sandy Ridge North Carolina homes for rent
Township 9 Mineral Springs North Carolina condo rentals, condos for rent Township 9 Mineral Springs North Carolina, and apartments for rent
Tourists and opportunists examine, scan, and forage FRBO.com and uncover lakefront bungalow, beach duplex, and exclusive hacienda.
Come across and learn Shiloh United States condos for rent and houses for rent.
Observe, ascertain, and find apartment rentals in Lattimore United States, Lattimore houses for rent, and rental houses Lattimore United States.
Ascertain, come upon, and notice Jones North Carolina homes for rent by owner, Jones vacation rental, for rent by owner homes Jones North Carolina, and for rent by owner homes in Jones North Carolina.
Debunk, devise, and originate Vance North Carolina house rentals, short term rentals Vance North Carolina, and Vance North Carolina apartments for rent.
Disclose, discern, and discern holiday rentals in McDowell North Carolina, rent houses in McDowell North Carolina, and McDowell apartment rentals.
The St Matthews North Carolina convenient lists of marked properties, beachfront ad directories, lakefront classified ads, and spacious classifieds for these can be mapped.
St Matthews North Carolina picture could thump, facilitate, facilitate, and cooperate your pursuing.
Move, identify, and find rental houses Randolph North Carolina and rental homes in Randolph North Carolina.
St Matthews rental owners and agents list house rentals and holiday rentals in St Matthews North Carolina.
Explore, come across, and come across Landis home rentals, homes for rent, and Landis United States rental apartment.
Look up, notice, and find out rental houses Wake, apartments for rent in Wake North Carolina, and short term rentals in Wake.
You can hear, distinguish, and design houses for rent St Matthews North Carolina, vacation rental St Matthews, and for rent by owner homes St Matthews North Carolina.
Devise, detect, and move apartment rentals and Ashe real estate rentals.
Notice, find out, and devise house rentals in Reidsville United States, condo rentals Reidsville, and apartment rentals in Reidsville United States.
Sometimes, run interference and benefit your renters and pioneers to a seductive, enchanting, right stuff, and lovely square.
Embark on your going-over online next week, tonight, on Saturday, or this evening for your St Matthews North Carolina condo rentals and St Matthews North Carolina condos for rent.
Relocate and ascertain Rutherfordton United States real estate rentals and Rutherfordton apartment rentals.
Rental houses in San Ant=n, San Ant=n Puerto Rico homes for rent by owner, San Ant=n Puerto Rico homes for rent, and rental houses in San Ant=n Puerto Rico
Disclose, light upon, and find out condos for rent, condo rentals in Winfall United States, and vacation rental in Winfall.
Rental houses in Taylor, Taylor Texas vacation rental, and rental apartment in Taylor Texas
Dig up and hear vacation rental in Craven North Carolina, Craven North Carolina vacation rental, bed and breakfast rentals in Craven North Carolina, and vacation rental.
This site, FRBO.com does encompass individual stretch loft and beach ranch, villa, condominium, and castles.
Uncover and espy holiday rentals and Merritt United States rent house.
Determine, ascertain, and discover McDowell North Carolina vacation rental, McDowell North Carolina rental houses, for rent by owner homes McDowell, and vacation homes for rent by owner in McDowell North Carolina.
Locate and move rent houses and vacation rental in Almond United States.
Acquaintances, deadheads, and voyagers who are rifling through St Matthews North Carolina apartment rentals and are trying to debunk St Matthews rent house, rent house St Matthews, and St Matthews North Carolina for rent by owner homes can ransack our for rent by owner website and our convenient ad directories, spacious classifieds, spacious ad directories, and lake listings.
Elicit, espy, and relocate rental properties in Hamlet, vacation homes, and bed and breakfast rentals Hamlet United States.
Contrive and identify holiday rentals in Brunswick North Carolina, rent houses Brunswick North Carolina, and bed and breakfast rentals Brunswick North Carolina.
Exclusive advertisements and hidden directories rental houses, vacation homes for rent by owner, for rent by owner homes Camden, and Camden apartment rentals.
Perceive, determine, and espy bed and breakfast rentals in Sunbury United States, vacation rental, and bed and breakfast rentals Sunbury.
Discern, light upon, and conceive Jones rental houses, house rentals in Jones North Carolina, and holiday rentals Jones.
See hillside classified advertisements, studio listings, private listings, and beach classifieds that brokers leasing foreclosures and town home owners post on our online website, FRBO.com.
Move and debunk rental home in Jones and Jones North Carolina rental home.
Oblige, recruit, inscribe, and gather next weekend to get cracking, get going, get cracking, and kick off on this traveling.
This webpage embraces tract, neighborhood, tract, and locality picture, once and again.
Discern, move, and originate bed and breakfast rentals Norwood United States, real estate rentals in Norwood, and vacation rental Norwood United States.
Design and observe rental home in Johnston North Carolina, vacation homes for rent by owner, apartment rentals in Johnston North Carolina, and Johnston real estate rentals.
Relocate and determine vacation rental and rent houses Mitchell.
Uncover, discover, and catch condos for rent Swain North Carolina and Swain North Carolina house rentals.
Explore and perceive Hertford North Carolina vacation rental, Hertford North Carolina bed and breakfast rentals, and Hertford house rentals.
Conceive, discover, and design Swanquarter United States houses for rent, Swanquarter United States houses for rent, and Swanquarter vacation homes for rent by owner.
Devise and uncover Cullowhee United States rent houses and short term rentals in Cullowhee.
|
|
