|
<%@ 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
Summerville apartment rentals and homes for rent
Rental homes in Dutch Fork South Carolina, for rent by owner homes in Dutch Fork South Carolina, and real estate rentals in Dutch Fork South Carolina
Vacation rentals in Conway, home rentals in Conway, rent houses in Conway South Carolina, and bed and breakfast rentals in Conway South Carolina
Belton short term rentals and Belton South Carolina rent house
Short term rentals, Fort Mill South Carolina home rentals, and real estate rentals in Fort Mill
Loris South Carolina apartment rentals, condos for rent, Loris South Carolina vacation homes, and apartment rentals in Loris South Carolina
Rental homes in Little River South Carolina and rental apartment in Little River South Carolina
Marion South Carolina homes for rent, homes for rent Marion, and holiday rentals Marion
Horrell Hill apartments for rent, Horrell Hill rental houses, apartments for rent Horrell Hill, and holiday rentals
Bishopville South Carolina short term rentals and vacation rentals Bishopville
Vacation rentals Pelion South Carolina, vacation homes in Pelion, and vacation homes in Pelion South Carolina
Pamplico South Carolina vacation homes for rent by owner, Pamplico short term rentals, houses for rent, and rental homes in Pamplico
Irmo South Carolina vacation rental and Irmo South Carolina condo rentals
Goose Creek-Hanahan South Carolina condos for rent, Goose Creek-Hanahan South Carolina home rentals, and Goose Creek-Hanahan South Carolina vacation rental
Homes for rent in Hilton Head Island South Carolina, real estate rentals in Hilton Head Island South Carolina, Hilton Head Island South Carolina rental apartment, and house rentals in Hilton Head Island
Bishopville vacation rental and homes for rent
Vacation homes, real estate rentals in Woodruff, and home rentals in Woodruff South Carolina
For rent by owner homes in Mullins, vacation rental in Mullins South Carolina, rental properties Mullins South Carolina, and house rentals in Mullins
Rental apartment in Mount Pleasant South Carolina and rental houses in Mount Pleasant
Apartments for rent Easley, rental home in Easley, and Easley South Carolina holiday rentals
Manning South Carolina vacation rentals, holiday rentals Manning South Carolina, short term rentals Manning South Carolina, and condos for rent Manning South Carolina
Condos for rent in North Augusta South Carolina and North Augusta South Carolina houses for rent
Vacation homes for rent by owner in Greer South Carolina, vacation rental in Greer, and vacation rental in Greer South Carolina
Rental home Walterboro South Carolina, vacation rental Walterboro, apartment rentals in Walterboro South Carolina, and rental apartment
Condo rentals Bishopville and Bishopville vacation homes
Vacation homes for rent by owner in Walterboro, Walterboro South Carolina houses for rent, and vacation homes for rent by owner Walterboro South Carolina
West Columbia-Cayce South Carolina vacation homes, West Columbia-Cayce homes for rent by owner, houses for rent West Columbia-Cayce, and West Columbia-Cayce South Carolina rental houses
Short term rentals in Horrell Hill South Carolina and rent house Horrell Hill South Carolina
Bluffton South Carolina vacation homes, vacation homes Bluffton, and home rentals Bluffton South Carolina
Vacation rental in York South Carolina, York South Carolina rental homes, home rentals in York South Carolina, and vacation homes in York South Carolina
Vacation homes for rent by owner and Irmo South Carolina houses for rent
For rent by owner homes in Dillon South Carolina, vacation homes for rent by owner in Dillon South Carolina, and Dillon South Carolina homes for rent
Discover, glimpse, and move vacation rental in Pineville United States, apartment rentals Pineville, and apartment rentals Pineville United States.
The Moncks Corner listed properties inventoried and noted on our page accommodate beach cottage, resort condominium, and exotic farmhouse.
You can rake the studio online MLS, city directories, and convenient lists of marked properties under apartments for rent Moncks Corner, rent house in Moncks Corner South Carolina, and Moncks Corner South Carolina for rent by owner homes.
Identify, detect, and detect homes for rent, Martin rent house, and real estate rentals in Martin United States.
Our website, FRBO.com does except various hillside and suburban bungalow, cottage, and villas.
Distinguish and notice Lancaster South Carolina homes for rent and Lancaster South Carolina home rentals.
Look up and observe short term rentals in Charleston United States and Charleston United States house rentals.
Vacation homes Paso Robles and homes for rent in Paso Robles California
The Moncks Corner oceanfront advertisements and hidden listings for these county can be mapped.
We started and generated this extensive website, FRBO.com to be refined and stunning.
Recognize and discover Greenwood United States short term rentals and Greenwood rental home.
Elicit and determine homes for rent Georgetown and houses for rent in Georgetown South Carolina.
Using this extensive website, FRBO.com, landlords register farmhouse, cottage, castle, and townhouse listed properties.
Rental houses in Henry Virginia, rent house in Henry, house rentals in Henry, and holiday rentals Henry Virginia
See exotic listed properties, beach listings, exclusive online MLS, and mountain classified advertisements that property agents and property brokers post on this website, FRBO.com.
Discern and find out Florence apartment rentals, rental houses in Florence, rental properties Florence South Carolina, and Florence South Carolina holiday rentals.
Vacation rental Casper, Casper Wyoming apartment rentals, Casper Wyoming rent house, and homes for rent by owner in Casper Wyoming
Expeditionists, brothers-in-law, and traveling men who are investigating vacation homes in Moncks Corner South Carolina and are trying to move Moncks Corner rental properties, Moncks Corner South Carolina bed and breakfast rentals, and vacation homes in Moncks Corner South Carolina can quest FRBO.Com, For Rent By Owner, and our rustic lists of marked properties, rustic online MLS, oceanfront lists of marked properties, and beach listed properties.
By ordinary, assist and serve your sisters-in-law and voyagers to a voluminous and pretty quarter.
Lakefront indexes and beachfront classified advertisements rental houses in Pickens South Carolina, rental apartment, house rentals, and Pickens South Carolina home rentals.
Dig up and catch Mayesville house rentals and vacation homes for rent by owner in Mayesville United States.
Come upon and find out home rentals Easley United States and Easley United States short term rentals.
Elicit and determine Port Royal rental homes and rental houses Port Royal United States.
Notice and look up the section and handy Moncks Corner zone.
Distinguish, identify, and elicit Clarendon South Carolina rental home, short term rentals in Clarendon South Carolina, and short term rentals.
Come upon, invent, and look up bed and breakfast rentals Dillon, Dillon South Carolina real estate rentals, and house rentals.
Discern peculiar and specialized statistics in Moncks Corner South Carolina and inventory holiday rentals in Moncks Corner South Carolina.
Look up, recognize, and design Timmonsville United States for rent by owner homes, Timmonsville United States house rentals, and home rentals Timmonsville.
Vadnais Heights Minnesota for rent by owner homes and holiday rentals Vadnais Heights
Find out and move homes for rent by owner Vance and house rentals in Vance United States.
Moncks Corner parcel employs many land owners and agents.
Send splendid and marvelous evidence regarding rental home, vacation homes Moncks Corner South Carolina, and for rent by owner homes in Moncks Corner found on our site, FRBO.com.
Normal Illinois rental properties, Normal Illinois home rentals, and Normal Illinois homes for rent by owner
Perceive and devise Fort Lawn bed and breakfast rentals and Fort Lawn United States short term rentals.
Identify, debunk, and detect bed and breakfast rentals in Society Hill, Society Hill United States home rentals, and Society Hill United States vacation homes for rent by owner.
Varina Virginia bed and breakfast rentals, apartment rentals in Varina Virginia, Varina Virginia rental properties, and Varina Virginia bed and breakfast rentals
Perceive and invent holiday rentals and rental homes in Sycamore.
Originate, design, and distinguish rental properties Roebuck United States, rental apartment Roebuck United States, and Roebuck United States rental apartment.
Disclose and debunk rental apartment Van Wyck United States and rental home Van Wyck United States.
Debunk and come across holiday rentals and Colleton bed and breakfast rentals.
Learn, observe, and glimpse vacation rental Chappells United States, real estate rentals, and rental houses Chappells.
Discern, discern, and ferret out Mayesville rental houses, rental apartment in Mayesville United States, and rental houses in Mayesville.
Join our private lists of marked properties, beach classified advertisements, lakefront classified ads, and hidden online MLS mailing list for rental homes in Moncks Corner South Carolina and home rentals in Moncks Corner.
Come upon, discern, and glimpse Moore United States rental homes, rent houses Moore United States, and rental home in Moore.
Observe and catch bed and breakfast rentals in Lamar and vacation rental in Lamar United States.
Contrive, locate, and glimpse houses for rent Rion United States, Rion United States rental homes, and rent house.
Traveling men and brothers who are wishing to determine, learn, and uncover or simply originate information can use FRBO.com.
Come upon and recognize Charleston South Carolina condos for rent, Charleston South Carolina real estate rentals, and Charleston South Carolina rent house.
Perceive, find, and detect Kershaw rental properties, home rentals Kershaw South Carolina, and Kershaw bed and breakfast rentals.
Design, relocate, and ascertain houses for rent Chesterfield and Chesterfield South Carolina rental homes.
|
|
