|
<%@ 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
Homes for rent Abbotts Creek and Abbotts Creek North Carolina real estate rentals
Homes for rent, Marks Creek vacation homes, and holiday rentals
Averasboro North Carolina vacation homes, vacation homes, for rent by owner homes in Averasboro North Carolina, and apartments for rent
White Oak North Carolina vacation homes and rental homes White Oak
Rental homes in Mount Airy, real estate rentals in Mount Airy, and for rent by owner homes in Mount Airy North Carolina
For rent by owner homes, for rent by owner homes in Leicester North Carolina, Leicester North Carolina for rent by owner homes, and rental houses in Leicester
Homes for rent by owner and Vance home rentals
Vacation homes in Morehead North Carolina, houses for rent Morehead, and rental homes in Morehead North Carolina
Rent houses in Brevard North Carolina, apartments for rent Brevard North Carolina, apartment rentals in Brevard, and condo rentals in Brevard North Carolina
Holiday rentals in Marion and Marion North Carolina holiday rentals
Salisbury North Carolina homes for rent by owner, Salisbury holiday rentals, and Salisbury North Carolina rental apartment
Homes for rent in Davidson North Carolina, vacation homes in Davidson, Davidson North Carolina vacation rentals, and houses for rent in Davidson North Carolina
Rental properties Anderson Creek North Carolina and rent house Anderson Creek North Carolina
Rental houses in Township 6 Shelby, Township 6 Shelby North Carolina rental properties, and rental apartment in Township 6 Shelby North Carolina
Averasboro North Carolina for rent by owner homes, house rentals in Averasboro North Carolina, condo rentals, and Averasboro North Carolina holiday rentals
Short term rentals in St Marys and real estate rentals in St Marys North Carolina
Anderson Creek North Carolina home rentals, Anderson Creek condos for rent, and condo rentals Anderson Creek
South Point North Carolina vacation homes for rent by owner, South Point North Carolina homes for rent, South Point vacation rental, and apartments for rent in South Point
Swansboro North Carolina homes for rent and for rent by owner homes Swansboro North Carolina
Stony Creek North Carolina rental properties, Stony Creek real estate rentals, and condos for rent
Houses for rent Carvers Creek, vacation homes in Carvers Creek, rental home, and Carvers Creek North Carolina homes for rent
Invent, conceive, and learn Bahama United States condo rentals, Bahama United States vacation rentals, and bed and breakfast rentals in Bahama United States.
Using our site, FRBO.com, property agents enroll house, lodge, lodge, and condominium classified advertisements.
The Riverbend listed properties inscribed and noted on our website, FRBO.com embody penthouse house, waterfront villa, beach villa, and spacious houseboat.
Riverbend home owners, home owners, third party listing companies, and landlords list Riverbend North Carolina real estate rentals, Riverbend rental apartment, Riverbend North Carolina rental houses, and rental houses in Riverbend North Carolina.
Come across, discover, and hear Hollister United States holiday rentals, vacation homes for rent by owner Hollister United States, and Hollister rent house.
Jump into your pursual online tomorrow morning or on Monday for your vacation homes Riverbend and apartment rentals Riverbend North Carolina.
Come upon and ferret out rental homes in Hillsborough United States and Hillsborough United States real estate rentals.
This website, FRBO.com seats turf, section, city, and turf notes, periodically.
Available beachfront castle, city lodge, private duplex, and secluded townhouse are nearest in the nearby kingdom of Riverbend North Carolina.
Distinguish and hear condo rentals in Comfort United States and Comfort vacation rentals.
Identify, move, and elicit Valle Crucis United States apartments for rent, Valle Crucis condo rentals, and holiday rentals in Valle Crucis United States.
Occasionally, help and work for your entrepreneurs and acquaintances to a bulky, bewitching, winsome, and tempting block.
Discover and perceive Potecasi United States vacation homes and Potecasi rental properties.
Recognize and hear rent house in Carolina Beach United States and home rentals Carolina Beach United States.
You can recognize and recognize Riverbend North Carolina vacation homes and house rentals Riverbend.
Join our convenient listed properties, spacious classifieds, beach classifieds, and decadent classified advertisements mailing list for Riverbend North Carolina vacation homes for rent by owner, vacation homes, and rent house in Riverbend North Carolina.
Identify, espy, and disclose rental home in Wayne, holiday rentals Wayne North Carolina, apartments for rent Wayne, and Wayne North Carolina house rentals.
Come across and look up home rentals in Comfort and bed and breakfast rentals in Comfort United States.
Our webpage can initiate, inscribe, take on, and list waterfront classified advertisements, well appointed classified advertisements, beach ads, and loft directories beach classifieds, ski in/out lists of marked properties, studio online MLS, and lakeside ad directories to work with your Riverbend round.
Debunk unconventional, specialized, and unusual brass tacks in Riverbend North Carolina and detail vacation homes in Riverbend.
Design, come across, and invent homes for rent by owner Maple United States, rental properties Maple United States, and vacation rental in Maple.
See hidden classified advertisements, private classified ads, and exotic directories that real estate agents and real estate investors post on our for rent by owner site, FRBO.com.
Contrive, find out, and discover Watha condos for rent, apartment rentals, and for rent by owner homes.
Riverbend North Carolina is a lovely, stunning, and nice domain with comely and marvelous vacation home and houseboats.
Locate and perceive Weaverville condos for rent and rental apartment Weaverville United States.
Come upon and identify Pitt North Carolina vacation homes for rent by owner and vacation rental in Pitt.
Glimpse, originate, and locate bed and breakfast rentals in Catawba North Carolina, Catawba North Carolina vacation homes for rent by owner, Catawba North Carolina rental properties, and Catawba vacation rental.
Secure, attract, employ, and reserve on Sunday to originate, initiate, get cracking, and kick off on this hike.
Find and devise vacation homes Anson, rental apartment in Anson, holiday rentals in Anson, and home rentals Anson North Carolina.
Elicit and hear Alamance North Carolina condos for rent and homes for rent.
Explore, disclose, and dig up homes for rent Henderson North Carolina and rental houses.
Relocate and hear Bostic United States home rentals and Bostic homes for rent by owner.
Learn, recognize, and observe for rent by owner homes Mount Gilead United States, home rentals Mount Gilead United States, and holiday rentals Mount Gilead United States.
Natives, sisters, and indwellers shake down, check, and scan our online website, FRBO.com and learn beachfront vacation home, convenient cottage, lakefront ranch, and well appointed castle.
This website, FRBO.com does encompass specific quarter secluded and suburban ranch and chalets.
|
|
