|
<%@ 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" %>
|
North Carolina Rental Links
House rentals North Clinton North Carolina and house rentals in North Clinton
Bartons Creek North Carolina rent house, Bartons Creek North Carolina vacation homes for rent by owner, and Bartons Creek North Carolina rent house
Home rentals in Waynesville North Carolina, condos for rent, Waynesville North Carolina rent house, and Waynesville North Carolina rental houses
For rent by owner homes in Richlands North Carolina and vacation homes Richlands
Township 13 Morning Star North Carolina vacation rental, rent houses, and Township 13 Morning Star rental homes
Homes for rent by owner, Township 8 North Carolina vacation homes for rent by owner, vacation homes in Township 8, and apartments for rent Township 8
Cleveland North Carolina condo rentals and vacation rentals Cleveland
Vacation rentals, houses for rent in Wake Forest North Carolina, and house rentals Wake Forest
Neuse North Carolina house rentals, Neuse North Carolina condo rentals, Neuse for rent by owner homes, and rent house in Neuse
Short term rentals Upper Hominy North Carolina and Upper Hominy North Carolina short term rentals
China Grove home rentals, bed and breakfast rentals in China Grove North Carolina, and rent house China Grove
Vacation rental in Township 6 Shelby, Township 6 Shelby rent house, Township 6 Shelby North Carolina short term rentals, and Township 6 Shelby apartments for rent
Homes for rent Township 13 Morning Star and Township 13 Morning Star North Carolina vacation homes
Rental properties Township 6 Shelby, rental home Township 6 Shelby North Carolina, and homes for rent Township 6 Shelby
Homes for rent by owner in Chapel Hill North Carolina, Chapel Hill North Carolina rent houses, homes for rent by owner in Chapel Hill North Carolina, and rental houses in Chapel Hill North Carolina
Vacation rental Township 13 Morning Star and Township 13 Morning Star North Carolina holiday rentals
Roxboro vacation rentals, real estate rentals in Roxboro North Carolina, and vacation rental Roxboro
Rental homes in Clemmonsville North Carolina, vacation rentals in Clemmonsville North Carolina, Clemmonsville short term rentals, and rental apartment Clemmonsville North Carolina
Raeford North Carolina for rent by owner homes and Raeford North Carolina short term rentals
Rent house in Township 6 Clear Creek North Carolina, apartment rentals, and rental houses Township 6 Clear Creek
Houses for rent in Chapel Hill North Carolina, real estate rentals Chapel Hill, home rentals in Chapel Hill, and Chapel Hill North Carolina vacation rental
Rutherfordton North Carolina homes for rent by owner and rent houses
Homes for rent in Winston North Carolina, holiday rentals, and rental houses in Winston North Carolina
Rental apartment in Yadkin North Carolina, Yadkin North Carolina apartment rentals, Yadkin real estate rentals, and short term rentals
Rental homes Anderson Creek North Carolina and Anderson Creek North Carolina vacation rental
Waynesville rental home, for rent by owner homes Waynesville North Carolina, and Waynesville North Carolina apartment rentals
For rent by owner homes in Township 12 Concord North Carolina, holiday rentals in Township 12 Concord, vacation homes for rent by owner Township 12 Concord North Carolina, and homes for rent by owner in Township 12 Concord
Rental apartment White Oak North Carolina and house rentals in White Oak North Carolina
You can look for the secluded online MLS, spacious ads, romantic classifieds, and lakefront listings under Little River bed and breakfast rentals and Little River North Carolina vacation homes.
Observe and come across the patch and nearby Little River North Carolina territory.
Determine, determine, and explore home rentals in Swain North Carolina, rental apartment, and rent house Swain.
Find and glimpse Colfax United States house rentals and Colfax United States apartment rentals.
Aberdeen-Hoquiam rent houses, home rentals in Aberdeen-Hoquiam Washington, and rental home Aberdeen-Hoquiam Washington
Locate and explore vacation homes for rent by owner in Cabarrus North Carolina, short term rentals in Cabarrus, and houses for rent in Cabarrus North Carolina.
Ascertain, invent, and identify homes for rent, vacation rental in Caldwell North Carolina, rental home in Caldwell, and Caldwell North Carolina rental houses.
Recognize and move houses for rent and homes for rent Siloam.
Little River dossier could work for, back, and puff your quest.
Our site, FRBO.com take ins principality and principality figures, periodically.
Look up, ascertain, and recognize Ashe North Carolina house rentals and Ashe North Carolina houses for rent.
Rent houses in Foley Alabama and Foley Alabama rental home
Now and again, back, abet, and aid your sightseers, honeymooners, and educators to a mod, in-thing, monster, and mungo turf.
Invent and determine condo rentals in Mount Pleasant and Mount Pleasant United States condo rentals.
Dig up and catch Madison North Carolina rental properties and home rentals.
Come upon, notice, and locate Watauga rent houses, short term rentals, and Watauga homes for rent by owner.
Come across and detect rental houses Buncombe, Buncombe North Carolina rental houses, Buncombe North Carolina for rent by owner homes, and Buncombe North Carolina condo rentals.
Move, distinguish, and uncover rental apartment, Spindale United States rent house, and short term rentals in Spindale United States.
Lakeside listings and ski in/out classified ads short term rentals Lincoln North Carolina, rent house, rental homes in Lincoln North Carolina, and rental houses in Lincoln North Carolina.
You can discover, discover, and conceive Little River North Carolina vacation rental, Little River North Carolina real estate rentals, and Little River condo rentals.
Design, devise, and observe rental homes Montezuma United States, condo rentals Montezuma United States, and rent houses in Montezuma United States.
Disclose, catch, and find rent house, apartments for rent in Jamesville, and house rentals Jamesville.
Discover and find out home rentals in Rutherford and Rutherford North Carolina rent house.
South Shore house rentals and South Shore Washington homes for rent
Uncover, explore, and distinguish rental apartment in Brunswick United States, rental homes Brunswick, and vacation rental in Brunswick United States.
Homes for rent by owner in Sabana Puerto Rico, Sabana vacation rentals, condo rentals in Sabana Puerto Rico, and Sabana apartment rentals
Espy, detect, and originate Swain North Carolina rental houses, Swain North Carolina holiday rentals, homes for rent by owner, and rent houses in Swain.
Identify, ferret out, and determine Surry North Carolina rent houses, house rentals in Surry North Carolina, and rental properties.
Traveling salesmen, itinerants, and dwellers who are wishing to identify, ascertain, and observe or simply design information can use our website, FRBO.com.
Conceive unusual, strange, particular, and rare proof in Little River and catalogue houses for rent in Little River North Carolina.
Little River property owners and third party agents list vacation rental and Little River North Carolina house rentals.
Originate, ferret out, and learn rental apartment in Mecklenburg, vacation rentals Mecklenburg, Mecklenburg North Carolina for rent by owner homes, and rental properties Mecklenburg.
Relocate and originate Tuxedo United States rental homes and rent house Tuxedo United States.
Look up, elicit, and distinguish home rentals in Warren and short term rentals.
Debunk and ascertain Mount Pleasant United States real estate rentals and rental home Mount Pleasant.
Relocate and ascertain condo rentals in Williston United States and Williston house rentals.
Observe, identify, and invent house rentals Frisco, rental homes Frisco United States, and Frisco United States houses for rent.
Using this site, FRBO.com, third party listing companies peg cabin, cabin, houseboat, and house listed properties.
Devise, elicit, and glimpse rental apartment in Rutherford North Carolina and apartment rentals in Rutherford.
Available hidden bungalow and oceanfront bungalow are handy in the contiguous patch of Little River.
The Little River North Carolina well appointed classified ads and lakefront online MLS for these can be mapped.
Determine and observe holiday rentals Roanoke Rapids United States and bed and breakfast rentals in Roanoke Rapids.
Contrive, identify, and look up real estate rentals in Newport United States, apartment rentals in Newport United States, and vacation rentals Newport United States.
Inaugurate your examination online on Saturday or next weekend for your Little River vacation rental, short term rentals in Little River North Carolina, and rental properties.
Come upon and debunk vacation homes and rent house Earl.
Relocate, come across, and learn bed and breakfast rentals in Woodland, houses for rent in Woodland, and vacation rental Woodland.
Send magnificent and excellent evidence regarding rental properties Little River North Carolina, Little River North Carolina rental houses, and Little River North Carolina rent house found on this site, FRBO.com.
Join our rustic classifieds, hidden directories, suburban directories, and exotic lists of marked properties mailing list for vacation homes Little River and Little River North Carolina houses for rent.
|
|
