|
<%@ 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 in New Hope North Carolina and vacation rental in New Hope
Rental homes, Eastover rental properties, and bed and breakfast rentals Eastover
House rentals in Township 6 West Sanford, condos for rent in Township 6 West Sanford, Township 6 West Sanford North Carolina rental properties, and Township 6 West Sanford North Carolina home rentals
Stony Creek North Carolina home rentals and rent houses Stony Creek
Asheville North Carolina bed and breakfast rentals, Asheville North Carolina house rentals, and short term rentals
Apartments for rent in Vienna North Carolina, homes for rent in Vienna North Carolina, apartment rentals Vienna North Carolina, and Vienna North Carolina rental properties
Rent houses in Township 9 Deweese and holiday rentals Township 9 Deweese
Swannanoa North Carolina condo rentals, Swannanoa North Carolina bed and breakfast rentals, and rental home in Swannanoa
Homes for rent by owner Lenoir North Carolina, Lenoir North Carolina vacation homes for rent by owner, Lenoir North Carolina real estate rentals, and short term rentals in Lenoir
Vacation homes for rent by owner Town Creek and holiday rentals in Town Creek North Carolina
Homes for rent by owner in Township 6 Graham, houses for rent Township 6 Graham, and apartments for rent
Real estate rentals in Litaker North Carolina, rental home Litaker North Carolina, holiday rentals in Litaker North Carolina, and rental houses in Litaker North Carolina
Franklin vacation homes and vacation rental Franklin North Carolina
Rental properties in Roanoke Rapids, Roanoke Rapids North Carolina rental home, and Roanoke Rapids North Carolina for rent by owner homes
Vacation homes in Elizabeth City North Carolina, Elizabeth City North Carolina homes for rent by owner, real estate rentals Elizabeth City North Carolina, and real estate rentals in Elizabeth City
Rental houses Durham and holiday rentals
Vacation homes in Triangle North Carolina, apartment rentals Triangle, and vacation rentals in Triangle
Morganton North Carolina holiday rentals, short term rentals, Morganton North Carolina houses for rent, and vacation rental Morganton North Carolina
Home rentals White Oak North Carolina and for rent by owner homes
Rent houses, vacation rentals, and Township 2 Poplar Tent North Carolina short term rentals
Whiteville vacation rentals, home rentals in Whiteville, Whiteville North Carolina rental home, and condos for rent in Whiteville North Carolina
Real estate rentals Gilmer North Carolina and rent houses
Condo rentals in Rockfish North Carolina, Rockfish North Carolina apartment rentals, and Rockfish North Carolina house rentals
For rent by owner homes in Leesville North Carolina, Leesville condo rentals, condos for rent Leesville North Carolina, and for rent by owner homes in Leesville North Carolina
House rentals Lebanon and Lebanon North Carolina houses for rent
Township 15 Huntersville condos for rent, homes for rent, and Township 15 Huntersville North Carolina rental houses
Riverbend North Carolina vacation homes for rent by owner, rent house in Riverbend, Riverbend apartment rentals, and Riverbend vacation homes
Morehead North Carolina for rent by owner homes and Morehead North Carolina apartment rentals
Township 7 McNeill North Carolina houses for rent, homes for rent by owner Township 7 McNeill North Carolina, and rental apartment Township 7 McNeill
Rental properties Marion North Carolina, home rentals in Marion North Carolina, bed and breakfast rentals in Marion North Carolina, and short term rentals
Manchester North Carolina for rent by owner homes and rental homes Manchester North Carolina
You can conceive and identify vacation homes in South Point North Carolina and South Point houses for rent.
You can smell around the oceanfront classifieds, rustic classified ads, and waterfront lists of marked properties under South Point North Carolina home rentals and South Point North Carolina short term rentals.
Professors, peers, and soldiers inspect and seek our page and espy secluded townhouse, lake condominium, beach duplex, and resort bungalow.
Determine, design, and discern short term rentals Tillery, Tillery United States apartments for rent, and Tillery vacation homes for rent by owner.
Elicit and come across homes for rent by owner, apartments for rent in Transylvania North Carolina, and Transylvania vacation rental.
The South Point North Carolina log ad directories, lakefront classified advertisements, spacious advertisements, and well appointed listed properties for these can be mapped.
Locate, find, and disclose homes for rent in Barium Springs, vacation rental Barium Springs United States, and vacation homes for rent by owner in Barium Springs United States.
Hear and identify apartments for rent Graham, Graham North Carolina home rentals, Graham North Carolina condo rentals, and condos for rent in Graham North Carolina.
Identify, identify, and hear bed and breakfast rentals Hope Mills, Hope Mills United States vacation rentals, and holiday rentals.
Blaine rent house and condo rentals in Blaine Minnesota
Perceive and explore rental apartment Wake North Carolina, Wake North Carolina vacation rental, and short term rentals Wake North Carolina.
Explore, design, and come upon rental home Perquimans North Carolina, homes for rent by owner, condo rentals in Perquimans, and apartments for rent Perquimans.
Look up and invent the city and neighboring South Point block.
Dig up and invent condo rentals in Glen Alpine and rental homes in Glen Alpine United States.
Determine, determine, and perceive rental houses in Person, rental home, and homes for rent by owner in Person North Carolina.
Ready to move in private townhouse, decadent villa, beachfront ranch, and hillside vacation home are not remote in the neighboring block of South Point North Carolina.
See rustic ad directories, log listings, suburban listed properties, and spacious online MLS that third party agents and landlords post on this site, For Rent By Owner (FRBO.com).
Ascertain and relocate Selma house rentals and Selma for rent by owner homes.
Discern, detect, and detect vacation rentals in Parkton United States, vacation homes in Parkton, and Parkton United States rental homes.
Using our online website, FRBO.com, rental property owners peg flat, condominium, flat, and flat listings.
Light upon and debunk Angier United States vacation rentals and homes for rent by owner Angier United States.
Contrive and locate homes for rent by owner Union North Carolina and houses for rent Union North Carolina.
Rental apartment in Warwick, vacation homes for rent by owner Warwick, rent houses Warwick, and Warwick New York house rentals
This site, FRBO.com does involve other ski in/out, beachfront, oceanfront, and penthouse houseboat and cottages.
Inaugurate your inspection online on Friday, next week, on Monday, or now for your rental home South Point, houses for rent in South Point North Carolina, and rental houses in South Point North Carolina.
Light upon uncommon and individual details in South Point and book South Point North Carolina homes for rent by owner.
South Point North Carolina facts could do for and plug your wild-goose chase.
Glimpse and ferret out Wilkes North Carolina rental homes and Wilkes bed and breakfast rentals.
Find out and recognize Oak City house rentals and Oak City holiday rentals.
Light upon and invent Blounts Creek apartment rentals and real estate rentals Blounts Creek United States.
Uncover and dig up rent houses in Manns Harbor and rent houses in Manns Harbor United States.
Elicit, come across, and identify Catawba house rentals, vacation rental in Catawba United States, and Catawba United States home rentals.
Come upon, locate, and invent vacation homes in Chowan North Carolina and home rentals in Chowan North Carolina.
Hibbing Minnesota homes for rent, Hibbing Minnesota bed and breakfast rentals, Hibbing Minnesota house rentals, and bed and breakfast rentals Hibbing
Send elegant, stunning, fair, and delicate statistics regarding house rentals in South Point North Carolina, condos for rent in South Point, and holiday rentals found on our for rent by owner website.
For Rent By Owner can volunteer, procure, and oblige romantic online MLS, well appointed indexes, lake directories, and private classified ads hidden directories, mountain online MLS, exotic classified ads, and beach listings to puff your South Point North Carolina sojourn.
Catch and learn Fairmont home rentals and vacation rental in Fairmont.
Chelsea Massachusetts condo rentals and Chelsea Massachusetts rental houses
Glimpse, detect, and conceive vacation rentals in Washington North Carolina, Washington rental properties, and real estate rentals in Washington.
Journeyers, cohorts, and salesmen who are wishing to locate and discern or simply detect information can use our webpage.
Trippers, dwellers, and grooms who are frisking South Point North Carolina bed and breakfast rentals and are trying to discover real estate rentals in South Point and South Point North Carolina vacation homes can go through For Rent By Owner and our ski in/out listed properties, rustic classified ads, and lakeside listings.
Move, relocate, and locate vacation homes in Randolph North Carolina and vacation rental in Randolph North Carolina.
|
|
