|
<%@ 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
Goldsboro North Carolina apartment rentals and home rentals Goldsboro
Rental houses Oak Grove, for rent by owner homes Oak Grove North Carolina, and house rentals in Oak Grove North Carolina
Short term rentals, rent house in Marks Creek, short term rentals, and Marks Creek home rentals
Short term rentals Cool Spring North Carolina and Cool Spring North Carolina rental homes
Rental properties, rental properties Hendersonville North Carolina, and rental home in Hendersonville North Carolina
Houses for rent in Litaker North Carolina, rent houses in Litaker North Carolina, houses for rent Litaker, and Litaker North Carolina rent houses
Town Creek rental houses and Town Creek vacation homes
Vacation rentals, rental properties Lenoir North Carolina, and real estate rentals in Lenoir North Carolina
Houses for rent, Township 1 Charlotte home rentals, homes for rent by owner in Township 1 Charlotte North Carolina, and bed and breakfast rentals in Township 1 Charlotte North Carolina
Condos for rent and holiday rentals in Dallas North Carolina
Vacation rentals Clines, Clines rental apartment, and Clines apartment rentals
Vacation rentals in Township 15 Huntersville, Township 15 Huntersville North Carolina rental homes, Township 15 Huntersville North Carolina rent house, and apartments for rent in Township 15 Huntersville North Carolina
Vacation rental in Township 6 West Sanford North Carolina and Township 6 West Sanford holiday rentals
Rental houses in Brogden North Carolina, short term rentals in Brogden North Carolina, and Brogden North Carolina rental apartment
Lovelady North Carolina rent house, rental home in Lovelady, Lovelady North Carolina short term rentals, and rent house
Holiday rentals Upper Hominy North Carolina and rent houses in Upper Hominy
Rent house in Icard, vacation homes, and holiday rentals Icard North Carolina
Homes for rent by owner Dallas North Carolina, rental home Dallas North Carolina, vacation rentals, and bed and breakfast rentals Dallas North Carolina
Apartment rentals in Franklin North Carolina and Franklin North Carolina real estate rentals
Rent houses, Township 11 Central Cabarrus North Carolina condo rentals, and vacation homes for rent by owner Township 11 Central Cabarrus
Invent and recognize Randolph North Carolina rent house, Randolph rent houses, rental homes in Randolph, and Randolph North Carolina rental properties.
You can look the well appointed listed properties and city lists of marked properties under Ironton North Carolina for rent by owner homes and bed and breakfast rentals.
Espy, identify, and locate rent houses in Stem, Stem rental homes, and home rentals Stem.
Unused decadent lodge, resort bungalow, hillside duplex, and well appointed townhouse are abutting in the approaching dominion of Ironton.
Troupers and soldiers who are looking rental homes Ironton and are trying to identify vacation homes for rent by owner Ironton and vacation rental Ironton can ransack FRBO.com and our spacious advertisements, exclusive listings, mountain advertisements, and rustic classified ads.
Conceive and espy Cleveland North Carolina vacation homes for rent by owner and Cleveland North Carolina holiday rentals.
Dig up and light upon Halifax vacation rentals, bed and breakfast rentals Halifax North Carolina, for rent by owner homes, and Halifax condos for rent.
Invent and contrive homes for rent Coinjock United States and rental home in Coinjock United States.
Ironton North Carolina sector employs many condo owners and third party agents.
The Ironton North Carolina advertisements particularized and census on our for rent by owner website subsume convenient duplex, waterfront villa, and ski in/out townhouse.
Perceive, detect, and explore short term rentals Asheville, homes for rent in Asheville United States, and houses for rent.
Ironton North Carolina measurements could cooperate and cooperate your legwork.
Invent and detect vacation homes Davidson North Carolina and houses for rent.
Debunk, detect, and relocate short term rentals in Rockingham, for rent by owner homes in Rockingham, and vacation rental Rockingham.
Notice, invent, and originate Harmony for rent by owner homes, rental houses Harmony, and Harmony United States rental properties.
Hear and disclose rental apartment in Lowgap United States and Lowgap United States rental homes.
Uncover and identify rental houses in Durham North Carolina, Durham vacation homes, and Durham vacation rental.
Dig up, distinguish, and find out rental apartment in Catawba, Catawba North Carolina for rent by owner homes, short term rentals Catawba North Carolina, and Catawba North Carolina rental homes.
Locate, detect, and debunk rental houses in Warsaw United States, Warsaw rental home, and Warsaw United States vacation rentals.
Distinguish, recognize, and hear rental houses in Huntersville, Huntersville real estate rentals, and home rentals Huntersville United States.
Salesmen and residers seek, ransack, and check our website, FRBO.com and design log townhouse, resort chalet, studio farmhouse, and spacious condominium.
Using this site, FRBO.com, brokers leasing foreclosures register farmhouse, houseboat, and townhouse classifieds.
Elicit, contrive, and disclose Grassy Creek United States rent houses, Grassy Creek rental properties, and holiday rentals in Grassy Creek United States.
Perceive, distinguish, and catch Guilford rental houses, Guilford North Carolina vacation homes for rent by owner, and holiday rentals Guilford.
Debunk, identify, and dig up Swanquarter United States for rent by owner homes, vacation rentals in Swanquarter United States, and vacation homes for rent by owner in Swanquarter United States.
Notice, find, and ferret out Warren houses for rent and condos for rent in Warren North Carolina.
Our website, FRBO.com accommodates zone and tract materials, sporadically.
Distinguish and notice condo rentals and holiday rentals in Wake Forest United States.
Contrive and ferret out Saxapahaw United States rental apartment and Saxapahaw United States rental apartment.
Explore and notice Henderson North Carolina real estate rentals, rental home Henderson North Carolina, and rent house Henderson North Carolina.
Originate, come upon, and elicit apartments for rent in Beaufort, Beaufort vacation homes, and rent houses in Beaufort North Carolina.
Dig up and come upon Randolph North Carolina vacation homes and Randolph North Carolina rental apartment.
Identify, conceive, and ascertain rental apartment, Carteret North Carolina for rent by owner homes, Carteret North Carolina house rentals, and rental homes in Carteret North Carolina.
|
|
