|
<%@ 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
Rental houses in Century and condos for rent in Century
Rental properties in Palm River-East Tampa Florida, Palm River-East Tampa rental home, and vacation rental in Palm River-East Tampa Florida
Rental homes in Okeechobee Florida, real estate rentals Okeechobee, apartments for rent in Okeechobee, and home rentals in Okeechobee Florida
Clermont for rent by owner homes and rental properties in Clermont
Home rentals, homes for rent by owner in Wauchula Florida, and Wauchula rental homes
Jupiter Florida rent house, Jupiter houses for rent, Jupiter Florida rental homes, and Jupiter Florida rental houses
Fort Pierce Florida vacation homes for rent by owner and condo rentals in Fort Pierce Florida
Arcadia West homes for rent by owner, Arcadia West Florida rent houses, and Arcadia West holiday rentals
For rent by owner homes in Leesburg, vacation homes for rent by owner in Leesburg Florida, Leesburg Florida bed and breakfast rentals, and Leesburg short term rentals
Union Park Florida rent house and rental home in Union Park Florida
Ocala Florida rental houses, house rentals Ocala, and condo rentals Ocala
Homestead Florida home rentals, vacation homes in Homestead Florida, rental houses in Homestead Florida, and Homestead Florida rent house
Indialantic-Melbourne Beach rental home and Indialantic-Melbourne Beach homes for rent
Short term rentals in Malabar, houses for rent, and Malabar Florida homes for rent by owner
Holiday rentals in North Peninsula Florida, real estate rentals North Peninsula Florida, vacation rentals North Peninsula, and vacation rentals North Peninsula
Palm River-East Tampa rent houses and rental homes in Palm River-East Tampa Florida
House rentals Hialeah Florida, condo rentals Hialeah Florida, and Hialeah Florida rental apartment
Rental home Flagler Beach, Flagler Beach Florida for rent by owner homes, apartments for rent, and holiday rentals
Havana Florida apartment rentals and Havana Florida vacation homes
Dunnellon Florida rental houses, Dunnellon vacation homes for rent by owner, and Dunnellon condos for rent
Rental properties in St Pete Beach Florida, rental homes St Pete Beach Florida, home rentals St Pete Beach, and homes for rent by owner St Pete Beach Florida
Perry North Florida homes for rent by owner and vacation homes for rent by owner in Perry North
Houses for rent Palmetto Florida, Palmetto Florida rental homes, and Palmetto Florida house rentals
Houses for rent, condos for rent Union Park Florida, home rentals, and condo rentals in Union Park
Glades Florida rent house and bed and breakfast rentals in Glades Florida
De Funiak Springs Florida home rentals, apartments for rent, and rental properties De Funiak Springs
We made, instituted, and erected this site, For Rent By Owner (FRBO.com) to be superb and good-looking.
Come across and contrive the dominion and not faraway Haines City plot.
Condos for rent in Hazard and Hazard Kentucky condos for rent
Identify, notice, and recognize rental apartment in Alachua Florida, rental properties Alachua, and apartments for rent Alachua Florida.
Conceive, espy, and come across houses for rent in Union Florida and houses for rent in Union Florida.
Sporadically, stump, benefit, and run interference your boarders and co-workers to a pretty, run after, stuffed, and comely state.
You can cast about the lakeside ads, spacious ads, suburban advertisements, and beach ad directories under short term rentals Haines City, Haines City rental apartment, and Haines City Florida rental home.
Locals and gypsies comb, cast about, and examine our for rent by owner website and conceive romantic chalet, penthouse condominium, spacious villa, and spacious lodge.
Distinguish and ascertain rental apartment Lanark Village and Lanark Village United States vacation rentals.
Notice, come upon, and uncover homes for rent by owner in Boca Grande United States, rent houses Boca Grande, and rental properties in Boca Grande United States.
Haines City property brokers, real estate investors, and property agents list Haines City Florida home rentals, homes for rent Haines City Florida, Haines City short term rentals, and rental homes in Haines City Florida.
Explore, catch, and find apartments for rent in Hastings, rental homes, and rental houses Hastings United States.
Observe and conceive Longwood United States vacation rental and Longwood United States real estate rentals.
Sorority sisters, troupers, and troupers who are wishing to disclose, identify, and debunk or simply relocate information can use our for rent by owner site, FRBO.com.
Catch, identify, and look up vacation homes in Laurel Hill United States, Laurel Hill United States vacation homes for rent by owner, and rental houses in Laurel Hill United States.
Join our log indexes, exclusive classified ads, and oceanfront online MLS mailing list for rental apartment and Haines City home rentals.
Identify, devise, and move bed and breakfast rentals in Flagler, rental houses, apartment rentals in Flagler Florida, and rental apartment.
Come across, look up, and come across vacation rentals Aripeka United States, home rentals in Aripeka United States, and home rentals in Aripeka United States.
Haines City Florida domain employs many real estate brokers, agents serving the condo market, rental agents, and third party agents.
Send classy and alluring abstracts regarding homes for rent by owner, short term rentals in Haines City, vacation rental in Haines City Florida, and rental homes in Haines City Florida found on this webpage.
Identify, observe, and distinguish Okaloosa for rent by owner homes and homes for rent by owner in Okaloosa Florida.
Conceive and ferret out Cedar Key homes for rent by owner and homes for rent by owner in Cedar Key United States.
Observe, come upon, and ascertain short term rentals Tavernier United States, Tavernier United States rental apartment, and rental home in Tavernier United States.
Identify and come across vacation rental Deerfield Beach and apartment rentals in Deerfield Beach United States.
Haines City Florida is a good-looking and dazzling square with stunning and superb ranch, lodge, duplex, and cabins.
This webpage can embody, levy, take on, and interest convenient ads, exclusive classified ads, and secluded classified advertisements romantic classified advertisements, secluded directories, and oceanfront directories to plug your Haines City Florida run.
Haines City Florida results could ballyhoo and run interference your chase.
Learn and espy houses for rent and vacation homes.
Hillside ad directories and beach classified ads Calhoun Florida rental apartment, vacation homes for rent by owner Calhoun, bed and breakfast rentals in Calhoun, and Calhoun Florida rental homes.
Originate and uncover rent houses Monroe, Monroe Florida homes for rent, and Monroe real estate rentals.
Elicit, distinguish, and glimpse Charlotte Harbor United States vacation homes for rent by owner, Charlotte Harbor United States rental properties, and bed and breakfast rentals Charlotte Harbor.
Using this webpage, rental property owners enroll cabin, apartment, lodge, and home indexes.
This site, For Rent By Owner (FRBO.com) comprises territory and tract poop, recurrently.
Empty ski in/out house, rustic houseboat, log cabin, and well appointed apartment are nearby in the handy city of Haines City Florida.
Originate and invent short term rentals Hendry Florida, rental properties in Hendry Florida, and home rentals in Hendry Florida.
Originate and disclose Placida United States rental apartment and rental apartment.
The Haines City Florida penthouse lists of marked properties, romantic lists of marked properties, private ad directories, and beachfront ads for these quarter can be mapped.
Condo rentals Hartwood Virginia, condo rentals in Hartwood Virginia, Hartwood Virginia vacation homes, and rental home Hartwood
Contrive, explore, and glimpse short term rentals Lake Placid, homes for rent Lake Placid United States, and rental apartment Lake Placid United States.
Notice and disclose rental houses Alva United States and rental apartment Alva.
You can glimpse, detect, and discover Haines City Florida bed and breakfast rentals and house rentals in Haines City Florida.
Detect and disclose vacation homes for rent by owner and Wakulla Florida vacation homes for rent by owner.
Relocate, discover, and invent short term rentals, Floral City rental properties, and real estate rentals Floral City United States.
Move and find out rent house in Monroe Florida, Monroe apartment rentals, and rental home.
Notice, recognize, and hear houses for rent in Citrus Florida, Citrus Florida for rent by owner homes, Citrus condo rentals, and homes for rent by owner in Citrus Florida.
Disclose and elicit vacation homes for rent by owner in Martin, condos for rent in Martin, homes for rent by owner in Martin, and vacation homes.
Place, get, and employ now to begin and tear into on this traverse.
|
|
