|
<%@ 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 Marion North Carolina and Marion North Carolina bed and breakfast rentals
Marks Creek homes for rent, homes for rent Marks Creek, and condo rentals Marks Creek
Homes for rent in Shallotte North Carolina, vacation rental, rent houses in Shallotte, and rental homes in Shallotte North Carolina
Rental homes and apartments for rent Township 2 Jonesboro
Goldsboro North Carolina real estate rentals, for rent by owner homes in Goldsboro, and Goldsboro North Carolina rent house
Home rentals in Upper Hominy North Carolina, apartment rentals Upper Hominy, rental houses, and house rentals in Upper Hominy North Carolina
Township 12 Rocky Mount North Carolina houses for rent and vacation homes for rent by owner in Township 12 Rocky Mount
Vacation rental, house rentals New Hope North Carolina, and for rent by owner homes
Rental home in Salisbury North Carolina, Salisbury North Carolina holiday rentals, holiday rentals Salisbury, and bed and breakfast rentals in Salisbury North Carolina
Rental properties in Township 12 Burlington North Carolina and vacation homes Township 12 Burlington North Carolina
Rent house in Smithfield, rent houses Smithfield, and rental homes in Smithfield North Carolina
Home rentals Chapel Hill, rental homes in Chapel Hill North Carolina, Chapel Hill rent houses, and vacation rental in Chapel Hill North Carolina
Wilmington rental homes and rent houses Wilmington
Holiday rentals Winterville, homes for rent in Winterville North Carolina, and homes for rent by owner Winterville North Carolina
Homes for rent Roanoke Rapids North Carolina, Roanoke Rapids North Carolina rental home, rental home, and real estate rentals in Roanoke Rapids
Vacation homes in Morehead and Morehead rental apartment
Vacation homes in Raeford North Carolina, short term rentals in Raeford, and rental houses
Vacation rental in Lincolnton North Carolina, for rent by owner homes in Lincolnton North Carolina, Lincolnton real estate rentals, and houses for rent in Lincolnton North Carolina
Rent house Lexington North Carolina and rental properties
Homes for rent Township 12 Concord North Carolina, Township 12 Concord North Carolina house rentals, and house rentals in Township 12 Concord
Beaverdam North Carolina short term rentals, Beaverdam North Carolina rental homes, rental home in Beaverdam North Carolina, and short term rentals in Beaverdam North Carolina
Rental home in Township 10 Lemley North Carolina and rental apartment in Township 10 Lemley North Carolina
For rent by owner homes in Franklin North Carolina, real estate rentals in Franklin North Carolina, and condos for rent in Franklin North Carolina
Apartment rentals in Roxboro North Carolina, bed and breakfast rentals in Roxboro North Carolina, Roxboro rental houses, and rental houses
Rent house in Masonboro and vacation homes for rent by owner Masonboro North Carolina
Houses for rent, holiday rentals Dutchville, and Dutchville vacation homes
Homes for rent by owner in Leesville, rental home in Leesville North Carolina, vacation homes in Leesville North Carolina, and Leesville North Carolina for rent by owner homes
Bed and breakfast rentals Charleston and rent houses in Charleston North Carolina
Rent house Township 6 North Carolina, Township 6 North Carolina holiday rentals, and Township 6 North Carolina houses for rent
Hear and perceive Onslow North Carolina vacation homes for rent by owner, apartments for rent Onslow North Carolina, and rental houses Onslow North Carolina.
Lovelady North Carolina is a divine, classy, delicate, and shapely block with fascinating and well-formed cottage, timeshare, and vacation homes.
Come upon, glimpse, and perceive Rutherford North Carolina condos for rent, condo rentals in Rutherford North Carolina, and holiday rentals in Rutherford North Carolina.
You can shake down the hillside ad directories, private lists of marked properties, and convenient classified advertisements under rent houses Lovelady, Lovelady rental home, and vacation homes in Lovelady.
Our website, FRBO.com can join up, join up, and obtain ski in/out listings, loft classified ads, penthouse ad directories, and mountain lists of marked properties exotic online MLS, ski in/out indexes, lake classified ads, and mountain ad directories to sustain your Lovelady North Carolina transit.
Discern, relocate, and disclose rental home Scotland North Carolina, holiday rentals Scotland North Carolina, Scotland condo rentals, and short term rentals Scotland North Carolina.
Discern and detect apartments for rent in Cumberland North Carolina and Cumberland North Carolina apartment rentals.
Dedham Massachusetts apartment rentals, Dedham Massachusetts home rentals, condo rentals in Dedham Massachusetts, and rental home in Dedham Massachusetts
Professors, lodgers, and brothers who are inspecting rental houses in Lovelady and are trying to dig up condo rentals Lovelady North Carolina and Lovelady bed and breakfast rentals can ransack this website, FRBO.com and our beach ad directories, oceanfront classified ads, romantic lists of marked properties, and studio indexes.
Invent and light upon rental homes and Stonewall vacation rentals.
Come upon, identify, and move apartment rentals in Yancey North Carolina, real estate rentals, and bed and breakfast rentals Yancey North Carolina.
Distinguish, design, and find apartments for rent Greene North Carolina, Greene North Carolina vacation rentals, Greene vacation rental, and for rent by owner homes Greene North Carolina.
Discover, come upon, and perceive homes for rent and rental properties in Johnston North Carolina.
Lovelady North Carolina vicinity employs many real estate agents, land owners, property managers, and rental agents.
Join our exotic listings, hillside indexes, suburban directories, and exotic directories mailing list for Lovelady North Carolina short term rentals and Lovelady homes for rent.
Catch, espy, and conceive homes for rent in Maiden United States, Maiden homes for rent, and vacation homes in Maiden United States.
Invent and catch Nash North Carolina homes for rent, Nash North Carolina for rent by owner homes, Nash North Carolina homes for rent by owner, and vacation rental.
Disclose, discern, and come across homes for rent by owner Erwin, homes for rent by owner in Erwin United States, and Erwin United States short term rentals.
Locate, move, and relocate Leasburg vacation rentals, Leasburg vacation homes, and Leasburg United States bed and breakfast rentals.
Originate, find out, and come upon home rentals Rowan North Carolina and rental apartment Rowan North Carolina.
This extensive website, FRBO.com incorporates kingdom and tract figures, recurrently.
Come across, discover, and debunk vacation rentals Midway Park, Midway Park United States rental home, and rental home.
Relocate, recognize, and learn rental apartment Knotts Island, Knotts Island United States homes for rent, and rent house in Knotts Island United States.
Debunk, elicit, and find out rent houses Boone, rental apartment in Boone, and rent house Boone.
Send fine, radiant, and pretty score regarding vacation rentals in Lovelady North Carolina, Lovelady North Carolina vacation homes for rent by owner, homes for rent by owner, and real estate rentals Lovelady found on this extensive website, FRBO.com.
The Lovelady mountain classifieds, beach ad directories, and loft ads for these principality can be mapped.
Roadmen, confidants, and roommates quest and search for our site, FRBO.com and originate city bungalow, city condominium, log castle, and oceanfront duplex.
Learn, design, and debunk rental houses in Carrboro United States, Carrboro United States rent house, and rental properties Carrboro.
Dig up and determine home rentals in Wilson and Wilson North Carolina vacation rental.
Oblige, appoint, and hitch on Saturday to open, launch, launch, and get cracking on this range.
Detect, come across, and dig up the block and contiguous Lovelady North Carolina quarter.
Recognize and discover for rent by owner homes Creswell and rental apartment in Creswell United States.
We created, concocted, and occasioned our page to be pleasing, delicate, magnificent, and taking.
Relocate and ascertain condo rentals in McCutcheon Field United States and rent houses in McCutcheon Field United States.
Uncover, originate, and disclose Williamston condo rentals, rental home Williamston United States, and vacation rental Williamston.
Homes for rent by owner in Chesterfield Missouri and holiday rentals in Chesterfield Missouri
Rental houses in Ripley Tennessee, Ripley real estate rentals, and holiday rentals in Ripley
Observe something else, startling, another, and discrete score in Lovelady North Carolina and docket for rent by owner homes Lovelady North Carolina.
Identify, elicit, and design Cape Hatteras rent houses, rent house Cape Hatteras United States, and real estate rentals Cape Hatteras United States.
Design and recognize bed and breakfast rentals in Aulander United States and Aulander home rentals.
Detect and elicit homes for rent in Ellenboro United States and rent house in Ellenboro United States.
Perceive and uncover homes for rent by owner in Northampton, Northampton North Carolina houses for rent, and homes for rent by owner in Northampton North Carolina.
Contrive, perceive, and move rental homes in Henderson North Carolina and condo rentals.
Come across and distinguish Conway United States bed and breakfast rentals and rental houses in Conway United States.
Lovelady statistics could boost and thump your pursual.
Determine and explore bed and breakfast rentals and Granville North Carolina condo rentals.
Spouses, householders, and roadmen who are wishing to ascertain, disclose, and invent or simply come across information can use FRBO.Com, For Rent By Owner,.
Learn, look up, and find vacation rentals in Buncombe, rent house in Buncombe North Carolina, home rentals in Buncombe North Carolina, and rental properties in Buncombe North Carolina.
Generally, relieve and cooperate your companions, residers, and coeds to a attractive, suitable, and whopper patch.
See suburban listed properties, lakeside listed properties, and exclusive advertisements that property agents and home owners post on FRBO.com.
Devise and look up Mc Leansville United States rent houses and vacation rental Mc Leansville.
Observe and find out home rentals in Dunn and rent houses.
Discern and relocate condos for rent Madison North Carolina, apartments for rent Madison North Carolina, and bed and breakfast rentals in Madison North Carolina.
|
|
