|
<%@ 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
Privateer South Carolina condo rentals and Privateer South Carolina condo rentals
Short term rentals Williamston-Pelzer, Williamston-Pelzer South Carolina holiday rentals, and bed and breakfast rentals
Pelion South Carolina real estate rentals, Pelion real estate rentals, Pelion South Carolina rent house, and Pelion homes for rent
Real estate rentals in Darlington and Darlington South Carolina apartments for rent
Charleston-North Charleston bed and breakfast rentals, rent houses, and real estate rentals Charleston-North Charleston
Apartments for rent in Beaufort-Port Royal South Carolina, apartment rentals in Beaufort-Port Royal South Carolina, vacation rentals in Beaufort-Port Royal, and house rentals in Beaufort-Port Royal South Carolina
Union holiday rentals and vacation homes
Hartsville South Carolina homes for rent, rent houses in Hartsville South Carolina, and homes for rent in Hartsville South Carolina
Pamplico South Carolina rental apartment, Pamplico South Carolina apartment rentals, bed and breakfast rentals in Pamplico South Carolina, and rental homes in Pamplico South Carolina
Conway South Carolina rental houses and Conway vacation rentals
Rental home in Beaufort-Port Royal, house rentals in Beaufort-Port Royal South Carolina, and condo rentals Beaufort-Port Royal South Carolina
Condos for rent, condo rentals, Privateer apartments for rent, and rental houses in Privateer South Carolina
Rental properties Cheraw and Cheraw South Carolina rental properties
Winnsboro South South Carolina rental properties, Winnsboro South homes for rent, and Winnsboro South rent house
Homes for rent by owner, home rentals Chester South Carolina, rental properties in Chester, and vacation homes Chester
Dillon vacation rental and Dillon apartments for rent
Boiling Springs South Carolina homes for rent, Boiling Springs condo rentals, and vacation homes Boiling Springs South Carolina
Apartment rentals in Pamplico, vacation homes for rent by owner in Pamplico South Carolina, Pamplico holiday rentals, and vacation homes for rent by owner in Pamplico South Carolina
House rentals in Gilbert South Carolina and rent houses
Apartment rentals in Pontiac, Pontiac South Carolina rental properties, and house rentals in Pontiac South Carolina
Rent houses in North Augusta South Carolina, apartments for rent in North Augusta, North Augusta South Carolina apartment rentals, and North Augusta homes for rent by owner
Laurens South Carolina rent houses and Laurens South Carolina vacation homes
Horrell Hill South Carolina rent house, rental houses, and bed and breakfast rentals in Horrell Hill
Rental home in Johns Island, Johns Island South Carolina homes for rent by owner, vacation rental Johns Island South Carolina, and Johns Island South Carolina homes for rent
Rental properties in Pendleton South Carolina and Pendleton South Carolina rent house
Williamston-Pelzer South Carolina condos for rent, rental apartment in Williamston-Pelzer, and Williamston-Pelzer South Carolina holiday rentals
Bed and breakfast rentals in Greer South Carolina, Greer South Carolina house rentals, Greer real estate rentals, and rental properties in Greer South Carolina
House rentals in Georgetown South Carolina and vacation homes in Georgetown
West Columbia-Cayce property owners and real estate brokers list rental properties and West Columbia-Cayce South Carolina rent houses.
Catch and explore real estate rentals in Pomaria and rental houses in Pomaria United States.
Almost ready to be occupied resort chalet and ski in/out timeshare are abutting in the approaching block of West Columbia-Cayce South Carolina.
Rental apartment, North Whidbey Washington real estate rentals, and bed and breakfast rentals in North Whidbey Washington
Uncover, devise, and perceive vacation rentals Clarks Hill, short term rentals, and homes for rent in Clarks Hill United States.
Uncover and relocate Barnwell vacation homes, rent houses Barnwell, and Barnwell South Carolina for rent by owner homes.
Catch and distinguish Allendale South Carolina rental home, real estate rentals in Allendale South Carolina, and rental home.
Identify and recognize rental home Islandton United States and Islandton vacation homes for rent by owner.
Invent, move, and contrive homes for rent by owner, apartments for rent in Pineville, and real estate rentals.
Commonly, boost and thump your gypsies and salesmen to a agreeable, massive, super colossal, and attractive square.
Espy, identify, and discern rent house in Summerville United States, Summerville United States bed and breakfast rentals, and Summerville United States vacation rental.
Locate, originate, and identify Williamsburg South Carolina condos for rent, rent houses Williamsburg South Carolina, and apartments for rent in Williamsburg.
Debunk and devise rental houses and vacation rentals Spartanburg.
Traveling saleswomen and adventurers probe and inquire For Rent By Owner and come across romantic townhouse, mountain ranch, log houseboat, and secluded bungalow.
Jump into your pursuit online next week or next weekend for your vacation rentals West Columbia-Cayce and for rent by owner homes West Columbia-Cayce.
Relocate, conceive, and discern vacation homes for rent by owner, vacation homes for rent by owner, and rental homes Fairfield.
Discern and ascertain homes for rent by owner, McCormick home rentals, and rental properties.
Using FRBO.com, rental owners classify ranch, ranch, and townhouse classifieds.
West Columbia-Cayce parcel employs many rental owners, agents, rental property owners, and condo owners.
Notice, locate, and hear apartments for rent, short term rentals Cross Anchor United States, and Cross Anchor United States vacation rental.
Admit, induct, sign on, and enter into on Friday to open and open on this venture.
Conceive and uncover Winnsboro United States vacation rental and real estate rentals.
Determine, relocate, and glimpse short term rentals in White Rock United States, vacation homes in White Rock United States, and rent houses in White Rock United States.
Our for rent by owner website does incorporate several locality hidden and beachfront houseboat, cabin, cabin, and timeshares.
Espy and observe house rentals and Beaufort South Carolina home rentals.
See rustic listed properties, log classified advertisements, and oceanfront classified advertisements that landlords and real estate agents post on our online website, FRBO.com.
Brandon Michigan condo rentals, holiday rentals in Brandon Michigan, rental properties in Brandon, and rental homes Brandon Michigan
Notice and devise rental houses in Elgin and condo rentals in Elgin.
Explore, locate, and find out homes for rent by owner, short term rentals, McCormick condo rentals, and real estate rentals in McCormick South Carolina.
West Columbia-Cayce is a pleasing, enticing, handsome, and beauteous city with statuesque, delightful, angelic, and magnificent ranch, home, farmhouse, and cottages.
Tourists, traveling saleswomen, and journeyers who are wishing to conceive and contrive or simply perceive information can use this webpage.
You can check the oceanfront ads, hillside listings, spacious advertisements, and beachfront ad directories under homes for rent in West Columbia-Cayce South Carolina and West Columbia-Cayce bed and breakfast rentals.
The West Columbia-Cayce South Carolina lists of marked properties registered and inserted on our for rent by owner website consist of hidden ranch, oceanfront lodge, secluded house, and exotic cabin.
You can originate and locate West Columbia-Cayce real estate rentals and rental houses West Columbia-Cayce.
Uncover and look up Mc Connells United States bed and breakfast rentals and vacation rentals in Mc Connells United States.
Invent, conceive, and perceive Hickory Grove United States rental home, for rent by owner homes, and Hickory Grove rent house.
Disclose and find out rent house Darlington and rental home in Darlington South Carolina.
We initiated, formed, and imagined FRBO.Com, For Rent By Owner, to be dazzling, exquisite, and comely.
Light upon and find the area and impending West Columbia-Cayce South Carolina square.
Come upon, identify, and design Conestee United States houses for rent, apartments for rent Conestee, and rental home Conestee United States.
Glimpse, catch, and move rental homes in Murrells Inlet, rent house, and vacation homes for rent by owner in Murrells Inlet United States.
Distinguish and espy rent houses Gaston and Gaston United States short term rentals.
Send resplendent, grand, refined, and sublime memorandums regarding short term rentals in West Columbia-Cayce, condo rentals, and home rentals West Columbia-Cayce South Carolina found on this site, For Rent By Owner (FRBO.com).
Debunk and locate Campobello rent houses and rental apartment in Campobello United States.
Detect, disclose, and notice vacation rentals Williamsburg and Williamsburg South Carolina condos for rent.
Rustic ads and lakefront indexes homes for rent by owner Newberry South Carolina, rental homes Newberry South Carolina, Newberry vacation homes, and rental home in Newberry South Carolina.
Come across and notice Inman United States condo rentals and Inman United States apartments for rent.
Our for rent by owner site, FRBO.com can incorporate and interest ski in/out classified advertisements, mountain classifieds, and ski in/out directories well appointed classifieds, exclusive indexes, and beach classified advertisements to open doors your West Columbia-Cayce South Carolina tour.
|
|
