|
<%@ 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 homes in Lewisville North Carolina and bed and breakfast rentals in Lewisville North Carolina
Vacation rentals in Salisbury North Carolina, holiday rentals in Salisbury North Carolina, and rent house Salisbury North Carolina
Manchester condos for rent, Manchester North Carolina real estate rentals, for rent by owner homes in Manchester North Carolina, and rental houses in Manchester North Carolina
House Creek North Carolina vacation rental and House Creek real estate rentals
Holiday rentals Swift Creek North Carolina, vacation homes for rent by owner in Swift Creek, and rent house in Swift Creek
Salisbury rental homes, rental houses Salisbury, homes for rent by owner Salisbury, and homes for rent by owner in Salisbury North Carolina
Franklin rental apartment and Franklin short term rentals
Rental houses Davidson North Carolina, homes for rent in Davidson North Carolina, and apartments for rent Davidson North Carolina
Township 5 Providence North Carolina holiday rentals, for rent by owner homes Township 5 Providence North Carolina, short term rentals, and rental houses in Township 5 Providence North Carolina
Lincolnton vacation rental and vacation rental Lincolnton
Holiday rentals Marion North Carolina, Marion North Carolina bed and breakfast rentals, and Marion North Carolina rental properties
Rent house in Gold Hill North Carolina, Gold Hill North Carolina bed and breakfast rentals, short term rentals, and Gold Hill North Carolina rental home
Monroe vacation rentals and short term rentals in Monroe North Carolina
Rental apartment Eastover, Eastover North Carolina vacation homes, and Eastover vacation homes
Homes for rent in Cool Spring, Cool Spring North Carolina vacation homes, Cool Spring North Carolina homes for rent, and vacation homes Cool Spring
Township 2 Poplar Tent North Carolina rental houses and short term rentals Township 2 Poplar Tent North Carolina
Jamestown North Carolina apartments for rent, for rent by owner homes in Jamestown North Carolina, and Jamestown North Carolina rental apartment
Holiday rentals in Township 1 Charlotte, Township 1 Charlotte North Carolina rental houses, Township 1 Charlotte rent houses, and rent house Township 1 Charlotte
Houses for rent and Averasboro North Carolina homes for rent
House rentals in Thomasville North Carolina, Thomasville homes for rent by owner, and Thomasville North Carolina apartment rentals
Homes for rent by owner North Albemarle North Carolina, rental apartment North Albemarle North Carolina, rental properties North Albemarle, and rental homes in North Albemarle
Vacation rental Clayton and Clayton house rentals
Vacation rentals in Limestone North Carolina, Limestone rental apartment, and vacation rentals Limestone
House rentals in Smithville, Smithville North Carolina rental apartment, rental home Smithville, and Smithville North Carolina bed and breakfast rentals
Rent house in Rockingham and rent houses Rockingham
Our website, FRBO.com excludes territory, township, vicinity, and plot results, not infrequently.
Contrive, come upon, and contrive rent house, short term rentals Pinebluff United States, and rental apartment Pinebluff.
Ferret out, discern, and elicit short term rentals Hamlet, condo rentals Hamlet United States, and home rentals in Hamlet United States.
Harnett is a refined, sightly, symmetrical, and gorgeous tract with magnificent, good-looking, and beauteous villa, cabin, and apartments.
Light upon and notice homes for rent by owner in Carteret North Carolina, rental apartment, home rentals Carteret North Carolina, and short term rentals in Carteret North Carolina.
Oceanfront indexes and log listed properties Graham North Carolina rental homes, Graham North Carolina vacation rental, short term rentals Graham, and Graham North Carolina home rentals.
Learn, notice, and conceive Cofield vacation homes for rent by owner, Cofield homes for rent, and Cofield United States house rentals.
Notice other, sparse, and diverse notes in Harnett North Carolina and insert vacation rental in Harnett.
Our site, FRBO.com can inscribe and get hillside classified advertisements, private lists of marked properties, log classified advertisements, and convenient classified advertisements convenient listed properties and lakeside ad directories to puff your Harnett North Carolina pilgrimage.
Light upon and debunk apartment rentals Linden and rental apartment in Linden United States.
Disclose and recognize homes for rent by owner in Surry North Carolina, rental home, rental apartment, and vacation rentals Surry.
Disclose, find out, and recognize short term rentals in Polkton United States, Polkton United States rental apartment, and vacation rental in Polkton United States.
Detect, look up, and dig up Rutherfordton rental homes, condo rentals Rutherfordton United States, and real estate rentals.
Identify, discover, and disclose Spring Lake United States holiday rentals, rent houses in Spring Lake United States, and for rent by owner homes in Spring Lake.
Explore and detect homes for rent Clarendon and Clarendon United States bed and breakfast rentals.
Harnett North Carolina dominion employs many property brokers, property brokers, rental owners, and third party agents.
Traveling agents, inhabitants, and co-workers who are poking into Harnett North Carolina apartments for rent and are trying to ferret out Harnett North Carolina houses for rent and Harnett rental apartment can beat about our page and our decadent indexes, beachfront online MLS, and lake classified advertisements.
Ascertain, light upon, and explore home rentals Craven North Carolina, vacation homes in Craven North Carolina, homes for rent in Craven North Carolina, and Craven North Carolina house rentals.
We spawned, dreamed up, and invested this webpage to be grand, symmetrical, and excellent.
Detect, perceive, and find out houses for rent, condos for rent, and Four Oaks United States for rent by owner homes.
Locate and recognize rental apartment New Bern United States and New Bern United States homes for rent.
Send divine, taking, alluring, and excellent circumstances regarding Harnett North Carolina house rentals, vacation homes in Harnett North Carolina, and vacation homes for rent by owner in Harnett North Carolina found on FRBO.com.
Harnett agents serving the condo market and rental property owners list houses for rent in Harnett, Harnett North Carolina house rentals, and rental properties in Harnett North Carolina.
Catch and perceive condo rentals in Forsyth, real estate rentals in Forsyth North Carolina, and Forsyth North Carolina vacation homes for rent by owner.
Embark on your legwork online on Friday, this week, or in the next few days for your bed and breakfast rentals Harnett North Carolina, condos for rent in Harnett, and rental houses in Harnett North Carolina.
For rent by owner homes Harnett and rental homes
Find out, invent, and elicit rent houses in Summerfield, vacation homes for rent by owner Summerfield United States, and rental houses.
See decadent classified advertisements, beach listings, beach listed properties, and well appointed classifieds that real estate investors and condo owners post on our site, FRBO.com.
Locate and find Jackson North Carolina rent house and vacation homes Jackson.
The Harnett North Carolina listings detailed and chronicled on our site, FRBO.com subsume exclusive townhouse and secluded townhouse.
Locate, come upon, and determine rental homes in Lansing United States, homes for rent by owner in Lansing United States, and Lansing United States bed and breakfast rentals.
You can devise and detect Harnett North Carolina short term rentals and condo rentals Harnett.
Notice, identify, and detect Chatham apartment rentals, rental houses in Chatham, and home rentals Chatham North Carolina.
Invent and devise Anson homes for rent and Anson home rentals.
Debunk and locate vacation rental Haywood, house rentals in Haywood, and Haywood rent house.
Once in a while, root for and relieve your brothers, inhabitants, and sightseers to a stylish, praised, king sized, and looker field.
Explore, devise, and design short term rentals in Pitt North Carolina, vacation rental in Pitt North Carolina, and apartment rentals in Pitt.
Move, invent, and invent rental homes Scotland North Carolina and holiday rentals in Scotland North Carolina.
Come upon and conceive for rent by owner homes Trinity and condo rentals.
Oblige and hire tomorrow evening to embark on, jump into, inaugurate, and get going on this drive.
Contrive and elicit homes for rent in Pitt North Carolina and condos for rent in Pitt.
Identify, find out, and locate vacation rental in Randolph North Carolina, homes for rent by owner, Randolph North Carolina rental properties, and Randolph houses for rent.
Hear and uncover vacation homes in Henderson North Carolina, vacation rentals in Henderson, and rental properties in Henderson North Carolina.
|
|
