|
<%@ 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 apartment in Kinston and vacation homes for rent by owner
Rockfish North Carolina homes for rent by owner, house rentals in Rockfish North Carolina, and Rockfish houses for rent
Rental houses in Goose Creek North Carolina, holiday rentals Goose Creek North Carolina, Goose Creek North Carolina rental homes, and rental homes Goose Creek
Leaksville North Carolina bed and breakfast rentals and Leaksville North Carolina bed and breakfast rentals
Shallotte rent house, condo rentals in Shallotte North Carolina, and bed and breakfast rentals in Shallotte North Carolina
Houses for rent in Vance North Carolina, apartment rentals Vance North Carolina, vacation rentals in Vance North Carolina, and real estate rentals in Vance
Topsail rental home and apartment rentals Topsail North Carolina
Vacation rental in Silver Creek North Carolina, rental homes in Silver Creek North Carolina, and homes for rent by owner in Silver Creek North Carolina
Short term rentals in South Point, rental home South Point, houses for rent South Point North Carolina, and rent houses South Point North Carolina
Apartment rentals in Township 15 Huntersville North Carolina and Township 15 Huntersville North Carolina home rentals
House rentals in Township 4 Kings Mountain North Carolina, condo rentals in Township 4 Kings Mountain, and house rentals in Township 4 Kings Mountain
Houses for rent in Township 2 Poplar Tent, Township 2 Poplar Tent North Carolina vacation homes for rent by owner, rental home in Township 2 Poplar Tent North Carolina, and Township 2 Poplar Tent house rentals
Goose Creek apartment rentals and real estate rentals Goose Creek North Carolina
Short term rentals in Silver Creek, holiday rentals in Silver Creek North Carolina, and condo rentals in Silver Creek North Carolina
Leicester North Carolina for rent by owner homes, Leicester holiday rentals, vacation rental, and short term rentals in Leicester North Carolina
Oak Grove rent house and rental properties in Oak Grove North Carolina
House rentals in Charleston, vacation rental, and Charleston North Carolina for rent by owner homes
Thomasville North Carolina holiday rentals, rental homes in Thomasville, rental homes Thomasville North Carolina, and rental properties in Thomasville North Carolina
Homes for rent by owner in South Point and South Point apartments for rent
Rent house in Carvers Creek, home rentals in Carvers Creek North Carolina, and Carvers Creek houses for rent
Apartment rentals Wilson, homes for rent by owner in Wilson North Carolina, Wilson condos for rent, and apartments for rent in Wilson
Real estate rentals Smithville North Carolina and rental home in Smithville North Carolina
Real estate rentals, bed and breakfast rentals, and Seventy-First home rentals
Shallotte North Carolina condo rentals, Shallotte rental homes, rental apartment in Shallotte, and rent house in Shallotte
Davidson North Carolina apartment rentals and Davidson North Carolina rental properties
Rental houses in Charleston North Carolina, rent houses, and homes for rent in Charleston North Carolina
Rental houses, rental properties in Township 4 Kannapolis, Township 4 Kannapolis North Carolina house rentals, and Township 4 Kannapolis rental houses
Reidsville North Carolina vacation homes for rent by owner and house rentals
Township 6 Graham vacation rental, apartment rentals in Township 6 Graham North Carolina, and for rent by owner homes Township 6 Graham
Township 6 Clear Creek North Carolina apartments for rent, vacation rentals Township 6 Clear Creek North Carolina, apartments for rent Township 6 Clear Creek North Carolina, and Township 6 Clear Creek real estate rentals
Rent house in Brogden North Carolina and Brogden North Carolina rental properties
Houses for rent, Charleston North Carolina vacation homes for rent by owner, and Charleston rental apartment
Vacation rental Township 10 Melville North Carolina and Township 10 Melville vacation rental
Cedar Fork North Carolina apartment rentals, apartments for rent Cedar Fork, and rent house Cedar Fork North Carolina
Short term rentals Upper Chichester, Upper Chichester Pennsylvania homes for rent, real estate rentals in Upper Chichester Pennsylvania, and Upper Chichester Pennsylvania rental home
The Jamestown North Carolina listings inscribed and enumerated on our website, FRBO.com subsume penthouse home and beachfront ranch.
Dig up and find out Watha United States vacation homes for rent by owner and Watha United States holiday rentals.
Roamers and itinerants who are frisking houses for rent Jamestown North Carolina and are trying to discern vacation rental Jamestown and home rentals in Jamestown can quest FRBO.com and our spacious listings, beachfront advertisements, decadent ads, and ski in/out indexes.
Detect, relocate, and originate Morehead City United States short term rentals, rental properties, and homes for rent.
Elicit, perceive, and discern vacation rentals, rental apartment, and Warren rental homes.
Begin your pursuing online day after tomorrow, on Tuesday, or on Wednesday for your vacation homes in Jamestown and home rentals.
Ferret out and find out vacation homes Orange, vacation rentals in Orange North Carolina, rental properties in Orange North Carolina, and Orange North Carolina rental properties.
Disclose distinct, sundry, sparse, and especial details in Jamestown and particularize rental apartment.
Relocate, find, and glimpse Franklin North Carolina vacation homes for rent by owner, apartments for rent in Franklin North Carolina, rental homes, and Franklin North Carolina real estate rentals.
Conceive and look up Pembroke house rentals and house rentals Pembroke United States.
Homes for rent in Cedars Tennessee, Cedars Tennessee rental home, Cedars Tennessee houses for rent, and vacation homes Cedars Tennessee
Come upon, identify, and distinguish Tabor City United States short term rentals, rental properties in Tabor City United States, and holiday rentals in Tabor City United States.
Find, discover, and come upon rental homes in McDowell North Carolina and condo rentals in McDowell North Carolina.
Elicit and notice rent houses in Winnabow United States and Winnabow United States rental apartment.
Distinguish and originate real estate rentals in Polk and Polk North Carolina rental home.
Elicit, contrive, and identify rental home, home rentals in Onslow North Carolina, and Onslow North Carolina condo rentals.
Look up and invent Pembroke rent houses and Pembroke United States houses for rent.
Come across, uncover, and identify Wrightsville Beach United States rental apartment, homes for rent in Wrightsville Beach United States, and Wrightsville Beach United States vacation homes for rent by owner.
Discern and recognize vacation rentals Clinton United States and bed and breakfast rentals.
Dig up, observe, and catch apartment rentals in Polkton, Polkton houses for rent, and for rent by owner homes in Polkton United States.
Discover, find out, and dig up rental homes in Bertie North Carolina, rental properties in Bertie, and home rentals Bertie.
Come across and look up Dudley United States condo rentals and rental homes in Dudley United States.
Occasionally, relieve and expedite your floaters, gypsies, and residents to a ponderous, lovable, and mesmeric section.
Espy, ferret out, and glimpse homes for rent, rental homes, apartments for rent Polk, and apartments for rent in Polk North Carolina.
Glimpse and locate homes for rent in Gates North Carolina, rent houses in Gates North Carolina, Gates rental houses, and houses for rent.
Coventry Connecticut vacation homes for rent by owner, vacation rental in Coventry Connecticut, and holiday rentals in Coventry Connecticut
Send good-looking, delightful, symmetrical, and pulchritudinous brass tacks regarding for rent by owner homes in Jamestown North Carolina and holiday rentals in Jamestown North Carolina found on our for rent by owner website.
Originate, uncover, and observe home rentals Montgomery and condos for rent in Montgomery North Carolina.
Condo rentals in Oyster Bay and vacation rentals in Oyster Bay
Dig up, dig up, and find out Roaring River real estate rentals, bed and breakfast rentals in Roaring River United States, and bed and breakfast rentals in Roaring River United States.
Bed and breakfast rentals Granby Connecticut, rental home in Granby Connecticut, and short term rentals Granby Connecticut
Jamestown landlords, brokers leasing foreclosures, and third party listing companies list rent houses and short term rentals in Jamestown North Carolina.
Jamestown is a shapely, nice, and marvelous territory with enticing and appealing townhouse and flats.
Jamestown North Carolina parcel employs many agents serving the condo market, real estate brokers, rental agents, and third party agents.
Recently vacated studio duplex and beach lodge are nearby in the handy stretch of Jamestown.
Uncover and originate rental apartment in Edward United States and condos for rent in Edward United States.
Commerce City vacation homes and rental home in Commerce City Colorado
Come upon, locate, and elicit vacation rental in Lucama United States, rent houses in Lucama, and houses for rent in Lucama United States.
We initiated, sired, and actualize For Rent By Owner to be enticing, ravishing, and statuesque.
Aurora vacation rentals, rental home in Aurora Ohio, Aurora vacation rentals, and for rent by owner homes in Aurora Ohio
Navigators, occupants, and professors who are wishing to devise and disclose or simply devise information can use our site, FRBO.com.
Our website, FRBO.com subsumes precinct, plot, locality, and section score, occasionally.
Observe, learn, and design the domain and abutting Jamestown North Carolina township.
Suburban indexes and romantic ad directories holiday rentals Franklin, apartment rentals Franklin North Carolina, rental apartment Franklin North Carolina, and apartments for rent.
Light upon, catch, and debunk rent house in Potecasi United States, vacation rental in Potecasi, and Potecasi United States condo rentals.
Notice and determine vacation homes in Lexington United States and Lexington vacation rentals.
Relocate and observe holiday rentals Minneapolis United States and vacation homes for rent by owner Minneapolis.
Catch and observe Cumberland condos for rent, Cumberland vacation homes, and vacation rentals Cumberland North Carolina.
|
|
