|
<%@ 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 homes Township 6 Shelby North Carolina and rent house Township 6 Shelby
Sandy Ridge North Carolina home rentals, Sandy Ridge North Carolina real estate rentals, and vacation homes in Sandy Ridge North Carolina
Township 1 Tarboro North Carolina holiday rentals, Township 1 Tarboro North Carolina holiday rentals, home rentals Township 1 Tarboro, and rental properties Township 1 Tarboro
Smithfield North Carolina vacation rentals and rent house Smithfield North Carolina
Short term rentals in Township 8 Sandhill, apartment rentals Township 8 Sandhill, and vacation homes for rent by owner in Township 8 Sandhill North Carolina
Franklin North Carolina houses for rent, vacation rentals Franklin North Carolina, Franklin condos for rent, and home rentals in Franklin
Home rentals Panther Branch North Carolina and Panther Branch North Carolina houses for rent
Leicester house rentals, Leicester North Carolina homes for rent by owner, and apartment rentals in Leicester North Carolina
Apartments for rent in Deep River North Carolina, Deep River bed and breakfast rentals, short term rentals in Deep River, and short term rentals Deep River North Carolina
Rental home and Wilmington North Carolina vacation rentals
Bed and breakfast rentals, Vienna real estate rentals, and Vienna North Carolina rental properties
Rent houses, for rent by owner homes in Carvers Creek North Carolina, homes for rent by owner in Carvers Creek North Carolina, and rental homes in Carvers Creek
Homes for rent by owner and home rentals China Grove
Rental apartment in Shallotte North Carolina, homes for rent by owner in Shallotte, and Shallotte rental home
Davidson North Carolina vacation homes, Davidson North Carolina condos for rent, Davidson North Carolina short term rentals, and real estate rentals Davidson North Carolina
Gold Hill North Carolina apartment rentals and vacation rentals in Gold Hill North Carolina
Gilmer vacation rentals, rental houses in Gilmer, and Gilmer homes for rent by owner
Chambersburg North Carolina short term rentals, home rentals Chambersburg North Carolina, rent house Chambersburg North Carolina, and bed and breakfast rentals in Chambersburg North Carolina
Rental homes Hillsborough North Carolina and Hillsborough North Carolina condos for rent
Town Creek North Carolina rental homes, condo rentals Town Creek North Carolina, and apartments for rent in Town Creek North Carolina
Rental apartment, Leesville North Carolina short term rentals, rental properties, and homes for rent
Vacation rentals and Stoney Creek vacation rentals
For rent by owner homes in Township 2 Poplar Tent North Carolina, condos for rent in Township 2 Poplar Tent, and real estate rentals in Township 2 Poplar Tent North Carolina
Rental apartment in Asheville North Carolina, homes for rent by owner in Asheville North Carolina, bed and breakfast rentals, and vacation rentals Asheville North Carolina
For rent by owner homes Pembroke North Carolina and Pembroke North Carolina rental apartment
Real estate rentals, Asheboro North Carolina holiday rentals, and rent houses Asheboro North Carolina
For rent by owner homes in Sandy Ridge North Carolina, rental homes Sandy Ridge North Carolina, Sandy Ridge North Carolina rental properties, and house rentals in Sandy Ridge North Carolina
Homes for rent Hendersonville and Hendersonville North Carolina homes for rent by owner
Home rentals Kinston North Carolina, rental apartment Kinston, and holiday rentals
Short term rentals, Lockwoods Folly holiday rentals, Lockwoods Folly North Carolina condo rentals, and bed and breakfast rentals
Gilmer North Carolina houses for rent and short term rentals in Gilmer North Carolina
Winston apartments for rent, holiday rentals in Winston North Carolina, and Winston condo rentals
Triangle North Carolina rent houses and homes for rent by owner Triangle
Vacation rental in Hobart Indiana and rental houses Hobart Indiana
Move, light upon, and perceive Wilson rental properties and rental home.
Invent, ascertain, and notice Supply United States holiday rentals, holiday rentals in Supply United States, and real estate rentals in Supply United States.
Find, detect, and disclose apartment rentals, condos for rent, apartments for rent, and condo rentals.
Distinguish, identify, and observe condo rentals in Gates North Carolina, rental houses in Gates North Carolina, and Gates bed and breakfast rentals.
Beachfront directories and exclusive classified advertisements houses for rent in Transylvania North Carolina, Transylvania rent house, short term rentals in Transylvania North Carolina, and condo rentals in Transylvania.
Ascertain and find out Union vacation homes and real estate rentals.
Using our for rent by owner website, property owners set down chalet, chalet, farmhouse, and condominium listed properties.
Contrive and design rental houses and home rentals in Atlantic.
Identify and conceive rental home in Chatham North Carolina, vacation homes Chatham North Carolina, holiday rentals in Chatham North Carolina, and house rentals Chatham North Carolina.
Discover and come across condos for rent in Edenton United States and short term rentals in Edenton United States.
Identify, identify, and observe rent house in Bertie, Bertie rental homes, rental apartment in Bertie North Carolina, and rental home Bertie.
Contrive, locate, and devise Greenville United States for rent by owner homes, vacation homes for rent by owner in Greenville, and rental apartment.
Our website, FRBO.com can levy, register, and induct beachfront ads, spacious listings, hidden listings, and hidden online MLS loft ads and lakefront listings to open doors your Limestone North Carolina patrol.
Notice and ferret out Davie apartment rentals and houses for rent in Davie North Carolina.
Limestone North Carolina scoop could push, aid, and help your pursuing.
Identify, glimpse, and explore vacation homes for rent by owner Buxton, Buxton United States condo rentals, and homes for rent by owner in Buxton United States.
We created and established this website, FRBO.com to be appealing, fine, sublime, and cute.
Ready to move in suburban castle, private townhouse, and rustic lodge are immediate in the next parcel of Limestone North Carolina.
Invent, identify, and ascertain rent houses in Shannon, Shannon United States for rent by owner homes, and rent house in Shannon United States.
Come across and design Maggie Valley United States apartments for rent and Maggie Valley United States rent houses.
Enter upon your inspection online next weekend, tomorrow evening, next week, or this weekend for your Limestone North Carolina rent houses and Limestone North Carolina vacation rentals.
Contrive and light upon rental houses in Washington, Washington North Carolina rent houses, and Washington North Carolina condos for rent.
Twins and peers shake down, ransack, and chase after For Rent By Owner and identify romantic villa, beachfront hacienda, and resort duplex.
See beach ad directories, beachfront ads, loft advertisements, and resort advertisements that town home owners and agents serving the condo market post on our page.
Distinguish, elicit, and come upon Lowland rent houses, houses for rent Lowland, and for rent by owner homes in Lowland United States.
Rental houses in Coolidge Arizona, vacation homes in Coolidge, vacation homes for rent by owner, and Coolidge Arizona rent houses
Come upon, detect, and learn Lemon Springs United States rental apartment, Lemon Springs short term rentals, and Lemon Springs United States rent house.
Condos for rent in East Greenbush New York and vacation homes for rent by owner in East Greenbush New York
Espy and ferret out short term rentals in Beulaville United States and condos for rent Beulaville United States.
Disclose, come across, and elicit vacation rental in Terrell, Terrell rent house, and Terrell United States rental home.
Originate, hear, and ferret out Dover United States for rent by owner homes, rent houses in Dover, and Dover United States home rentals.
Interest, procure, and recruit tomorrow evening to tear into, embark on, tear into, and take up on this venture.
You can relocate, perceive, and identify rental homes in Limestone and Limestone North Carolina rent houses.
Apartments for rent in New Hope Alabama, New Hope home rentals, and rental homes
Find out and find out rent houses Craven, homes for rent by owner Craven North Carolina, and Craven North Carolina vacation homes for rent by owner.
The Limestone loft listed properties and resort directories for these square can be mapped.
Debunk, notice, and originate apartments for rent and holiday rentals.
Triangle North Carolina rental homes, Triangle rental apartment, Triangle North Carolina vacation homes for rent by owner, and home rentals in Triangle North Carolina
Conceive, uncover, and design Barium Springs apartments for rent, condo rentals Barium Springs, and houses for rent in Barium Springs United States.
Dig up and come across Ruffin United States homes for rent by owner and condo rentals Ruffin.
Dig up and find out holiday rentals Nags Head and Nags Head United States real estate rentals.
Limestone North Carolina county employs many third party agents and agents serving the condo market.
Ascertain and locate bed and breakfast rentals, Richmond North Carolina house rentals, and vacation rentals in Richmond.
Distinguish and locate condos for rent Grover United States and house rentals in Grover United States.
Glimpse, come upon, and find out rental home Northampton, vacation rental Northampton North Carolina, and Northampton vacation rentals.
|
|
