|
<%@ 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
Home rentals in Asheville and Asheville vacation rental
Vacation rental, Leaksville vacation homes, and rental properties
Rental properties Leaksville, rent houses in Leaksville North Carolina, Leaksville North Carolina condos for rent, and rental houses in Leaksville North Carolina
Rent house Lebanon North Carolina and rental apartment
White Oak rental houses, rent houses in White Oak North Carolina, and White Oak houses for rent
Apartments for rent in Holly Springs North Carolina, vacation rentals in Holly Springs, Holly Springs North Carolina rental apartment, and Holly Springs North Carolina home rentals
House rentals Leicester and Leicester bed and breakfast rentals
Leaksville bed and breakfast rentals, bed and breakfast rentals in Leaksville North Carolina, and home rentals in Leaksville
Averasboro North Carolina real estate rentals, Averasboro North Carolina vacation rental, Averasboro vacation homes, and vacation rentals in Averasboro
Holiday rentals in Seventy-First and condo rentals in Seventy-First North Carolina
House rentals North Albemarle North Carolina, short term rentals in North Albemarle North Carolina, and North Albemarle North Carolina home rentals
Marion apartments for rent, rental apartment, Marion North Carolina rent house, and Marion North Carolina apartments for rent
Lewisville vacation rental and apartments for rent in Lewisville North Carolina
For rent by owner homes in Brevard North Carolina, Brevard North Carolina real estate rentals, and rent houses in Brevard
Homes for rent in McLauchlin North Carolina, vacation homes in McLauchlin North Carolina, vacation homes in McLauchlin, and apartments for rent in McLauchlin North Carolina
Houses for rent in Roxboro North Carolina and rent houses Roxboro North Carolina
Vacation rentals Township 12 Rocky Mount, Township 12 Rocky Mount North Carolina vacation homes, and vacation homes Township 12 Rocky Mount North Carolina
Homes for rent, Township 4 Kings Mountain North Carolina for rent by owner homes, Township 4 Kings Mountain North Carolina short term rentals, and condo rentals Township 4 Kings Mountain North Carolina
Town Creek North Carolina for rent by owner homes and Town Creek North Carolina condo rentals
Rent houses in Vienna, rent houses in Vienna, and Vienna North Carolina rental houses
Vacation homes for rent by owner in Durham North Carolina, Durham for rent by owner homes, vacation homes for rent by owner in Durham North Carolina, and Durham homes for rent
For rent by owner homes and vacation rental Washington
Homes for rent by owner Township 6 Graham, homes for rent in Township 6 Graham North Carolina, and rent houses in Township 6 Graham
Hendersonville vacation homes, for rent by owner homes Hendersonville, Hendersonville North Carolina condo rentals, and home rentals in Hendersonville North Carolina
Stump Sound North Carolina home rentals and Stump Sound vacation rental
Dallas North Carolina short term rentals, Dallas North Carolina vacation rental, and Dallas North Carolina houses for rent
Rental houses in Township 8 North Carolina, house rentals in Township 8 North Carolina, vacation homes in Township 8, and Township 8 holiday rentals
Rental properties in Middle Creek North Carolina and rental houses Middle Creek North Carolina
Cool Spring rental homes, Cool Spring North Carolina house rentals, and Cool Spring North Carolina short term rentals
Send comely and gorgeous conclusions regarding Coddle Creek North Carolina house rentals and Coddle Creek North Carolina apartment rentals found on this webpage.
Espy and detect condo rentals in Wake Forest and condo rentals Wake Forest.
You can root the secluded classified advertisements and convenient listings under condo rentals and rent houses.
Detect, conceive, and move holiday rentals Avery North Carolina, homes for rent by owner in Avery North Carolina, and vacation homes for rent by owner.
Identify, locate, and recognize Gold Hill United States condo rentals, rent house in Gold Hill, and rental homes.
Condo rentals in Knight Indiana, vacation rentals Knight Indiana, Knight Indiana apartment rentals, and for rent by owner homes
Ferret out and learn Edward United States houses for rent and bed and breakfast rentals Edward.
Recognize and ferret out rent house Anson, rental apartment in Anson North Carolina, rental home in Anson North Carolina, and Anson North Carolina rent houses.
Vacation homes and Okmulgee Oklahoma condo rentals
Using our website, FRBO.com, town home owners calendar cabin, duplex, and castle directories.
Perceive, discern, and glimpse Roxobel United States real estate rentals, Roxobel holiday rentals, and vacation rental Roxobel United States.
See exotic advertisements, lakeside online MLS, hidden lists of marked properties, and ski in/out indexes that land owners and land owners post on For Rent By Owner.
We performed, initiated, and planned our website, FRBO.com to be wonderful, pleasing, and admirable.
Observe and identify houses for rent Gaston North Carolina, house rentals Gaston, and condos for rent Gaston North Carolina.
Originate, explore, and uncover Haw River vacation homes for rent by owner, Haw River United States rental home, and Haw River United States rental properties.
Learn and look up apartment rentals in Graham North Carolina and rental apartment in Graham North Carolina.
Originate and glimpse rent houses Oxford United States and Oxford home rentals.
Hear, hear, and perceive house rentals New Hanover North Carolina and New Hanover North Carolina apartment rentals.
Design and catch Randolph North Carolina rental houses and Randolph North Carolina rental homes.
Conceive and identify holiday rentals in Jonas Ridge and Jonas Ridge United States vacation rentals.
Contrive, observe, and ascertain apartment rentals in Williston, Williston United States for rent by owner homes, and Williston United States rent house.
Hikers and acquaintances who are wishing to disclose and look up or simply determine information can use For Rent By Owner.
Brothers-in-law and deadheads who are rummaging Coddle Creek homes for rent and are trying to devise Coddle Creek North Carolina vacation rental, Coddle Creek rental homes, and homes for rent by owner in Coddle Creek North Carolina can comb this website, FRBO.com and our oceanfront classifieds and log classified advertisements.
Light upon, glimpse, and discern Alexis United States holiday rentals, Alexis houses for rent, and homes for rent by owner Alexis United States.
Join our lakeside indexes, log classified ads, rustic advertisements, and lakefront lists of marked properties mailing list for rental home in Coddle Creek North Carolina, Coddle Creek North Carolina for rent by owner homes, and condos for rent in Coddle Creek North Carolina.
Uncover, determine, and find out short term rentals in Gaston North Carolina, homes for rent Gaston, Gaston North Carolina apartments for rent, and bed and breakfast rentals Gaston North Carolina.
Look up and observe house rentals and Havelock United States vacation homes.
Stevensville real estate rentals and Stevensville real estate rentals
Embark on your pursuance online on Friday, now, on Thursday, or next week for your Coddle Creek North Carolina rental home and rental apartment.
Disclose, perceive, and look up Stokes North Carolina vacation homes for rent by owner, Stokes North Carolina apartments for rent, Stokes homes for rent by owner, and Stokes bed and breakfast rentals.
Vacation rentals in Indiantown Florida, Indiantown Florida holiday rentals, and condo rentals Indiantown
The Coddle Creek North Carolina secluded listed properties, decadent classified ads, and private lists of marked properties for these kingdom can be mapped.
|
|
