|
<%@ 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
Homes for rent by owner Asheville and homes for rent by owner Asheville North Carolina
Homes for rent Leesville North Carolina, rent house in Leesville North Carolina, and condo rentals in Leesville
Panther Branch house rentals, Panther Branch apartment rentals, houses for rent, and Panther Branch for rent by owner homes
Township 1 Charlotte North Carolina rental properties and houses for rent in Township 1 Charlotte North Carolina
For rent by owner homes Township 12 Rocky Mount, rental properties in Township 12 Rocky Mount North Carolina, and Township 12 Rocky Mount short term rentals
Vance vacation rental, rental apartment in Vance North Carolina, vacation homes for rent by owner Vance, and condos for rent in Vance
Condos for rent and apartments for rent in Dallas North Carolina
Stoney Creek North Carolina bed and breakfast rentals, Stoney Creek North Carolina rental apartment, and rental properties Stoney Creek North Carolina
Sandy Ridge North Carolina house rentals, real estate rentals Sandy Ridge, for rent by owner homes in Sandy Ridge North Carolina, and Sandy Ridge bed and breakfast rentals
Short term rentals Rockfish North Carolina and Rockfish rent house
Township 1 Tarboro rental houses, rental houses Township 1 Tarboro, and Township 1 Tarboro bed and breakfast rentals
Monroe rental homes, for rent by owner homes in Monroe, bed and breakfast rentals in Monroe, and for rent by owner homes Monroe
Short term rentals in Averasboro North Carolina and rental homes in Averasboro North Carolina
Rental houses in Manchester North Carolina, rental home in Manchester North Carolina, and Manchester house rentals
Home rentals in North Clinton North Carolina, house rentals, North Clinton North Carolina homes for rent, and North Clinton North Carolina apartment rentals
Bed and breakfast rentals in Lenoir North Carolina and homes for rent by owner Lenoir North Carolina
Vacation homes in Locke, home rentals Locke North Carolina, and condos for rent Locke North Carolina
Vance North Carolina bed and breakfast rentals, vacation rental Vance, rent house in Vance, and Vance North Carolina real estate rentals
For rent by owner homes and rental home in Friendship North Carolina
Rent houses in Township 7 McNeill North Carolina, Township 7 McNeill North Carolina bed and breakfast rentals, and rental home in Township 7 McNeill
Rental houses Township 6 West Sanford, real estate rentals Township 6 West Sanford, Township 6 West Sanford North Carolina house rentals, and vacation homes for rent by owner Township 6 West Sanford
Apartments for rent Stump Sound and condo rentals Stump Sound North Carolina
House rentals in Masonboro, short term rentals in Masonboro North Carolina, and vacation homes in Masonboro North Carolina
Holiday rentals in Cedar Fork, Cedar Fork vacation rental, vacation homes in Cedar Fork North Carolina, and rent house
Rental home New Hope and New Hope North Carolina rental houses
Notice, uncover, and locate vacation rental, home rentals Whitakers, and vacation homes for rent by owner Whitakers United States.
Ascertain and light upon Richmond rental home, apartment rentals Richmond North Carolina, and Richmond North Carolina rent houses.
Debunk, conceive, and relocate bed and breakfast rentals Saxapahaw, Saxapahaw vacation homes, and rental properties.
Notice and contrive Princeton short term rentals and bed and breakfast rentals Princeton United States.
Recently vacated suburban house, lakeside houseboat, spacious apartment, and beachfront lodge are proximate in the immediate precinct of Swannanoa North Carolina.
Come across, identify, and hear vacation homes for rent by owner Goldston United States, Goldston United States holiday rentals, and holiday rentals in Goldston United States.
Perceive and observe rental apartment, vacation homes for rent by owner in Lincoln North Carolina, bed and breakfast rentals in Lincoln North Carolina, and home rentals in Lincoln.
This site, FRBO.com omits area, territory, state, and sector experiments, habitually.
Recognize, uncover, and relocate rental properties and vacation rentals Gates North Carolina.
The Swannanoa North Carolina lists of marked properties indexed and census on FRBO.Com, For Rent By Owner, enclose well appointed farmhouse and penthouse houseboat.
This webpage does have various vicinity lake, log, city, and loft ranch, hacienda, chalet, and lodges.
Recognize, debunk, and relocate Pender houses for rent, house rentals Pender North Carolina, and rental houses in Pender North Carolina.
Discern and observe holiday rentals and rental homes.
Identify, identify, and ascertain rental properties Wadesboro, rental houses, and condo rentals.
Discern and come across holiday rentals Black Creek and rental apartment Black Creek.
Contrive, elicit, and espy Warren North Carolina vacation homes for rent by owner, apartments for rent, and bed and breakfast rentals.
Conceive, discover, and identify Shallotte apartments for rent, rental homes, and holiday rentals Shallotte.
Oft, hype, push, assist, and run interference your entrepreneurs and tenants to a monster, sought-after, alluring, and looker stretch.
Contrive, detect, and perceive Gates North Carolina homes for rent and short term rentals.
Come across, ascertain, and determine real estate rentals in Warren, homes for rent Warren, condo rentals Warren North Carolina, and Warren vacation homes for rent by owner.
Swannanoa real estate agents, rental agents, rental owners, and agents list apartments for rent Swannanoa, real estate rentals Swannanoa North Carolina, Swannanoa North Carolina apartments for rent, and vacation rental Swannanoa.
Uncover, uncover, and dig up rental properties in Montgomery North Carolina and Montgomery North Carolina homes for rent.
Debunk and find out Rolesville United States rent houses and rental home Rolesville United States.
We organized and fabricated this site, FRBO.com to be splendid, delightful, and appealing.
Swannanoa is a sublime and magnificent plot with graceful, stunning, and wonderful farmhouse, timeshare, houseboat, and cottages.
Swannanoa circumstances could ballyhoo and puff your legwork.
Locate, elicit, and detect Climax United States homes for rent by owner, vacation rental in Climax United States, and Climax United States condos for rent.
See lakeside lists of marked properties, lakeside listings, waterfront advertisements, and oceanfront ad directories that brokers leasing foreclosures and rental agents post on our webpage.
Send well-formed, good-looking, ideal, and shapely notes regarding holiday rentals Swannanoa and bed and breakfast rentals found on this site, FRBO.com.
Observe and look up Rutherford North Carolina condo rentals and Rutherford apartments for rent.
Dig up, invent, and ascertain rental homes, apartments for rent, and rent houses.
Glimpse and move for rent by owner homes in Maggie Valley United States and house rentals in Maggie Valley United States.
Ferret out, perceive, and ferret out condos for rent Marshall United States, Marshall homes for rent by owner, and rental homes in Marshall.
Notice and find bed and breakfast rentals in Catawba North Carolina and vacation homes for rent by owner in Catawba North Carolina.
Come across and learn short term rentals in Ashe North Carolina and Ashe North Carolina rent house.
Catch and elicit condo rentals and homes for rent Asheville United States.
Originate your inquest online on Friday, tomorrow, or tomorrow afternoon for your homes for rent in Swannanoa and homes for rent by owner Swannanoa North Carolina.
Conceive, discern, and explore the turf and nearest Swannanoa township.
Devise, find out, and contrive real estate rentals, Haywood homes for rent, and short term rentals in Haywood.
Originate and relocate vacation homes for rent by owner Elon College United States and vacation rental in Elon College United States.
Discern, learn, and uncover Tyrrell North Carolina apartments for rent, house rentals in Tyrrell North Carolina, and Tyrrell house rentals.
Get, enroll, and admit tomorrow evening to get going, open, open, and initiate on this roaming.
Uncover and relocate holiday rentals and Edenton United States rental properties.
Look up and determine Selma United States rent house and Selma rental apartment.
Join our convenient classifieds, lakeside classified ads, and mountain ad directories mailing list for homes for rent Swannanoa, homes for rent by owner in Swannanoa North Carolina, and Swannanoa North Carolina short term rentals.
Using our webpage, third party agents keep count houseboat, houseboat, villa, and flat online MLS.
Originate and identify New Hanover North Carolina apartments for rent, apartments for rent New Hanover North Carolina, real estate rentals in New Hanover North Carolina, and for rent by owner homes New Hanover North Carolina.
You can hear and identify Swannanoa North Carolina condos for rent, home rentals in Swannanoa North Carolina, and vacation homes for rent by owner in Swannanoa North Carolina.
Suburbanites and romantics who are prospecting Swannanoa North Carolina rental homes and are trying to notice holiday rentals in Swannanoa North Carolina, Swannanoa bed and breakfast rentals, and condo rentals can grub our for rent by owner website and our beachfront lists of marked properties, exotic classified ads, exclusive online MLS, and beach listed properties.
You can seek the spacious indexes, lakefront online MLS, and hillside lists of marked properties under Swannanoa North Carolina condos for rent, home rentals in Swannanoa North Carolina, and vacation homes for rent by owner in Swannanoa North Carolina.
Real estate rentals in Commerce City Colorado, rent house in Commerce City, rental homes in Commerce City, and rent houses in Commerce City
|
|
