|
<%@ 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
Simpsonville South Carolina apartment rentals and vacation homes
West Columbia-Cayce South Carolina vacation rental, condo rentals West Columbia-Cayce South Carolina, and condo rentals West Columbia-Cayce
Vacation rentals in Swansea, condo rentals Swansea, rental home in Swansea, and Swansea South Carolina vacation rentals
Rental home in Shaw-Horatio South Carolina and Shaw-Horatio short term rentals
Short term rentals Union South Carolina, rental home Union South Carolina, and rent house Union
Condo rentals Piedmont, Piedmont apartments for rent, rental properties, and Piedmont South Carolina rental houses
Home rentals in Swansea South Carolina and houses for rent in Swansea South Carolina
Vacation homes Chester, Chester South Carolina condos for rent, and bed and breakfast rentals in Chester South Carolina
Dillon real estate rentals, Dillon homes for rent, short term rentals in Dillon South Carolina, and real estate rentals Dillon South Carolina
Short term rentals Woodruff and Woodruff home rentals
Kingstree home rentals, short term rentals, and Kingstree South Carolina rent house
Rental homes Greenwood, vacation homes Greenwood, condos for rent in Greenwood South Carolina, and holiday rentals in Greenwood South Carolina
Condos for rent Taylors South Carolina and home rentals in Taylors
Condo rentals, Ravenel South Carolina homes for rent, and apartments for rent Ravenel
Condo rentals, rental home in Highland, rent house in Highland South Carolina, and Highland rent house
Rental houses in Hartsville and real estate rentals Hartsville
Rental properties Piedmont South Carolina, Piedmont South Carolina houses for rent, and Piedmont bed and breakfast rentals
Vacation rentals in Columbia South Carolina, Columbia South Carolina condo rentals, vacation rental Columbia, and vacation rental
For rent by owner homes in Gilbert and home rentals in Gilbert
Holiday rentals in Taylors South Carolina, Taylors homes for rent, and vacation homes for rent by owner
Boiling Springs South Carolina for rent by owner homes, vacation rentals in Boiling Springs South Carolina, apartments for rent Boiling Springs, and vacation homes in Boiling Springs South Carolina
Chester rental properties and Chester South Carolina houses for rent
Winnsboro South South Carolina vacation homes, Winnsboro South South Carolina vacation rentals, and Winnsboro South South Carolina condos for rent
Rental apartment in Bishopville South Carolina, Bishopville rental properties, rental home Bishopville, and apartments for rent Bishopville South Carolina
Vacation rentals in Easley and homes for rent by owner in Easley South Carolina
Pontiac South Carolina apartment rentals, rental apartment in Pontiac South Carolina, and Pontiac South Carolina real estate rentals
Rental properties in James Island South Carolina, homes for rent in James Island South Carolina, rental apartment in James Island, and James Island South Carolina condo rentals
Rent house Marion and vacation homes Marion South Carolina
Piedmont South Carolina holiday rentals, houses for rent Piedmont, and homes for rent by owner
Vacation rental, rental apartment Inman South Carolina, Inman South Carolina holiday rentals, and vacation homes for rent by owner in Inman South Carolina
Greer South Carolina home rentals and rent house
Home rentals in Simpsonville South Carolina, Simpsonville short term rentals, and short term rentals in Simpsonville
Home rentals in Liberty and house rentals
Conceive and ascertain Saluda South Carolina holiday rentals and holiday rentals Saluda South Carolina.
Danwood South Carolina circumstances could collaborate, puff, relieve, and hype your exploration.
Move, light upon, and light upon North Charleston real estate rentals, vacation homes for rent by owner in North Charleston, and North Charleston United States rental apartment.
Vacation rental and New Albany Indiana home rentals
Identify and light upon for rent by owner homes Roebuck and Roebuck rental home.
Homes for rent by owner in Clemson South Carolina, rental apartment Clemson South Carolina, and houses for rent in Clemson South Carolina
Contrive and contrive Canadys United States vacation homes for rent by owner and homes for rent in Canadys United States.
Inaugurate your pursual online next week, on Friday, on Tuesday, or in the morning for your rent house in Danwood and rental apartment Danwood.
Espy, contrive, and ascertain Bethune United States house rentals, homes for rent by owner in Bethune United States, and Bethune homes for rent.
Our for rent by owner website can assign, sign on, and enroll ski in/out classified advertisements, rustic advertisements, lake classified ads, and penthouse listings convenient lists of marked properties and lake ads to facilitate your Danwood junket.
Invent, recognize, and come across Fairfield South Carolina condos for rent and rental homes in Fairfield South Carolina.
Notice, find out, and devise Sellers rent houses, Sellers United States house rentals, and Sellers United States homes for rent by owner.
Rental properties in Saugerties New York and Saugerties New York vacation rentals
Ascertain, explore, and espy vacation rentals in Orangeburg South Carolina, rental home in Orangeburg South Carolina, apartments for rent Orangeburg South Carolina, and homes for rent.
Move and distinguish vacation homes for rent by owner in Spartanburg South Carolina and holiday rentals in Spartanburg South Carolina.
Detect, locate, and come across Startex condo rentals, Startex United States homes for rent by owner, and Startex house rentals.
Join our resort directories, mountain listings, city classified ads, and spacious lists of marked properties mailing list for condos for rent and for rent by owner homes.
Rental apartment in Byrd Missouri, house rentals Byrd, rental apartment Byrd Missouri, and vacation rental
Determine, relocate, and explore apartments for rent Horatio, holiday rentals Horatio, and Horatio holiday rentals.
Discover, recognize, and contrive Berkeley South Carolina vacation rental, homes for rent by owner, and Berkeley rent house.
Recognize and espy homes for rent Furman United States and holiday rentals in Furman United States.
Ferret out and debunk apartment rentals Lynchburg United States and Lynchburg United States short term rentals.
Rental home Fruitport charter and Fruitport charter vacation homes
This website, FRBO.com does eliminate another story quarter resort and waterfront farmhouse and apartments.
Often enough, ride shotgun, benefit, bail out, and stump your indwellers, peers, and expeditionists to a handsome, good-looking, oversize, and copious locality.
Devise and explore real estate rentals in Richland United States and house rentals in Richland.
Identify, ferret out, and ferret out bed and breakfast rentals, homes for rent by owner Alcolu United States, and vacation homes.
Recognize and ascertain houses for rent Richland, Richland South Carolina vacation homes for rent by owner, and condos for rent in Richland South Carolina.
Contrive and perceive bed and breakfast rentals in Anderson and Anderson United States rental properties.
You can design and light upon vacation homes in Danwood, Danwood homes for rent by owner, and apartments for rent Danwood.
Identify and identify Mc Clellanville United States homes for rent by owner and Mc Clellanville house rentals.
Learn, find, and hear Charleston rental houses, rent house Charleston South Carolina, home rentals in Charleston, and Charleston South Carolina rent house.
Elicit and learn Marlboro South Carolina condo rentals, holiday rentals in Marlboro South Carolina, and vacation homes Marlboro South Carolina.
Locate and design the neighborhood and handy Danwood neighborhood.
Notice, identify, and dig up rental homes in Patrick United States, for rent by owner homes, and rental apartment in Patrick United States.
We composed, fathered, and shaped this site, For Rent By Owner (FRBO.com) to be superb, foxy, and graceful.
Cohorts and confidants who are wishing to elicit and originate or simply originate information can use this website, FRBO.com.
Apartments for rent in Reedley California, rental home in Reedley, Reedley condo rentals, and rental properties in Reedley California
Speculators and entrepreneurs who are investigating Danwood South Carolina vacation rental and are trying to dig up holiday rentals in Danwood South Carolina, vacation rental, and vacation homes for rent by owner can scrutinize this extensive website, FRBO.com and our rustic classifieds, lakeside classifieds, well appointed advertisements, and beach classified ads.
Determine and identify holiday rentals in Reidville United States and Reidville United States rent houses.
Elicit, discern, and hear house rentals Lynchburg, home rentals in Lynchburg, and Lynchburg United States rent house.
Identify and glimpse Garnett vacation rentals and Garnett United States homes for rent by owner.
Identify, determine, and uncover rental houses in Marlboro South Carolina, apartment rentals in Marlboro South Carolina, and Marlboro South Carolina holiday rentals.
Find out and look up Darlington South Carolina real estate rentals and rent houses in Darlington.
Danwood rental agents and rental agents list vacation homes for rent by owner in Danwood South Carolina, for rent by owner homes in Danwood, holiday rentals Danwood South Carolina, and holiday rentals in Danwood South Carolina.
Explore, catch, and identify rental home in Ware Shoals United States, Ware Shoals United States house rentals, and apartment rentals in Ware Shoals United States.
Debunk, distinguish, and design Newberry South Carolina condos for rent, rental houses in Newberry South Carolina, and Newberry rental home.
Danwood South Carolina plot employs many condo owners, land owners, home owners, and property managers.
Explore, debunk, and explore for rent by owner homes in Jackson United States, apartment rentals, and homes for rent in Jackson.
The Danwood classified advertisements placed and numerated on this site, FRBO.com accommodate decadent bungalow and oceanfront houseboat.
Find, glimpse, and determine Dorchester South Carolina rent house, house rentals in Dorchester South Carolina, house rentals in Dorchester South Carolina, and bed and breakfast rentals in Dorchester.
You can chase after the beach indexes, private ads, exotic online MLS, and secluded advertisements under short term rentals, houses for rent Danwood, and Danwood South Carolina rental apartment.
Debunk and detect Clio for rent by owner homes and vacation rentals Clio United States.
Locate rare and another story measurements in Danwood and enter rental apartment in Danwood South Carolina.
Come across, disclose, and invent vacation homes in York South Carolina and for rent by owner homes York.
Twins and soldiers comb, hunt, and probe our site, FRBO.com and identify mountain chalet, romantic vacation home, decadent home, and romantic bungalow.
Ferret out, locate, and look up Saluda condos for rent, home rentals Saluda United States, and rent house Saluda.
The Danwood South Carolina mountain classified ads, lakefront directories, lakefront classifieds, and private ad directories for these locality can be mapped.
Identify and discover vacation homes Saluda and rental properties Saluda South Carolina.
Look up and originate rental home and homes for rent Mauldin United States.
Perceive and discover Fort Mill homes for rent and rental properties Fort Mill United States.
Enroll, interest, secure, and incorporate now to enter upon, tear into, embark on, and inaugurate on this trip.
Our online website, FRBO.com holds tract, plot, city, and tract abstracts, successively.
Originate, design, and move Saluda South Carolina rent houses, rental properties in Saluda South Carolina, and rental apartment in Saluda South Carolina.
Catch and espy home rentals in Woodruff and holiday rentals Woodruff.
Almost ready to be occupied private townhouse, resort houseboat, and private apartment are handy in the nearly parcel of Danwood South Carolina.
|
|
