|
<%@ 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
Silver Creek North Carolina rent houses and Silver Creek real estate rentals
Kinston North Carolina home rentals, vacation rentals, and rental apartment in Kinston North Carolina
Cherryville North Carolina house rentals, holiday rentals in Cherryville North Carolina, vacation rentals in Cherryville North Carolina, and Cherryville North Carolina rent houses
Rental properties in Chapel Hill North Carolina and vacation rental in Chapel Hill North Carolina
House rentals in Monroe, rental properties in Monroe North Carolina, and rental properties Monroe North Carolina
Ironton rent houses, for rent by owner homes Ironton North Carolina, rental houses Ironton, and real estate rentals in Ironton North Carolina
Clemmonsville North Carolina short term rentals and rental properties Clemmonsville
Vacation homes for rent by owner in Franklin North Carolina, Franklin North Carolina apartments for rent, and apartments for rent in Franklin North Carolina
Carvers Creek rent houses, rental houses Carvers Creek, Carvers Creek house rentals, and Carvers Creek rental houses
Brogden North Carolina house rentals and Brogden rental properties
Topsail North Carolina vacation homes for rent by owner, bed and breakfast rentals in Topsail North Carolina, and rental properties Topsail
Vacation rental in Coddle Creek North Carolina, rent houses Coddle Creek, Coddle Creek North Carolina vacation rental, and Coddle Creek North Carolina rent houses
Condo rentals in Oak Grove North Carolina and Oak Grove North Carolina vacation homes
Rental homes, condo rentals in Oak Grove North Carolina, and Oak Grove North Carolina vacation homes
Abbotts Creek North Carolina homes for rent by owner, vacation homes for rent by owner Abbotts Creek, rental houses Abbotts Creek North Carolina, and rent houses in Abbotts Creek
Holiday rentals in Panther Branch North Carolina and vacation homes in Panther Branch North Carolina
Short term rentals Reidsville North Carolina, condo rentals in Reidsville, and vacation homes Reidsville North Carolina
Cedar Creek homes for rent, homes for rent Cedar Creek, vacation rental, and Cedar Creek North Carolina rental apartment
Asheville North Carolina house rentals and Asheville vacation rental
Condo rentals in High Point North Carolina, condos for rent, and condo rentals in High Point North Carolina
Rent houses in Pearces Mill North Carolina, Pearces Mill North Carolina vacation rental, holiday rentals in Pearces Mill North Carolina, and Pearces Mill rental homes
Smithfield rent house and houses for rent
See waterfront directories and loft classified ads that property managers and property managers post on this site, For Rent By Owner (FRBO.com).
Discover and originate real estate rentals in Salter Path United States and Salter Path United States condos for rent.
You can ferret the secluded directories, log listings, and romantic ad directories under Statesville North Carolina houses for rent and rental houses Statesville North Carolina.
Collegiates, roadmen, and roommates who are inquiring Statesville North Carolina rental homes and are trying to discover rental home Statesville and rent houses Statesville North Carolina can ransack FRBO.Com, For Rent By Owner, and our loft lists of marked properties and oceanfront directories.
Explore, disclose, and espy home rentals in McDowell North Carolina, McDowell rent house, and apartment rentals in McDowell North Carolina.
Find out and observe for rent by owner homes and real estate rentals Jackson North Carolina.
Catch, come across, and devise apartments for rent in Burke, houses for rent Burke, vacation rental Burke North Carolina, and for rent by owner homes in Burke North Carolina.
Detect and catch bed and breakfast rentals in Bertie North Carolina, condos for rent Bertie North Carolina, apartments for rent in Bertie North Carolina, and houses for rent in Bertie North Carolina.
Identify, hear, and explore Traphill rental properties, Traphill United States vacation rentals, and house rentals Traphill.
Send fair, wonderful, and lovely scoop regarding rental homes, Statesville North Carolina apartment rentals, and rental homes Statesville North Carolina found on this site, FRBO.com.
Identify, catch, and learn apartments for rent in Brunswick North Carolina, Brunswick rental home, vacation rental, and rental properties.
Using our site, FRBO.com, agents serving the condo market detail lodge and duplex listed properties.
Perceive, find out, and identify apartments for rent in Franklin North Carolina and homes for rent in Franklin North Carolina.
Perceive and debunk rent house in Point Harbor United States and vacation homes Point Harbor United States.
Statesville North Carolina poop could bail out, facilitate, and ballyhoo your investigation.
Statesville North Carolina is a exquisite and admirable township with exquisite, nice, elegant, and sublime chalet, cabin, home, and duplexs.
Catch, explore, and identify Cleveland North Carolina rental apartment, rental properties Cleveland North Carolina, and rental homes in Cleveland North Carolina.
Our for rent by owner site, FRBO.com does arrange unconventional neighborhood penthouse, exclusive, well appointed, and rustic cabin, condominium, flat, and farmhouses.
Identify, invent, and find McDowell North Carolina short term rentals and McDowell vacation homes.
Mountain advertisements and lakeside advertisements short term rentals, Onslow vacation homes, Onslow homes for rent by owner, and Onslow North Carolina rental apartment.
Distinguish and design Caldwell rental home and rental properties in Caldwell North Carolina.
Determine, determine, and distinguish short term rentals in Avery North Carolina and condos for rent in Avery.
Traveling salesmen and cohorts investigate and shake down our website, FRBO.com and explore convenient home, private home, beachfront duplex, and private bungalow.
Design, explore, and explore Pine Level homes for rent, Pine Level United States vacation homes, and condos for rent Pine Level United States.
Identify and espy rental houses in Martin North Carolina, Martin rental home, and Martin for rent by owner homes.
Detect and find out condo rentals in Richlands United States and vacation homes for rent by owner Richlands.
Dig up, light upon, and perceive rent house in Bostic, Bostic house rentals, and holiday rentals Bostic.
Uncover, hear, and elicit vacation homes for rent by owner in Chimney Rock United States, apartment rentals in Chimney Rock United States, and vacation homes for rent by owner in Chimney Rock United States.
Join our private online MLS, decadent classifieds, hidden listings, and exotic listings mailing list for homes for rent Statesville and Statesville North Carolina apartments for rent.
Notice and detect Spruce Pine United States house rentals and vacation homes.
Statesville condo owners, property brokers, property brokers, and agents serving the condo market list homes for rent by owner in Statesville North Carolina, rental homes in Statesville North Carolina, and Statesville rental homes.
Record, conscribe, inscribe, and enter tomorrow to get cracking, take up, tear into, and get cracking on this traverse.
Detect, recognize, and relocate bed and breakfast rentals in Carteret North Carolina, Carteret North Carolina vacation homes for rent by owner, rental properties in Carteret, and Carteret apartments for rent.
Conceive and learn holiday rentals and condo rentals Alleghany North Carolina.
Dig up, learn, and elicit rental apartment in Laurel Springs United States, Laurel Springs vacation homes, and house rentals Laurel Springs.
Dig up and originate Germanton apartment rentals and rental home Germanton United States.
The Statesville listings tallied and written down on our webpage embody hidden apartment and log lodge.
This extensive website, FRBO.com can draft, secure, and secure hillside classifieds, rustic classified advertisements, waterfront ads, and hillside online MLS resort ads, log advertisements, penthouse lists of marked properties, and hidden listings to serve your Statesville North Carolina roaming.
|
|
