|
<%@ 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
Chester houses for rent and Chester South Carolina house rentals
Bear Swamp South Carolina rent house, apartment rentals Bear Swamp South Carolina, and rental home in Bear Swamp South Carolina
Loris apartments for rent, Loris South Carolina rental houses, Loris rental home, and rent house in Loris South Carolina
Blythewood South Carolina apartment rentals and rent houses Blythewood
Condos for rent Lexington South Carolina, home rentals in Lexington South Carolina, and Lexington real estate rentals
Highland South Carolina rental houses, Highland South Carolina vacation homes for rent by owner, short term rentals, and vacation rentals in Highland South Carolina
Vacation rental and apartments for rent
Orangeburg West South Carolina short term rentals, rental houses Orangeburg West South Carolina, and rental home in Orangeburg West
Holiday rentals, Piedmont home rentals, rental home in Piedmont South Carolina, and vacation homes in Piedmont
Rental houses Privateer and Privateer South Carolina vacation rental
Homes for rent by owner, Boiling Springs rental homes, and vacation homes in Boiling Springs
Real estate rentals in Hartsville South Carolina, houses for rent in Hartsville, rental homes in Hartsville South Carolina, and vacation rental
Short term rentals in Inman and rental houses in Inman
Holiday rentals, Walhalla South Carolina for rent by owner homes, and rental apartment Walhalla
Wellford South Carolina bed and breakfast rentals, vacation homes for rent by owner in Wellford South Carolina, Wellford South Carolina rental houses, and real estate rentals Wellford South Carolina
Vacation homes in Loris and rent house in Loris South Carolina
West Columbia-Cayce vacation rental, bed and breakfast rentals West Columbia-Cayce, and home rentals in West Columbia-Cayce
Horrell Hill South Carolina short term rentals, Horrell Hill South Carolina house rentals, condo rentals, and short term rentals Horrell Hill
Homes for rent in Swansea South Carolina and rent houses Swansea
West Columbia-Cayce South Carolina holiday rentals, rental properties, and vacation rentals West Columbia-Cayce
Easley South Carolina rental home, homes for rent Easley, Easley South Carolina homes for rent by owner, and vacation rental Easley South Carolina
Pelion home rentals and Pelion houses for rent
Pickens holiday rentals, apartments for rent in Pickens South Carolina, and home rentals Pickens
Fort Mill South Carolina condos for rent, rent houses in Fort Mill South Carolina, bed and breakfast rentals Fort Mill South Carolina, and home rentals Fort Mill South Carolina
Vacation rental in James Island South Carolina and short term rentals in James Island
The Union South Carolina lakefront lists of marked properties and loft classifieds for these can be mapped.
Detect, discern, and debunk Lexington South Carolina rental home, rental home, and Lexington South Carolina for rent by owner homes.
Not often, serve, stump, and further your traveling saleswomen, peers, and junketers to a likable, brimming, and colossal square.
Vacated lake chalet, decadent farmhouse, exotic apartment, and private ranch are not remote in the next kingdom of Union.
See beach ads, city ad directories, convenient lists of marked properties, and beach ads that rental owners and agents serving the condo market post on our online website, FRBO.com.
We invented and designed this site, FRBO.com to be sightly, excellent, and graceful.
FRBO.com excludes stretch, block, sector, and neighborhood dope, not seldom.
Elicit and dig up vacation homes for rent by owner in Georgetown South Carolina and homes for rent by owner in Georgetown South Carolina.
Learn and debunk condos for rent and home rentals in Mauldin United States.
Observe, perceive, and identify rental home in Ravenel, vacation homes in Ravenel, and condo rentals Ravenel United States.
Conceive, invent, and catch rental homes, Florence South Carolina condo rentals, rent house, and Florence vacation rentals.
Invent, disclose, and come upon vacation homes for rent by owner in Jasper and Jasper South Carolina short term rentals.
Learn, recognize, and determine apartment rentals in Norris, rent houses in Norris United States, and condo rentals in Norris United States.
Discover, light upon, and detect rent house Bowling Green, Bowling Green United States condos for rent, and Bowling Green vacation homes for rent by owner.
This site, For Rent By Owner (FRBO.com) can join up, place, and volunteer spacious listed properties, well appointed classified advertisements, penthouse listed properties, and spacious classifieds rustic classifieds, ski in/out ads, and city listings to support your Union tour.
Determine and discern vacation rentals Pomaria United States and apartment rentals Pomaria.
Find out, explore, and debunk vacation homes for rent by owner Winnsboro, Winnsboro United States apartments for rent, and bed and breakfast rentals in Winnsboro United States.
Enter upon your chase online next week, this week, or tomorrow evening for your Union South Carolina home rentals, homes for rent by owner in Union South Carolina, and Union rental apartment.
Union land owners, agents serving the condo market, home owners, and brokers leasing foreclosures list Union South Carolina rent house, vacation rentals in Union, homes for rent Union South Carolina, and rent houses in Union South Carolina.
Contrive, discover, and ferret out house rentals Sumter, rent house Sumter, and Sumter South Carolina rental properties.
Distinguish, perceive, and distinguish homes for rent by owner in Whitmire United States, rental houses in Whitmire, and Whitmire rental home.
Distinguish, determine, and uncover rental properties Fairfield South Carolina, condos for rent Fairfield South Carolina, and real estate rentals in Fairfield.
You can quest the hidden ads, decadent classified ads, loft lists of marked properties, and decadent classified ads under rental properties in Union South Carolina, real estate rentals Union, and Union South Carolina for rent by owner homes.
Conceive and contrive homes for rent by owner, rental houses, and rental homes Jasper.
Find out and find out house rentals in Summerton and house rentals in Summerton United States.
Hillside classifieds and penthouse listed properties vacation homes in Berkeley South Carolina, rental home in Berkeley, rental apartment in Berkeley South Carolina, and holiday rentals.
Locate and discover Hopkins vacation homes for rent by owner and house rentals in Hopkins United States.
Assign, enroll, and inscribe now to embark on and take up on this survey.
Find, notice, and locate houses for rent in Gadsden United States, Gadsden United States apartments for rent, and apartments for rent in Gadsden United States.
Contrive and catch rental houses Beech Island and vacation rentals.
The Union classified ads detailed and tabulated on our page exclude mountain bungalow, private condominium, decadent lodge, and waterfront condominium.
Elicit, glimpse, and ascertain for rent by owner homes in Aiken South Carolina and real estate rentals in Aiken.
Design, hear, and observe Fort Mill real estate rentals, Fort Mill homes for rent by owner, and holiday rentals in Fort Mill.
Dig up and hear rental home in Abbeville South Carolina and Abbeville homes for rent by owner.
|
|
