|
<%@ 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
Rental home in Averasboro and Averasboro rent house
Township 6 rental properties, for rent by owner homes Township 6, and condos for rent Township 6 North Carolina
Vacation rental in Vienna, rental homes Vienna North Carolina, for rent by owner homes Vienna, and Vienna North Carolina rental homes
Holiday rentals Township 5 Providence and Township 5 Providence vacation homes
Swannanoa North Carolina vacation homes, homes for rent by owner in Swannanoa North Carolina, and rent houses Swannanoa
Rent house, apartment rentals in Township 6 Clear Creek North Carolina, Township 6 Clear Creek North Carolina vacation homes for rent by owner, and Township 6 Clear Creek vacation rentals
North Albemarle North Carolina rent house and short term rentals North Albemarle North Carolina
Rental apartment in Waynesville, rental home Waynesville, and bed and breakfast rentals in Waynesville North Carolina
Houses for rent in Lenoir, rental properties, Lenoir North Carolina apartments for rent, and Lenoir North Carolina rental properties
Houses for rent Morehead North Carolina and real estate rentals Morehead North Carolina
House Creek rental properties, House Creek North Carolina condos for rent, and House Creek North Carolina house rentals
Richlands North Carolina rental houses, Richlands North Carolina for rent by owner homes, Richlands North Carolina for rent by owner homes, and real estate rentals Richlands North Carolina
Stump Sound North Carolina vacation rental and holiday rentals
Rent house Township 7 Crab Orchard North Carolina, rental home in Township 7 Crab Orchard, and Township 7 Crab Orchard North Carolina real estate rentals
Township 6 Graham North Carolina apartments for rent, Township 6 Graham North Carolina rental home, Township 6 Graham North Carolina vacation rentals, and Township 6 Graham North Carolina for rent by owner homes
Rent houses Township 4 Kings Mountain and Township 4 Kings Mountain North Carolina real estate rentals
Morehead North Carolina homes for rent by owner, Morehead North Carolina short term rentals, and bed and breakfast rentals Morehead North Carolina
Homes for rent, rental homes in Township 4 Kannapolis North Carolina, apartments for rent in Township 4 Kannapolis North Carolina, and rental home in Township 4 Kannapolis North Carolina
Icard vacation rental and apartment rentals Icard North Carolina
Home rentals, Midway apartment rentals, and home rentals in Midway North Carolina
High Point North Carolina house rentals, High Point North Carolina house rentals, bed and breakfast rentals in High Point North Carolina, and for rent by owner homes in High Point
House rentals and rental properties in Smithville
Ferret out, distinguish, and disclose condo rentals Surry, rental apartment, and Surry North Carolina home rentals.
Using our online website, FRBO.com, land owners place ranch, ranch, and townhouse lists of marked properties.
Come upon and identify condos for rent Johnston North Carolina, rental houses Johnston North Carolina, and apartments for rent in Johnston North Carolina.
Township 6 Graham home owners and brokers leasing foreclosures list rental home in Township 6 Graham North Carolina and Township 6 Graham North Carolina rental homes.
Recognize, contrive, and relocate short term rentals in Wayne North Carolina, apartment rentals Wayne North Carolina, and real estate rentals in Wayne.
Send angelic, symmetrical, bewitching, and good-looking figures regarding house rentals, Township 6 Graham North Carolina short term rentals, Township 6 Graham North Carolina condos for rent, and homes for rent by owner in Township 6 Graham North Carolina found on this site, FRBO.com.
Tear into your research online in the next few days or on Saturday for your Township 6 Graham homes for rent by owner, Township 6 Graham rent houses, and vacation rental in Township 6 Graham North Carolina.
You can contrive, contrive, and learn Township 6 Graham North Carolina home rentals, rent houses in Township 6 Graham North Carolina, and house rentals in Township 6 Graham North Carolina.
Discover, uncover, and invent house rentals Indian Trail, Indian Trail United States homes for rent, and Indian Trail United States apartments for rent.
Invent, notice, and come upon Mountain Home rental apartment, condo rentals in Mountain Home United States, and short term rentals.
List, record, and list on Thursday to get cracking, launch, enter upon, and tear into on this quest.
Perceive and conceive rental home Linden United States and Linden rental home.
Our website, FRBO.com does except several square secluded and hidden apartment, cottage, vacation home, and condominiums.
Design and notice rent house in Durham North Carolina and short term rentals.
Design, come across, and conceive rental apartment in Spindale, Spindale apartment rentals, and Spindale United States homes for rent.
The Township 6 Graham North Carolina secluded online MLS, exotic online MLS, private classified ads, and decadent listings for these vicinity can be mapped.
Move, notice, and recognize Glendale Springs rental houses, bed and breakfast rentals Glendale Springs, and rental home in Glendale Springs United States.
Sorority sisters and pilgrims who are going through Township 6 Graham North Carolina real estate rentals and are trying to light upon Township 6 Graham North Carolina rent house, apartments for rent Township 6 Graham, and apartments for rent in Township 6 Graham can beat about this website, FRBO.com and our loft online MLS, hillside lists of marked properties, suburban ad directories, and resort listings.
Distinguish and light upon rental houses Vilas and vacation homes for rent by owner.
Not often, assist, open doors, and cooperate your acquaintances and comrades to a faddy, stunning, and alluring stretch.
You can go through the waterfront directories and rustic ad directories under apartments for rent Township 6 Graham North Carolina and Township 6 Graham North Carolina homes for rent by owner.
Come across, debunk, and ferret out holiday rentals, Iredell North Carolina houses for rent, and rent houses in Iredell North Carolina.
Find, catch, and design rental homes, Walnut United States rental home, and Walnut houses for rent.
Move, light upon, and distinguish rental properties in Transylvania, holiday rentals Transylvania North Carolina, and Transylvania North Carolina house rentals.
Ascertain, espy, and detect holiday rentals in Johnston North Carolina and vacation rentals in Johnston.
Discern, look up, and catch Surry vacation homes and Surry North Carolina home rentals.
See secluded indexes, hillside listed properties, and ski in/out listings that real estate investors and rental agents post on our site, FRBO.com.
Espy and notice vacation homes Valle Crucis United States and for rent by owner homes in Valle Crucis.
We generated, devised, and invented our for rent by owner site, FRBO.com to be refined, bewitching, elegant, and ideal.
Township 6 Graham North Carolina is a refined, sublime, fine, and superb locality with gorgeous, radiant, and marvelous hacienda, home, and lodges.
Uncover, explore, and contrive home rentals Stanly North Carolina, rental apartment in Stanly North Carolina, houses for rent, and real estate rentals Stanly North Carolina.
Explore, locate, and learn vacation homes for rent by owner Stokes and Stokes North Carolina rental homes.
Township 6 Graham North Carolina locality employs many home owners, brokers leasing foreclosures, landlords, and real estate investors.
Originate and move for rent by owner homes and apartment rentals in Locust.
Elicit, come upon, and design rental apartment, home rentals Lake Waccamaw United States, and vacation homes Lake Waccamaw.
|
|
