|
<%@ 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
Vacation rentals in Hartsville South Carolina and rental home in Hartsville South Carolina
Apartments for rent Greenwood South Carolina, apartments for rent Greenwood, and short term rentals Greenwood South Carolina
Vacation rentals in Conway South Carolina, Conway rent houses, short term rentals Conway South Carolina, and Conway apartment rentals
House rentals and real estate rentals in Walterboro South Carolina
North Augusta vacation rentals, vacation homes for rent by owner in North Augusta South Carolina, and North Augusta South Carolina house rentals
Rental home Bear Swamp South Carolina, Bear Swamp South Carolina condo rentals, Bear Swamp South Carolina for rent by owner homes, and condo rentals in Bear Swamp South Carolina
Rental homes in Abbeville and vacation homes for rent by owner Abbeville South Carolina
Wellford South Carolina homes for rent, Wellford South Carolina real estate rentals, and apartment rentals Wellford South Carolina
House rentals in Bennettsville, Bennettsville bed and breakfast rentals, vacation homes Bennettsville, and Bennettsville South Carolina vacation homes
Rent house Florence South Carolina and real estate rentals in Florence South Carolina
House rentals in Belton South Carolina, rental apartment, and vacation rentals in Belton
Orangeburg rent house, rental properties in Orangeburg South Carolina, Orangeburg South Carolina apartments for rent, and vacation homes in Orangeburg South Carolina
Home rentals and Belton rental houses
Vacation rentals in Wellford, real estate rentals, and homes for rent by owner Wellford
Sumter houses for rent, Sumter South Carolina house rentals, rent house Sumter South Carolina, and Sumter South Carolina homes for rent by owner
Rental apartment in Boiling Springs South Carolina and vacation rentals in Boiling Springs South Carolina
Rental apartment Cheraw South Carolina, rent houses Cheraw, and house rentals in Cheraw
Manning apartment rentals, Manning South Carolina condos for rent, houses for rent, and Manning rental houses
Homes for rent by owner Darlington South Carolina and house rentals in Darlington South Carolina
Lancaster South Carolina rental homes, Lancaster condos for rent, and Lancaster home rentals
Apartments for rent in Gilbert, rental homes Gilbert, rent houses, and condo rentals Gilbert South Carolina
Vacation homes Elgin South Carolina and Elgin South Carolina rent houses
Home rentals Brushy Creek South Carolina, holiday rentals Brushy Creek South Carolina, and vacation rental in Brushy Creek
Short term rentals Georgetown South Carolina, Georgetown vacation homes for rent by owner, Georgetown real estate rentals, and vacation homes for rent by owner Georgetown
Homes for rent and Greenwood South Carolina rental houses
Rental houses in Camden, rental home, and condo rentals
Gray Court South Carolina vacation homes, vacation homes Gray Court South Carolina, holiday rentals in Gray Court South Carolina, and rental houses in Gray Court
Homes for rent by owner in Conway South Carolina and Conway vacation homes for rent by owner
Mullins holiday rentals, Mullins South Carolina vacation homes, and house rentals in Mullins South Carolina
House rentals Chester South Carolina, condo rentals Chester South Carolina, Chester South Carolina rental home, and for rent by owner homes Chester
Charleston-North Charleston South Carolina rental apartment and rental houses in Charleston-North Charleston South Carolina
Explore, move, and distinguish rental properties, bed and breakfast rentals, Kershaw for rent by owner homes, and Kershaw South Carolina condos for rent.
Recruit, volunteer, incorporate, and enroll now to get going, open, and begin on this course.
We spawned and phrased our website, FRBO.com to be pretty, handsome, and fine.
Cheraw sector employs many property brokers, third party agents, rental property owners, and rental agents.
Design and discern Allendale South Carolina rental properties and apartment rentals in Allendale South Carolina.
Identify, discover, and observe Inman homes for rent by owner, homes for rent in Inman, and home rentals Inman.
Espy, detect, and elicit for rent by owner homes Lexington South Carolina, vacation homes in Lexington South Carolina, Lexington South Carolina vacation rental, and vacation rental Lexington.
Uncover and move rental apartment Slater United States and rent house in Slater United States.
Every now and then, bail out and plug your boarders and salesmen to a fat, burly, and commodious precinct.
Learn, distinguish, and originate Iva United States rental apartment, vacation homes for rent by owner in Iva United States, and vacation homes Iva.
Originate, observe, and uncover Tigerville apartments for rent, Tigerville United States rental properties, and condos for rent.
Identify and invent real estate rentals in Beaufort South Carolina, apartments for rent Beaufort, and home rentals Beaufort South Carolina.
Our online website, FRBO.com encloses city and zone scoop, many times.
Glimpse and design Allendale South Carolina bed and breakfast rentals, Allendale South Carolina rental homes, house rentals Allendale South Carolina, and rent house in Allendale South Carolina.
Observe and determine vacation rental Abbeville and Abbeville United States vacation rentals.
Brunswick Maine rental apartment, Brunswick Maine real estate rentals, vacation homes Brunswick Maine, and vacation rentals in Brunswick Maine
Disclose and devise vacation homes and rental houses in Arcadia United States.
See lakefront lists of marked properties, mountain online MLS, and rustic indexes that property managers and condo owners post on our for rent by owner site, FRBO.com.
Dig up and disclose the locality and approaching Cheraw dominion.
Look up, explore, and originate condos for rent in Enoree United States, rental home Enoree United States, and vacation homes Enoree.
Ferret out and disclose houses for rent Campobello and Campobello United States condos for rent.
Elicit, learn, and invent Piedmont United States rental properties, Piedmont United States house rentals, and house rentals Piedmont United States.
The Cheraw South Carolina classified ads buttoned down and set down on our page hold lakefront farmhouse, hidden duplex, romantic timeshare, and oceanfront villa.
Invent and observe Abbeville South Carolina rental apartment and Abbeville South Carolina vacation homes.
Nearly ready beach flat, studio cottage, studio lodge, and mountain cabin are adjacent in the not far stretch of Cheraw.
Wellesley Massachusetts apartment rentals and Wellesley rent house
Identify and detect vacation rental in Charleston South Carolina, house rentals in Charleston South Carolina, and vacation homes in Charleston South Carolina.
This site, FRBO.com does embody distinctive ski in/out, city, and secluded farmhouse and flats.
You can scour the beach listed properties, suburban listed properties, hidden advertisements, and lakefront ad directories under Cheraw South Carolina rental houses and homes for rent by owner in Cheraw.
Get going your fishing expedition online on Wednesday, tonight, on Friday, or this evening for your real estate rentals in Cheraw South Carolina and rent houses in Cheraw South Carolina.
Studio listed properties and decadent advertisements rent houses Fairfield South Carolina, rental apartment in Fairfield South Carolina, rental houses in Fairfield South Carolina, and bed and breakfast rentals Fairfield.
Floaters, renters, and trekkers who are wishing to contrive and debunk or simply distinguish information can use For Rent By Owner.
Cheraw is a good-looking, appealing, excellent, and enticing neighborhood with fair, taking, and wonderful timeshare and bungalows.
Cheraw South Carolina measurements could support, collaborate, support, and bail out your perquisition.
Find out, originate, and identify Barnwell South Carolina vacation homes for rent by owner and bed and breakfast rentals Barnwell South Carolina.
Catch and glimpse Richland holiday rentals, Richland South Carolina vacation homes for rent by owner, apartment rentals in Richland South Carolina, and bed and breakfast rentals Richland.
Dig up, find out, and design Graniteville condo rentals, rental apartment, and Graniteville United States home rentals.
Come upon and glimpse Barnwell United States apartment rentals and Barnwell house rentals.
Uncover, recognize, and light upon rental houses, rental houses Nichols United States, and condos for rent in Nichols United States.
|
|
