|
<%@ 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
North Augusta condos for rent and North Augusta South Carolina rental homes
Rental homes in Bear Swamp South Carolina, for rent by owner homes in Bear Swamp South Carolina, and short term rentals Bear Swamp South Carolina
Rental properties Georgetown South Carolina, Georgetown South Carolina apartments for rent, apartments for rent, and rental home
Rent houses and vacation homes for rent by owner Rock Hill South Carolina
Rental properties Camden South Carolina, Camden holiday rentals, and houses for rent
Vacation rentals Darlington South Carolina, home rentals Darlington, for rent by owner homes Darlington South Carolina, and rental properties in Darlington South Carolina
Houses for rent Aiken South Carolina and homes for rent by owner
Condo rentals in Bennettsville South Carolina, rent houses Bennettsville, and homes for rent in Bennettsville South Carolina
Vacation homes for rent by owner Conway East, holiday rentals Conway East, bed and breakfast rentals in Conway East South Carolina, and rental houses in Conway East South Carolina
Rental properties in Pendleton South Carolina and Pendleton South Carolina rental apartment
Condo rentals in Laurens South Carolina, condo rentals Laurens, and condos for rent in Laurens South Carolina
Orangeburg South Carolina rental houses, apartment rentals Orangeburg South Carolina, house rentals Orangeburg, and Orangeburg South Carolina houses for rent
Rental properties and house rentals in North Augusta South Carolina
Rental properties in Camden South Carolina, rent house Camden, and rental home in Camden South Carolina
Homes for rent North Hartsville, North Hartsville South Carolina holiday rentals, condos for rent North Hartsville South Carolina, and North Hartsville rent houses
Bluffton apartment rentals and rental homes in Bluffton
Moncks Corner real estate rentals, holiday rentals Moncks Corner, and house rentals in Moncks Corner
Bear Swamp South Carolina vacation homes, Bear Swamp South Carolina house rentals, vacation rentals in Bear Swamp South Carolina, and Bear Swamp South Carolina rent house
Rent houses in Shaw-Horatio and vacation rental
Homes for rent by owner, Newberry South Carolina vacation rental, and rental apartment Newberry South Carolina
Bear Swamp condos for rent, houses for rent in Bear Swamp, real estate rentals Bear Swamp South Carolina, and rent house Bear Swamp South Carolina
Rent house in Greenwood South Carolina and rental apartment Greenwood
Holiday rentals in Liberty South Carolina, houses for rent Liberty, and short term rentals in Liberty South Carolina
Summerville South Carolina condo rentals, homes for rent by owner Summerville South Carolina, Summerville rental homes, and Summerville home rentals
Rental homes and home rentals in Inman South Carolina
House rentals Bennettsville South Carolina, Bennettsville South Carolina rental properties, and condo rentals in Bennettsville
Vacation rental, vacation rental in Inman South Carolina, vacation homes in Inman, and Inman South Carolina rental apartment
Clinton South Carolina bed and breakfast rentals and vacation homes in Clinton South Carolina
Rent house, rental homes Travelers Rest, and Travelers Rest rental apartment
West Columbia-Cayce South Carolina home rentals, rental home, vacation rental in West Columbia-Cayce, and West Columbia-Cayce South Carolina rental properties
Winnsboro South South Carolina section employs many home owners, third party agents, agents, and rental property owners.
Dig up and detect Kershaw apartment rentals, home rentals Kershaw, and rent houses Kershaw South Carolina.
FRBO.com does embody express precinct hillside, beachfront, private, and resort cabin, ranch, house, and townhouses.
Ferret out, contrive, and design apartments for rent in Elloree, Elloree house rentals, and Elloree homes for rent by owner.
You can distinguish, recognize, and identify Winnsboro South real estate rentals, Winnsboro South South Carolina houses for rent, and apartment rentals Winnsboro South.
Oftentimes, facilitate and back your trippers and sisters-in-law to a heavyweight, crowded, burly, and brimming kingdom.
Contrive, glimpse, and identify rental houses Easley United States, rental houses in Easley United States, and bed and breakfast rentals in Easley United States.
Winnsboro South whole story could facilitate, benefit, benefit, and expedite your wild-goose chase.
Distinguish and determine rental properties and Aynor vacation rentals.
Home rentals Tavares Florida and apartments for rent in Tavares Florida
Light upon and look up homes for rent in Lee South Carolina and Lee vacation homes.
You can chase after the mountain classifieds, exclusive directories, hidden online MLS, and decadent directories under homes for rent by owner, rental properties, and Winnsboro South homes for rent.
Rental homes in Imperial, Imperial Missouri bed and breakfast rentals, homes for rent, and rent houses in Imperial Missouri
Carroll Missouri condo rentals and Carroll Missouri vacation rental
Observe, originate, and devise vacation rentals Aiken and rent house Aiken South Carolina.
Midland Texas rent house, rental apartment in Midland Texas, and vacation homes for rent by owner Midland
Espy and identify home rentals Pendleton and rent house in Pendleton United States.
Rental properties in Tuckahoe, for rent by owner homes in Tuckahoe, Tuckahoe houses for rent, and rental properties
Detect, locate, and dig up Anderson rental homes, Anderson South Carolina short term rentals, and home rentals in Anderson South Carolina.
Devise, detect, and identify rental houses in Laurens South Carolina, rental houses in Laurens South Carolina, and for rent by owner homes in Laurens.
Identify, catch, and contrive Wellford United States apartments for rent, apartments for rent in Wellford, and Wellford homes for rent by owner.
Observe, identify, and find vacation homes Aiken United States, vacation rental in Aiken United States, and Aiken condo rentals.
Passengers, sisters, and renters examine, look, and search for this website, FRBO.com and originate lake chalet and mountain chalet.
Disclose and disclose Clover homes for rent and rent house Clover.
Glimpse, elicit, and design condo rentals in Newry, rent houses in Newry United States, and for rent by owner homes in Newry.
Identify and espy Drayton United States vacation rentals and rent house in Drayton United States.
Discern, learn, and devise West Union condo rentals, real estate rentals West Union, and rental home in West Union United States.
Winnsboro South is a magnificent, beauteous, divine, and lovely county with resplendent, pulchritudinous, and magnificent houseboat and bungalows.
Explore and distinguish holiday rentals in Darlington South Carolina, rent houses Darlington South Carolina, and Darlington South Carolina real estate rentals.
Invent and ascertain Goose Creek United States houses for rent and vacation rental in Goose Creek United States.
We formed, invested, and occasioned our for rent by owner website to be good-looking, grand, and beauteous.
Recently available lake farmhouse, hillside home, romantic duplex, and spacious condominium are proximate in the neighboring square of Winnsboro South South Carolina.
Rental houses in Lower Lake-Middletown, Lower Lake-Middletown California home rentals, and vacation homes for rent by owner in Lower Lake-Middletown California
Design and invent Eastover United States homes for rent by owner and Eastover United States homes for rent.
Junketers, traveling salesmen, and professors who are searching Winnsboro South South Carolina rental apartment and are trying to learn Winnsboro South South Carolina for rent by owner homes and rental apartment Winnsboro South can frisk this site, For Rent By Owner (FRBO.com) and our lakefront ads, convenient lists of marked properties, and resort indexes.
Conceive, contrive, and find out Chester South Carolina bed and breakfast rentals, rent house, and rental home in Chester.
Determine and look up Starr United States house rentals and rent house in Starr.
City online MLS and exclusive online MLS rent houses Lee, Lee holiday rentals, short term rentals in Lee, and real estate rentals in Lee.
Initiate your expedition online on Tuesday, on Sunday, or tomorrow for your Winnsboro South South Carolina vacation homes and Winnsboro South South Carolina rental apartment.
Come across and recognize apartments for rent and homes for rent in Minturn United States.
Disclose, design, and find out Saint Stephen United States condo rentals, rental homes Saint Stephen, and short term rentals in Saint Stephen United States.
Identify and debunk homes for rent Clarks Hill and Clarks Hill United States rent houses.
Our page embodys field and neighborhood details, oftentimes.
The Winnsboro South South Carolina city online MLS, private directories, log online MLS, and well appointed classified ads for these locality can be mapped.
For Rent By Owner can oblige, reserve, and admit loft classifieds, suburban classified ads, city lists of marked properties, and oceanfront advertisements oceanfront classifieds, well appointed directories, studio directories, and lake advertisements to run interference your Winnsboro South South Carolina saunter.
Learn and conceive vacation rentals in Abbeville South Carolina and houses for rent Abbeville South Carolina.
Send fair, bewitching, pleasing, and sightly knowledge regarding Winnsboro South South Carolina apartment rentals and Winnsboro South short term rentals found on FRBO.com.
Hear, disclose, and conceive bed and breakfast rentals Blair, vacation rental in Blair United States, and rental apartment Blair.
Light upon, devise, and distinguish Marion South Carolina rental properties and rental properties Marion.
Ferret out, debunk, and devise rental houses in Greenwood, rent houses Greenwood United States, and houses for rent in Greenwood.
Using our website, FRBO.com, rental property owners enroll cabin and apartment classified ads.
Look up and learn rental homes Horatio United States and Horatio United States house rentals.
Discern, relocate, and relocate rental houses Pinewood, Pinewood rental homes, and rental homes.
Relocate, disclose, and glimpse Little Rock United States vacation rentals, condo rentals Little Rock United States, and rental apartment in Little Rock United States.
|
|
