<%@ include file="/WEB-INF/jsp/radius_function.jsp" %> <% try { // lat and lng definition are on file city_scriptlet.jspf double[] cords = getRadiusCords(60, lat, lng); Class.forName("com.mysql.jdbc.Driver"); Connection 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 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"); 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(); %> <% } con.close(); } catch(Exception e) {out.print(e.toString()); out.print(e.getMessage()); } %>

Property ID	Address	Country	Bedrooms	Bathrooms	Square feet
#<%=property_id%>	<%=address%>	<%=country_name%>	<%=bedrooms%>	<%=bathrooms%>	<%=sqft%>

Market your <%=city_name%> property for FREE!!!



We are now live. Welcome to the new FRBO.com, For Rent By Owner properties aimed at the vacation rental market. Property owners can now list properties on the site. We will be adding additional functionalitie over the next month. We are excited about this opportunity. Please provide us feedback and any suggestions you might have. We specialize in marketing <%=city_name%> rental homes, <%=city_name%> homes for rent, <%=city_name%> property management, and <%=city_name%> vacation rentals.

We are now live. Welcome to the new FRBO.com, For Rent By Owner properties aimed at the vacation rental market. Property owners can now list properties on the site. We will be adding additional functionalitie over the next month. We are excited about this opportunity. Please provide us feedback and any suggestions you might have.

We are currently offering specials for listing you property with us. Each listing includes:

1. Up to 15 Photos
2. Up to 20 rate schedules (by season, etc.)
3. 30-day money back guarantee
4. Online calendar and availablity system (by the end of the February)
5. Advertise to the more than 16,000 unique visitors we receieve each month

While we are just starting the listing service, our website has been receiving traffic over the past 2 years. We will be tracking this traffic over on the "Traffic" area. This is before we start our promotional efforts.

Register and list your <%=city_name%> property today.

FREE

Our <%=city_name%> visitors are looking for their next vacation rental in <%=city_name%>. Get in early and have an advantage to over your fellow <%=city_name%> rental property owner. Vacation Rentals By indie Owners is a large fragmented <%=city_name%> market. On an ongoing basis, our strategy is to offer a superior product at a lower cost to the <%=city_name%> vacation rental property owner.

We continue to add enhancements to the site. We also welcome your feedback.

Please send the word out to your friends and relatives.

Thanks for supporting us in our start-up.

The FRBO.com, For Rent By Owner, Team