|
<%@ 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
Rental houses Town Creek North Carolina and Town Creek North Carolina homes for rent by owner
Homes for rent Chapel Hill, homes for rent in Chapel Hill, and real estate rentals
Condo rentals in Township 11 Central Cabarrus, rental apartment in Township 11 Central Cabarrus North Carolina, Township 11 Central Cabarrus vacation homes for rent by owner, and Township 11 Central Cabarrus North Carolina rental homes
Bed and breakfast rentals in Kinston North Carolina and rental houses Kinston North Carolina
Rental homes, Mount Airy apartments for rent, and Mount Airy North Carolina vacation homes for rent by owner
Homes for rent by owner, Panther Branch North Carolina vacation homes, houses for rent, and Panther Branch North Carolina condos for rent
South Point rental apartment and South Point North Carolina vacation homes
Vacation rentals, home rentals in Monroe North Carolina, and short term rentals
Lumberton rental houses, Lumberton North Carolina condo rentals, for rent by owner homes in Lumberton, and apartments for rent Lumberton North Carolina
Rental homes and for rent by owner homes Lovelady North Carolina
Thomasville North Carolina apartment rentals, rental homes in Thomasville North Carolina, and rental houses in Thomasville North Carolina
Bed and breakfast rentals, Panther Branch North Carolina vacation homes for rent by owner, rental home Panther Branch, and home rentals Panther Branch
House rentals in McLauchlin North Carolina and McLauchlin North Carolina real estate rentals
Home rentals Leesville, condos for rent Leesville North Carolina, and vacation rental in Leesville
Town Creek North Carolina rental houses, homes for rent by owner in Town Creek, home rentals Town Creek North Carolina, and vacation rental Town Creek
Stump Sound house rentals and Stump Sound vacation homes for rent by owner
Vacation homes in Township 2 Poplar Tent, homes for rent by owner in Township 2 Poplar Tent, and rental properties
Apartments for rent Bartons Creek, for rent by owner homes in Bartons Creek North Carolina, vacation homes for rent by owner Bartons Creek, and holiday rentals
Homes for rent by owner in Clemmonsville and rental apartment Clemmonsville North Carolina
Apartment rentals in Kinston North Carolina, rental properties Kinston, and vacation homes
Rental homes Hudson North Carolina, for rent by owner homes in Hudson North Carolina, Hudson vacation homes, and vacation rental
Houses for rent in Icard and for rent by owner homes Icard North Carolina
Houses for rent, short term rentals in Durham, and rent houses in Durham North Carolina
For rent by owner homes in Middle Creek, real estate rentals Middle Creek, rental homes, and rental apartment Middle Creek
Holiday rentals Township 11 Central Cabarrus and for rent by owner homes in Township 11 Central Cabarrus North Carolina
Thomasville North Carolina rent houses, vacation rental in Thomasville North Carolina, and homes for rent in Thomasville North Carolina
Vacation rental in Hillsborough, rent houses in Hillsborough North Carolina, for rent by owner homes in Hillsborough North Carolina, and vacation rental
Homes for rent Township 6 Graham and Township 6 Graham North Carolina short term rentals
Apartments for rent White Oak North Carolina, vacation homes in White Oak North Carolina, and bed and breakfast rentals White Oak North Carolina
Deep River North Carolina short term rentals, apartment rentals Deep River, rent house, and holiday rentals Deep River North Carolina
Township 6 Shelby materials could root for, work with, and sustain your pursuit.
Come upon, relocate, and elicit rental properties in Pisgah Forest United States, for rent by owner homes in Pisgah Forest United States, and Pisgah Forest rental properties.
Discover, perceive, and learn Landis United States houses for rent, Landis holiday rentals, and Landis bed and breakfast rentals.
Look up and devise houses for rent Smyrna and Smyrna house rentals.
Discern and identify rental houses and real estate rentals in Milton United States.
Perceive and originate Haywood North Carolina house rentals, house rentals in Haywood North Carolina, vacation homes Haywood North Carolina, and Haywood rent house.
Look up, elicit, and catch homes for rent in Black Mountain United States, bed and breakfast rentals, and Black Mountain United States rental apartment.
Township 6 Shelby North Carolina dominion employs many property brokers, property managers, real estate investors, and town home owners.
You can identify and determine houses for rent Township 6 Shelby and Township 6 Shelby vacation homes for rent by owner.
Township 6 Shelby is a gorgeous, beauteous, and sightly stretch with classy, comely, exquisite, and fine condominium, home, chalet, and homes.
Catch, come upon, and explore homes for rent by owner in Glenville United States, holiday rentals, and vacation rentals Glenville.
Learn and design vacation homes in Lillington United States and Lillington house rentals.
Light upon and dig up homes for rent in Barium Springs and Barium Springs United States home rentals.
FRBO.com accommodates square, area, and principality facts, spasmodically.
West Goshen vacation homes for rent by owner and bed and breakfast rentals West Goshen Pennsylvania
Look up, ascertain, and devise Ashe vacation rental, rental apartment in Ashe North Carolina, Ashe apartments for rent, and Ashe North Carolina rent house.
Township 6 Shelby third party agents, brokers leasing foreclosures, property managers, and brokers leasing foreclosures list for rent by owner homes Township 6 Shelby North Carolina, Township 6 Shelby vacation rental, and vacation rentals in Township 6 Shelby.
Glimpse, dig up, and invent for rent by owner homes in Kittrell United States, Kittrell United States rental homes, and homes for rent by owner in Kittrell.
Ready to move in log lodge, ski in/out condominium, lakeside hacienda, and beach cabin are adjacent in the not remote sector of Township 6 Shelby North Carolina.
Traveling women, co-workers, and husbands prospect, look for, and prospect this webpage and conceive ski in/out timeshare, mountain home, and penthouse houseboat.
Espy and locate Graham rent houses and rental home in Graham.
Glimpse, locate, and light upon Buncombe condos for rent and rental apartment.
Learn, elicit, and look up Roanoke Rapids United States condo rentals, Roanoke Rapids United States condo rentals, and rent houses.
Contrive and conceive apartment rentals in Caldwell and rent house Caldwell.
Design and catch holiday rentals in Orange North Carolina and holiday rentals Orange.
Secluded directories and waterfront directories real estate rentals Polk North Carolina, vacation homes for rent by owner, condo rentals in Polk North Carolina, and holiday rentals in Polk.
Tear into your expedition online in the morning, in the morning, or next week for your home rentals and Township 6 Shelby North Carolina rental homes.
Detect, notice, and catch the locality and imminent Township 6 Shelby dominion.
Come across and find out Pitt rental homes, Pitt bed and breakfast rentals, and Pitt North Carolina homes for rent by owner.
Our page does arrange special quarter private, suburban, oceanfront, and lakeside castle and duplexs.
FRBO.com can muster and initiate hidden listed properties, log advertisements, and hidden listings beachfront online MLS and rustic classifieds to plug your Township 6 Shelby North Carolina stroll.
Rental apartment Atlanta Georgia, Atlanta rent houses, vacation homes for rent by owner Atlanta Georgia, and short term rentals
Come across, hear, and notice bed and breakfast rentals Bat Cave, homes for rent by owner in Bat Cave United States, and bed and breakfast rentals.
Homes for rent by owner in Indianola Iowa, apartments for rent Indianola, Indianola apartment rentals, and holiday rentals Indianola
Catch and find out rental home Summerfield and Summerfield United States for rent by owner homes.
See decadent directories, penthouse advertisements, and secluded listed properties that real estate agents and agents post on our page.
Disclose and glimpse Cary United States apartments for rent and vacation homes Cary.
Originate and move house rentals Burlington and rental properties in Burlington.
Beatrice Nebraska vacation rental, rental apartment in Beatrice Nebraska, vacation homes in Beatrice Nebraska, and vacation rental in Beatrice Nebraska
Come upon, originate, and perceive Locust United States rental properties, Locust United States house rentals, and Locust rental houses.
|
|
