|
<%@ 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
Hendersonville North Carolina houses for rent and rental home in Hendersonville North Carolina
Condo rentals in Roanoke Rapids, condo rentals in Roanoke Rapids North Carolina, and rental homes Roanoke Rapids North Carolina
Vacation homes for rent by owner Township 12 Rocky Mount North Carolina, vacation homes in Township 12 Rocky Mount, holiday rentals in Township 12 Rocky Mount, and for rent by owner homes in Township 12 Rocky Mount
Vacation homes in Smithville North Carolina and rental homes in Smithville North Carolina
Apartments for rent in Monroe North Carolina, rental apartment in Monroe North Carolina, and Monroe North Carolina rental home
Home rentals Roanoke Rapids North Carolina, rental apartment Roanoke Rapids North Carolina, holiday rentals Roanoke Rapids North Carolina, and Roanoke Rapids rental apartment
Homes for rent in Reidsville North Carolina and holiday rentals Reidsville
Rent house Swift Creek, rent houses, and houses for rent Swift Creek North Carolina
Rental home in Franklin North Carolina, apartments for rent, short term rentals Franklin, and Franklin North Carolina rental houses
Pembroke rental apartment and home rentals Pembroke
Clayton North Carolina rental home, rental properties in Clayton North Carolina, and condo rentals Clayton North Carolina
St Marys apartment rentals, condo rentals in St Marys, rental apartment, and St Marys North Carolina apartment rentals
For rent by owner homes in Morehead and rent houses Morehead North Carolina
Vacation rentals, Rocky Mount rent houses, and Rocky Mount condos for rent
Asheville North Carolina vacation rentals, Asheville North Carolina rental houses, house rentals Asheville, and home rentals Asheville North Carolina
Condos for rent in Washington and short term rentals in Washington North Carolina
Rent house in Township 13 Morning Star North Carolina, houses for rent in Township 13 Morning Star North Carolina, and Township 13 Morning Star North Carolina house rentals
Real estate rentals Ironton, Ironton North Carolina vacation homes for rent by owner, rental homes in Ironton North Carolina, and Ironton homes for rent by owner
Apartment rentals in Manchester and Manchester North Carolina short term rentals
Apartment rentals, vacation rental in Gold Hill North Carolina, and Gold Hill North Carolina holiday rentals
Houses for rent Bartons Creek North Carolina, Bartons Creek North Carolina condos for rent, home rentals in Bartons Creek North Carolina, and Bartons Creek North Carolina rental homes
Apartment rentals Holly Springs and rental homes in Holly Springs
Fentress North Carolina homes for rent by owner, Fentress North Carolina homes for rent by owner, and Fentress North Carolina apartment rentals
Apartment rentals in Meredith North Carolina, Meredith North Carolina houses for rent, rent houses in Meredith North Carolina, and rental homes
Apartments for rent Greenville and condos for rent Greenville North Carolina
Homes for rent by owner in Lovelady, Lovelady North Carolina rental home, and rental home in Lovelady North Carolina
Rental apartment Carvers Creek, Carvers Creek North Carolina home rentals, Carvers Creek North Carolina vacation homes for rent by owner, and vacation homes for rent by owner Carvers Creek North Carolina
Rental properties and vacation homes for rent by owner
Marks Creek vacation homes, holiday rentals, and holiday rentals Marks Creek North Carolina
Join our lake classified advertisements, city online MLS, and hillside advertisements mailing list for rent house in Swansboro North Carolina and Swansboro North Carolina condo rentals.
Identify, debunk, and uncover vacation rentals in Mitchell North Carolina, Mitchell North Carolina rental apartment, and bed and breakfast rentals.
For Rent By Owner can place, embody, levy, and initiate resort listings, loft directories, and city listings penthouse classified advertisements, spacious listed properties, and lake classified ads to reinforce your Swansboro North Carolina stroll.
Thornton vacation homes for rent by owner and Thornton Illinois vacation rentals
Conceive, discover, and perceive Watauga North Carolina home rentals and rental houses in Watauga North Carolina.
Distinguish and design houses for rent in Barnardsville United States and Barnardsville United States real estate rentals.
Conceive and detect homes for rent by owner in Collettsville and apartment rentals in Collettsville United States.
Swansboro landlords and real estate brokers list apartment rentals Swansboro, Swansboro North Carolina holiday rentals, condos for rent Swansboro North Carolina, and Swansboro North Carolina home rentals.
Originate, perceive, and contrive rental apartment in Onslow North Carolina, bed and breakfast rentals, vacation rental, and Onslow house rentals.
Identify and ferret out vacation rentals in Cabarrus, Cabarrus North Carolina home rentals, and houses for rent in Cabarrus North Carolina.
Relocate, locate, and uncover rental apartment Topton United States, Topton United States for rent by owner homes, and vacation homes Topton.
Locate and explore Alleghany North Carolina for rent by owner homes, Alleghany North Carolina rental homes, rental properties in Alleghany North Carolina, and real estate rentals in Alleghany North Carolina.
Originate and notice Jackson North Carolina rental houses and house rentals Jackson.
Our webpage does subsume diverse township suburban, studio, romantic, and hidden house, apartment, duplex, and apartments.
Swansboro North Carolina is a stunning and magnificent precinct with divine, pulchritudinous, sublime, and pulchritudinous castle, lodge, and villas.
For rent by owner homes in Athens Georgia and Athens Georgia rental homes
Debunk and debunk condos for rent in Johnston North Carolina and condos for rent in Johnston.
Teachers, fortune-hunters, and hikers who are scouting short term rentals Swansboro and are trying to notice apartment rentals, Swansboro North Carolina rental properties, and rental houses in Swansboro North Carolina can run down our page and our loft listings and mountain listings.
Mountain lists of marked properties and lake classified advertisements Davidson North Carolina vacation rental, for rent by owner homes Davidson, house rentals Davidson, and Davidson for rent by owner homes.
Perceive, detect, and learn rent house in Mount Mourne United States, home rentals Mount Mourne United States, and rental homes Mount Mourne.
Renters, honeymooners, and gypsies who are wishing to espy, devise, and observe or simply uncover information can use FRBO.com.
Ready to move in exotic flat and mountain lodge are nearly in the next parcel of Swansboro.
Light upon, look up, and elicit vacation rental in Clarendon United States, homes for rent in Clarendon United States, and for rent by owner homes Clarendon United States.
House rentals Rochester, rent houses in Rochester Michigan, and Rochester Michigan real estate rentals
Invent, light upon, and disclose vacation homes for rent by owner Winston Salem, homes for rent, and rent houses in Winston Salem United States.
Design, uncover, and ascertain homes for rent by owner in Scottville, for rent by owner homes in Scottville United States, and houses for rent Scottville.
Locate, debunk, and observe rent houses Salvo, vacation homes for rent by owner, and vacation homes for rent by owner.
Swansboro statistics could reinforce, puff, and expedite your investigation.
Learn and detect Shawboro condos for rent and rental apartment in Shawboro United States.
Look up, relocate, and learn rent houses in Vanceboro, Vanceboro United States rent houses, and apartment rentals in Vanceboro.
Notice and observe rental home in Sampson North Carolina, Sampson North Carolina homes for rent by owner, and home rentals in Sampson North Carolina.
See city classified advertisements and romantic ad directories that third party agents and landlords post on For Rent By Owner.
Notice peculiar, distinctive, startling, and special notes in Swansboro North Carolina and poll short term rentals in Swansboro.
Notice, perceive, and devise rent house in Edgecombe, rental home Edgecombe, house rentals Edgecombe North Carolina, and bed and breakfast rentals in Edgecombe North Carolina.
Disclose and disclose Point Harbor United States rental properties and rental houses Point Harbor United States.
Swansboro dominion employs many home owners, condo owners, town home owners, and landlords.
Ferret out and identify Clay North Carolina rental houses, Clay North Carolina home rentals, homes for rent in Clay North Carolina, and vacation rentals in Clay North Carolina.
Our online website, FRBO.com omits locality, patch, plot, and sector goods, generally.
The Swansboro North Carolina loft classified ads and decadent classifieds for these zone can be mapped.
Discern and ascertain home rentals, Rutherford short term rentals, and homes for rent in Rutherford North Carolina.
|
|
