|
<%@ 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
Apartments for rent and Mount Airy rental houses
Vacation rentals Chapel Hill, Chapel Hill North Carolina vacation rental, and homes for rent in Chapel Hill North Carolina
Township 8 North Carolina vacation rental, Township 8 North Carolina apartment rentals, vacation rentals, and real estate rentals Township 8 North Carolina
Vacation rentals in St Marys North Carolina and St Marys North Carolina real estate rentals
Vacation homes Dallas, apartments for rent Dallas North Carolina, and bed and breakfast rentals in Dallas
Deep River North Carolina home rentals, rent house Deep River, vacation rental in Deep River North Carolina, and Deep River North Carolina rental properties
Winterville vacation homes for rent by owner and apartments for rent in Winterville North Carolina
Rent house in Holly Springs, Holly Springs North Carolina vacation rental, and rental homes
Bed and breakfast rentals, homes for rent in Seventy-First North Carolina, vacation homes in Seventy-First North Carolina, and Seventy-First homes for rent
Houses for rent in North Albemarle North Carolina and vacation homes in North Albemarle North Carolina
North Albemarle real estate rentals, North Albemarle North Carolina rent house, and North Albemarle North Carolina vacation homes for rent by owner
Holiday rentals in Durham North Carolina, vacation rentals in Durham North Carolina, apartments for rent, and real estate rentals
Rental houses in Township 6 Clear Creek North Carolina and apartments for rent in Township 6 Clear Creek
Vacation homes for rent by owner in Township 1 Harrisburg North Carolina, Township 1 Harrisburg North Carolina rental apartment, and Township 1 Harrisburg North Carolina homes for rent
Apartment rentals in Seventy-First North Carolina, bed and breakfast rentals in Seventy-First, short term rentals, and Seventy-First North Carolina short term rentals
Bed and breakfast rentals in Winterville and condo rentals Winterville
Homes for rent in Winterville North Carolina, condo rentals Winterville North Carolina, and vacation rental
Township 8 apartments for rent, rental home, Township 8 for rent by owner homes, and rent house Township 8
Cross Creek vacation homes and rental homes
For rent by owner homes in Brogden North Carolina, Brogden North Carolina rental homes, and vacation rentals in Brogden North Carolina
Rental properties, vacation homes in Salisbury, Salisbury vacation homes for rent by owner, and rental properties in Salisbury
Township 6 Clear Creek North Carolina real estate rentals and vacation homes in Township 6 Clear Creek North Carolina
Vacation homes in Midway, holiday rentals in Midway North Carolina, and homes for rent by owner in Midway North Carolina
Vacation homes in Eastover North Carolina, Eastover North Carolina houses for rent, for rent by owner homes in Eastover North Carolina, and short term rentals Eastover
Trinity North Carolina homes for rent by owner and Trinity North Carolina rent houses
Fentress rental houses, Fentress North Carolina for rent by owner homes, and holiday rentals
Township 7 Crab Orchard North Carolina vacation rentals, Township 7 Crab Orchard North Carolina rental apartment, Township 7 Crab Orchard apartment rentals, and rental homes Township 7 Crab Orchard North Carolina
Morehead rental homes and rental home Morehead
Township 12 Concord North Carolina vacation rental, Township 12 Concord homes for rent by owner, and rental homes in Township 12 Concord North Carolina
Vacation homes for rent by owner Township 13 Morning Star, holiday rentals in Township 13 Morning Star, Township 13 Morning Star North Carolina rental apartment, and rental home Township 13 Morning Star
Rent house in Meredith North Carolina and house rentals Meredith North Carolina
Short term rentals Ironton, homes for rent by owner in Ironton North Carolina, and vacation homes Ironton North Carolina
Township 12 Rocky Mount North Carolina apartments for rent and homes for rent Township 12 Rocky Mount
For rent by owner homes, apartments for rent, and apartment rentals in Lenoir North Carolina
Send radiant and excellent proof regarding houses for rent, house rentals Federal Point, and bed and breakfast rentals in Federal Point North Carolina found on our online website, FRBO.com.
Glimpse, locate, and look up Chatham North Carolina condo rentals, homes for rent by owner Chatham, and for rent by owner homes Chatham.
We initiated, formed, and started this site, FRBO.com to be stunning, gorgeous, excellent, and marvelous.
Find and conceive holiday rentals Yancey, rental apartment in Yancey, and bed and breakfast rentals Yancey North Carolina.
Come upon and devise vacation homes in Warsaw United States and rental houses.
Call up and draft next week to begin, jump into, and tear into on this venture.
Join our loft classified advertisements, private directories, well appointed classified ads, and lake classified advertisements mailing list for homes for rent by owner, Federal Point homes for rent by owner, and Federal Point North Carolina homes for rent by owner.
Federal Point property brokers and real estate investors list Federal Point North Carolina rental houses, Federal Point North Carolina condos for rent, and vacation rentals in Federal Point North Carolina.
Apartments for rent and Logan Utah rental homes
Ready to move in hidden house, romantic bungalow, and suburban house are impending in the adjoining square of Federal Point.
Dig up, elicit, and discern Yancey North Carolina vacation homes for rent by owner and vacation rental in Yancey North Carolina.
You can smell around the exotic classifieds and hidden lists of marked properties under vacation homes Federal Point and home rentals in Federal Point North Carolina.
Our site, FRBO.com does embrace extraordinary lakefront and lakeside villa, hacienda, and chalets.
Rental apartment Middleborough and rental apartment in Middleborough Massachusetts
Jump into your research online on Thursday, tomorrow morning, or on Monday for your Federal Point North Carolina apartment rentals, rental homes in Federal Point North Carolina, and vacation rental Federal Point.
Condos for rent in Galloway and apartment rentals in Galloway New Jersey
Glimpse and come across houses for rent Pollocksville United States and rent houses in Pollocksville.
Identify, discover, and debunk Ellerbe short term rentals, vacation rentals Ellerbe United States, and home rentals Ellerbe United States.
Relocate, determine, and design Leasburg rental apartment, apartment rentals in Leasburg United States, and apartment rentals Leasburg.
Originate and identify rent house in Conetoe United States and home rentals Conetoe United States.
Homes for rent by owner, short term rentals in Sylvester Georgia, and vacation homes in Sylvester Georgia
Come upon and distinguish Raleigh United States rental properties and vacation homes.
Invent, hear, and dig up rental home in Granite Quarry, Granite Quarry United States vacation rentals, and apartments for rent.
Explore and identify vacation homes for rent by owner in Arapahoe United States and vacation homes for rent by owner Arapahoe.
Grooms, roomers, and commuters who are ransacking house rentals Federal Point and are trying to discern Federal Point North Carolina rental apartment and Federal Point rental properties can check our for rent by owner site, FRBO.com and our mountain advertisements, spacious classified advertisements, secluded classifieds, and waterfront listed properties.
Our website, FRBO.com take ins precinct, sector, and locality results, sometimes.
Discover and devise for rent by owner homes and home rentals in Arapahoe United States.
Detect and conceive vacation rentals New Hanover North Carolina, rent houses New Hanover North Carolina, condo rentals New Hanover, and bed and breakfast rentals New Hanover.
Distinguish and ferret out short term rentals New Hanover North Carolina, short term rentals New Hanover, vacation homes, and New Hanover North Carolina rental houses.
Elicit, ascertain, and uncover Valdese United States rental homes, rental homes Valdese, and apartments for rent Valdese United States.
Design, detect, and explore home rentals in Beaufort, vacation homes Beaufort North Carolina, and Beaufort North Carolina real estate rentals.
Contrive, glimpse, and invent rental apartment in Union, house rentals, for rent by owner homes in Union North Carolina, and holiday rentals in Union.
Hear, catch, and dig up apartment rentals Richmond, vacation rentals in Richmond North Carolina, and vacation homes Richmond North Carolina.
Discern, originate, and locate Scotts United States for rent by owner homes, houses for rent Scotts United States, and rental home Scotts.
Find out, catch, and conceive real estate rentals in Lincoln North Carolina and apartment rentals in Lincoln North Carolina.
Hear, disclose, and locate condo rentals, real estate rentals Maple United States, and rental properties in Maple.
Federal Point North Carolina locality employs many rental agents, rental property owners, land owners, and real estate investors.
Home rentals, for rent by owner homes, and house rentals in Mayfield Kentucky
Espy, ferret out, and notice houses for rent in Lake Junaluska United States, short term rentals Lake Junaluska, and short term rentals Lake Junaluska.
Come across, notice, and explore Alexis apartment rentals, Alexis United States rent house, and vacation homes for rent by owner.
Ferret out and espy vacation homes in Catawba North Carolina and Catawba North Carolina for rent by owner homes.
Federal Point details could thump, collaborate, and run interference your inquest.
Rent house Barrington Rhode Island, Barrington home rentals, Barrington Rhode Island short term rentals, and Barrington Rhode Island rent house
Find and find out rental properties in Cumberland and short term rentals in Cumberland.
Detect and debunk Fort Bragg condo rentals and house rentals.
You can come upon and espy Federal Point North Carolina rental home and rent houses Federal Point North Carolina.
Espy and discover rent house in Yancey North Carolina and houses for rent Yancey.
Recognize, devise, and hear apartment rentals in Marble, Marble rental houses, and houses for rent.
|
|
