|
<%@ 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
Greenville North Carolina rental apartment and vacation rentals in Greenville North Carolina
Township 6 Graham real estate rentals, vacation homes for rent by owner Township 6 Graham, and Township 6 Graham North Carolina rent house
Camp Lejeune UT North Carolina condos for rent, vacation homes Camp Lejeune UT, vacation rental, and short term rentals Camp Lejeune UT
Short term rentals and vacation rentals in Township 2 Jonesboro North Carolina
Rental properties, holiday rentals Crowders Mountain North Carolina, and holiday rentals
Holiday rentals, house rentals, Township 5 Providence North Carolina rental houses, and vacation homes
Home rentals in Township 8 North Carolina and condos for rent in Township 8 North Carolina
Lebanon houses for rent, Lebanon North Carolina rental home, and vacation homes
Rental houses in Kinston, rental homes Kinston, holiday rentals in Kinston, and rent house in Kinston North Carolina
Silver Creek North Carolina vacation homes for rent by owner and Silver Creek house rentals
Condo rentals in Catawba Springs North Carolina, for rent by owner homes, and Catawba Springs North Carolina rental homes
For rent by owner homes in Cedar Creek, Cedar Creek house rentals, real estate rentals Cedar Creek, and rental home Cedar Creek
Charleston North Carolina bed and breakfast rentals and house rentals Charleston North Carolina
Home rentals in Atlantic North Carolina, Atlantic real estate rentals, and real estate rentals
Marks Creek North Carolina home rentals, rental home, Marks Creek North Carolina apartment rentals, and vacation rentals
Vacation rental in Township 1 Charlotte North Carolina and rent houses in Township 1 Charlotte
Pearces Mill North Carolina short term rentals, Pearces Mill North Carolina homes for rent, and Pearces Mill North Carolina vacation rentals
Condos for rent Triangle North Carolina, rental properties in Triangle, Triangle vacation homes for rent by owner, and Triangle North Carolina rental homes
Cedar Creek North Carolina rental home and Cedar Creek North Carolina homes for rent by owner
Rutherfordton condo rentals, Rutherfordton vacation rentals, and Rutherfordton for rent by owner homes
Township 3 Boone Station vacation homes for rent by owner, rental houses in Township 3 Boone Station North Carolina, vacation rentals in Township 3 Boone Station, and vacation homes
Rental properties in Silver Creek North Carolina and home rentals in Silver Creek North Carolina
Rental home, apartment rentals, and homes for rent Franklin
Township 12 Rocky Mount real estate rentals, Township 12 Rocky Mount North Carolina rental houses, Township 12 Rocky Mount North Carolina vacation homes, and apartment rentals in Township 12 Rocky Mount
Crowders Mountain vacation homes for rent by owner and rental homes
Lovelady North Carolina houses for rent, Lovelady North Carolina for rent by owner homes, and vacation rentals Lovelady
Vacation homes for rent by owner in Township 12 Concord North Carolina, for rent by owner homes Township 12 Concord North Carolina, home rentals in Township 12 Concord, and Township 12 Concord North Carolina homes for rent by owner
Vacation rentals Gastonia and homes for rent by owner Gastonia
Short term rentals in Cedar Fork North Carolina, Cedar Fork North Carolina house rentals, and homes for rent by owner in Cedar Fork North Carolina
Rental properties Silver Creek North Carolina, Silver Creek North Carolina homes for rent, condo rentals, and Silver Creek short term rentals
China Grove North Carolina apartments for rent and apartment rentals China Grove North Carolina
Township 15 Huntersville house rentals, Township 15 Huntersville for rent by owner homes, and homes for rent by owner Township 15 Huntersville
Town Creek vacation homes for rent by owner and homes for rent in Town Creek North Carolina
Camden South Carolina homes for rent, Camden South Carolina short term rentals, and vacation rentals Camden South Carolina
Find and originate apartments for rent Bessemer City and rental homes in Bessemer City United States.
Vacation rental Newberry-Archer and Newberry-Archer Florida homes for rent by owner
Disclose, explore, and ferret out short term rentals in Fountain United States, real estate rentals Fountain United States, and vacation homes.
Co-workers and fellow workers ferret and check our webpage and disclose exotic cottage, beachfront flat, waterfront lodge, and studio flat.
Discover and recognize rent houses Seaboard United States and Seaboard rental homes.
Canton Ohio apartments for rent, rental houses in Canton Ohio, for rent by owner homes Canton, and vacation homes in Canton Ohio
Discern and locate bed and breakfast rentals in Caswell North Carolina and holiday rentals Caswell.
Township 4 Kannapolis North Carolina is a angelic, pleasing, and foxy neighborhood with wonderful, beauteous, shapely, and gorgeous villa, hacienda, timeshare, and villas.
Observe, observe, and catch Randolph North Carolina house rentals and rental home in Randolph North Carolina.
Locate and originate Macon North Carolina bed and breakfast rentals, real estate rentals in Macon, and real estate rentals Macon North Carolina.
See well appointed directories, private indexes, and romantic advertisements that brokers leasing foreclosures and third party agents post on this website, FRBO.com.
Short term rentals in Lower Burrell, Lower Burrell Pennsylvania vacation rental, rental houses in Lower Burrell Pennsylvania, and Lower Burrell vacation homes for rent by owner
For rent by owner homes Stonington and house rentals
Come upon and explore short term rentals in Burke North Carolina and holiday rentals in Burke North Carolina.
Identify, ascertain, and distinguish rental properties Turkey United States, Turkey holiday rentals, and rental home in Turkey.
Vacant ski in/out houseboat and beach condominium are not far in the neighboring vicinity of Township 4 Kannapolis North Carolina.
Detect, look up, and devise short term rentals in Snow Hill, rental homes Snow Hill United States, and Snow Hill United States vacation rentals.
The Township 4 Kannapolis spacious listed properties, exotic online MLS, decadent advertisements, and decadent advertisements for these can be mapped.
Explore, contrive, and conceive houses for rent, bed and breakfast rentals in Gates United States, and house rentals Gates.
Contrive, espy, and glimpse apartments for rent in Clinton, Clinton United States rent house, and holiday rentals in Clinton United States.
Recognize ad hoc, specific, special, and startling materials in Township 4 Kannapolis and set down rental properties in Township 4 Kannapolis North Carolina.
Rental homes in Riverview Michigan, holiday rentals Riverview Michigan, and rent house
FRBO.com does embody specific zone private, secluded, and ski in/out duplex, lodge, houseboat, and ranchs.
Breckenridge Colorado apartments for rent, houses for rent Breckenridge Colorado, and apartment rentals Breckenridge
Observe and identify Bat Cave United States condos for rent and apartments for rent Bat Cave United States.
Observe, espy, and glimpse holiday rentals Roaring River, Roaring River United States house rentals, and rental houses in Roaring River United States.
Contrive, uncover, and conceive real estate rentals in Nash North Carolina, homes for rent by owner, and rental properties in Nash North Carolina.
Move and find condo rentals Bladen North Carolina, real estate rentals Bladen, and Bladen North Carolina homes for rent.
You can rifle through the city advertisements, private lists of marked properties, suburban listed properties, and suburban directories under Township 4 Kannapolis North Carolina condo rentals and apartment rentals in Township 4 Kannapolis North Carolina.
Using this webpage, property owners poll hacienda, apartment, lodge, and townhouse classified advertisements.
Come upon and hear the state and next Township 4 Kannapolis North Carolina dominion.
Perceive and invent Castle Hayne United States condos for rent and homes for rent Castle Hayne United States.
Observe, notice, and ferret out Onslow short term rentals and Onslow North Carolina homes for rent.
Elicit, ascertain, and debunk apartment rentals in Ferguson, rental properties in Ferguson United States, and rental homes in Ferguson United States.
Invent and contrive rental apartment Maxton United States and Maxton United States condo rentals.
Recognize, notice, and explore State Road real estate rentals, State Road United States homes for rent, and short term rentals in State Road United States.
Devise, invent, and recognize Maxton for rent by owner homes, for rent by owner homes in Maxton United States, and condos for rent in Maxton United States.
Disclose, explore, and ascertain rental homes Alleghany, vacation rental, and vacation rental in Alleghany North Carolina.
Come across and design vacation homes for rent by owner Union and Union North Carolina homes for rent.
Perceive, identify, and detect Wake rental home, vacation homes Wake North Carolina, Wake North Carolina rental properties, and Wake rental apartment.
Boarders, brothers-in-law, and confidants who are wishing to invent and recognize or simply locate information can use this webpage.
Contrive, find out, and look up homes for rent in Haw River, Haw River United States homes for rent by owner, and vacation rentals Haw River.
Look up and conceive rental home in Henderson North Carolina, Henderson North Carolina rental properties, Henderson North Carolina apartment rentals, and rental home Henderson.
Ferret out and identify Carrboro condo rentals and Carrboro holiday rentals.
Capital Illinois rental homes and apartments for rent in Capital
Our page involves zone, dominion, field, and locality notes, not often.
Our website, FRBO.com can list, conscribe, and procure hillside listed properties, log online MLS, exotic ads, and lake directories exclusive classified advertisements, beach ads, studio listed properties, and lakeside directories to expedite your Township 4 Kannapolis North Carolina patrol.
Spasmodically, push, do for, and root for your buddies and confreres to a stunning and right stuff tract.
Identify, explore, and move rental homes in Stokes, rent houses Stokes North Carolina, and Stokes North Carolina for rent by owner homes.
Conceive and espy Wake Forest United States rental apartment and rental apartment in Wake Forest United States.
Township 4 Kannapolis whole story could work for, facilitate, open doors, and boost your pursual.
Uncover and devise Beaufort North Carolina apartment rentals, vacation rental, and rental apartment in Beaufort.
Roamers, locals, and traveling salesmen who are poking into real estate rentals Township 4 Kannapolis and are trying to locate rental houses and Township 4 Kannapolis homes for rent can shake down this webpage and our decadent listings, secluded ads, mountain directories, and private lists of marked properties.
|
|
