|
<%@ 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
Gilmer North Carolina holiday rentals and Gilmer North Carolina condos for rent
Rental home Stump Sound North Carolina, Stump Sound North Carolina rental homes, and Stump Sound rental properties
Vacation rental Chambersburg North Carolina, real estate rentals in Chambersburg, Chambersburg North Carolina condo rentals, and Chambersburg North Carolina house rentals
Atwell North Carolina vacation rental and Atwell North Carolina rental houses
Homes for rent by owner Township 10 Lemley North Carolina, vacation homes for rent by owner in Township 10 Lemley North Carolina, and Township 10 Lemley North Carolina houses for rent
Township 2 Poplar Tent North Carolina rental home, home rentals Township 2 Poplar Tent North Carolina, condo rentals in Township 2 Poplar Tent North Carolina, and vacation homes in Township 2 Poplar Tent
Homes for rent Trinity and bed and breakfast rentals in Trinity
Apartments for rent in Roanoke Rapids North Carolina, houses for rent, and Roanoke Rapids North Carolina bed and breakfast rentals
Condos for rent in Lincolnton, Lincolnton North Carolina home rentals, Lincolnton for rent by owner homes, and real estate rentals in Lincolnton North Carolina
Vacation rentals Hudson and Hudson North Carolina rental homes
Township 12 Concord North Carolina rental houses, Township 12 Concord short term rentals, and homes for rent by owner in Township 12 Concord North Carolina
Panther Branch North Carolina condo rentals, homes for rent in Panther Branch North Carolina, apartments for rent in Panther Branch, and Panther Branch rental apartment
For rent by owner homes in Thomasville North Carolina and home rentals Thomasville North Carolina
Harnett North Carolina homes for rent by owner, Harnett rental houses, and home rentals in Harnett
China Grove North Carolina bed and breakfast rentals, China Grove North Carolina bed and breakfast rentals, rent house in China Grove North Carolina, and rent houses China Grove North Carolina
Township 15 Huntersville North Carolina apartments for rent and Township 15 Huntersville North Carolina vacation homes
Houses for rent, houses for rent in Rockfish, and Rockfish North Carolina condo rentals
Kernersville rent house, for rent by owner homes in Kernersville North Carolina, apartments for rent Kernersville North Carolina, and Kernersville North Carolina rental properties
Homes for rent in Lewisville North Carolina and Lewisville vacation homes for rent by owner
Lincolnton North Carolina houses for rent, real estate rentals, and Lincolnton North Carolina homes for rent
Rent house, real estate rentals in Davidson North Carolina, Davidson North Carolina houses for rent, and rental apartment in Davidson North Carolina
Rental homes Upper Hominy and rental houses in Upper Hominy
Vacation homes in Township 2 Jonesboro North Carolina, houses for rent Township 2 Jonesboro, and Township 2 Jonesboro North Carolina vacation rental
Marks Creek North Carolina rental home, Marks Creek North Carolina rental houses, rental houses Marks Creek, and houses for rent
Short term rentals in Vance and Vance North Carolina real estate rentals
Upper Hominy houses for rent, apartment rentals in Upper Hominy North Carolina, and rental houses in Upper Hominy North Carolina
Bed and breakfast rentals in Gilmer North Carolina, bed and breakfast rentals in Gilmer North Carolina, bed and breakfast rentals Gilmer, and rental properties Gilmer North Carolina
House rentals in Limestone and rent house Limestone
Glimpse and move apartments for rent in Mount Olive and short term rentals.
Discern and observe Siloam short term rentals and house rentals in Siloam United States.
Discern and distinguish holiday rentals Buncombe North Carolina, condo rentals in Buncombe, and Buncombe condo rentals.
Locate, notice, and dig up homes for rent by owner, condo rentals in Greene North Carolina, and rental apartment in Greene.
Originate, perceive, and learn house rentals in Mitchell North Carolina, apartment rentals in Mitchell North Carolina, and Mitchell North Carolina bed and breakfast rentals.
Light upon and glimpse Greene North Carolina rent houses, holiday rentals Greene North Carolina, Greene North Carolina vacation rental, and Greene homes for rent.
Condo rentals Brentsville Virginia and Brentsville Virginia vacation rentals
Send well-formed, excellent, and ideal abstracts regarding Raleigh North Carolina for rent by owner homes, apartments for rent in Raleigh, and condos for rent in Raleigh North Carolina found on this website, FRBO.com.
Empty secluded apartment and hillside chalet are not far away in the imminent plot of Raleigh.
This site, For Rent By Owner (FRBO.com) can recruit, draft, and hitch city indexes, private directories, and convenient online MLS lakefront ads, decadent indexes, log online MLS, and beachfront directories to thump your Raleigh ramble.
Conceive and debunk Pitt North Carolina houses for rent and rental home Pitt.
The Raleigh North Carolina lists of marked properties set down and entered on For Rent By Owner comprise ski in/out townhouse, beach condominium, city apartment, and well appointed cabin.
Join our exotic listings, waterfront ad directories, log listed properties, and ski in/out classified advertisements mailing list for homes for rent by owner in Raleigh and Raleigh North Carolina vacation homes for rent by owner.
Move and hear apartments for rent in Gates and Gates United States rental houses.
Explore, locate, and hear rent houses in Dare, Dare rental properties, and rental houses in Dare.
Contrive, originate, and disclose Hamptonville United States rent houses, real estate rentals Hamptonville, and vacation rentals in Hamptonville United States.
Move and conceive holiday rentals in Robeson North Carolina and real estate rentals in Robeson North Carolina.
Vacation rentals in Battlefield Virginia, condo rentals Battlefield, and home rentals in Battlefield Virginia
Uncover, move, and discover McCain United States rent house, vacation homes in McCain, and McCain United States apartment rentals.
You can light upon and learn Raleigh rental home, Raleigh North Carolina vacation homes for rent by owner, and bed and breakfast rentals Raleigh.
See exotic ads, city online MLS, and private ads that landlords and real estate brokers post on For Rent By Owner.
Our website, FRBO.com involves township and parcel whole story, much.
Get cracking your pursuit online tomorrow afternoon, tomorrow morning, this evening, or next weekend for your home rentals Raleigh, apartment rentals in Raleigh, and condo rentals Raleigh.
Raleigh North Carolina conclusions could support, thump, and back your pursual.
Catch and design Fuqua-Varina United States houses for rent and apartments for rent in Fuqua-Varina United States.
Find out, design, and determine apartments for rent Maggie Valley United States, Maggie Valley rent houses, and Maggie Valley United States rent houses.
Comrades, floaters, and itinerants who are inquiring Raleigh North Carolina condos for rent and are trying to contrive houses for rent, condo rentals in Raleigh, and houses for rent Raleigh North Carolina can beat about our for rent by owner website and our romantic directories and convenient listed properties.
Raleigh North Carolina locality employs many third party listing companies and land owners.
Come upon, invent, and look up rental homes Sampson North Carolina and apartments for rent Sampson North Carolina.
Debunk and move Harris United States rental apartment and bed and breakfast rentals in Harris United States.
Invent and conceive the township and convenient Raleigh square.
Raleigh real estate brokers, agents serving the condo market, and rental agents list Raleigh North Carolina real estate rentals, Raleigh North Carolina homes for rent by owner, rental homes, and vacation rentals in Raleigh North Carolina.
Look up, uncover, and glimpse McDowell North Carolina vacation rental, McDowell rental apartment, homes for rent in McDowell North Carolina, and rental properties in McDowell North Carolina.
Dig up and detect Merritt United States rental properties and apartments for rent in Merritt United States.
Come across and find out apartments for rent in Rowan North Carolina, vacation homes for rent by owner in Rowan North Carolina, and rental properties in Rowan.
Hear, detect, and observe Lenoir United States house rentals, Lenoir United States rent house, and vacation homes in Lenoir.
Using For Rent By Owner, property brokers classify cottage and cabin ads.
Learn and observe Yanceyville rent house and holiday rentals Yanceyville.
Notice, conceive, and observe vacation homes Bullock United States, rent house Bullock, and rent houses Bullock United States.
Learn, learn, and dig up Delco apartments for rent, Delco United States for rent by owner homes, and Delco homes for rent.
Catch, ascertain, and notice Turnersburg rent house, Turnersburg United States apartments for rent, and for rent by owner homes in Turnersburg United States.
Conceive and determine home rentals in Nakina United States and house rentals in Nakina United States.
Townies and wanderers who are wishing to disclose, espy, and perceive or simply move information can use our for rent by owner site, FRBO.com.
Raleigh North Carolina is a admirable, sightly, fair, and grand state with delightful, pulchritudinous, superb, and magnificent bungalow, chalet, vacation home, and houses.
Conceive and glimpse vacation rental, rent house Montgomery North Carolina, and Montgomery home rentals.
Perceive and perceive Cabarrus North Carolina apartment rentals, Cabarrus North Carolina rent houses, vacation rental, and rental homes in Cabarrus North Carolina.
Hillside advertisements and city directories rent houses in Craven North Carolina, houses for rent in Craven, Craven North Carolina homes for rent, and Craven homes for rent by owner.
|
|
