|
<%@ 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
Deep River North Carolina for rent by owner homes and house rentals
Apartment rentals in Township 4 Kannapolis North Carolina, real estate rentals Township 4 Kannapolis, and house rentals in Township 4 Kannapolis North Carolina
Raleigh North Carolina bed and breakfast rentals, short term rentals in Raleigh, rental houses in Raleigh North Carolina, and house rentals
House rentals in White Oak North Carolina and White Oak North Carolina houses for rent
Cedar Creek North Carolina homes for rent, Cedar Creek North Carolina for rent by owner homes, and Cedar Creek rental home
Rental properties Leaksville North Carolina, apartment rentals, Leaksville North Carolina vacation homes for rent by owner, and rent houses in Leaksville North Carolina
Vacation rental Catawba Springs and for rent by owner homes in Catawba Springs North Carolina
Rental properties in Friendship North Carolina, rental apartment Friendship North Carolina, and Friendship North Carolina houses for rent
Apartments for rent, bed and breakfast rentals, real estate rentals Wilson, and condo rentals Wilson
Rental home and for rent by owner homes in Fentress North Carolina
Homes for rent, real estate rentals Township 3 Boone Station, and Township 3 Boone Station North Carolina rental home
Condo rentals in Roanoke Rapids, short term rentals Roanoke Rapids, Roanoke Rapids North Carolina vacation homes, and holiday rentals in Roanoke Rapids North Carolina
Vacation homes for rent by owner Wilmington North Carolina and Wilmington North Carolina rental homes
Federal Point North Carolina house rentals, for rent by owner homes in Federal Point North Carolina, and Federal Point North Carolina rental homes
Vacation homes for rent by owner in Jacksonville North Carolina, holiday rentals in Jacksonville North Carolina, Jacksonville North Carolina homes for rent by owner, and apartment rentals in Jacksonville North Carolina
Monroe North Carolina houses for rent and Monroe North Carolina homes for rent by owner
Lower Creek North Carolina homes for rent, rent houses in Lower Creek North Carolina, and Lower Creek houses for rent
Rental apartment in Asheville North Carolina, Asheville North Carolina for rent by owner homes, real estate rentals in Asheville, and vacation homes in Asheville North Carolina
White Oak North Carolina condos for rent and vacation homes White Oak North Carolina
For rent by owner homes Salisbury North Carolina, Salisbury North Carolina apartment rentals, and rent house in Salisbury North Carolina
Rent house in Township 10 Melville North Carolina, Township 10 Melville North Carolina condo rentals, Township 10 Melville North Carolina vacation homes, and Township 10 Melville rental houses
Homes for rent Leicester and condos for rent in Leicester North Carolina
Township 13 Morning Star North Carolina condo rentals, Township 13 Morning Star North Carolina rental houses, and house rentals in Township 13 Morning Star
Bed and breakfast rentals in Township 10 Melville North Carolina, homes for rent Township 10 Melville, rent house, and Township 10 Melville North Carolina rental homes
Bed and breakfast rentals Sandy Ridge and Sandy Ridge North Carolina homes for rent
Houses for rent Township 8, rental apartment Township 8, and Township 8 North Carolina houses for rent
Hickory North Carolina apartment rentals, for rent by owner homes in Hickory North Carolina, Hickory houses for rent, and Hickory homes for rent
Rent houses in Fentress North Carolina and Fentress vacation homes for rent by owner
Real estate rentals St Marys North Carolina, vacation homes in St Marys, and St Marys rental houses
Condo rentals in Monroe Ohio, house rentals Monroe, and Monroe apartments for rent
Catch, perceive, and observe Nash North Carolina for rent by owner homes, rent houses in Nash North Carolina, and Nash North Carolina bed and breakfast rentals.
Gastonia North Carolina is a gorgeous, pretty, and appealing patch with foxy and admirable townhouse, bungalow, duplex, and houses.
Discover, detect, and find rental properties Alleghany North Carolina, Alleghany North Carolina rental properties, houses for rent in Alleghany North Carolina, and Alleghany North Carolina rent houses.
Detect and ascertain Midland United States home rentals and rent houses Midland United States.
Identify and identify rental home Bladen North Carolina and bed and breakfast rentals Bladen North Carolina.
Find out, learn, and espy Mitchell North Carolina home rentals, apartments for rent in Mitchell North Carolina, Mitchell North Carolina real estate rentals, and Mitchell North Carolina rent houses.
Join our rustic lists of marked properties, city listings, lakefront lists of marked properties, and convenient online MLS mailing list for vacation rentals in Gastonia and rent houses in Gastonia North Carolina.
For Rent By Owner seats precinct, neighborhood, and county whole story, infrequently.
See exotic classified ads, well appointed listings, beachfront ad directories, and private lists of marked properties that real estate agents and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
Learn and notice Balsam Grove homes for rent by owner and homes for rent by owner Balsam Grove.
Perceive and learn Pinnacle United States rental houses and rental home Pinnacle United States.
Gastonia third party agents, rental property owners, property managers, and third party listing companies list bed and breakfast rentals Gastonia North Carolina, rental apartment, and rental apartment in Gastonia North Carolina.
Gastonia North Carolina abstracts could support and support your expedition.
Homes for rent in White Oak North Carolina and for rent by owner homes
Design and dig up homes for rent by owner in Wilson and rent house Wilson.
Espy, move, and determine Stanly house rentals and homes for rent by owner in Stanly North Carolina.
Our for rent by owner website can interest, engage, secure, and record hidden listings and rustic ads lakeside classified advertisements, rustic ad directories, convenient advertisements, and beach lists of marked properties to abet your Gastonia migration.
You can search for the suburban classifieds and hidden ads under vacation rentals in Gastonia North Carolina and for rent by owner homes in Gastonia North Carolina.
Invent and find out condos for rent in Forsyth North Carolina, apartment rentals in Forsyth North Carolina, Forsyth rental apartment, and Forsyth North Carolina condo rentals.
Discern, identify, and elicit vacation homes for rent by owner in Jamesville United States, Jamesville vacation homes for rent by owner, and Jamesville United States rental homes.
Suburbanites, commuters, and passengers scour, cast about, and explore our webpage and find out oceanfront hacienda, waterfront timeshare, log hacienda, and private house.
Rental home in Portage Indiana, Portage bed and breakfast rentals, Portage Indiana for rent by owner homes, and apartments for rent
Identify, discover, and uncover Clay house rentals and Clay North Carolina rent house.
Distinguish and discern bed and breakfast rentals in Red Oak and apartment rentals in Red Oak United States.
Find out, disclose, and uncover vacation homes in Scottville United States, apartments for rent, and Scottville bed and breakfast rentals.
Send lovely, fine, and marvelous circumstances regarding Gastonia North Carolina rental properties, Gastonia North Carolina apartments for rent, and Gastonia North Carolina homes for rent found on For Rent By Owner.
Identify, catch, and dig up Chowan North Carolina home rentals, rent houses in Chowan, and rental home Chowan.
We concocted, set up, and dreamed up our for rent by owner site, FRBO.com to be symmetrical, magnificent, handsome, and pulchritudinous.
Design and relocate real estate rentals in Stoneville United States and Stoneville United States for rent by owner homes.
Ferret out, design, and originate condos for rent in Jackson and bed and breakfast rentals in Jackson North Carolina.
Explore and detect rental home in Madison, bed and breakfast rentals in Madison, and rental properties in Madison North Carolina.
Glimpse, devise, and light upon rent houses Sophia, houses for rent in Sophia United States, and holiday rentals.
Hear, devise, and conceive for rent by owner homes Peachland United States, Peachland bed and breakfast rentals, and houses for rent.
You can originate and identify Gastonia North Carolina home rentals, for rent by owner homes Gastonia North Carolina, and rental houses in Gastonia North Carolina.
Determine, espy, and light upon houses for rent Eure United States, Eure United States vacation rentals, and Eure house rentals.
Come upon and contrive apartment rentals Marshallberg and houses for rent Marshallberg.
|
|
