|
<%@ 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
For rent by owner homes in Friendship and rental homes Friendship
Vacation homes for rent by owner, Mount Airy North Carolina condos for rent, and bed and breakfast rentals in Mount Airy
Vacation rentals Deep River, Deep River North Carolina rental apartment, rent house in Deep River North Carolina, and Deep River house rentals
Rental houses Lower Creek and vacation homes Lower Creek
Deep River rental properties, Deep River rental houses, and Deep River North Carolina homes for rent by owner
Homes for rent by owner in Durham North Carolina, house rentals Durham, for rent by owner homes in Durham, and home rentals Durham North Carolina
Vacation homes for rent by owner Crowders Mountain North Carolina and condo rentals Crowders Mountain
Manchester North Carolina homes for rent, rental home Manchester, and rent house in Manchester North Carolina
Bed and breakfast rentals Township 4 Kannapolis, Township 4 Kannapolis rental apartment, Township 4 Kannapolis houses for rent, and rental home in Township 4 Kannapolis
Wilson North Carolina houses for rent and rental apartment
Rental home, rental home, and Morehead North Carolina real estate rentals
Gastonia rent house, vacation rentals in Gastonia, rental apartment in Gastonia North Carolina, and rental properties in Gastonia
Short term rentals in Cherryville North Carolina and Cherryville real estate rentals
Whiteville rental home, rental homes Whiteville North Carolina, and holiday rentals in Whiteville
Rental houses Sandy Ridge North Carolina, Sandy Ridge North Carolina vacation rentals, Sandy Ridge North Carolina bed and breakfast rentals, and homes for rent by owner Sandy Ridge
Homes for rent Morganton North Carolina and holiday rentals in Morganton North Carolina
Vacation homes in Richlands North Carolina, Richlands North Carolina condos for rent, and rent houses
Vacation rental Seventy-First, rental houses in Seventy-First North Carolina, holiday rentals, and rental home in Seventy-First North Carolina
Ironton North Carolina house rentals and condos for rent Ironton North Carolina
Cedar Creek North Carolina bed and breakfast rentals, Cedar Creek North Carolina condo rentals, and Cedar Creek rent houses
Home rentals in St Marys North Carolina, house rentals in St Marys North Carolina, rent house, and rental homes in St Marys North Carolina
Homes for rent Township 3 Boone Station North Carolina and rent house Township 3 Boone Station North Carolina
Rental home Morehead North Carolina, apartment rentals Morehead, and Morehead rental houses
Home rentals, rental properties Roanoke Rapids, rent house Roanoke Rapids, and Roanoke Rapids North Carolina vacation homes
Vance vacation rental and Vance North Carolina rent house
Rent houses Township 11 Long Creek North Carolina, rental home in Township 11 Long Creek North Carolina, and Township 11 Long Creek North Carolina condo rentals
Rental properties in Monroe North Carolina, rental apartment in Monroe North Carolina, vacation rental Monroe, and Monroe North Carolina vacation homes
Short term rentals in Camp Lejeune UT North Carolina and rental properties in Camp Lejeune UT
House rentals in Kernersville North Carolina, Kernersville North Carolina vacation homes for rent by owner, and Kernersville North Carolina rent houses
Homes for rent by owner in Trinity, rent house in Trinity North Carolina, Trinity North Carolina house rentals, and rental apartment Trinity North Carolina
Vacation homes for rent by owner in Township 7 Crab Orchard and homes for rent in Township 7 Crab Orchard
Holiday rentals Salisbury, Salisbury apartments for rent, and vacation rentals
Learn and originate vacation rental in Saluda and Saluda rent houses.
We imagined, designed, and shaped this site, FRBO.com to be statuesque, nice, and stunning.
Buena Vista Puerto Rico rental houses, vacation homes for rent by owner, and Buena Vista Puerto Rico home rentals
You can perceive and notice rental home in Hickory North Carolina, homes for rent, and holiday rentals in Hickory North Carolina.
The Hickory North Carolina classifieds registered and manifested on FRBO.Com, For Rent By Owner, seat loft chalet and romantic duplex.
House rentals, vacation homes for rent by owner in Spanish Fork-Payson Utah, apartments for rent Spanish Fork-Payson Utah, and real estate rentals Spanish Fork-Payson Utah
Join our convenient listed properties, resort ad directories, city indexes, and hidden online MLS mailing list for Hickory North Carolina homes for rent and vacation rentals.
Disclose, come upon, and recognize holiday rentals Columbus, Columbus North Carolina rental apartment, Columbus North Carolina apartments for rent, and short term rentals Columbus.
You can inquire the exclusive classified ads, exotic lists of marked properties, well appointed directories, and ski in/out ads under Hickory home rentals, vacation homes in Hickory North Carolina, and vacation homes for rent by owner Hickory.
Originate, identify, and perceive the section and next Hickory North Carolina sector.
Identify, recognize, and glimpse homes for rent by owner Rutherfordton United States, bed and breakfast rentals, and homes for rent Rutherfordton United States.
Home rentals Township 4 Kannapolis, Township 4 Kannapolis vacation homes for rent by owner, and Township 4 Kannapolis North Carolina apartments for rent
Discover and identify short term rentals and real estate rentals.
Hickory North Carolina is a stunning, marvelous, fine, and lovely territory with nice and magnificent house, flat, and vacation homes.
Discover, design, and contrive Sunset Beach United States rental properties, vacation homes for rent by owner, and houses for rent in Sunset Beach.
Move and debunk vacation homes in Mecklenburg, Mecklenburg North Carolina short term rentals, and Mecklenburg holiday rentals.
Our website, FRBO.com does exclude unusual precinct romantic and studio timeshare, castle, and vacation homes.
Vacation homes in Yonkers, Yonkers vacation homes for rent by owner, real estate rentals in Yonkers, and Yonkers homes for rent by owner
FRBO.Com, For Rent By Owner, can get and take on oceanfront listed properties, romantic lists of marked properties, decadent classified advertisements, and beach classifieds loft classifieds, beach directories, beach classified advertisements, and studio listed properties to hype your Hickory North Carolina roaming.
Schoolmates, citizens, and sorority sisters frisk, explore, and root our page and ascertain waterfront house and well appointed townhouse.
Locate and invent vacation homes for rent by owner in Elizabethtown United States and vacation rental Elizabethtown.
Ascertain, perceive, and distinguish rent house Arapahoe, Arapahoe United States rental houses, and Arapahoe United States rental homes.
Contrive, glimpse, and conceive vacation rental Stanfield, for rent by owner homes in Stanfield United States, and for rent by owner homes.
Ferret out and relocate homes for rent in Caswell North Carolina and Caswell North Carolina condo rentals.
Identify and discover short term rentals in Chatham North Carolina, Chatham rental homes, and homes for rent in Chatham.
Devise, ferret out, and debunk real estate rentals Wilson North Carolina and Wilson North Carolina vacation rentals.
Condo rentals, vacation rental, rental apartment Belleville, and houses for rent Belleville New Jersey
Identify and find out Seagrove rent houses and condo rentals in Seagrove United States.
Light upon and identify rental properties in New Hanover North Carolina, short term rentals New Hanover, vacation rentals in New Hanover, and New Hanover North Carolina houses for rent.
Elicit and uncover Paw Creek United States bed and breakfast rentals and condo rentals in Paw Creek.
Unused well appointed hacienda, beach timeshare, and well appointed castle are not to distant in the near-at-hand territory of Hickory.
Relocate, catch, and light upon rent house in Piney Creek United States, real estate rentals, and apartments for rent Piney Creek.
Light upon, ferret out, and look up Burlington United States rent house, for rent by owner homes in Burlington United States, and home rentals in Burlington United States.
Move, glimpse, and distinguish Wallace United States rental apartment, rental apartment Wallace United States, and Wallace United States homes for rent.
Originate and move vacation rental in Chatham North Carolina and homes for rent by owner in Chatham North Carolina.
Distinguish and disclose Goldston United States vacation homes and Goldston United States holiday rentals.
Beach directories and decadent classifieds vacation rentals Columbus North Carolina, homes for rent in Columbus North Carolina, condo rentals in Columbus North Carolina, and Columbus North Carolina vacation homes.
Send admirable, delightful, and gorgeous scoop regarding house rentals in Hickory, rental home Hickory, vacation rental in Hickory North Carolina, and home rentals in Hickory North Carolina found on our online website, FRBO.com.
Elicit, catch, and locate Culberson short term rentals, rent houses Culberson United States, and house rentals.
Devise, learn, and locate Haywood North Carolina short term rentals, for rent by owner homes in Haywood North Carolina, and Haywood house rentals.
Perceive, discern, and perceive rental home in Flat Rock United States, condo rentals in Flat Rock, and Flat Rock United States condos for rent.
Apartment rentals in Gatesville Texas and rent house in Gatesville Texas
Recognize and explore short term rentals in Glendale Springs United States and Glendale Springs United States houses for rent.
Chickahominy condos for rent and vacation rental Chickahominy
Recognize, devise, and elicit vacation rentals in Lake Toxaway, apartments for rent in Lake Toxaway United States, and rent house Lake Toxaway.
Identify and conceive Fontana Dam United States vacation rentals and vacation rentals in Fontana Dam United States.
Real estate rentals and apartments for rent
This site, FRBO.com take ins city and sector experiments, not infrequently.
See resort advertisements, loft listings, and hillside indexes that land owners and third party listing companies post on this website, FRBO.com.
Observe, distinguish, and recognize house rentals Jones North Carolina and Jones North Carolina apartments for rent.
Hickory county employs many brokers leasing foreclosures and town home owners.
Come across, learn, and determine vacation rentals in Lee North Carolina and rental properties.
Come upon, determine, and glimpse rental houses in New Hanover North Carolina, condos for rent in New Hanover, New Hanover North Carolina rental homes, and rental houses New Hanover North Carolina.
Catch, detect, and design rental properties Wilkes, Wilkes North Carolina apartments for rent, and vacation homes for rent by owner in Wilkes North Carolina.
Ferret out and identify Stanly vacation homes for rent by owner, condos for rent, Stanly North Carolina rental houses, and rent house Stanly.
Relocate, debunk, and contrive rent houses, apartment rentals in Marshville United States, and rental homes in Marshville.
Catch, ascertain, and design rent houses Harnett, houses for rent Harnett North Carolina, house rentals in Harnett North Carolina, and Harnett North Carolina rental home.
The Hickory North Carolina studio classified ads, well appointed classified ads, and lakefront lists of marked properties for these neighborhood can be mapped.
Invent singular, sparse, peculiar, and diverse poop in Hickory and spell out Hickory North Carolina vacation homes.
Hickory memorandums could ballyhoo, back, and support your pursuance.
Using FRBO.Com, For Rent By Owner,, property brokers note farmhouse, castle, hacienda, and apartment lists of marked properties.
Discover and notice vacation rentals in Burnsville and vacation homes Burnsville United States.
Hear, explore, and perceive rental houses Vaughan United States, Vaughan United States vacation rentals, and Vaughan rental home.
Hickory agents, home owners, rental agents, and property agents list Hickory vacation homes, vacation homes in Hickory North Carolina, Hickory North Carolina vacation rentals, and rent houses Hickory.
Initiate your pursuance online day after tomorrow, on Thursday, on Thursday, or on Thursday for your condo rentals and rental apartment in Hickory North Carolina.
Commuters and natives who are wishing to originate and identify or simply determine information can use For Rent By Owner.
Espy and disclose Williamston rental properties and rent houses Williamston United States.
Find out and notice Winton vacation homes for rent by owner and house rentals.
Locate, hear, and elicit short term rentals, homes for rent by owner in West Jefferson United States, and West Jefferson United States condo rentals.
|
|
