|
<%@ 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" %>
|
South Carolina Rental Links
Mount Pleasant South Carolina short term rentals and rent house in Mount Pleasant South Carolina
Apartment rentals in Clover South Carolina, Clover for rent by owner homes, and apartments for rent in Clover South Carolina
Homes for rent, home rentals in North Augusta South Carolina, North Augusta South Carolina holiday rentals, and house rentals North Augusta South Carolina
Anderson South Carolina short term rentals and rent houses
Little River condo rentals, Little River South Carolina homes for rent, and rental houses in Little River
Rental apartment Pendleton South Carolina, real estate rentals in Pendleton South Carolina, Pendleton South Carolina homes for rent, and rental apartment in Pendleton
Darlington for rent by owner homes and rental apartment in Darlington South Carolina
Real estate rentals Elgin South Carolina, apartments for rent in Elgin South Carolina, and real estate rentals in Elgin
Apartments for rent Clover South Carolina, rental home in Clover South Carolina, apartments for rent in Clover, and home rentals Clover
Mullins South Carolina rent house and real estate rentals Mullins South Carolina
Real estate rentals, Dutch Fork South Carolina short term rentals, and condo rentals in Dutch Fork South Carolina
Laurens South Carolina homes for rent, rental houses Laurens South Carolina, apartment rentals, and rent house Laurens South Carolina
House rentals and Bluffton rental properties
Sumter South Carolina rent house, rent house Sumter, and holiday rentals Sumter
Walhalla South Carolina house rentals, Walhalla South Carolina for rent by owner homes, Walhalla condos for rent, and houses for rent Walhalla South Carolina
Cheraw South Carolina real estate rentals and houses for rent in Cheraw
Taylors South Carolina vacation rental, vacation rentals Taylors, and rental apartment in Taylors South Carolina
Real estate rentals in Ravenel South Carolina, house rentals in Ravenel, Ravenel South Carolina apartment rentals, and vacation rental Ravenel South Carolina
Rental houses in Pendleton South Carolina and apartment rentals in Pendleton South Carolina
Rent house in Pontiac South Carolina, rent houses Pontiac South Carolina, and holiday rentals in Pontiac
Piedmont apartments for rent, Piedmont South Carolina vacation rentals, Piedmont South Carolina home rentals, and rental properties Piedmont
Holiday rentals Inman South Carolina and rental homes in Inman South Carolina
Waccamaw South Carolina rental houses, Waccamaw South Carolina homes for rent by owner, and apartment rentals in Waccamaw South Carolina
Rent houses, rental homes Clemson, Clemson apartment rentals, and rental properties in Clemson South Carolina
Vacation homes for rent by owner in Greenville South Carolina and real estate rentals in Greenville
Pelion South Carolina rental apartment, Pelion homes for rent, and Pelion homes for rent by owner
Short term rentals Mount Pleasant South Carolina, homes for rent in Mount Pleasant, vacation homes in Mount Pleasant South Carolina, and short term rentals in Mount Pleasant South Carolina
Rental houses in Simpsonville and Simpsonville vacation homes
Cheraw South Carolina bed and breakfast rentals, Cheraw South Carolina rental apartment, and rent house Cheraw
Rent houses, house rentals Myrtle Beach South Carolina, Myrtle Beach South Carolina condo rentals, and Myrtle Beach condo rentals
Taylors South Carolina rent houses and Taylors South Carolina vacation rentals
Pickens South Carolina rent houses, vacation homes Pickens, and Pickens South Carolina rent house
See lake indexes, city ads, and city classified advertisements that agents and land owners post on this site, For Rent By Owner (FRBO.com).
Uncover, perceive, and conceive homes for rent, Holly Hill rental houses, and bed and breakfast rentals.
Recognize, ascertain, and come across home rentals in Estill, apartments for rent Estill, and real estate rentals in Estill United States.
Learn, conceive, and distinguish Hampton rental houses, Hampton South Carolina home rentals, Hampton condo rentals, and real estate rentals Hampton South Carolina.
Rent houses, Hendersonville North Carolina house rentals, house rentals in Hendersonville North Carolina, and rental properties in Hendersonville
Design, disclose, and conceive condos for rent, vacation homes for rent by owner in Landrum United States, and vacation rental Landrum.
Disclose and perceive homes for rent by owner in Saluda South Carolina, vacation homes for rent by owner in Saluda South Carolina, and rent houses in Saluda South Carolina.
Dig up, discern, and notice apartment rentals in Abbeville South Carolina, bed and breakfast rentals in Abbeville, Abbeville South Carolina homes for rent by owner, and rental houses in Abbeville South Carolina.
Ferret out and look up homes for rent by owner and rental home Charleston AFB United States.
Discern and determine vacation rental in Mc Bee and Mc Bee United States holiday rentals.
Originate, light upon, and come across houses for rent in Marlboro, Marlboro South Carolina vacation homes for rent by owner, and Marlboro rental apartment.
Come across, ferret out, and find out Cordova houses for rent, rental homes, and rent house in Cordova United States.
Glimpse and detect vacation homes Charleston United States and Charleston United States bed and breakfast rentals.
Initiate your pursuing online tomorrow morning, this weekend, tomorrow, or on Friday for your short term rentals in Newberry South Carolina and condo rentals in Newberry South Carolina.
Send cute, dazzling, and wonderful proof regarding Newberry South Carolina condos for rent, Newberry rent houses, and Newberry South Carolina home rentals found on our page.
You can look the lake listings and romantic classifieds under vacation rentals in Newberry South Carolina and bed and breakfast rentals in Newberry.
Glimpse, notice, and notice holiday rentals Richland South Carolina, Richland houses for rent, and Richland South Carolina apartment rentals.
Perceive, elicit, and hear vacation homes for rent by owner in Newberry, short term rentals, for rent by owner homes, and real estate rentals Newberry South Carolina.
Vacation rentals in Inverness Florida, homes for rent in Inverness Florida, and holiday rentals in Inverness
House rentals in Bethlehem Pennsylvania, short term rentals Bethlehem Pennsylvania, and condo rentals Bethlehem Pennsylvania
Holiday rentals in Granbury East Texas and real estate rentals Granbury East Texas
Almost ready to be occupied mountain bungalow, log villa, beachfront chalet, and romantic houseboat are contiguous in the not to distant turf of Newberry.
Hear and recognize for rent by owner homes Horry South Carolina and Horry bed and breakfast rentals.
Using our for rent by owner website, property owners particularize condominium, ranch, and home classified ads.
This extensive website, FRBO.com seats neighborhood, precinct, domain, and area documents, many times.
Debunk, light upon, and explore vacation homes in Mc Connells, rental homes Mc Connells United States, and Mc Connells United States condos for rent.
FRBO.com does eliminate bizarre city suburban, convenient, and well appointed farmhouse, villa, timeshare, and lodges.
Join our beach ad directories, city lists of marked properties, and lake online MLS mailing list for short term rentals Newberry South Carolina and vacation rental Newberry.
Come upon, glimpse, and design rental properties Nesmith, home rentals Nesmith, and Nesmith holiday rentals.
Ferret out and identify Marion South Carolina rental home and house rentals in Marion South Carolina.
Discern and debunk homes for rent in Newberry and Newberry United States rental home.
Identify and perceive Slater rent houses and rent houses in Slater United States.
Newberry landlords and agents serving the condo market list rental houses in Newberry South Carolina, homes for rent in Newberry South Carolina, and houses for rent Newberry South Carolina.
Educators, confidants, and wanderers who are wishing to disclose and glimpse or simply originate information can use our webpage.
Invent, relocate, and ferret out vacation homes for rent by owner Isle of Palms United States, Isle of Palms United States rent houses, and Isle of Palms condo rentals.
Vacation rentals in Elgin South Carolina and homes for rent by owner
Discern, debunk, and find out rental properties Hilda United States, apartments for rent in Hilda United States, and rent house Hilda.
Recurrently, relieve and serve your occupants, drifters, and opportunists to a favored, well-liked, and pretty tract.
Rental properties in Township 12 Burlington North Carolina, rent house in Township 12 Burlington, Township 12 Burlington North Carolina apartments for rent, and vacation homes in Township 12 Burlington North Carolina
|
|
