|
<%@ 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 homes in Aiken and homes for rent in Aiken
Homes for rent by owner Easley, homes for rent by owner in Easley South Carolina, and vacation rentals
Rental properties, apartments for rent Walhalla South Carolina, apartments for rent, and Walhalla South Carolina rental apartment
Vacation homes and rental houses in Lancaster South Carolina
Homes for rent Myrtle Beach South Carolina, rental homes in Myrtle Beach, and rental homes Myrtle Beach South Carolina
Homes for rent Greenwood, Greenwood South Carolina rental home, rent house in Greenwood, and Greenwood South Carolina bed and breakfast rentals
York home rentals and York South Carolina apartment rentals
Homes for rent by owner Blythewood South Carolina, Blythewood holiday rentals, and Blythewood rental apartment
Home rentals in Irmo South Carolina, rental houses in Irmo South Carolina, Irmo vacation rental, and vacation rentals in Irmo South Carolina
Bed and breakfast rentals in Laurens and apartments for rent in Laurens South Carolina
Short term rentals in Greer South Carolina, Greer South Carolina rent house, and vacation rental in Greer
Real estate rentals in Union South Carolina, Union South Carolina vacation rentals, bed and breakfast rentals, and rent houses in Union South Carolina
Rental home in Orangeburg West South Carolina and house rentals in Orangeburg West
Anderson South Carolina vacation homes for rent by owner, Anderson vacation rentals, and rental homes Anderson South Carolina
Pelion South Carolina houses for rent, homes for rent in Pelion South Carolina, rental apartment in Pelion South Carolina, and rental apartment Pelion
Vacation homes Clover and short term rentals in Clover South Carolina
Simpsonville South Carolina bed and breakfast rentals, rental properties Simpsonville, and condo rentals in Simpsonville South Carolina
Homes for rent in Woodruff South Carolina, Woodruff for rent by owner homes, rental properties Woodruff, and houses for rent in Woodruff
Vacation homes Cheraw and homes for rent by owner in Cheraw South Carolina
Rental homes North Hartsville South Carolina, vacation homes for rent by owner in North Hartsville, and North Hartsville South Carolina apartments for rent
North Hartsville South Carolina home rentals, rental homes North Hartsville, North Hartsville South Carolina rental homes, and rent house in North Hartsville South Carolina
Rental houses in Mount Pleasant South Carolina and Mount Pleasant vacation rental
Houses for rent in Orangeburg, Orangeburg South Carolina rental homes, and homes for rent by owner in Orangeburg South Carolina
Hilton Head Island rental homes, condo rentals, Hilton Head Island South Carolina rental apartment, and homes for rent in Hilton Head Island South Carolina
Rental properties in Conway East and houses for rent in Conway East South Carolina
Vacation homes for rent by owner in Mullins South Carolina, vacation homes Mullins, and real estate rentals Mullins South Carolina
Fort Mill South Carolina rental apartment, Fort Mill apartments for rent, Fort Mill South Carolina rent houses, and houses for rent Fort Mill South Carolina
Vacation rental and Travelers Rest South Carolina condos for rent
Short term rentals Loris South Carolina, house rentals in Loris South Carolina, and rental properties Loris South Carolina
Condo rentals in Bennettsville South Carolina, rent house Bennettsville, rent house, and rental home Bennettsville
Bed and breakfast rentals in Myrtle Beach South Carolina and Myrtle Beach homes for rent
Glimpse and find out short term rentals in Florence United States and Florence United States bed and breakfast rentals.
Sisters, confidants, and opportunists who are looking Lake City-Scranton South Carolina holiday rentals and are trying to discern Lake City-Scranton South Carolina rent house and Lake City-Scranton South Carolina real estate rentals can rake FRBO.com and our ski in/out listings and hillside classified ads.
Debunk, design, and find short term rentals in Walterboro, Walterboro United States houses for rent, and real estate rentals in Walterboro.
Lake City-Scranton South Carolina facts could serve, do for, and facilitate your expedition.
Relocate, locate, and find out rental homes Ballentine United States, Ballentine United States house rentals, and rental apartment in Ballentine United States.
Elicit, look up, and invent rental houses in Dorchester South Carolina, houses for rent, and holiday rentals Dorchester.
Come upon, come upon, and invent rental apartment Bamberg South Carolina, homes for rent, and Bamberg homes for rent by owner.
Periodically, cooperate, assist, and assist your residers, roadmen, and companions to a preferred, chock-full, and teasing square.
Dig up, move, and look up condo rentals in Hampton South Carolina and Hampton South Carolina houses for rent.
Contrive, dig up, and come upon houses for rent in Pendleton United States, vacation rental Pendleton United States, and short term rentals in Pendleton.
Design and ascertain Georgetown South Carolina rent house, home rentals in Georgetown, vacation rentals in Georgetown, and Georgetown houses for rent.
Reserve and join up tomorrow morning to originate, tear into, jump into, and inaugurate on this pilgrimage.
Invent, observe, and espy Drayton houses for rent, real estate rentals, and vacation rentals Drayton.
This site, For Rent By Owner (FRBO.com) does eliminate rare convenient, suburban, beach, and oceanfront villa, home, timeshare, and farmhouses.
Houses for rent, homes for rent in Elk River Minnesota, rental apartment in Elk River Minnesota, and Elk River vacation rental
Design, relocate, and discover Hilda United States rental home, house rentals in Hilda United States, and condo rentals in Hilda United States.
Convenient ad directories and lake classified ads houses for rent Abbeville, Abbeville South Carolina houses for rent, rental homes Abbeville South Carolina, and homes for rent by owner Abbeville.
Originate and discern Plum Branch United States apartments for rent and rental home Plum Branch United States.
Perceive, discern, and ascertain house rentals Swansea United States, Swansea United States vacation rentals, and home rentals Swansea.
Ramblers, students, and better halves scan and frisk our website, FRBO.com and dig up romantic houseboat, exotic castle, oceanfront duplex, and resort duplex.
For rent by owner homes in Orland, condo rentals in Orland California, houses for rent in Orland California, and Orland California houses for rent
See beachfront advertisements, rustic lists of marked properties, and exclusive classifieds that landlords and town home owners post on our for rent by owner website.
Distinguish and perceive Cheraw United States condo rentals and rental houses Cheraw United States.
Determine, look up, and identify Spartanburg rent house, rental apartment in Spartanburg, real estate rentals Spartanburg South Carolina, and holiday rentals Spartanburg.
Ready to move in oceanfront ranch, hillside castle, and secluded houseboat are convenient in the immediate kingdom of Lake City-Scranton South Carolina.
Invent, devise, and uncover vacation rentals in Elloree United States, homes for rent, and Elloree United States vacation homes for rent by owner.
Kingston New York home rentals, Kingston rental properties, and apartments for rent Kingston
Dig up, learn, and come upon condo rentals in Jenkinsville United States, condos for rent in Jenkinsville, and Jenkinsville vacation homes for rent by owner.
Learn, identify, and discern apartment rentals in Charleston South Carolina and rental houses Charleston South Carolina.
Identify and hear vacation homes for rent by owner in Pineland United States and Pineland United States house rentals.
Uncover and perceive home rentals in Montmorenci and Montmorenci bed and breakfast rentals.
Ascertain and identify Pauline homes for rent and Pauline United States homes for rent by owner.
FRBO.com incorporates township, zone, principality, and domain abstracts, generally.
Determine, catch, and recognize condo rentals, Williamston United States rental properties, and Williamston real estate rentals.
You can distinguish and design homes for rent in Lake City-Scranton South Carolina and Lake City-Scranton South Carolina bed and breakfast rentals.
Detect and look up Seneca United States rental homes and real estate rentals Seneca.
Locate, dig up, and disclose apartment rentals, Greenwood South Carolina rental home, Greenwood South Carolina rent house, and homes for rent by owner in Greenwood South Carolina.
Come upon and ascertain Lexington house rentals and rental apartment Lexington South Carolina.
Debunk startling and various memorandums in Lake City-Scranton South Carolina and docket short term rentals in Lake City-Scranton.
|
|
