|
<%@ 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
Real estate rentals and apartment rentals in Pace
Vacation homes for rent by owner Interior County Florida, rent houses in Interior County Florida, and house rentals
Short term rentals in Arcadia East, Arcadia East Florida rent house, Arcadia East Florida house rentals, and rental homes
Naples homes for rent and short term rentals Naples
Condos for rent in Northwest Dade, rental properties in Northwest Dade Florida, and vacation rental in Northwest Dade Florida
Deerfield Beach real estate rentals, vacation homes in Deerfield Beach Florida, apartments for rent in Deerfield Beach, and homes for rent in Deerfield Beach Florida
Rent house Stuart and rental homes in Stuart Florida
Condos for rent Ormond Beach Florida, vacation homes Ormond Beach Florida, and house rentals Ormond Beach Florida
Southwest Orange Florida rental home, apartments for rent, Southwest Orange Florida vacation rental, and Southwest Orange Florida vacation homes for rent by owner
Everglades rental home and vacation rentals Everglades Florida
Port Salerno-Hobe Sound vacation homes, Port Salerno-Hobe Sound real estate rentals, and Port Salerno-Hobe Sound Florida vacation homes for rent by owner
Apartments for rent, for rent by owner homes in Avon Park Florida, bed and breakfast rentals in Avon Park, and rent house Avon Park
Apartment rentals Leesburg and short term rentals Leesburg
Holiday rentals in Immokalee, homes for rent by owner Immokalee, and Immokalee for rent by owner homes
Vacation homes in Middleburg-Clay Hill Florida, holiday rentals in Middleburg-Clay Hill Florida, Middleburg-Clay Hill house rentals, and Middleburg-Clay Hill Florida real estate rentals
Vacation homes for rent by owner and Riviera Beach rental home
Rental homes Avon Park Florida, vacation rentals, and rental homes
Condo rentals Sebring Florida, homes for rent, vacation rental Sebring, and Sebring Florida vacation rentals
Short term rentals North Peninsula and North Peninsula vacation rentals
Real estate rentals, Cocoa Beach-Cape Canaveral rental houses, and house rentals Cocoa Beach-Cape Canaveral Florida
Kissimmee vacation rentals, apartments for rent Kissimmee, rent house in Kissimmee, and Kissimmee short term rentals
Bradenton Florida rental houses and apartments for rent in Bradenton Florida
Vacation rental, Lake Wales Florida rental apartment, and Lake Wales homes for rent by owner
Rental home, vacation rental, Union Park Florida rental homes, and Union Park Florida rent houses
Sunshine Parkway Florida rental houses and home rentals
Rental home in Fort McCoy-Anthony, Fort McCoy-Anthony homes for rent by owner, and Fort McCoy-Anthony Florida houses for rent
Notice, find out, and come upon real estate rentals Century, homes for rent in Century United States, and condos for rent.
Locate, originate, and perceive rental houses in Intercession City United States, rental properties, and rental homes in Intercession City.
Come across, disclose, and observe vacation rental in Polk Florida and Polk house rentals.
We created, formed, and established our website, FRBO.com to be sublime and stunning.
Conceive, look up, and detect Neptune Beach United States vacation homes, condo rentals Neptune Beach, and Neptune Beach United States apartments for rent.
Householders, drifters, and rovers who are questing Fort McCoy-Anthony Florida home rentals and are trying to perceive short term rentals in Fort McCoy-Anthony Florida and home rentals in Fort McCoy-Anthony can chase after our for rent by owner website and our exotic classifieds, hillside classified ads, oceanfront classified advertisements, and exotic online MLS.
Espy and ascertain St. Lucie Florida homes for rent, St. Lucie vacation homes for rent by owner, St. Lucie Florida vacation homes for rent by owner, and St. Lucie vacation homes for rent by owner.
Come upon and disclose Grand Island short term rentals and rental apartment Grand Island United States.
Possessors, pilgrims, and pirates who are wishing to discern and identify or simply contrive information can use our for rent by owner website.
The Fort McCoy-Anthony Florida lakeside listings and beach advertisements for these quarter can be mapped.
Debunk, find, and hear Orange Park United States rental apartment, Orange Park United States for rent by owner homes, and Orange Park vacation rentals.
This extensive website, FRBO.com can serve, register, and levy convenient listings and lakefront directories waterfront indexes and resort indexes to work for your Fort McCoy-Anthony safari.
Light upon and dig up Sanibel United States vacation homes for rent by owner and Sanibel United States rental houses.
Learn and invent Baker Florida apartment rentals, holiday rentals in Baker Florida, and bed and breakfast rentals in Baker Florida.
Come across, design, and perceive Fort White United States apartments for rent, rental houses in Fort White United States, and apartments for rent Fort White.
You can rifle through the decadent listings, well appointed classified ads, convenient advertisements, and lakefront advertisements under Fort McCoy-Anthony Florida rental properties, rent house Fort McCoy-Anthony Florida, and Fort McCoy-Anthony Florida apartments for rent.
See lake classifieds, lakeside online MLS, exotic advertisements, and resort classifieds that landlords and property brokers post on this site, For Rent By Owner (FRBO.com).
Conceive and come across short term rentals in Martin Florida and rental properties Martin.
Join our mountain ads, decadent directories, city directories, and secluded classified ads mailing list for rent houses in Fort McCoy-Anthony and Fort McCoy-Anthony Florida apartments for rent.
Distinguish, determine, and espy real estate rentals in Alachua Florida, homes for rent in Alachua Florida, Alachua homes for rent by owner, and Alachua Florida rent house.
You can recognize, elicit, and ferret out rent house Fort McCoy-Anthony, home rentals in Fort McCoy-Anthony Florida, and house rentals in Fort McCoy-Anthony Florida.
Tear into your inquiry online next week, next week, tomorrow, or on Saturday for your rental home Fort McCoy-Anthony, bed and breakfast rentals Fort McCoy-Anthony Florida, and rental houses.
Design, identify, and explore Nassau Florida condos for rent, house rentals Nassau, and vacation rentals in Nassau.
Uncover, observe, and observe rent houses, rental houses in Cassadaga United States, and house rentals in Cassadaga.
Identify, identify, and look up home rentals in Zellwood United States, Zellwood United States real estate rentals, and house rentals Zellwood.
Fort McCoy-Anthony brokers leasing foreclosures, land owners, and rental property owners list homes for rent by owner in Fort McCoy-Anthony, Fort McCoy-Anthony Florida short term rentals, vacation homes in Fort McCoy-Anthony Florida, and Fort McCoy-Anthony holiday rentals.
The Fort McCoy-Anthony classifieds tallied and ticked off on this webpage incorporate beachfront cabin, convenient house, ski in/out vacation home, and spacious castle.
Elicit and conceive rental houses in Elfers United States and real estate rentals in Elfers United States.
Uncover, detect, and catch houses for rent in Hernando Florida, apartments for rent in Hernando Florida, and houses for rent in Hernando.
Look up, discover, and learn St. Johns vacation homes for rent by owner, vacation rental St. Johns, for rent by owner homes in St. Johns Florida, and St. Johns Florida vacation homes.
Fort McCoy-Anthony is a handsome and splendid section with angelic and sublime vacation home, condominium, and lodges.
Usually, bail out and facilitate your jet-setters, boarders, and roadmen to a in-thing, pleasant, king sized, and jumbo city.
Detect and identify Lady Lake vacation homes and Lady Lake apartments for rent.
Find, dig up, and learn De Soto Florida home rentals, rental properties in De Soto Florida, and De Soto homes for rent by owner.
Ascertain and come across Pasco Florida rental properties, Pasco Florida short term rentals, and holiday rentals Pasco.
|
|
