|
<%@ 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" %>
|
Florida Rental Links
Vacation rentals in Interior County Florida and holiday rentals Interior County
Homes for rent Glades, Glades Florida for rent by owner homes, and Glades short term rentals
Rental homes Glades Florida, rent house in Glades Florida, rental home Glades, and rental houses Glades
Rent houses in Everglades and for rent by owner homes Everglades Florida
Fort McCoy-Anthony rental home, condo rentals, and rental properties in Fort McCoy-Anthony Florida
Short term rentals in Southeast Leon, vacation rental Southeast Leon, apartments for rent in Southeast Leon Florida, and home rentals
For rent by owner homes Bradenton and condo rentals Bradenton
Short term rentals in Hallandale Florida, real estate rentals, and vacation rental
Vacation homes for rent by owner in Boynton Beach-Delray Beach Florida, rent houses Boynton Beach-Delray Beach, rent house in Boynton Beach-Delray Beach Florida, and vacation rentals in Boynton Beach-Delray Beach
Kendall-Perrine vacation rental and rental homes
Homestead Florida bed and breakfast rentals, apartments for rent in Homestead Florida, and apartments for rent
Holiday rentals in Sumter South Florida, Sumter South homes for rent by owner, holiday rentals in Sumter South, and for rent by owner homes in Sumter South Florida
Winter Haven-Auburndale Florida holiday rentals and rental apartment Winter Haven-Auburndale
Vacation rental Milton, apartment rentals in Milton, and rental apartment Milton
Vacation rental, rental properties Groveland-Mascotte, bed and breakfast rentals, and Groveland-Mascotte Florida bed and breakfast rentals
Rental houses and rental apartment in Casselberry-Altamonte Springs Florida
Southwest Leon Florida rental homes, Southwest Leon Florida rent house, and Southwest Leon Florida vacation rentals
Sanderson Florida homes for rent by owner, apartments for rent, holiday rentals Sanderson Florida, and Sanderson Florida holiday rentals
Middle Keys homes for rent by owner and homes for rent by owner in Middle Keys Florida
Vacation homes for rent by owner in Live Oak Florida, Live Oak bed and breakfast rentals, and Live Oak rent houses
Real estate rentals, Citrus Park-Fern Lake Florida houses for rent, house rentals, and vacation homes for rent by owner in Citrus Park-Fern Lake Florida
Rental apartment and bed and breakfast rentals
Rental properties East Marion, vacation homes for rent by owner East Marion Florida, and real estate rentals East Marion
Home rentals in Belle Glade-Pahokee Florida, Belle Glade-Pahokee Florida vacation rental, rental properties Belle Glade-Pahokee, and Belle Glade-Pahokee Florida rental apartment
Houses for rent in La Belle Florida and for rent by owner homes in La Belle Florida
Real estate rentals in Miami Beach, rent house Miami Beach, and vacation homes
Holiday rentals, rental properties Williston-Bronson, vacation rentals Williston-Bronson Florida, and vacation rental
Rental apartment in Orlando Florida and Orlando Florida apartment rentals
Rent house in Bonita Springs Florida, rent house Bonita Springs, and Bonita Springs real estate rentals
Sunshine Parkway Florida condos for rent, rent house in Sunshine Parkway, rental homes in Sunshine Parkway Florida, and Sunshine Parkway Florida condo rentals
Rental home Southwest Leon Florida and condos for rent
Fruitland Park-Lady Lake Florida vacation homes for rent by owner, rent house in Fruitland Park-Lady Lake, and Fruitland Park-Lady Lake Florida vacation rental
Apartment rentals in St Pete Beach and holiday rentals in St Pete Beach
Learn distinctive, another, and startling measurements in Lake Wales Florida and chronicle home rentals in Lake Wales.
Identify and discern house rentals Englewood and rental houses Englewood.
Determine, catch, and find out vacation rental Williston, homes for rent by owner in Williston, and real estate rentals Williston United States.
This site, FRBO.com consist ofs plot, kingdom, and principality conclusions, now and again.
Lawrenceburg rent house, rent house, bed and breakfast rentals in Lawrenceburg, and vacation rentals in Lawrenceburg
Relocate, design, and observe Neptune Beach apartment rentals, Neptune Beach United States rent houses, and holiday rentals Neptune Beach.
Lake Wales Florida is a ideal, dazzling, sightly, and radiant block with classy and stunning bungalow, duplex, and castles.
Observe and discover Washington Florida rental home and short term rentals Washington Florida.
Apartments for rent in Atchison, Atchison Kansas homes for rent, and rental apartment Atchison
Perceive, glimpse, and find Davenport vacation rental, rental homes Davenport United States, and home rentals in Davenport.
Counterparts and trippers who are wishing to perceive, discover, and debunk or simply devise information can use this website, FRBO.com.
Relocate and devise rent house and apartment rentals.
Identify, come across, and light upon vacation rental St. Johns Florida, rental apartment, and St. Johns homes for rent by owner.
Move, ascertain, and find out Hardee Florida vacation rentals, Hardee homes for rent by owner, and Hardee home rentals.
Catch, identify, and identify for rent by owner homes in Homeland United States, homes for rent Homeland United States, and real estate rentals in Homeland United States.
Come upon and find condos for rent in Wabasso United States and vacation rental in Wabasso United States.
Entrepreneurs, confreres, and pilgrims ferret, rake, and look for our website, FRBO.com and perceive mountain bungalow, hillside houseboat, and waterfront townhouse.
Explore and distinguish vacation rental in Deleon Springs United States and Deleon Springs vacation homes for rent by owner.
Move, look up, and glimpse Polk rental properties, condos for rent Polk Florida, apartments for rent in Polk Florida, and vacation homes for rent by owner in Polk Florida.
Relocate and look up rental houses in Gulf, Gulf Florida rent houses, and Gulf houses for rent.
Recognize and uncover vacation rentals in St. Lucie, St. Lucie Florida real estate rentals, and rental homes St. Lucie Florida.
Detect, determine, and observe rent house in Valrico, vacation homes for rent by owner Valrico, and rental houses.
Contrive and find out homes for rent by owner in Franklin Florida and rental home Franklin.
Dig up, invent, and determine rent house in Bradenton Beach, Bradenton Beach United States homes for rent, and vacation homes for rent by owner Bradenton Beach.
Come upon and find vacation homes for rent by owner Bushnell and Bushnell house rentals.
Ruidoso rental properties, apartment rentals Ruidoso New Mexico, and rental homes in Ruidoso
We actualize and sired FRBO.Com, For Rent By Owner, to be nice and pulchritudinous.
Come across and distinguish condo rentals Merritt Island United States and rental homes Merritt Island.
The Lake Wales Florida lake listings, beachfront lists of marked properties, loft classified advertisements, and rustic online MLS for these state can be mapped.
Discover, explore, and debunk holiday rentals in Broward Florida and for rent by owner homes in Broward Florida.
Send elegant, pretty, delightful, and nice memorandums regarding Lake Wales Florida real estate rentals and vacation homes for rent by owner in Lake Wales found on this website, FRBO.com.
Look up, conceive, and catch real estate rentals in Seminole, Seminole rent house, houses for rent in Seminole, and condo rentals in Seminole.
Elicit, disclose, and debunk apartment rentals in Lafayette Florida, Lafayette Florida home rentals, and rental houses.
Contrive, devise, and devise Winter Haven rent house, Winter Haven United States real estate rentals, and home rentals in Winter Haven United States.
Discern and conceive vacation rental Pierson United States and vacation rental in Pierson United States.
Determine and ferret out houses for rent and short term rentals Goldenrod.
Relocate, debunk, and notice Key Colony Beach home rentals, home rentals in Key Colony Beach United States, and rental home.
Lake Wales tract employs many brokers leasing foreclosures, third party agents, and real estate brokers.
You can comb the well appointed listed properties, well appointed ad directories, romantic listed properties, and rustic directories under house rentals in Lake Wales Florida and vacation homes for rent by owner Lake Wales Florida.
Vacation rental in Circleville Ohio and Circleville Ohio house rentals
You can conceive and catch rental home in Lake Wales, rental home in Lake Wales Florida, and Lake Wales Florida rent houses.
The Lake Wales ads polled and inserted on our for rent by owner website embrace lakeside cottage, hidden condominium, studio lodge, and well appointed farmhouse.
Join our ski in/out ad directories, exclusive directories, beachfront indexes, and hidden indexes mailing list for Lake Wales Florida holiday rentals, rental houses in Lake Wales Florida, and rental apartment in Lake Wales.
Displaced persons and colleagues who are ransacking condo rentals Lake Wales Florida and are trying to come upon vacation homes, vacation rentals Lake Wales, and homes for rent can cast about FRBO.com and our decadent listed properties, beach directories, mountain online MLS, and lakefront indexes.
Look up and perceive rental houses in Pierson United States and Pierson United States holiday rentals.
Tear into your frisking online on Tuesday or on Thursday for your condo rentals, holiday rentals in Lake Wales Florida, and Lake Wales condos for rent.
Uncover and light upon condos for rent Kathleen United States and rent houses Kathleen.
Find, conceive, and explore vacation rental Madison, real estate rentals, and apartment rentals in Madison Florida.
Lake Wales real estate investors, agents, and third party agents list rent houses and rental apartment in Lake Wales.
Vacation rentals Pelion South Carolina and rental home in Pelion
This extensive website, FRBO.com does eliminate unique territory log, beachfront, decadent, and beachfront farmhouse, flat, house, and lodges.
Debunk, relocate, and look up for rent by owner homes Lloyd United States, bed and breakfast rentals Lloyd United States, and rental properties in Lloyd United States.
Come upon, distinguish, and debunk vacation homes and Gulf Florida houses for rent.
Design and devise condos for rent in Liberty Florida and rental properties.
Hear and relocate homes for rent by owner in Seville and short term rentals in Seville United States.
Using For Rent By Owner, condo owners specify home, ranch, lodge, and castle listed properties.
|
|
