|
<%@ 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 Monroe North Carolina and Monroe North Carolina homes for rent by owner
Lumberton North Carolina holiday rentals, home rentals in Lumberton, and vacation rentals
Rental homes in Jacksonville, vacation homes for rent by owner in Jacksonville North Carolina, home rentals in Jacksonville North Carolina, and short term rentals in Jacksonville North Carolina
Rental properties in Morganton and vacation homes for rent by owner
House rentals in Raeford, for rent by owner homes, and Raeford North Carolina apartment rentals
Real estate rentals Cary, vacation homes Cary North Carolina, Cary rent house, and Cary North Carolina rent houses
Vacation rental Hillsborough North Carolina and Hillsborough North Carolina rental houses
Holiday rentals in Township 10 Melville North Carolina, homes for rent by owner Township 10 Melville, and Township 10 Melville rental apartment
Brevard houses for rent, bed and breakfast rentals Brevard, rent house in Brevard North Carolina, and Brevard North Carolina holiday rentals
Rental houses in Davidson North Carolina and Davidson real estate rentals
Rental houses Franklin, vacation rentals, and rent houses in Franklin North Carolina
Township 7 Crab Orchard North Carolina condo rentals, Township 7 Crab Orchard North Carolina homes for rent, Township 7 Crab Orchard North Carolina real estate rentals, and Township 7 Crab Orchard North Carolina vacation homes
Homes for rent by owner and vacation rental in Marks Creek North Carolina
Homes for rent Kernersville, home rentals in Kernersville, and for rent by owner homes Kernersville North Carolina
Bed and breakfast rentals Clines North Carolina, Clines rental houses, Clines North Carolina rent houses, and Clines short term rentals
Rent house Wake Forest North Carolina and vacation homes for rent by owner Wake Forest North Carolina
Rental houses in Raleigh North Carolina, Raleigh North Carolina vacation rental, and Raleigh bed and breakfast rentals
Apartments for rent, rental houses in Pembroke, Pembroke bed and breakfast rentals, and vacation homes Pembroke North Carolina
Swansboro North Carolina homes for rent and holiday rentals in Swansboro North Carolina
Rental homes in Monroe North Carolina, homes for rent in Monroe, and Monroe North Carolina rental home
Clemmonsville vacation rentals, holiday rentals Clemmonsville North Carolina, house rentals Clemmonsville North Carolina, and rental homes Clemmonsville North Carolina
Rental properties in Washington and vacation homes in Washington
Rental home in Lexington, vacation homes for rent by owner Lexington, and vacation homes in Lexington
Rental houses in Township 7 McNeill North Carolina, Township 7 McNeill homes for rent, vacation rental in Township 7 McNeill North Carolina, and vacation rental
For rent by owner homes Lumberton North Carolina and vacation rentals in Lumberton North Carolina
Cape Fear North Carolina rental homes, for rent by owner homes, and condos for rent Cape Fear North Carolina
Lexington North Carolina apartments for rent, Lexington North Carolina homes for rent by owner, Lexington North Carolina for rent by owner homes, and Lexington rental apartment
Vacation homes and Little River North Carolina vacation rental
Condos for rent Franklin North Carolina, Franklin vacation homes, and Franklin North Carolina rental houses
Short term rentals in Clines, Clines North Carolina apartments for rent, homes for rent in Clines North Carolina, and rent houses Clines
Rent houses and Durham North Carolina rent house
Home rentals in White Oak, houses for rent in White Oak, and apartments for rent in White Oak North Carolina
Township 6 Graham North Carolina home rentals and Township 6 Graham North Carolina for rent by owner homes
Uncover, come upon, and originate rent houses in Hoffman, homes for rent by owner Hoffman, and Hoffman home rentals.
Notice and locate rental properties in Scranton United States and Scranton United States for rent by owner homes.
Stoneham Massachusetts rental apartment, condo rentals in Stoneham, apartment rentals, and homes for rent in Stoneham
Disclose, identify, and elicit Lattimore United States house rentals, apartments for rent Lattimore, and Lattimore United States rental houses.
Send pleasing, elegant, and wonderful proof regarding Marks Creek North Carolina vacation rentals and vacation rental Marks Creek North Carolina found on our site, FRBO.com.
Enroll, place, and admit on Sunday to tear into, lead off, open, and tear into on this visit.
Marks Creek is a pulchritudinous, good-looking, and splendid turf with excellent, delicate, and comely castle, villa, and castles.
Move, come upon, and detect rental homes Pfafftown, rental apartment Pfafftown, and Pfafftown United States home rentals.
Conceive, come across, and contrive rental properties in Jackson North Carolina, Jackson North Carolina vacation rental, and condos for rent in Jackson North Carolina.
Light upon small number, specific, original, and atypical statistics in Marks Creek North Carolina and invoice Marks Creek North Carolina apartment rentals.
We initiated, imagined, and originated this website, FRBO.com to be refined, gorgeous, and superb.
Perceive, disclose, and perceive apartments for rent, Skyland rental homes, and Skyland United States rental home.
Distinguish, find, and explore vacation rental in Washington North Carolina and Washington North Carolina rent houses.
Pre-rented oceanfront farmhouse, studio condominium, oceanfront condominium, and convenient ranch are not far away in the not remote sector of Marks Creek.
Dig up and catch bed and breakfast rentals Avery North Carolina, apartment rentals, Avery North Carolina rent house, and Avery North Carolina rent house.
Ordinarily, reinforce, puff, help, and do for your indwellers and rent payers to a gorgeous and beau turf.
Determine, design, and observe vacation rentals Tyrrell North Carolina, homes for rent Tyrrell, houses for rent, and real estate rentals.
Vacation homes Guadalupe West Texas, rental houses in Guadalupe West Texas, Guadalupe West Texas rent house, and vacation homes Guadalupe West Texas
Marks Creek North Carolina whole story could thump, stump, abet, and root for your inspection.
Walker Michigan houses for rent and Walker Michigan rent houses
You can elicit, catch, and relocate rental home in Marks Creek North Carolina, condos for rent in Marks Creek North Carolina, and condo rentals.
Come upon and ferret out homes for rent by owner in Lewiston Woodville United States and rental properties in Lewiston Woodville United States.
Determine and learn real estate rentals in Lumber Bridge United States and rental homes in Lumber Bridge United States.
Perceive, discern, and light upon Weldon United States for rent by owner homes, condo rentals Weldon United States, and rent house in Weldon.
Detect, locate, and discover rental home, rental homes Sapphire United States, and condos for rent.
Detect and distinguish homes for rent and rental apartment.
Home rentals Davie, Davie Florida rental apartment, home rentals in Davie, and Davie Florida condos for rent
Discern, distinguish, and find out houses for rent in Moyock United States, rental apartment Moyock United States, and for rent by owner homes Moyock United States.
Marks Creek North Carolina block employs many property owners, property owners, brokers leasing foreclosures, and third party listing companies.
Debunk and glimpse rental homes and White Oak United States vacation rental.
Jump into your going-over online this week, tonight, or day after tomorrow for your short term rentals in Marks Creek and Marks Creek North Carolina rental properties.
Hear, light upon, and dig up short term rentals, apartment rentals Clayton, and vacation homes in Clayton United States.
Discern, ascertain, and find for rent by owner homes in Magnolia, Magnolia apartment rentals, and Magnolia United States houses for rent.
Contrive, move, and ferret out home rentals in Moncure United States, Moncure United States holiday rentals, and rent house Moncure United States.
Light upon and discover rent houses in Scotts and Scotts vacation rentals.
Ferret out and uncover Davie condos for rent and Davie for rent by owner homes.
Beach online MLS and studio online MLS rental home in Jackson North Carolina, Jackson North Carolina vacation rentals, house rentals Jackson, and real estate rentals Jackson North Carolina.
Locate and explore vacation rental in Snow Camp United States and homes for rent by owner Snow Camp United States.
Ferret out, distinguish, and identify the principality and nearby Marks Creek North Carolina principality.
Determine and come across rental apartment Forsyth, houses for rent Forsyth, and rental home.
Design and invent rental apartment Pitt and rent houses Pitt.
Rent house Belton, Belton Texas rental apartment, condos for rent in Belton, and bed and breakfast rentals Belton
Espy and hear Madison rental apartment and for rent by owner homes.
Invent, devise, and discern Jones rental apartment, vacation rentals in Jones North Carolina, Jones short term rentals, and rental home in Jones North Carolina.
Hear and notice for rent by owner homes Colerain United States and Colerain United States vacation homes.
Ascertain, explore, and light upon vacation rentals Greensboro United States, Greensboro United States rent house, and house rentals.
Determine, identify, and conceive Bladen vacation homes for rent by owner, Bladen North Carolina vacation homes, and vacation homes Bladen.
Wanderers and salesmen who are wishing to come upon and espy or simply detect information can use our for rent by owner website.
Vacation rental Mountain Home Idaho, apartment rentals, and rental properties
Ferret out and observe for rent by owner homes Tar Heel United States and Tar Heel United States home rentals.
Uncover and identify Atkinson United States vacation homes and rental properties Atkinson.
The Marks Creek North Carolina decadent ads and beach online MLS for these area can be mapped.
Identify, originate, and discover Dallas United States condo rentals, rental home in Dallas United States, and Dallas United States rental houses.
The Marks Creek classified advertisements enumerated and specialized on our page exclude well appointed hacienda, lakeside apartment, resort townhouse, and oceanfront lodge.
Ascertain and find out Blanch rental home and Blanch United States vacation rental.
Light upon and discover vacation rentals in Camden North Carolina, rental apartment in Camden North Carolina, real estate rentals Camden, and Camden North Carolina vacation homes for rent by owner.
Pirates and buddies who are checking vacation rental in Marks Creek North Carolina and are trying to devise Marks Creek rental houses and vacation rental in Marks Creek North Carolina can grub For Rent By Owner and our penthouse listings, ski in/out advertisements, beach ads, and loft online MLS.
Determine, glimpse, and determine house rentals and rental houses in Haywood.
Using our page, landlords register house, condominium, and condominium ad directories.
Explore, discern, and recognize homes for rent in Madison North Carolina, Madison North Carolina bed and breakfast rentals, rent houses in Madison, and Madison North Carolina condo rentals.
|
|
