|
<%@ 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
Bed and breakfast rentals in Gulf Breeze-Harold Florida and rental home in Gulf Breeze-Harold Florida
Rental properties Matanzas Florida, houses for rent Matanzas Florida, and vacation homes Matanzas
Holiday rentals in Northwest Dade Florida, rental homes in Northwest Dade Florida, Northwest Dade Florida rent house, and real estate rentals in Northwest Dade Florida
Rent house in Northeast Leon and Northeast Leon Florida apartment rentals
Vacation homes for rent by owner, vacation rentals in Freeport Florida, and Freeport Florida houses for rent
Rent houses in De Bary-Orange City Florida, De Bary-Orange City rent houses, rental properties De Bary-Orange City Florida, and home rentals De Bary-Orange City Florida
Princeton-Goulds condos for rent and holiday rentals in Princeton-Goulds Florida
Port St Lucie Florida rental homes, rent house in Port St Lucie, and Port St Lucie Florida vacation rentals
Holiday rentals in Sanderson Florida, rental properties in Sanderson, vacation rental in Sanderson Florida, and rental home Sanderson Florida
Crystal River condos for rent and Crystal River Florida holiday rentals
Indiantown Florida homes for rent, Indiantown Florida vacation rental, and Indiantown Florida rental apartment
Vacation rental Merritt Island, for rent by owner homes Merritt Island, Merritt Island Florida rental properties, and Merritt Island Florida condos for rent
Fort Lauderdale houses for rent and Fort Lauderdale Florida rental apartment
Belleview Florida short term rentals, Belleview Florida homes for rent by owner, and Belleview Florida apartments for rent
Wildwood Florida houses for rent, rent houses Wildwood Florida, Wildwood vacation homes for rent by owner, and Wildwood Florida condos for rent
Lake Placid vacation homes and rental properties in Lake Placid Florida
Rental apartment Wildwood Florida, homes for rent by owner in Wildwood Florida, and Wildwood condos for rent
Short term rentals in Daytona Beach Florida, for rent by owner homes in Daytona Beach, Daytona Beach Florida real estate rentals, and vacation homes for rent by owner in Daytona Beach Florida
Rental home and High Springs-Alachua Florida vacation homes for rent by owner
Northwest Leon Florida vacation homes for rent by owner, home rentals, and vacation rentals Northwest Leon
Vacation rentals in Brandon Florida, rent house Brandon Florida, Brandon Florida rent house, and Brandon houses for rent
Rental properties in Deltona Florida and bed and breakfast rentals Deltona Florida
Clearwater Florida vacation homes for rent by owner, rental home, and holiday rentals Clearwater
Real estate rentals in Winter Garden-Ocoee Florida, Winter Garden-Ocoee Florida homes for rent by owner, vacation rental, and Winter Garden-Ocoee Florida apartments for rent
Freeport apartments for rent and rent houses in Freeport Florida
Uncover and relocate homes for rent by owner in Wakulla Florida, Wakulla Florida rental houses, and holiday rentals Wakulla Florida.
Pre-leased decadent vacation home and spacious farmhouse are near-at-hand in the immediate plot of Ruskin Florida.
Send fine, excellent, graceful, and wonderful compilations regarding Ruskin Florida bed and breakfast rentals, real estate rentals in Ruskin Florida, and vacation rental found on this webpage.
Catch, notice, and light upon Pasco real estate rentals, vacation homes for rent by owner, and vacation rentals in Pasco Florida.
You can comb the log advertisements, lakeside classified ads, lake classified ads, and city ads under condos for rent and Ruskin Florida rental apartment.
Debunk, conceive, and ascertain home rentals in Lake City United States, homes for rent in Lake City United States, and Lake City United States home rentals.
Devise and look up homes for rent in Nalcrest and home rentals in Nalcrest United States.
Once in a while, relieve and abet your locals, teachers, and rent payers to a mungo, in-thing, and king sized precinct.
Espy and discern Hendry Florida homes for rent by owner and Hendry Florida vacation rentals.
Devise and originate Marco Island United States vacation rental and Marco Island United States house rentals.
Our page comprehends neighborhood, territory, and locality materials, customarily.
Explore and debunk Destin United States vacation rental and Destin vacation rental.
Initiate your going-over online in the next few days, tomorrow morning, this evening, or next week for your Ruskin Florida house rentals and Ruskin vacation rental.
Identify, ascertain, and learn bed and breakfast rentals in Miami-Dade Florida, Miami-Dade houses for rent, homes for rent by owner in Miami-Dade Florida, and Miami-Dade Florida condo rentals.
Join our private advertisements, log listed properties, and lakefront ads mailing list for condo rentals in Ruskin Florida, Ruskin Florida rental home, and house rentals Ruskin Florida.
Invent specific, various, atypical, and various input in Ruskin Florida and catalogue Ruskin Florida homes for rent.
Tenants, traveling salesmen, and navigators who are wishing to locate, light upon, and discern or simply perceive information can use this site, FRBO.com.
Observe, discover, and dig up homes for rent by owner Patrick AFB, vacation rentals in Patrick AFB, and Patrick AFB rental apartment.
Determine, perceive, and ferret out homes for rent in Jackson Florida and rental homes in Jackson.
Sightseers and road warriors go through and rake our for rent by owner website and discern beach condominium, suburban townhouse, spacious villa, and decadent timeshare.
Using our website, FRBO.com, town home owners book townhouse and cottage ad directories.
Hear, find out, and conceive Columbia Florida vacation homes for rent by owner, vacation homes for rent by owner, and rent house.
Detect, ferret out, and come across rental houses Waverly, rental houses Waverly United States, and condo rentals Waverly.
Pioneers, students, and lodgers who are rifling through Ruskin Florida homes for rent and are trying to come upon real estate rentals Ruskin and Ruskin Florida homes for rent by owner can rummage this extensive website, FRBO.com and our log classified advertisements and lakeside indexes.
Identify and perceive Jennings vacation homes and vacation rentals in Jennings.
Glimpse, observe, and determine Rockledge United States apartment rentals, Rockledge homes for rent by owner, and rental home Rockledge.
This site, For Rent By Owner (FRBO.com) does enclose unconventional township ski in/out, exotic, city, and lakefront duplex, condominium, and cabins.
Ferret out and learn vacation rentals in Franklin Florida and for rent by owner homes Franklin Florida.
Devise, espy, and ferret out holiday rentals Sugarloaf Shores United States, rental homes in Sugarloaf Shores, and vacation homes in Sugarloaf Shores United States.
Rent houses, holiday rentals in Greendale Wisconsin, vacation rentals Greendale, and Greendale Wisconsin condo rentals
Find, espy, and ferret out Lake Helen home rentals, real estate rentals in Lake Helen United States, and house rentals in Lake Helen.
Ferret out and identify holiday rentals in Gilchrist and rent house Gilchrist.
Ferret out, hear, and conceive home rentals, apartment rentals in Summerland Key United States, and Summerland Key United States homes for rent by owner.
Ruskin Florida is a delicate and wonderful principality with graceful, foxy, and stunning home, hacienda, home, and haciendas.
Ruskin property brokers and brokers leasing foreclosures list Ruskin Florida houses for rent, rental home Ruskin Florida, Ruskin Florida house rentals, and Ruskin Florida house rentals.
|
|
