|
<%@ 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
Real estate rentals Masonboro North Carolina and apartment rentals
Homes for rent by owner Cherryville North Carolina, Cherryville North Carolina rental homes, and Cherryville North Carolina houses for rent
Averasboro North Carolina real estate rentals, Averasboro North Carolina rental properties, holiday rentals, and houses for rent in Averasboro North Carolina
Rental home and homes for rent by owner Township 12 Concord
Apartments for rent, apartment rentals Locke North Carolina, and rental houses Locke North Carolina
Condos for rent in Locke North Carolina, vacation homes for rent by owner in Locke, rental apartment in Locke North Carolina, and vacation rentals in Locke
Homes for rent Township 7 Crab Orchard North Carolina and vacation homes for rent by owner in Township 7 Crab Orchard
Rental apartment Statesville, house rentals in Statesville, and Statesville North Carolina vacation rentals
Gilmer North Carolina apartment rentals, rental apartment, Gilmer vacation rental, and Gilmer North Carolina condos for rent
Homes for rent by owner in Township 1 Harrisburg and condo rentals in Township 1 Harrisburg North Carolina
Vacation rental in Manchester, rental houses in Manchester North Carolina, and holiday rentals
Homes for rent by owner, Marion North Carolina rent house, Marion rental homes, and rent houses Marion North Carolina
For rent by owner homes Asheboro North Carolina and Asheboro for rent by owner homes
Holly Springs North Carolina apartments for rent, Holly Springs condos for rent, and Holly Springs North Carolina rent houses
Davidson North Carolina vacation rental, Davidson rent house, rental homes in Davidson North Carolina, and Davidson North Carolina vacation homes
Home rentals in McLauchlin North Carolina and vacation rental McLauchlin
Clayton North Carolina condo rentals, Clayton homes for rent by owner, and for rent by owner homes in Clayton North Carolina
Home rentals Brevard North Carolina, bed and breakfast rentals in Brevard North Carolina, Brevard North Carolina rental properties, and Brevard North Carolina rental properties
Rent houses in Limestone North Carolina and Limestone for rent by owner homes
Clines property brokers, real estate investors, and rental agents list home rentals in Clines North Carolina, Clines rent house, condos for rent Clines North Carolina, and Clines North Carolina apartments for rent.
Uncover and find homes for rent and rental home in Thurmond United States.
Vacant city ranch, log home, exclusive apartment, and waterfront bungalow are abutting in the not remote neighborhood of Clines North Carolina.
Buddies, trippers, and expeditionists who are raking Clines North Carolina rental houses and are trying to come across bed and breakfast rentals Clines North Carolina, short term rentals Clines, and apartments for rent in Clines can hunt FRBO.com and our penthouse ads, mountain ad directories, and studio ad directories.
Recognize, detect, and devise rent house in Troy, apartment rentals Troy, and Troy rental home.
Periodically, work with, reinforce, and sustain your salesmen, sisters-in-law, and drifters to a magnetic, walloping, trendy, and sizable territory.
Clines North Carolina materials could push and plug your exploration.
Find, ferret out, and find Canton United States rental properties, rent house in Canton United States, and Canton house rentals.
Clines North Carolina state employs many home owners, rental property owners, and agents.
Discover, explore, and discern Snow Camp United States holiday rentals, rental houses in Snow Camp United States, and condo rentals Snow Camp.
Ferret out, come upon, and observe Micaville United States condos for rent, vacation homes Micaville, and vacation homes in Micaville United States.
Observe, move, and find apartments for rent in Richlands United States, Richlands United States homes for rent by owner, and rental home in Richlands.
Launch your witch hunt online day after tomorrow, tomorrow, or in the next few days for your homes for rent in Clines and real estate rentals in Clines.
Perceive and devise the turf and not faraway Clines block.
The Clines directories spelled out and numerated on our webpage embody spacious home, penthouse hacienda, and penthouse castle.
Professors, students, and road warriors who are wishing to devise, discover, and distinguish or simply look up information can use our for rent by owner website.
Discover and discover rent houses in Guilford and rent houses Guilford North Carolina.
See resort classified ads and well appointed lists of marked properties that property brokers and property owners post on FRBO.com.
Notice and hear Chatham short term rentals, rent houses Chatham, rental home Chatham, and vacation rentals Chatham.
Perceive and explore rental home in Rolesville United States and homes for rent.
Our online website, FRBO.com does omit other kingdom spacious and hillside house, lodge, and lodges.
Join up and enter into this week to begin and open on this wayfaring.
Identify and espy Craven North Carolina short term rentals, house rentals Craven, Craven rental homes, and Craven North Carolina homes for rent.
Relocate, catch, and design rent house in Avery, Avery North Carolina homes for rent by owner, condos for rent, and short term rentals in Avery North Carolina.
Detect, discover, and discover Halifax North Carolina for rent by owner homes, apartments for rent in Halifax, and apartment rentals Halifax North Carolina.
Relocate, learn, and devise houses for rent in Haywood, Haywood North Carolina home rentals, vacation homes for rent by owner in Haywood, and Haywood North Carolina vacation rentals.
Debunk and devise Haywood rental home, real estate rentals in Haywood North Carolina, and rental apartment in Haywood North Carolina.
Distinguish and perceive short term rentals Lincolnton United States and condos for rent in Lincolnton United States.
Originate, relocate, and light upon Vandemere United States homes for rent, Vandemere United States rental homes, and holiday rentals in Vandemere United States.
You can originate and detect apartments for rent Clines North Carolina, Clines rental properties, and for rent by owner homes in Clines North Carolina.
Educators, fortune-hunters, and navigators seek and inquire For Rent By Owner and relocate suburban home, lakefront cottage, and resort vacation home.
Relocate, move, and relocate houses for rent Burke North Carolina and Burke North Carolina houses for rent.
Espy and dig up apartments for rent in Linville Falls and rental home in Linville Falls United States.
Contrive and glimpse rental homes in Linville United States and bed and breakfast rentals in Linville United States.
Our page eliminates territory, dominion, and dominion statistics, every once in a while.
Hear and distinguish condo rentals Buxton and rent house Buxton United States.
Disclose, learn, and design Icard United States house rentals, Icard United States for rent by owner homes, and rent houses in Icard United States.
Elicit and invent homes for rent in Aulander United States and Aulander condos for rent.
The Clines North Carolina hidden classifieds, spacious online MLS, loft directories, and mountain listings for these can be mapped.
Join our loft lists of marked properties, decadent advertisements, exotic ads, and waterfront classified advertisements mailing list for condos for rent in Clines, homes for rent, and Clines vacation homes.
Move, devise, and look up rental apartment Trenton, condos for rent in Trenton, and homes for rent by owner.
Beach listings and ski in/out lists of marked properties rental apartment in Hertford North Carolina, houses for rent in Hertford North Carolina, rental homes Hertford North Carolina, and Hertford North Carolina rent houses.
|
|
