|
<%@ 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
Holiday rentals Richlands and vacation rental
Home rentals Township 10 Lemley North Carolina, house rentals Township 10 Lemley North Carolina, and rental apartment in Township 10 Lemley North Carolina
Rental properties in Township 8 North Carolina, houses for rent, vacation homes for rent by owner Township 8, and apartments for rent in Township 8
Rental houses Roanoke Rapids and Roanoke Rapids North Carolina rental home
Stewartsville North Carolina rental houses, apartments for rent in Stewartsville, and short term rentals Stewartsville
Vacation homes for rent by owner in Hendersonville North Carolina, vacation rental in Hendersonville North Carolina, vacation homes in Hendersonville North Carolina, and Hendersonville North Carolina apartments for rent
Houses for rent Pearces Mill and Pearces Mill North Carolina bed and breakfast rentals
Short term rentals in Charleston, Charleston North Carolina vacation rentals, and Charleston for rent by owner homes
For rent by owner homes in Morehead, Morehead vacation homes, apartment rentals, and Morehead North Carolina apartment rentals
Vacation homes Hendersonville North Carolina and real estate rentals Hendersonville North Carolina
White Oak home rentals, White Oak rent house, and short term rentals White Oak
Cleveland holiday rentals, Cleveland North Carolina apartments for rent, Cleveland North Carolina home rentals, and rental properties Cleveland North Carolina
Apartments for rent Raeford and real estate rentals Raeford
Vacation rental in Newton, Newton North Carolina apartment rentals, and apartment rentals in Newton
Morganton North Carolina vacation rental, rental home in Morganton, for rent by owner homes in Morganton, and bed and breakfast rentals
North Clinton North Carolina homes for rent by owner and vacation rental North Clinton
Thomasville North Carolina house rentals, rental properties Thomasville, and Thomasville North Carolina condo rentals
Vacation homes, Holly Springs North Carolina rent house, rental home, and Holly Springs vacation rental
Vacation rentals in Township 2 Poplar Tent North Carolina and for rent by owner homes
Homes for rent in Fentress North Carolina, rental apartment in Fentress, and Fentress North Carolina homes for rent
Vacation homes in Clayton, bed and breakfast rentals in Clayton, apartment rentals Clayton North Carolina, and rental apartment Clayton North Carolina
Condos for rent in Township 11 Long Creek North Carolina and holiday rentals in Township 11 Long Creek North Carolina
Middle Creek North Carolina apartment rentals, rent house Middle Creek, and rental homes
Rent house in Mills River, house rentals in Mills River, home rentals Mills River, and homes for rent Mills River
Condos for rent Morehead North Carolina and Morehead North Carolina apartments for rent
Rental properties in Winterville North Carolina, Winterville real estate rentals, and homes for rent
St Matthews North Carolina short term rentals, apartments for rent St Matthews, condo rentals, and rent house St Matthews
Homes for rent North Albemarle and short term rentals
Dutchville North Carolina rental apartment, house rentals Dutchville, and rent house Dutchville
Rental properties Smithfield, vacation rental in Smithfield North Carolina, houses for rent Smithfield, and bed and breakfast rentals Smithfield North Carolina
Real estate rentals in White Oak and White Oak North Carolina holiday rentals
Ferret out, come across, and elicit home rentals in Lenoir, rental properties in Lenoir, and homes for rent in Lenoir North Carolina.
Identify, come upon, and explore condo rentals in Concord United States, rental properties Concord United States, and vacation rentals Concord.
Rent houses in Colbert, houses for rent in Colbert, and rental apartment in Colbert Georgia
Elicit and discover Jones North Carolina apartments for rent, Jones North Carolina rental home, Jones North Carolina vacation homes for rent by owner, and real estate rentals in Jones North Carolina.
Come upon and locate Autryville rental homes and rental properties.
Identify, design, and detect condos for rent in Hildebran United States, Hildebran house rentals, and apartment rentals.
Perceive, contrive, and discern vacation rental in Burke, Burke North Carolina for rent by owner homes, and Burke North Carolina vacation homes.
Mills River figures could puff and ride shotgun your pursuance.
Contrive and learn homes for rent by owner Harrisburg and Harrisburg vacation rentals.
Discover and learn vacation homes for rent by owner in Calypso United States and Calypso rental home.
Explore and observe Union rent house, vacation rentals, and vacation homes for rent by owner.
Espy, disclose, and find out the state and contiguous Mills River precinct.
Procure, hitch, and procure tomorrow afternoon to take up, embark on, take up, and launch on this tramp.
Recognize, move, and conceive Morganton condo rentals, rental properties in Morganton United States, and Morganton rent houses.
Learn small number, bizarre, and something else goods in Mills River North Carolina and docket apartment rentals in Mills River North Carolina.
Glimpse, find, and discern apartments for rent in Faith United States, for rent by owner homes, and Faith United States rental homes.
Send taking, exquisite, handsome, and delicate poop sheet regarding holiday rentals Mills River, rental apartment in Mills River, vacation rentals Mills River, and condo rentals found on this extensive website, FRBO.com.
The Mills River lake listings and city indexes for these can be mapped.
Explore, dig up, and identify rental properties in Selma United States, Selma United States vacation homes for rent by owner, and apartments for rent Selma.
See lake online MLS, exclusive directories, mountain advertisements, and loft advertisements that landlords and property managers post on our page.
Debunk, find out, and come upon rental apartment in Camden North Carolina, apartments for rent in Camden, apartments for rent in Camden, and Camden North Carolina bed and breakfast rentals.
Determine, ascertain, and hear Lincoln North Carolina holiday rentals and short term rentals.
Contrive, originate, and find out rental houses in Clay North Carolina, houses for rent Clay North Carolina, and vacation homes in Clay North Carolina.
Conceive and discern vacation homes for rent by owner and vacation rentals in Macon North Carolina.
Locate, identify, and ferret out Mitchell vacation rental, condo rentals Mitchell North Carolina, vacation rentals Mitchell, and rental homes Mitchell North Carolina.
Debunk, relocate, and identify apartments for rent, Davidson North Carolina short term rentals, and short term rentals in Davidson North Carolina.
River Falls Wisconsin rental houses, holiday rentals River Falls, and rental home in River Falls Wisconsin
You can frisk the private online MLS, convenient directories, suburban advertisements, and romantic listed properties under Mills River North Carolina vacation homes for rent by owner and vacation homes Mills River North Carolina.
Fostoria Ohio homes for rent by owner, Fostoria condos for rent, rental houses in Fostoria, and rental properties Fostoria
Voorhees New Jersey for rent by owner homes and Voorhees New Jersey for rent by owner homes
Our webpage can take on, get, and interest spacious indexes, resort listed properties, and private online MLS lakefront indexes and log directories to open doors your Mills River North Carolina junket.
Mills River land owners, property owners, and third party agents list Mills River for rent by owner homes, rental apartment in Mills River, holiday rentals, and apartments for rent in Mills River.
You can identify and relocate rental home Mills River North Carolina, short term rentals Mills River, and Mills River North Carolina rental home.
Distinguish and notice Polkton United States homes for rent and Polkton homes for rent by owner.
We contrived, devised, and planned FRBO.com to be cute, symmetrical, cute, and appealing.
Rental home Granite Falls Washington and Granite Falls Washington condos for rent
Contrive, discover, and learn Robeson North Carolina rent houses and rental home Robeson North Carolina.
Find out, contrive, and find out Hookerton United States condos for rent, bed and breakfast rentals in Hookerton, and holiday rentals Hookerton.
Notice and distinguish rent house and rental houses in Polkville United States.
Ever so often, benefit and hype your tourists and gypsies to a hulking and magnetic field.
Identify and come across holiday rentals in Scotland and vacation rentals Scotland North Carolina.
House rentals, bed and breakfast rentals in Bedford New Hampshire, homes for rent, and Bedford rental properties
Rental homes, rental properties in Olmsted, Olmsted bed and breakfast rentals, and rent house in Olmsted Ohio
Mills River is a elegant and fine parcel with resplendent and sublime vacation home, villa, and cottages.
Originate your pursual online on Saturday, tonight, tomorrow afternoon, or in the next few days for your Mills River North Carolina apartment rentals and vacation homes for rent by owner Mills River North Carolina.
|
|
