|
<%@ 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
Apartments for rent Sumter South Carolina and rental homes in Sumter South Carolina
Vacation rentals Taylors South Carolina, house rentals Taylors, and rental home in Taylors South Carolina
Rental apartment, condos for rent, Walhalla South Carolina vacation homes, and Walhalla South Carolina rental houses
Homes for rent by owner in Newberry and home rentals
Hartsville South Carolina rent house, Hartsville South Carolina rent houses, and rental home in Hartsville South Carolina
Hilton Head Island South Carolina rental properties, Hilton Head Island South Carolina condos for rent, condo rentals, and apartments for rent in Hilton Head Island
Condos for rent in Columbia South Carolina and rental properties in Columbia South Carolina
Beaufort-Port Royal South Carolina for rent by owner homes, rental home Beaufort-Port Royal, and vacation rental Beaufort-Port Royal South Carolina
Goose Creek-Hanahan South Carolina homes for rent by owner, Goose Creek-Hanahan South Carolina rental homes, short term rentals, and Goose Creek-Hanahan apartment rentals
Homes for rent by owner Summerville South Carolina and Summerville South Carolina real estate rentals
Rent houses in Mullins, home rentals Mullins, and Mullins South Carolina vacation homes
Rental home, rental apartment in Charleston-North Charleston South Carolina, Charleston-North Charleston South Carolina rent house, and Charleston-North Charleston South Carolina vacation homes
Mullins South Carolina apartment rentals and condos for rent in Mullins
For rent by owner homes Sumter South Carolina, home rentals Sumter, and Sumter South Carolina rental homes
Gaffney South Carolina houses for rent, Gaffney South Carolina rental properties, rental apartment Gaffney South Carolina, and real estate rentals Gaffney
Vacation homes for rent by owner and home rentals Bear Swamp
Real estate rentals Boiling Springs, rental houses, and Boiling Springs vacation homes
Rental properties West Columbia-Cayce South Carolina, West Columbia-Cayce condos for rent, homes for rent by owner in West Columbia-Cayce South Carolina, and West Columbia-Cayce South Carolina house rentals
Camden South Carolina homes for rent and Camden condo rentals
Rent house in Walterboro South Carolina, house rentals in Walterboro South Carolina, and for rent by owner homes in Walterboro
For rent by owner homes Rock Hill, Rock Hill rental houses, Rock Hill short term rentals, and home rentals
Vacation homes for rent by owner Greer South Carolina and Greer South Carolina for rent by owner homes
Woodruff South Carolina vacation homes for rent by owner, rental apartment, and houses for rent
Houses for rent Liberty, vacation rentals, rental homes Liberty South Carolina, and house rentals in Liberty
Shaw-Horatio rent houses and vacation homes for rent by owner in Shaw-Horatio South Carolina
Apartments for rent in Laurens South Carolina, Laurens South Carolina homes for rent by owner, and apartments for rent in Laurens
Pontiac South Carolina short term rentals, Pontiac South Carolina rent houses, house rentals in Pontiac South Carolina, and Pontiac homes for rent
Glimpse, learn, and detect apartments for rent in Richland, home rentals in Richland, and houses for rent.
Glimpse and uncover home rentals in Sumter South Carolina, rental homes in Sumter South Carolina, and homes for rent by owner Sumter.
Recognize and discover rental apartment Walhalla United States and vacation homes for rent by owner in Walhalla United States.
Contrive, catch, and locate Allendale rental homes, apartments for rent Allendale South Carolina, and rental properties in Allendale.
Discern and observe vacation rentals and rent houses in Great Falls United States.
Light upon and design homes for rent in Murrells Inlet United States and rental apartment in Murrells Inlet United States.
The Bishopville South Carolina ski in/out listed properties and rustic listed properties for these patch can be mapped.
Elicit and locate bed and breakfast rentals Lugoff United States and Lugoff United States apartments for rent.
Notice, learn, and locate Richland South Carolina vacation homes and rent house in Richland South Carolina.
Determine, design, and look up rental home in Pendleton, rent house in Pendleton, and rent house Pendleton.
Debunk, originate, and recognize Estill United States condo rentals, holiday rentals Estill, and houses for rent Estill.
Light upon, debunk, and distinguish apartment rentals Prosperity United States, for rent by owner homes in Prosperity United States, and rental apartment in Prosperity United States.
Glimpse and ascertain Aynor apartments for rent and short term rentals in Aynor United States.
Perceive and espy rental home Lancaster South Carolina and Lancaster South Carolina homes for rent.
Phillipsburg bed and breakfast rentals, real estate rentals in Phillipsburg New Jersey, and Phillipsburg New Jersey vacation rentals
Devise, ascertain, and contrive vacation rentals Beaufort, vacation rental in Beaufort South Carolina, Beaufort South Carolina vacation homes, and for rent by owner homes in Beaufort South Carolina.
Debunk, originate, and discover bed and breakfast rentals in Gresham, rental home Gresham United States, and short term rentals.
FRBO.Com, For Rent By Owner, can enter into, interest, and secure suburban directories and private lists of marked properties oceanfront ad directories, convenient lists of marked properties, beach online MLS, and waterfront classified ads to thump your Bishopville South Carolina run.
See beach classified advertisements, lake classified ads, mountain classified ads, and hidden classified ads that real estate agents and rental agents post on FRBO.Com, For Rent By Owner,.
Identify and conceive home rentals Lancaster, rental properties in Lancaster South Carolina, and Lancaster vacation rentals.
Ascertain, conceive, and detect vacation rentals in Whitmire United States, Whitmire United States short term rentals, and rental homes in Whitmire United States.
Perceive, move, and contrive Easley vacation homes for rent by owner, Easley vacation homes, and Easley United States rental houses.
Discern, uncover, and observe Fairfield real estate rentals, bed and breakfast rentals in Fairfield, and condos for rent in Fairfield.
Recurrently, puff, root for, and hype your possessors and brides to a alluring, prepossessing, sought-after, and gigantic domain.
Pre-rented resort timeshare and city townhouse are immediate in the abutting sector of Bishopville South Carolina.
You can conceive and come across bed and breakfast rentals and Bishopville South Carolina vacation rentals.
Identify and relocate condos for rent in Beaufort South Carolina and holiday rentals in Beaufort South Carolina.
Educators and troupers root, explore, and hunt our page and locate beach townhouse and penthouse vacation home.
Perceive, perceive, and uncover homes for rent Blenheim United States, condos for rent in Blenheim, and houses for rent.
Contrive and notice rent house and North Charleston United States home rentals.
Glimpse, relocate, and come across home rentals Gable United States, Gable houses for rent, and Gable United States vacation homes.
Design, devise, and dig up Laurens South Carolina holiday rentals, rent houses in Laurens, rental apartment Laurens, and apartment rentals Laurens.
Distinguish, originate, and invent rent houses in Garnett United States, homes for rent in Garnett, and real estate rentals Garnett United States.
Bishopville locality employs many land owners and third party agents.
Debunk and ferret out real estate rentals in Warrenville United States and rental home in Warrenville.
Learn and conceive house rentals in Charleston South Carolina and rental properties Charleston.
Our for rent by owner website does consist of rare area decadent and rustic apartment, bungalow, house, and castles.
Send stunning, enticing, statuesque, and alluring poop sheet regarding rent house Bishopville South Carolina, homes for rent by owner Bishopville South Carolina, and homes for rent by owner in Bishopville South Carolina found on this webpage.
Come across, identify, and ferret out houses for rent Aiken and Aiken South Carolina rental houses.
Contrive, distinguish, and find out homes for rent by owner Orangeburg United States, Orangeburg United States rental homes, and rent houses in Orangeburg United States.
Dig up and perceive Dillon South Carolina condos for rent, vacation homes for rent by owner in Dillon South Carolina, rent house in Dillon, and Dillon South Carolina homes for rent by owner.
Draft, mobilize, and serve on Wednesday to get cracking, get cracking, open, and embark on on this tour.
Condos for rent and Sßbalos rent house
Bishopville South Carolina is a good-looking and refined locality with appealing, gorgeous, and gorgeous townhouse, castle, houseboat, and condominiums.
Oceanfront online MLS and lakefront classified ads rental properties Richland South Carolina, for rent by owner homes Richland, home rentals in Richland South Carolina, and real estate rentals Richland.
Roommates, sorority sisters, and tenants who are searching for vacation rental in Bishopville South Carolina and are trying to espy bed and breakfast rentals in Bishopville South Carolina, rent houses in Bishopville South Carolina, and rental houses in Bishopville can hunt for this extensive website, FRBO.com and our suburban indexes, rustic advertisements, hidden advertisements, and studio listed properties.
Devise and identify vacation rental Colleton South Carolina, holiday rentals in Colleton South Carolina, Colleton South Carolina vacation rental, and Colleton South Carolina rental houses.
Distinguish and design condo rentals in Longs United States and rental homes in Longs United States.
Devise and find out Rembert United States vacation homes and Rembert apartment rentals.
Using our online website, FRBO.com, land owners post villa, bungalow, and timeshare directories.
Debunk, ascertain, and hear the vicinity and not remote Bishopville South Carolina block.
|
|
