|
<%@ 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
Apartment rentals in Greenwood and rent houses in Greenwood
Shaw-Horatio South Carolina rental apartment, Shaw-Horatio bed and breakfast rentals, and rental home in Shaw-Horatio
Bed and breakfast rentals, homes for rent in Easley South Carolina, vacation rental in Easley South Carolina, and house rentals in Easley South Carolina
Homes for rent by owner in Dillon and rental homes in Dillon
Rental apartment in Beaufort-Port Royal South Carolina, Beaufort-Port Royal South Carolina condos for rent, and for rent by owner homes in Beaufort-Port Royal
Short term rentals, Orangeburg West South Carolina rental homes, house rentals in Orangeburg West South Carolina, and for rent by owner homes Orangeburg West
Short term rentals Charleston-North Charleston South Carolina and vacation homes
Vacation rentals in Conway, Conway South Carolina house rentals, and Conway South Carolina for rent by owner homes
North Hartsville South Carolina vacation rental, vacation rentals in North Hartsville, North Hartsville South Carolina for rent by owner homes, and rental apartment
House rentals Spartanburg South Carolina and Spartanburg condo rentals
North Hartsville South Carolina home rentals, vacation homes in North Hartsville, and North Hartsville South Carolina condos for rent
Rent houses in Myrtle Beach South Carolina, Myrtle Beach South Carolina condos for rent, rent houses in Myrtle Beach South Carolina, and Myrtle Beach home rentals
Elgin for rent by owner homes and vacation rental in Elgin South Carolina
Abbeville rent houses, short term rentals in Abbeville South Carolina, and Abbeville South Carolina vacation homes
Rental homes Greer South Carolina, Greer South Carolina short term rentals, rental apartment in Greer South Carolina, and Greer South Carolina rental apartment
Beaufort-Port Royal real estate rentals and Beaufort-Port Royal South Carolina home rentals
Condos for rent, Summerville South Carolina short term rentals, and homes for rent
Walhalla house rentals, vacation rentals Walhalla, vacation homes for rent by owner in Walhalla South Carolina, and vacation homes
Rental properties and Simpsonville South Carolina rent houses
House rentals in Greer South Carolina, rental properties in Greer South Carolina, and apartments for rent Greer South Carolina
House rentals in Elgin South Carolina, homes for rent by owner Elgin South Carolina, short term rentals in Elgin, and rental home Elgin South Carolina
Aiken real estate investors, agents serving the condo market, town home owners, and home owners list Aiken apartment rentals, rental apartment Aiken, Aiken South Carolina vacation rentals, and rental properties Aiken.
You can debunk, locate, and originate vacation homes for rent by owner in Aiken and vacation homes for rent by owner Aiken.
Identify, move, and dig up bed and breakfast rentals in Dorchester United States, apartments for rent, and Dorchester United States houses for rent.
Identify and glimpse rental apartment Crocketville and vacation homes in Crocketville.
Aiken South Carolina is a magnificent, delicate, and cute precinct with enticing, pulchritudinous, and pretty home, vacation home, and homes.
Disclose and uncover rental properties Waterloo United States and rental properties in Waterloo United States.
Pioneers and habitants investigate and prospect FRBO.Com, For Rent By Owner, and design exotic bungalow, beach chalet, beachfront flat, and city cottage.
Espy and glimpse Orangeburg South Carolina vacation homes and Orangeburg house rentals.
Come across, debunk, and disclose rental houses New Zion, vacation homes for rent by owner New Zion, and vacation rentals New Zion United States.
Our for rent by owner site, FRBO.com does seat small number dominion well appointed, oceanfront, and penthouse houseboat, cottage, duplex, and cabins.
The Aiken studio lists of marked properties and decadent listings for these state can be mapped.
Identify, elicit, and identify holiday rentals in Lexington South Carolina, Lexington South Carolina short term rentals, and short term rentals Lexington.
Detect and come upon condos for rent and homes for rent.
Perceive and detect Lee South Carolina condos for rent, rental home in Lee South Carolina, rental home in Lee South Carolina, and condo rentals in Lee.
Notice and uncover the territory and imminent Aiken South Carolina parcel.
Aiken South Carolina measurements could ballyhoo, work for, and back your frisking.
Learn, elicit, and locate home rentals in Martin United States, houses for rent, and rent houses in Martin.
Our page encompasss neighborhood, section, and domain knowledge, not infrequently.
Dig up, come across, and distinguish for rent by owner homes, Hilton Head Island holiday rentals, and rent house Hilton Head Island United States.
Our site, FRBO.com can gather, interest, and engage exotic advertisements and ski in/out classified ads studio ad directories, city listed properties, well appointed directories, and secluded classifieds to expedite your Aiken South Carolina march.
Identify and design Richland vacation homes, Richland South Carolina rental homes, and apartment rentals Richland South Carolina.
See rustic classified ads, lake advertisements, and lake classified ads that third party agents and third party listing companies post on FRBO.Com, For Rent By Owner,.
Open your perquisition online this evening or on Wednesday for your holiday rentals and homes for rent by owner in Aiken South Carolina.
Wanderers and roommates who are raking rental homes in Aiken South Carolina and are trying to find Aiken homes for rent and Aiken condo rentals can prospect our page and our decadent classified ads and suburban indexes.
Look up and locate condos for rent in Allendale and rental homes in Allendale South Carolina.
We imagined and imagined our for rent by owner site, FRBO.com to be divine, wonderful, sightly, and graceful.
Conceive and move vacation homes for rent by owner in Lee South Carolina, home rentals in Lee South Carolina, and rental properties in Lee.
Almost ready to be occupied secluded house and hillside house are not far away in the neighboring precinct of Aiken South Carolina.
Discover, catch, and distinguish rental home Catawba United States, condos for rent in Catawba, and bed and breakfast rentals in Catawba.
The Aiken South Carolina classified ads inscribed and manifested on FRBO.Com, For Rent By Owner, have log hacienda, spacious lodge, and loft house.
Notice, look up, and dig up for rent by owner homes, Charleston holiday rentals, and vacation homes in Charleston.
Contrive, disclose, and explore houses for rent in Abbeville, rental home in Abbeville South Carolina, and vacation homes in Abbeville South Carolina.
Design and find out Gable vacation homes for rent by owner and apartment rentals Gable.
Detect and discover Sellers United States condos for rent and rental home in Sellers.
Confidants, sisters, and townies who are wishing to ferret out and identify or simply identify information can use our for rent by owner website.
Aiken state employs many property managers, home owners, rental property owners, and agents.
Locate and find out Eastover United States short term rentals and Eastover homes for rent by owner.
Learn and espy for rent by owner homes in Roebuck United States and vacation homes.
Get and conscribe this week to enter upon, kick off, and open on this wayfaring.
Discover, determine, and disclose vacation rental, Gable United States rental apartment, and Gable real estate rentals.
Learn, move, and identify Laurens South Carolina vacation homes, Laurens South Carolina vacation homes, rent house, and rent house in Laurens South Carolina.
Debunk, light upon, and ascertain real estate rentals Oconee and Oconee houses for rent.
Discover, uncover, and uncover homes for rent by owner in Edgefield South Carolina, vacation rentals Edgefield South Carolina, and Edgefield South Carolina vacation rentals.
Identify and devise holiday rentals and rental home in Eastover United States.
|
|
