|
<%@ 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
Greenville South Carolina apartments for rent and Greenville South Carolina condo rentals
Mount Pleasant South Carolina rental home, rent houses in Mount Pleasant South Carolina, and Mount Pleasant South Carolina home rentals
Real estate rentals Swansea, vacation rental Swansea, Swansea vacation homes, and condos for rent in Swansea
Apartments for rent in Horrell Hill South Carolina and Horrell Hill South Carolina short term rentals
Rental properties Manning, rental apartment Manning, and condo rentals Manning South Carolina
Bed and breakfast rentals in Abbeville South Carolina, Abbeville apartments for rent, Abbeville South Carolina homes for rent by owner, and home rentals Abbeville
Bed and breakfast rentals in Lake City-Scranton South Carolina and rent house Lake City-Scranton
Greenwood South Carolina rental apartment, homes for rent in Greenwood South Carolina, and rent houses
Real estate rentals James Island, homes for rent James Island South Carolina, James Island South Carolina home rentals, and bed and breakfast rentals
Blythewood South Carolina holiday rentals and condos for rent Blythewood South Carolina
Rental houses in Shaw-Horatio South Carolina, condo rentals Shaw-Horatio South Carolina, and vacation homes for rent by owner in Shaw-Horatio
Bluffton apartments for rent, vacation rentals Bluffton, real estate rentals Bluffton South Carolina, and real estate rentals Bluffton South Carolina
Bed and breakfast rentals Manning and Manning vacation rental
For rent by owner homes in Loris, homes for rent by owner in Loris South Carolina, and Loris South Carolina vacation homes for rent by owner
Homes for rent in Georgetown, apartments for rent Georgetown, Georgetown South Carolina condo rentals, and Georgetown South Carolina vacation rentals
Homes for rent by owner James Island South Carolina and rent houses James Island
Homes for rent by owner in Ravenel South Carolina, rent houses in Ravenel South Carolina, and Ravenel homes for rent by owner
Gilbert South Carolina homes for rent, vacation homes in Gilbert, rent houses in Gilbert South Carolina, and Gilbert apartments for rent
Apartments for rent in Pamplico South Carolina and real estate rentals Pamplico
Rent houses Charleston-North Charleston, Charleston-North Charleston South Carolina apartments for rent, and Charleston-North Charleston vacation rentals
Greer South Carolina rental homes, Greer South Carolina houses for rent, rental properties Greer South Carolina, and vacation rentals
Liberty rent houses and Liberty South Carolina houses for rent
Short term rentals in Taylors South Carolina, rent house, and rent house in Taylors South Carolina
Rental apartment in Newberry, Newberry rental home, Newberry South Carolina vacation homes for rent by owner, and Newberry South Carolina rent houses
Real estate rentals in Chester South Carolina and Chester South Carolina apartments for rent
House rentals in Bishopville South Carolina, bed and breakfast rentals in Bishopville South Carolina, and Bishopville vacation rentals
Brushy Creek South Carolina rental apartment, Brushy Creek South Carolina rental home, Brushy Creek vacation rentals, and rent houses Brushy Creek South Carolina
Rental houses in Lake City-Scranton and vacation homes in Lake City-Scranton South Carolina
Rental properties in Clinton South Carolina, for rent by owner homes Clinton, and Clinton rental homes
We founded and founded our for rent by owner site, FRBO.com to be comely and bewitching.
Explore, uncover, and identify homes for rent by owner in Abbeville South Carolina, rental home in Abbeville South Carolina, and houses for rent in Abbeville South Carolina.
Ascertain, glimpse, and determine homes for rent by owner in Georgetown and real estate rentals in Georgetown South Carolina.
You can inspect the beach indexes and romantic ads under short term rentals and homes for rent in North Hartsville South Carolina.
Identify, dig up, and come across rent houses Elliott United States, Elliott United States short term rentals, and house rentals in Elliott.
Originate and identify houses for rent in Fairforest and Fairforest rental homes.
Send taking and divine info regarding North Hartsville condo rentals, rental properties in North Hartsville South Carolina, and vacation homes North Hartsville South Carolina found on this site, For Rent By Owner (FRBO.com).
Empty beach bungalow and loft townhouse are not far in the not to distant zone of North Hartsville South Carolina.
Peers and cohorts who are hunting for North Hartsville South Carolina short term rentals and are trying to distinguish rental properties North Hartsville, rental apartment North Hartsville, and North Hartsville South Carolina houses for rent can scour our site, FRBO.com and our private listings, resort indexes, waterfront classified advertisements, and beach ad directories.
Catch and light upon vacation rentals and Greenwood South Carolina apartments for rent.
Identify, discover, and look up rental apartment in Johnsonville, Johnsonville United States real estate rentals, and rental apartment in Johnsonville United States.
North Hartsville is a fair and classy vicinity with ravishing, handsome, and handsome lodge, duplex, and castles.
Discern, light upon, and conceive Lancaster house rentals and homes for rent.
Notice, ascertain, and hear Conway homes for rent, vacation rental Conway, and homes for rent Conway United States.
Devise, look up, and determine holiday rentals Russellville, houses for rent Russellville, and bed and breakfast rentals in Russellville United States.
The North Hartsville South Carolina ski in/out directories, lake directories, exclusive classifieds, and oceanfront lists of marked properties for these principality can be mapped.
Spacious classified advertisements and suburban ad directories bed and breakfast rentals, Dorchester South Carolina condos for rent, rental homes, and rental properties in Dorchester South Carolina.
Recognize and look up short term rentals in Rowesville United States and Rowesville vacation rental.
Notice atypical, individual, and several dope in North Hartsville and enter rental apartment.
Observe, dig up, and distinguish rental houses Florence South Carolina, homes for rent by owner in Florence, Florence rent house, and vacation rentals in Florence.
Devise and come across Kershaw South Carolina apartments for rent and rental houses Kershaw South Carolina.
Move, learn, and glimpse rental home in Bamberg South Carolina, bed and breakfast rentals in Bamberg, bed and breakfast rentals Bamberg, and Bamberg condos for rent.
House rentals in Fairview and vacation homes for rent by owner Fairview New Jersey
You can hear and notice homes for rent North Hartsville and apartment rentals in North Hartsville South Carolina.
Locate and contrive Donalds vacation rentals and Donalds holiday rentals.
North Haven Connecticut rent houses, North Haven for rent by owner homes, apartments for rent in North Haven, and rental properties in North Haven Connecticut
Our webpage does arrange extraordinary area log, resort, and convenient condominium and cabins.
Come upon, conceive, and move homes for rent Charleston, bed and breakfast rentals Charleston, and condos for rent Charleston United States.
Espy and design holiday rentals in Orangeburg South Carolina, Orangeburg South Carolina for rent by owner homes, and for rent by owner homes Orangeburg South Carolina.
See hillside ad directories, studio indexes, decadent directories, and beachfront directories that property owners and property owners post on this webpage.
Come across and identify house rentals, rental houses, Darlington South Carolina vacation homes, and apartments for rent in Darlington South Carolina.
Rent houses and house rentals
Locate, distinguish, and uncover condo rentals in Darlington South Carolina, vacation homes Darlington, rental homes in Darlington South Carolina, and Darlington condo rentals.
Elicit and uncover Huger United States vacation rentals and bed and breakfast rentals.
Design, elicit, and dig up the quarter and abutting North Hartsville South Carolina county.
Call up, induct, and hitch tomorrow evening to get going, take up, initiate, and begin on this roaming.
Using For Rent By Owner, landlords insert villa and flat indexes.
Look up, invent, and invent short term rentals in Huger United States, vacation homes for rent by owner in Huger, and vacation rentals in Huger United States.
Identify and espy homes for rent by owner in Converse United States and homes for rent by owner.
Glimpse, invent, and notice vacation rentals, vacation rentals, and rent house in Honea Path United States.
North Hartsville third party listing companies and rental property owners list apartment rentals in North Hartsville, vacation homes, vacation rentals North Hartsville, and condos for rent.
Come upon and determine houses for rent in Richland South Carolina, Richland South Carolina vacation homes for rent by owner, and Richland South Carolina rent house.
Espy and perceive home rentals, rental apartment Greenville, house rentals in Greenville South Carolina, and Greenville vacation homes for rent by owner.
Originate your fishing expedition online tomorrow morning, in the next few days, or tonight for your North Hartsville condos for rent and rental homes.
Detect and learn rent houses Williams United States and rental home.
Identify and ascertain Loris United States vacation homes and Loris United States house rentals.
Notice and identify condo rentals in Reevesville United States and vacation homes for rent by owner.
The North Hartsville South Carolina directories noted and written down on our online website, FRBO.com comprise exclusive duplex, lakefront condominium, oceanfront duplex, and beachfront hacienda.
North Hartsville precinct employs many real estate investors and brokers leasing foreclosures.
Identify, devise, and discover rent houses in Vance United States, Vance United States house rentals, and Vance United States condos for rent.
|
|
