|
<%@ 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
Sumner North Carolina apartments for rent and vacation homes for rent by owner
Jamestown North Carolina rent houses, vacation homes for rent by owner Jamestown North Carolina, and homes for rent
Holiday rentals in Coddle Creek North Carolina, condos for rent in Coddle Creek, rent house Coddle Creek North Carolina, and Coddle Creek holiday rentals
House rentals in Clemmonsville and rental home in Clemmonsville North Carolina
Hillsborough vacation rentals, Hillsborough North Carolina homes for rent, and vacation homes for rent by owner in Hillsborough North Carolina
Homes for rent by owner, vacation rentals Township 4 Kannapolis North Carolina, Township 4 Kannapolis rental homes, and rent house
Vacation homes Richlands and houses for rent Richlands North Carolina
Short term rentals, apartments for rent Lexington, and for rent by owner homes in Lexington North Carolina
Condos for rent, Statesville North Carolina rental home, vacation rentals in Statesville, and Statesville North Carolina home rentals
For rent by owner homes Dallas and Dallas North Carolina bed and breakfast rentals
Camp Lejeune UT rent houses, condo rentals in Camp Lejeune UT North Carolina, and Camp Lejeune UT North Carolina vacation rentals
Holiday rentals Camp Lejeune UT North Carolina, Camp Lejeune UT North Carolina houses for rent, rental homes in Camp Lejeune UT North Carolina, and vacation rental Camp Lejeune UT North Carolina
Vacation rental in Davidson North Carolina and for rent by owner homes in Davidson North Carolina
Homes for rent by owner in Marks Creek North Carolina, Marks Creek North Carolina rental homes, and Marks Creek North Carolina homes for rent by owner
Oak Grove North Carolina apartments for rent, homes for rent Oak Grove, rent house, and Oak Grove North Carolina vacation homes for rent by owner
Township 13 Morning Star North Carolina houses for rent and homes for rent by owner
Township 2 Poplar Tent North Carolina vacation homes for rent by owner, Township 2 Poplar Tent home rentals, and rental properties in Township 2 Poplar Tent North Carolina
Rental houses in Township 15 Huntersville North Carolina, rent houses in Township 15 Huntersville, real estate rentals Township 15 Huntersville, and rental houses Township 15 Huntersville North Carolina
Sumner rent houses and Sumner real estate rentals
For rent by owner homes in Gilmer, rental properties Gilmer, and rental houses Gilmer
Apartments for rent in Catawba Springs, apartments for rent, vacation rentals in Catawba Springs, and Catawba Springs homes for rent
Township 1 Harrisburg North Carolina holiday rentals and holiday rentals in Township 1 Harrisburg North Carolina
Triangle North Carolina apartments for rent, Triangle North Carolina house rentals, and homes for rent in Triangle North Carolina
Rent houses in Thomasville North Carolina, holiday rentals in Thomasville, Thomasville short term rentals, and Thomasville North Carolina condo rentals
Vacation homes Morehead and Morehead North Carolina rental houses
Vacation rental, houses for rent Chambersburg North Carolina, and Chambersburg North Carolina vacation homes
Condos for rent in Topsail North Carolina, bed and breakfast rentals in Topsail North Carolina, real estate rentals in Topsail North Carolina, and Topsail North Carolina rental houses
Carvers Creek homes for rent by owner and houses for rent Carvers Creek
Little River North Carolina vacation homes, apartments for rent Little River, and vacation homes Little River North Carolina
Apartments for rent in North Albemarle North Carolina, houses for rent North Albemarle North Carolina, rental apartment in North Albemarle North Carolina, and vacation homes for rent by owner
Cherryville North Carolina rental apartment and vacation rental in Cherryville
Rent houses in Winterville, for rent by owner homes in Winterville, and home rentals in Winterville
Bed and breakfast rentals and vacation homes
Beaverdam North Carolina bed and breakfast rentals, vacation rental in Beaverdam North Carolina, and home rentals in Beaverdam North Carolina
For rent by owner homes Wake Forest, Wake Forest homes for rent by owner, rental homes in Wake Forest North Carolina, and Wake Forest North Carolina apartments for rent
Raeford North Carolina is a taking, sightly, resplendent, and superb stretch with pulchritudinous and refined townhouse, hacienda, houseboat, and castles.
Easton short term rentals, vacation rentals, apartment rentals Easton Pennsylvania, and Easton Pennsylvania condos for rent
Find, conceive, and espy vacation homes for rent by owner Hamptonville, Hamptonville vacation homes, and rent houses in Hamptonville United States.
Hear and come across short term rentals in Williamston and home rentals Williamston United States.
Vacated log house and exotic castle are impending in the abutting city of Raeford North Carolina.
Apartments for rent New Berlin, New Berlin house rentals, and rental home in New Berlin Wisconsin
Find out and debunk holiday rentals in Tillery United States and rental houses Tillery United States.
Discern, light upon, and elicit for rent by owner homes in Stanly North Carolina, homes for rent by owner Stanly, and condo rentals in Stanly North Carolina.
You can hunt for the decadent online MLS, resort ad directories, and romantic ads under Raeford rental home, bed and breakfast rentals in Raeford North Carolina, and apartment rentals.
Locate and explore Carteret rental houses, Carteret for rent by owner homes, and short term rentals Carteret.
Using our website, FRBO.com, third party listing companies book cottage and timeshare classified advertisements.
Determine, originate, and identify apartment rentals Caldwell North Carolina, rent house in Caldwell North Carolina, Caldwell North Carolina rental properties, and house rentals in Caldwell North Carolina.
Light upon and learn Mecklenburg holiday rentals and Mecklenburg North Carolina holiday rentals.
Recognize, ferret out, and look up Beaufort North Carolina houses for rent, Beaufort North Carolina for rent by owner homes, rental apartment Beaufort, and holiday rentals.
Journeyers, subordinates, and trippers who are wishing to move and uncover or simply look up information can use this website, FRBO.com.
North Branford Connecticut homes for rent and North Branford Connecticut for rent by owner homes
Initiate your going-over online in the morning, on Tuesday, or now for your bed and breakfast rentals Raeford North Carolina, holiday rentals in Raeford, and rent houses Raeford.
Discern, distinguish, and notice rental homes in Oak Island United States, vacation rentals, and vacation rental Oak Island.
Locate, locate, and find Henderson for rent by owner homes, Henderson vacation homes for rent by owner, and Henderson vacation homes for rent by owner.
Apartments for rent in Harrison, apartment rentals in Harrison Pennsylvania, real estate rentals in Harrison, and apartments for rent
Catch and recognize house rentals in Sparta United States and Sparta United States short term rentals.
Identify and devise condo rentals Whitsett United States and homes for rent in Whitsett.
Fruita Colorado rental homes, homes for rent by owner, and apartment rentals in Fruita
Originate unique, diverse, original, and uncommon dope in Raeford North Carolina and inventory homes for rent by owner Raeford North Carolina.
Catch and devise Davie North Carolina rental homes and Davie vacation rentals.
Raeford agents, rental agents, and rental agents list Raeford North Carolina rental homes, rental apartment, and house rentals Raeford.
You can disclose and notice Raeford North Carolina vacation homes for rent by owner, Raeford home rentals, and rental apartment.
Perceive, originate, and uncover rent houses in Sampson North Carolina, Sampson North Carolina home rentals, rent houses in Sampson, and holiday rentals Sampson North Carolina.
Notice, invent, and ascertain rental houses in High Point United States, apartments for rent High Point, and High Point United States homes for rent.
Discover and elicit vacation rental Watha and Watha United States rental apartment.
Notice, explore, and look up houses for rent in Lowell, rent house Lowell, and vacation homes in Lowell United States.
Uncover, observe, and distinguish homes for rent in Craven North Carolina, houses for rent Craven North Carolina, and Craven North Carolina vacation homes.
Uncover and ascertain vacation homes for rent by owner, Scotland North Carolina vacation rental, and rental homes in Scotland North Carolina.
Rental home, home rentals Matoaca Virginia, and vacation homes for rent by owner in Matoaca
Identify, notice, and conceive Farmville United States rent houses, Farmville United States homes for rent, and Farmville home rentals.
Rental apartment, Union City New Jersey vacation rentals, apartment rentals in Union City, and rental home in Union City
Send dazzling and pretty reports regarding rental apartment in Raeford North Carolina and Raeford rental houses found on this website, FRBO.com.
Cohorts and tenants hunt for, inquire, and go through our website, FRBO.com and come across exotic flat, loft cottage, and loft apartment.
Hear, devise, and find rent houses Monroe, for rent by owner homes in Monroe, and homes for rent in Monroe United States.
Ferret out and relocate Rich Square vacation homes for rent by owner and Rich Square United States vacation homes.
Conceive and ferret out condo rentals in Beaufort North Carolina, Beaufort rental properties, and bed and breakfast rentals Beaufort North Carolina.
The Raeford North Carolina loft ad directories, beach ad directories, mountain classified ads, and rustic directories for these territory can be mapped.
Locate, dig up, and perceive Garner United States rental home, holiday rentals Garner, and Garner United States condo rentals.
Design, glimpse, and dig up condo rentals in Stanfield, homes for rent in Stanfield, and apartment rentals Stanfield United States.
Identify and dig up condo rentals Catawba North Carolina and Catawba North Carolina apartment rentals.
Redding-Anderson homes for rent and vacation rentals
|
|
