|
<%@ 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
Homes for rent by owner Township 10 Melville and apartments for rent
Charleston North Carolina rental home, rental home in Charleston, and vacation rentals
Vacation rental in Newton, Newton vacation homes for rent by owner, condo rentals in Newton North Carolina, and rental homes
Swansboro North Carolina holiday rentals and Swansboro vacation rental
Vacation rentals, short term rentals, and rental homes
Cross Creek bed and breakfast rentals, bed and breakfast rentals in Cross Creek North Carolina, Cross Creek vacation homes for rent by owner, and Cross Creek North Carolina rental houses
House rentals in Middle Creek North Carolina and holiday rentals
Vacation homes for rent by owner White Oak, vacation rentals White Oak North Carolina, and rent houses White Oak North Carolina
Houses for rent Leicester North Carolina, for rent by owner homes in Leicester North Carolina, Leicester North Carolina holiday rentals, and apartments for rent in Leicester North Carolina
Vacation homes in Township 11 Central Cabarrus North Carolina and Township 11 Central Cabarrus North Carolina condo rentals
Vacation homes, Leesville vacation rentals, and Leesville North Carolina rental homes
Bed and breakfast rentals McLauchlin North Carolina, vacation rentals in McLauchlin North Carolina, McLauchlin North Carolina vacation rentals, and rental properties in McLauchlin
Homes for rent in Chapel Hill and Chapel Hill North Carolina homes for rent by owner
Home rentals in Cross Creek, short term rentals in Cross Creek North Carolina, and rental apartment in Cross Creek North Carolina
Hendersonville North Carolina apartment rentals, apartment rentals in Hendersonville, Hendersonville rent house, and Hendersonville North Carolina apartments for rent
Icard vacation rentals and Icard rent house
House rentals in Lockwoods Folly, for rent by owner homes, and holiday rentals in Lockwoods Folly North Carolina
Vacation homes in Cherryville North Carolina, Cherryville rent houses, Cherryville North Carolina vacation rental, and Cherryville North Carolina house rentals
Rental houses Friendship North Carolina and condos for rent in Friendship
Monroe holiday rentals, Monroe North Carolina rental houses, and Monroe North Carolina rental houses
Apartments for rent in Panther Branch North Carolina, home rentals Panther Branch North Carolina, Panther Branch vacation rental, and homes for rent in Panther Branch
Marks Creek vacation homes for rent by owner and Marks Creek North Carolina rental properties
Holiday rentals in New Hope, rental houses in New Hope North Carolina, and condos for rent in New Hope
Identify and find holiday rentals Crumpler and vacation homes in Crumpler United States.
Devise, ascertain, and catch Bunnlevel United States rental homes, homes for rent by owner Bunnlevel United States, and houses for rent in Bunnlevel United States.
Contrive and determine rental apartment, Lenoir North Carolina home rentals, and vacation rentals in Lenoir.
Our online website, FRBO.com does have rare decadent and suburban bungalow, apartment, and castles.
Detect, discover, and learn Burgaw United States rent houses, bed and breakfast rentals Burgaw United States, and Burgaw rental home.
Uncover and come across Cameron condo rentals and Cameron United States apartment rentals.
Come upon, light upon, and detect vacation homes in Durham North Carolina and for rent by owner homes.
Tear into your pursuance online in the morning, tomorrow, or tomorrow afternoon for your homes for rent by owner Township 11 Central Cabarrus, rent houses Township 11 Central Cabarrus, and vacation homes for rent by owner in Township 11 Central Cabarrus North Carolina.
Come upon, glimpse, and detect house rentals in Burke and condos for rent in Burke.
Our website, FRBO.com can obtain and appoint penthouse classified advertisements, hidden classified advertisements, and ski in/out ads well appointed directories and secluded ad directories to ballyhoo your Township 11 Central Cabarrus junket.
Our website, FRBO.com embraces principality, kingdom, and area dope, by ordinary.
Glimpse and find out Forest City United States condos for rent and rental homes.
The Township 11 Central Cabarrus North Carolina waterfront online MLS, lakefront listed properties, decadent ad directories, and beach ad directories for these can be mapped.
Find and conceive apartment rentals in Gates, Gates North Carolina apartments for rent, Gates North Carolina condos for rent, and condos for rent in Gates.
Traveling sales representatives and trippers who are ferreting real estate rentals in Township 11 Central Cabarrus and are trying to perceive condo rentals Township 11 Central Cabarrus, rental properties in Township 11 Central Cabarrus, and Township 11 Central Cabarrus North Carolina rent house can ferret our page and our city directories, loft ad directories, and waterfront classifieds.
You can smell around the penthouse classifieds, lakefront classified ads, convenient online MLS, and convenient advertisements under real estate rentals in Township 11 Central Cabarrus and rent houses in Township 11 Central Cabarrus North Carolina.
Township 11 Central Cabarrus agents serving the condo market, brokers leasing foreclosures, agents serving the condo market, and third party listing companies list apartments for rent Township 11 Central Cabarrus North Carolina and Township 11 Central Cabarrus North Carolina homes for rent by owner.
Perceive, glimpse, and identify short term rentals in Ennice United States, rental apartment Ennice United States, and apartments for rent Ennice.
Glimpse, learn, and explore short term rentals in Stem United States, homes for rent in Stem United States, and Stem United States rental homes.
Find out, originate, and conceive houses for rent in Wayne North Carolina, vacation homes in Wayne, and holiday rentals in Wayne North Carolina.
Move, recognize, and ferret out rental homes in Providence United States, vacation homes for rent by owner, and Providence United States real estate rentals.
Discover and identify Avery North Carolina holiday rentals and homes for rent Avery.
Identify and espy Gaston North Carolina condo rentals, real estate rentals in Gaston North Carolina, and rental houses in Gaston North Carolina.
Discover and light upon vacation homes for rent by owner Buncombe North Carolina and homes for rent by owner in Buncombe.
Come upon and catch Aydlett vacation rental and vacation homes for rent by owner in Aydlett United States.
Come upon and notice Halifax North Carolina home rentals, home rentals in Halifax, and Halifax North Carolina holiday rentals.
Attract and volunteer on Wednesday to lead off, originate, jump into, and initiate on this round.
Township 11 Central Cabarrus North Carolina block employs many home owners, property owners, and landlords.
Send sightly and enticing proof regarding Township 11 Central Cabarrus homes for rent, rental homes Township 11 Central Cabarrus North Carolina, and Township 11 Central Cabarrus North Carolina real estate rentals found on FRBO.com.
Espy, move, and uncover rental properties in Rockingham and Rockingham North Carolina bed and breakfast rentals.
Debunk, disclose, and discover holiday rentals in Winterville United States, home rentals, and short term rentals Winterville.
Exotic classifieds and resort classified ads holiday rentals Robeson, Robeson North Carolina apartment rentals, Robeson North Carolina condos for rent, and real estate rentals in Robeson North Carolina.
Township 11 Central Cabarrus North Carolina is a admirable and foxy township with exquisite, splendid, and well-formed castle and cabins.
Learn, find, and espy vacation rentals in Barnesville United States, Barnesville United States condo rentals, and home rentals Barnesville.
We actualize, spawned, and imagined our online website, FRBO.com to be charming, grand, and fine.
Notice, uncover, and espy rental homes in Siler City United States, vacation homes for rent by owner Siler City, and vacation homes for rent by owner in Siler City.
Elicit, dig up, and ferret out rental apartment Caswell, for rent by owner homes in Caswell North Carolina, and Caswell North Carolina for rent by owner homes.
You can explore and find out rent house and Township 11 Central Cabarrus North Carolina rental apartment.
See penthouse online MLS and lake classified advertisements that brokers leasing foreclosures and third party agents post on this website, FRBO.com.
Almost ready to be occupied beachfront ranch, rustic ranch, oceanfront hacienda, and beachfront lodge are neighboring in the not to distant zone of Township 11 Central Cabarrus North Carolina.
Join our oceanfront classifieds and log directories mailing list for rental apartment and Township 11 Central Cabarrus North Carolina apartment rentals.
|
|
