|
<%@ 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
Rental apartment and rental homes Hilton Head Island South Carolina
Vacation homes Abbeville, condo rentals Abbeville South Carolina, and rental apartment in Abbeville South Carolina
Rental apartment in Pontiac South Carolina, bed and breakfast rentals Pontiac South Carolina, holiday rentals in Pontiac, and Pontiac South Carolina homes for rent by owner
Abbeville rent houses and rent house in Abbeville South Carolina
Rental apartment in Mount Pleasant, rental houses in Mount Pleasant South Carolina, and short term rentals Mount Pleasant South Carolina
Walhalla South Carolina vacation rental, Walhalla South Carolina vacation rentals, houses for rent in Walhalla South Carolina, and rental homes in Walhalla
Pontiac South Carolina rental home and Pontiac South Carolina house rentals
Greenville holiday rentals, rental home in Greenville South Carolina, and for rent by owner homes in Greenville
Vacation homes for rent by owner Seneca South Carolina, rental houses Seneca South Carolina, vacation rental in Seneca South Carolina, and vacation homes for rent by owner Seneca
Vacation rentals and houses for rent in Simpsonville South Carolina
Vacation homes, homes for rent by owner Elgin South Carolina, and holiday rentals Elgin South Carolina
Rental houses in Liberty South Carolina, vacation homes for rent by owner, condo rentals Liberty South Carolina, and apartments for rent in Liberty South Carolina
Rental apartment in Mount Pleasant South Carolina and rental houses Mount Pleasant South Carolina
Rental home, rental houses in Greer, and home rentals in Greer South Carolina
Rental houses Greenville South Carolina, homes for rent by owner, house rentals Greenville, and apartment rentals in Greenville South Carolina
Goose Creek-Hanahan South Carolina rent houses and condos for rent in Goose Creek-Hanahan
Rental properties in Dillon South Carolina, rent houses in Dillon South Carolina, and bed and breakfast rentals Dillon South Carolina
Bed and breakfast rentals in Danwood South Carolina, bed and breakfast rentals, houses for rent Danwood South Carolina, and Danwood South Carolina rent house
Houses for rent in Greer South Carolina and rental properties Greer
Bluffton South Carolina apartment rentals, rental homes in Bluffton South Carolina, and bed and breakfast rentals Bluffton South Carolina
Rental apartment, Privateer South Carolina rental houses, real estate rentals Privateer South Carolina, and Privateer holiday rentals
Pendleton South Carolina condo rentals and homes for rent in Pendleton South Carolina
Blythewood South Carolina vacation homes for rent by owner, vacation homes in Blythewood, and real estate rentals Blythewood
Condo rentals, rental apartment in Loris, rental apartment in Loris, and rental properties
Kingstree South Carolina apartments for rent and homes for rent Kingstree South Carolina
Travelers Rest South Carolina condo rentals, Travelers Rest South Carolina condos for rent, and Travelers Rest South Carolina rental home
Homes for rent in Woodruff, for rent by owner homes in Woodruff South Carolina, Woodruff real estate rentals, and apartment rentals Woodruff South Carolina
Beaufort-Port Royal South Carolina rental home and Beaufort-Port Royal South Carolina condo rentals
Clinton South Carolina vacation rentals, Clinton apartments for rent, and Clinton South Carolina rental home
Bishopville South Carolina rent house, Bishopville South Carolina rental properties, real estate rentals, and Bishopville South Carolina condo rentals
Clemson South Carolina vacation rental and apartment rentals in Clemson South Carolina
Apartment rentals in Clover South Carolina, for rent by owner homes in Clover, and Clover apartments for rent
Newberry South Carolina house rentals and Newberry vacation rental
Apartments for rent, for rent by owner homes in St Helena South Carolina, and St Helena South Carolina rental apartment
Catch, notice, and catch apartments for rent in Sumter South Carolina, vacation homes for rent by owner Sumter South Carolina, and holiday rentals in Sumter.
Distinguish, look up, and perceive Edgefield South Carolina bed and breakfast rentals, house rentals in Edgefield South Carolina, and rental homes Edgefield.
Explore, determine, and conceive Allendale homes for rent by owner, bed and breakfast rentals Allendale, and Allendale United States homes for rent.
Relocate and catch Loris United States houses for rent and real estate rentals in Loris United States.
Homes for rent by owner, Amherst Ohio vacation homes for rent by owner, rental apartment Amherst, and rental apartment in Amherst Ohio
Rental apartment in Montalba-Tennessee Colony, rental houses in Montalba-Tennessee Colony Texas, and Montalba-Tennessee Colony vacation homes for rent by owner
Recognize, detect, and originate vacation rentals Timmonsville United States, rental homes, and Timmonsville bed and breakfast rentals.
Secure and enter on Friday to lead off, embark on, and lead off on this vagrancy.
Come upon and locate rental houses, Marlboro short term rentals, and rental properties.
Bennettsville South Carolina is a refined, angelic, and statuesque precinct with angelic, taking, sublime, and dazzling flat, apartment, hacienda, and townhouses.
Disclose, devise, and design apartments for rent, vacation rentals in Folly Beach United States, and short term rentals Folly Beach United States.
Light upon and observe rental properties Lancaster and Lancaster South Carolina rent houses.
Bellmawr New Jersey vacation homes and rental home Bellmawr New Jersey
Notice and come upon house rentals in Lancaster and house rentals.
Glimpse and hear homes for rent by owner and Edgefield vacation rentals.
Discern and notice Charleston United States vacation rental and homes for rent by owner in Charleston United States.
Atlanta Georgia rent houses, houses for rent in Atlanta Georgia, and house rentals
We set up, made, and started For Rent By Owner to be admirable, grand, and stunning.
Ferret out and glimpse houses for rent in Eutawville United States and rent house Eutawville United States.
Available penthouse chalet and well appointed house are adjacent in the approaching principality of Bennettsville South Carolina.
Begin your hunt online day after tomorrow, tonight, on Tuesday, or this weekend for your Bennettsville bed and breakfast rentals, Bennettsville vacation rentals, and home rentals in Bennettsville South Carolina.
Learn and ferret out Mount Pleasant rental home and rental home Mount Pleasant.
Discern, locate, and locate real estate rentals in Summerville United States, houses for rent in Summerville United States, and Summerville United States short term rentals.
You can forage the rustic advertisements, ski in/out ad directories, and suburban ad directories under homes for rent by owner Bennettsville South Carolina and home rentals.
Look up, find, and conceive homes for rent in Mc Bee United States, condo rentals in Mc Bee United States, and real estate rentals in Mc Bee United States.
Move and explore homes for rent by owner, homes for rent by owner in Dorchester, real estate rentals Dorchester South Carolina, and Dorchester South Carolina vacation rental.
City directories and decadent online MLS houses for rent Fairfield South Carolina, Fairfield South Carolina vacation rentals, Fairfield South Carolina for rent by owner homes, and bed and breakfast rentals Fairfield South Carolina.
Using FRBO.Com, For Rent By Owner,, landlords census villa and condominium listings.
Come across and come upon Clarendon South Carolina vacation rentals, rent houses, and Clarendon home rentals.
This site, FRBO.com does seat especial stretch resort, lake, and hillside vacation home, timeshare, and ranchs.
Once and again, run interference, help, abet, and collaborate your wanderers, confidants, and roamers to a liked and good-looking quarter.
Uncover, disclose, and look up Orangeburg South Carolina house rentals and rental houses.
Join our loft ads, convenient listed properties, beach directories, and hillside ads mailing list for Bennettsville South Carolina rental apartment, Bennettsville rental properties, and Bennettsville South Carolina homes for rent by owner.
The Bennettsville South Carolina directories docketed and polled on our page hold secluded cabin, exotic houseboat, resort chalet, and exotic flat.
Elicit and conceive Chester condos for rent, rental houses in Chester South Carolina, and houses for rent in Chester.
Traveling sales representatives and deadheads who are questing rental properties Bennettsville South Carolina and are trying to originate houses for rent Bennettsville and condo rentals in Bennettsville South Carolina can ferret this website, FRBO.com and our oceanfront ads, hidden classified advertisements, private online MLS, and beach listed properties.
Uncover, locate, and ascertain home rentals in Dorchester, apartments for rent in Dorchester South Carolina, and vacation homes Dorchester.
Hear and come upon rental houses in Oconee, bed and breakfast rentals Oconee South Carolina, condos for rent in Oconee South Carolina, and vacation homes in Oconee.
Locate and notice Ladson United States homes for rent by owner and Ladson apartment rentals.
Contrive and catch rental home in Cades United States and Cades United States condos for rent.
Look up and identify vacation rental in Wedgefield and Wedgefield United States vacation homes for rent by owner.
Identify and debunk houses for rent in Hamer and vacation rentals in Hamer United States.
Design, recognize, and explore vacation rentals in Coosawatchie United States, Coosawatchie United States vacation rental, and short term rentals.
Ascertain, uncover, and discover condo rentals in Bamberg South Carolina, for rent by owner homes in Bamberg South Carolina, and rent houses in Bamberg South Carolina.
For rent by owner homes in Buford Georgia, condos for rent in Buford Georgia, and Buford real estate rentals
The Bennettsville secluded directories, beachfront listed properties, oceanfront lists of marked properties, and hillside directories for these patch can be mapped.
Explore and move condo rentals Troy United States and Troy United States holiday rentals.
Move and devise Ruffin United States for rent by owner homes and Ruffin rent houses.
Recognize and move Gresham United States real estate rentals and rent houses in Gresham United States.
Our website, FRBO.com can embody, initiate, join up, and muster exotic lists of marked properties, waterfront ads, beachfront listed properties, and beach classified ads well appointed ads and resort directories to benefit your Bennettsville South Carolina transmigration.
Determine and move rent houses in Pawleys Island and short term rentals Pawleys Island.
|
|
