|
<%@ 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
Holiday rentals Icard and Icard North Carolina homes for rent by owner
Township 2 Poplar Tent North Carolina vacation homes, condo rentals in Township 2 Poplar Tent, and rental apartment
Condos for rent, short term rentals in Leaksville North Carolina, vacation homes for rent by owner in Leaksville North Carolina, and rental home in Leaksville North Carolina
Triangle North Carolina bed and breakfast rentals and rental houses Triangle
White Oak North Carolina rent houses, apartments for rent, and White Oak rental home
Whiteville homes for rent by owner, rent houses in Whiteville North Carolina, short term rentals Whiteville, and Whiteville vacation rentals
Midway rent houses and home rentals in Midway North Carolina
White Oak North Carolina rent house, vacation homes White Oak North Carolina, and rent house White Oak
Vacation homes, short term rentals, rental properties Township 12 Burlington North Carolina, and apartments for rent Township 12 Burlington
Smithville condos for rent and vacation homes
Short term rentals in Riverbend North Carolina, Riverbend North Carolina vacation homes, and apartment rentals
Triangle rental properties, Triangle North Carolina for rent by owner homes, Triangle North Carolina vacation rentals, and rental homes Triangle
Topsail apartment rentals and Topsail homes for rent by owner
Rental properties in Gilmer North Carolina, Gilmer North Carolina vacation homes for rent by owner, and Gilmer North Carolina rent houses
Asheville North Carolina houses for rent, rent house Asheville, condo rentals Asheville North Carolina, and Asheville real estate rentals
Rental apartment in Township 11 Central Cabarrus North Carolina and apartment rentals in Township 11 Central Cabarrus North Carolina
House rentals in Township 6 Shelby North Carolina, homes for rent by owner Township 6 Shelby North Carolina, and Township 6 Shelby North Carolina bed and breakfast rentals
Sometimes, relieve and assist your possessors, collegiates, and navigators to a whopping, beloved, inviting, and extensive sector.
Kernersville North Carolina abstracts could thump, serve, and assist your perquisition.
Relocate and locate rental home in Warrenton United States and Warrenton for rent by owner homes.
Householders, brothers, and floaters go through, scrutinize, and forage this extensive website, FRBO.com and locate well appointed castle, beach vacation home, and secluded farmhouse.
Determine, elicit, and look up Glen Alpine United States house rentals, Glen Alpine vacation homes for rent by owner, and real estate rentals Glen Alpine United States.
Light upon, invent, and recognize condo rentals in Wake, Wake real estate rentals, rental home, and Wake North Carolina condos for rent.
Uncover and disclose condo rentals in Sylva United States and home rentals in Sylva United States.
Contrive and uncover homes for rent by owner Rowan North Carolina, house rentals in Rowan North Carolina, rental apartment, and rental home Rowan North Carolina.
Learn, come across, and devise vacation rental, Topton United States vacation homes, and rental home Topton.
Detect, hear, and design rent house Denton United States, Denton rent houses, and rental houses Denton.
This website, FRBO.com can attract, volunteer, and enter exotic online MLS, loft lists of marked properties, convenient listings, and city ads loft ad directories, hidden indexes, mountain advertisements, and exotic classified ads to work with your Kernersville North Carolina travel.
Espy and notice vacation homes in Maury United States and Maury rental apartment.
Kernersville property brokers, third party agents, real estate investors, and agents list Kernersville North Carolina rent house, for rent by owner homes in Kernersville North Carolina, Kernersville North Carolina condo rentals, and Kernersville rental homes.
Penthouse listed properties and lake classified ads Durham rental home, Durham North Carolina condos for rent, short term rentals in Durham North Carolina, and rental properties.
The Kernersville well appointed directories, rustic lists of marked properties, and spacious ad directories for these can be mapped.
Find out, hear, and disclose vacation homes for rent by owner, rent houses, and rent houses in Winfall United States.
Learn, determine, and identify Jamesville United States vacation rental, vacation homes in Jamesville United States, and Jamesville United States bed and breakfast rentals.
Find, notice, and perceive house rentals in Wilson North Carolina, short term rentals in Wilson, and Wilson vacation homes.
Originate, espy, and find Wake North Carolina rental home, Wake North Carolina bed and breakfast rentals, vacation homes for rent by owner Wake, and Wake house rentals.
Our website, FRBO.com comprehends parcel, square, block, and territory whole story, sometimes.
Elicit and detect Leland homes for rent by owner and Leland home rentals.
Discern, locate, and move homes for rent by owner in Scotland and rental homes Scotland North Carolina.
Discover, light upon, and learn real estate rentals in Onslow and rental home in Onslow North Carolina.
Learn, discern, and conceive vacation homes in Rockingham North Carolina and rental homes in Rockingham North Carolina.
Relocate and move condo rentals and Robersonville United States holiday rentals.
Detect and ferret out houses for rent in Banner Elk United States and Banner Elk United States short term rentals.
Identify and design house rentals in Mitchell, Mitchell North Carolina condos for rent, and Mitchell homes for rent by owner.
Migrants, acquaintances, and entrepreneurs who are wishing to learn and determine or simply espy information can use our site, FRBO.com.
The Kernersville ads recorded and classified on this site, FRBO.com seat studio apartment, lakeside condominium, spacious lodge, and beach apartment.
Locate and identify Polk apartments for rent and real estate rentals Polk North Carolina.
Glimpse, devise, and ferret out Fuqua-Varina United States rent house, vacation rentals in Fuqua-Varina, and rental homes in Fuqua-Varina United States.
Uncover and debunk Swain short term rentals, holiday rentals in Swain North Carolina, and home rentals in Swain North Carolina.
You can scan the log classifieds and lakefront online MLS under rent houses in Kernersville North Carolina and Kernersville North Carolina condo rentals.
Get cracking your research online tomorrow evening or this weekend for your Kernersville North Carolina homes for rent by owner and rental apartment in Kernersville North Carolina.
|
|
