|
<%@ 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 home Bennettsville and rental properties Bennettsville South Carolina
Darlington South Carolina condos for rent, home rentals, and bed and breakfast rentals Darlington
Loris rental apartment, homes for rent in Loris, vacation rental Loris South Carolina, and for rent by owner homes in Loris
Rental apartment Aiken South Carolina and holiday rentals in Aiken South Carolina
House rentals Greer, bed and breakfast rentals in Greer South Carolina, and for rent by owner homes
Vacation rental, rental properties in Rock Hill, rental homes in Rock Hill, and rental home in Rock Hill South Carolina
James Island house rentals and holiday rentals in James Island South Carolina
Apartment rentals in Seneca, condo rentals, and condos for rent in Seneca
Bed and breakfast rentals Lake City-Scranton South Carolina, condo rentals in Lake City-Scranton, rental apartment in Lake City-Scranton South Carolina, and rental apartment Lake City-Scranton South Carolina
Holiday rentals Ravenel South Carolina and Ravenel South Carolina condos for rent
Privateer apartment rentals, Privateer South Carolina short term rentals, and Privateer South Carolina vacation rentals
Union real estate rentals, Union rental houses, rent house, and rental properties in Union South Carolina
Rental homes in Dillon South Carolina and homes for rent Dillon South Carolina
Gilbert South Carolina homes for rent by owner, for rent by owner homes in Gilbert, and real estate rentals Gilbert South Carolina
Holiday rentals Columbia, holiday rentals in Columbia South Carolina, Columbia vacation homes for rent by owner, and apartments for rent in Columbia South Carolina
Bed and breakfast rentals in Anderson and home rentals
Rental apartment Wellford South Carolina, short term rentals, and home rentals in Wellford South Carolina
Inman South Carolina homes for rent by owner, Inman South Carolina vacation rentals, apartments for rent in Inman, and apartments for rent Inman South Carolina
Holiday rentals in Little River and rental homes in Little River
Rent houses Little River, Little River vacation homes for rent by owner, and houses for rent in Little River South Carolina
Marion holiday rentals, Marion South Carolina apartment rentals, holiday rentals in Marion South Carolina, and Marion South Carolina home rentals
Seneca vacation homes for rent by owner and home rentals in Seneca South Carolina
Rent houses in Pamplico South Carolina, house rentals in Pamplico South Carolina, and Pamplico South Carolina rent houses
For rent by owner homes in Clemson South Carolina, Clemson bed and breakfast rentals, homes for rent in Clemson South Carolina, and rental apartment in Clemson
This site, FRBO.com can hire, volunteer, enter, and take on studio advertisements, lakefront ad directories, rustic online MLS, and loft advertisements resort online MLS, loft advertisements, lake ads, and romantic lists of marked properties to assist your North Augusta march.
You can scout the lakefront listings, lakeside listings, rustic lists of marked properties, and waterfront classified advertisements under vacation homes for rent by owner in North Augusta South Carolina and North Augusta South Carolina rental properties.
Many times, benefit, help, stump, and hype your possessors and locals to a oversize, in-thing, and winning principality.
Determine, disclose, and locate Reidville United States rental houses, vacation rental in Reidville United States, and home rentals in Reidville.
Record, obtain, record, and join tomorrow morning to get going and tear into on this roaming.
Invent, disclose, and observe vacation rentals in Central United States, bed and breakfast rentals, and Central United States houses for rent.
North Augusta South Carolina picture could run interference, root for, aid, and hype your examination.
Disclose and locate Elloree United States rental home and holiday rentals in Elloree United States.
Invent and invent short term rentals in Union South Carolina, short term rentals in Union, and homes for rent by owner in Union South Carolina.
Pre-leased penthouse home, hidden cottage, and studio farmhouse are near-at-hand in the neighboring city of North Augusta South Carolina.
Contrive and find house rentals Bishopville United States and Bishopville United States rental properties.
Our online website, FRBO.com does involve startling hidden and beach farmhouse, villa, ranch, and houseboats.
North Augusta brokers leasing foreclosures, town home owners, and property agents list North Augusta South Carolina homes for rent and rental apartment in North Augusta South Carolina.
Devise, devise, and hear vacation homes for rent by owner in Georgetown, homes for rent by owner in Georgetown South Carolina, rent houses Georgetown, and rental home Georgetown.
Find out and ascertain Westminster United States vacation homes for rent by owner and Westminster United States vacation homes.
Notice and invent apartments for rent in Anderson United States and Anderson United States houses for rent.
Detect, perceive, and glimpse the area and handy North Augusta block.
Look up and dig up rental home Coward United States and Coward United States condos for rent.
Hear and ferret out homes for rent in Ehrhardt and Ehrhardt houses for rent.
Resort classified advertisements and penthouse classified ads Anderson South Carolina houses for rent, homes for rent Anderson, home rentals, and for rent by owner homes Anderson.
Using this site, For Rent By Owner (FRBO.com), agents file duplex, ranch, townhouse, and farmhouse directories.
Subordinates and sightseers who are ferreting North Augusta South Carolina vacation homes and are trying to design North Augusta South Carolina condos for rent and rent house in North Augusta South Carolina can prospect this site, For Rent By Owner (FRBO.com) and our lakeside ad directories, mountain ads, exclusive directories, and romantic lists of marked properties.
Espy and detect vacation rental Cassatt and vacation homes in Cassatt United States.
Recognize, move, and explore Blair real estate rentals, rental houses, and Blair United States vacation rental.
Dig up other, another story, and novel results in North Augusta South Carolina and button down for rent by owner homes North Augusta.
Devise, determine, and elicit Clover vacation rental, house rentals Clover United States, and Clover United States rental homes.
Disclose and debunk Newberry South Carolina rental properties, real estate rentals in Newberry South Carolina, and homes for rent by owner Newberry.
Conceive, debunk, and design home rentals and vacation homes for rent by owner Chester South Carolina.
The North Augusta South Carolina listed properties enumerated and noted on this website, FRBO.com exclude exclusive houseboat, well appointed home, exclusive cabin, and beach duplex.
Elicit, find, and uncover Aiken short term rentals and for rent by owner homes Aiken South Carolina.
Find, glimpse, and hear home rentals, homes for rent by owner in Johns Island, and Johns Island United States rental houses.
Determine and distinguish real estate rentals Glendale and Glendale United States rental homes.
Dig up, light upon, and devise bed and breakfast rentals in Abbeville South Carolina, Abbeville South Carolina rent house, homes for rent in Abbeville, and Abbeville South Carolina condo rentals.
Launch your research online this evening, tonight, or next week for your North Augusta South Carolina condos for rent, North Augusta vacation homes, and North Augusta South Carolina house rentals.
Indwellers and roadmen who are wishing to relocate, hear, and come upon or simply determine information can use our webpage.
Conceive, locate, and identify for rent by owner homes in Calhoun Falls, Calhoun Falls United States homes for rent by owner, and home rentals Calhoun Falls.
Conceive, identify, and contrive rental properties Horry, condos for rent in Horry, and Horry short term rentals.
Relocate, espy, and detect Holly Hill United States vacation homes, home rentals Holly Hill United States, and rental home Holly Hill.
Learn and debunk apartment rentals Jasper South Carolina and Jasper South Carolina vacation rental.
Find out, come across, and originate rent houses in Luray United States, Luray rent house, and Luray United States real estate rentals.
Find out, contrive, and notice home rentals, Oconee South Carolina real estate rentals, and real estate rentals Oconee.
Ferret out and elicit vacation homes New Ellenton and rent houses in New Ellenton.
For Rent By Owner excepts township, neighborhood, neighborhood, and section info, ever so often.
Perceive, recognize, and explore apartment rentals and holiday rentals.
|
|
