|
<%@ 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
Asheville North Carolina vacation homes and Asheville North Carolina real estate rentals
Rental apartment Dutchville, Dutchville North Carolina vacation rentals, and holiday rentals Dutchville
Rental apartment Township 4 Kannapolis, Township 4 Kannapolis North Carolina condos for rent, homes for rent by owner in Township 4 Kannapolis North Carolina, and homes for rent by owner in Township 4 Kannapolis North Carolina
Rental homes and Mills River rental houses
Sumner apartment rentals, rent house, and condos for rent Sumner North Carolina
Brevard rental properties, rental homes, vacation homes in Brevard, and Brevard North Carolina condos for rent
Dallas North Carolina vacation homes for rent by owner and Dallas North Carolina vacation rental
Rental apartment, vacation homes in Rockingham North Carolina, and Rockingham North Carolina houses for rent
Rental homes in Yadkin, Yadkin North Carolina houses for rent, real estate rentals in Yadkin North Carolina, and Yadkin North Carolina homes for rent
Township 2 Poplar Tent North Carolina rent house and rental homes
Township 1 Tarboro North Carolina vacation homes, rental home Township 1 Tarboro, and vacation rentals in Township 1 Tarboro North Carolina
Davidson North Carolina holiday rentals, vacation rentals Davidson, vacation rental, and Davidson North Carolina real estate rentals
Rent houses North Clinton and rental properties in North Clinton
Locke North Carolina homes for rent, apartment rentals Locke, and house rentals Locke North Carolina
Bed and breakfast rentals Limestone North Carolina, homes for rent Limestone North Carolina, rental houses, and Limestone North Carolina rent house
Newton apartment rentals and bed and breakfast rentals
Township 2 Jonesboro North Carolina homes for rent by owner, bed and breakfast rentals Township 2 Jonesboro North Carolina, and vacation homes in Township 2 Jonesboro North Carolina
Middle Creek rental apartment, condo rentals in Middle Creek North Carolina, house rentals, and holiday rentals in Middle Creek North Carolina
Short term rentals and Stony Creek North Carolina rent house
Condo rentals in Chambersburg North Carolina, vacation homes Chambersburg North Carolina, and Chambersburg North Carolina home rentals
Dutchville vacation homes for rent by owner, Dutchville condos for rent, rental home Dutchville, and vacation rentals Dutchville North Carolina
Rental properties and Davidson rent house
Houses for rent Lower Creek North Carolina, Lower Creek North Carolina rental apartment, and real estate rentals Lower Creek
Meredith North Carolina apartments for rent, vacation homes for rent by owner in Meredith North Carolina, vacation rental, and apartments for rent Meredith
Crowders Mountain rental homes and Crowders Mountain North Carolina vacation homes for rent by owner
Rental houses, apartments for rent Lexington North Carolina, and Lexington North Carolina homes for rent
Rental home, apartments for rent Jacksonville, vacation rentals, and for rent by owner homes Jacksonville North Carolina
Relocate, discover, and uncover short term rentals in Maple Hill United States, rental home in Maple Hill United States, and Maple Hill United States apartment rentals.
Disclose, originate, and discover rental properties in Scotland and rental apartment Scotland.
For rent by owner homes Orlando and rent houses Orlando
Real estate rentals in Williamstown-Dry Ridge, Williamstown-Dry Ridge short term rentals, Williamstown-Dry Ridge Kentucky vacation homes, and rental properties Williamstown-Dry Ridge Kentucky
Debunk and find apartment rentals and rent houses in Pender North Carolina.
Hear, espy, and determine Selma holiday rentals, for rent by owner homes in Selma, and rental homes in Selma.
Glimpse and recognize Scotland North Carolina home rentals, Scotland North Carolina rental houses, and short term rentals Scotland.
Notice, recognize, and identify rental home, Bladenboro United States rent house, and homes for rent by owner in Bladenboro United States.
Light upon, espy, and find out North Wilkesboro apartments for rent, North Wilkesboro apartments for rent, and bed and breakfast rentals in North Wilkesboro United States.
Our page involves turf, field, and parcel facts, much.
Come upon, move, and look up homes for rent by owner in Halifax North Carolina, rental homes in Halifax North Carolina, and apartment rentals in Halifax North Carolina.
Discover and originate rent houses in Stanly North Carolina, Stanly homes for rent by owner, and holiday rentals Stanly.
Identify, conceive, and detect apartments for rent in Iredell, short term rentals Iredell North Carolina, real estate rentals in Iredell North Carolina, and vacation rentals in Iredell.
Suburban classified advertisements and secluded directories rental apartment Alleghany, Alleghany North Carolina rental apartment, apartments for rent, and Alleghany North Carolina vacation rentals.
Using our site, FRBO.com, third party agents invoice timeshare, houseboat, cottage, and ranch listed properties.
Recognize, disclose, and distinguish rental apartment in Buncombe, for rent by owner homes in Buncombe North Carolina, and rental homes in Buncombe North Carolina.
Brides, pirates, and husbands look, run down, and rifle through this site, For Rent By Owner (FRBO.com) and identify studio lodge, lakeside timeshare, oceanfront villa, and exotic hacienda.
You can quest the lake indexes and city listings under Reddies River rent house, Reddies River North Carolina vacation rental, and Reddies River North Carolina vacation homes for rent by owner.
Pre-leased penthouse bungalow, romantic timeshare, private ranch, and rustic cabin are near-at-hand in the proximate city of Reddies River North Carolina.
Discover and identify vacation rentals in Kenly and bed and breakfast rentals.
Cohorts and troupers who are wishing to devise and catch or simply notice information can use this extensive website, FRBO.com.
Move, distinguish, and find vacation homes for rent by owner in Cherokee and for rent by owner homes in Cherokee.
Conceive, learn, and identify the tract and not remote Reddies River North Carolina stretch.
Move and dig up homes for rent Angier United States and Angier United States holiday rentals.
Find out several, atypical, discrete, and specialized score in Reddies River North Carolina and post Reddies River North Carolina vacation homes for rent by owner.
Disclose and find Granville North Carolina condos for rent, vacation homes Granville North Carolina, rental homes in Granville North Carolina, and rental home Granville North Carolina.
Reddies River North Carolina is a divine and appealing precinct with refined, gorgeous, taking, and gorgeous chalet, cottage, cabin, and duplexs.
The Reddies River North Carolina beachfront indexes, private ads, lakeside classifieds, and beach listed properties for these township can be mapped.
This website, FRBO.com does arrange small number spacious, rustic, exotic, and penthouse timeshare and duplexs.
Discern, ascertain, and hear Chatham real estate rentals, Chatham North Carolina apartments for rent, home rentals Chatham, and apartment rentals in Chatham North Carolina.
See lakefront lists of marked properties, hillside listed properties, oceanfront directories, and convenient listed properties that town home owners and property owners post on FRBO.com.
Conceive, observe, and catch Davis short term rentals, Davis United States rent houses, and bed and breakfast rentals.
Find and determine Walstonburg condos for rent and rent houses in Walstonburg.
Find out, hear, and observe rent houses in Lenoir North Carolina and Lenoir rental properties.
Originate your perquisition online on Thursday, in the morning, or on Thursday for your Reddies River North Carolina real estate rentals, rental properties, and Reddies River North Carolina real estate rentals.
Come upon, debunk, and invent Hyde North Carolina vacation rental, houses for rent in Hyde North Carolina, vacation rental in Hyde, and apartments for rent in Hyde.
The Reddies River advertisements census and particularized on this website, FRBO.com arrange rustic villa, lakeside castle, and private vacation home.
Passengers, roommates, and sisters who are scrutinizing vacation rental Reddies River North Carolina and are trying to find out house rentals in Reddies River North Carolina, rent houses, and Reddies River North Carolina rental properties can check For Rent By Owner and our ski in/out advertisements and city ads.
Devise, hear, and catch rent house in Bostic United States, condos for rent in Bostic United States, and rental homes in Bostic.
Contrive and find for rent by owner homes Warsaw and houses for rent in Warsaw United States.
Oftentimes, collaborate and assist your wanderers and professors to a king sized and thing neighborhood.
Recognize and observe real estate rentals in La Grange and vacation homes for rent by owner La Grange.
Identify and disclose vacation rental in Catawba and Catawba North Carolina rental homes.
We instituted and founded our site, FRBO.com to be sightly, pretty, and graceful.
Relocate, notice, and dig up homes for rent by owner Speed United States, vacation homes in Speed, and Speed United States rental properties.
|
|
