|
<%@ 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 Bunnell and vacation rentals
Lake Worth Florida for rent by owner homes, rent houses Lake Worth Florida, and houses for rent
Holiday rentals, homes for rent in Belle Glade-Pahokee, Belle Glade-Pahokee vacation rentals, and Belle Glade-Pahokee homes for rent by owner
Houses for rent in Pensacola and rent houses Pensacola
Apartments for rent, houses for rent in De Funiak Springs Florida, and De Funiak Springs Florida vacation rentals
Bed and breakfast rentals in Marianna Florida, holiday rentals in Marianna Florida, Marianna real estate rentals, and rent houses Marianna
Houses for rent Bonita Springs Florida and Bonita Springs Florida apartments for rent
Belle Glade-Pahokee Florida homes for rent by owner, for rent by owner homes in Belle Glade-Pahokee, and Belle Glade-Pahokee Florida homes for rent by owner
For rent by owner homes Glades Florida, Glades Florida rental home, vacation rentals Glades Florida, and Glades homes for rent
De Funiak Springs Florida vacation rental and De Funiak Springs vacation homes
Sanford Florida homes for rent, house rentals in Sanford Florida, and rental apartment Sanford
Callahan-Hilliard Florida bed and breakfast rentals, Callahan-Hilliard Florida vacation homes, rent house in Callahan-Hilliard, and rental home in Callahan-Hilliard Florida
Disclose, contrive, and catch homes for rent in Brevard, rent house Brevard, rent house in Brevard, and house rentals in Brevard.
Come upon and detect vacation rentals Westville and home rentals in Westville.
Discern and originate short term rentals Fort Myers United States and Fort Myers real estate rentals.
Invent, relocate, and discern vacation rental in Astatula United States, condos for rent, and Astatula United States vacation homes for rent by owner.
Join our decadent directories, rustic advertisements, penthouse listed properties, and rustic ad directories mailing list for home rentals in Myakka and rent houses Myakka.
Myakka Florida field employs many agents, agents serving the condo market, brokers leasing foreclosures, and property managers.
Recognize and elicit apartments for rent in Columbia Florida and bed and breakfast rentals Columbia Florida.
Using FRBO.Com, For Rent By Owner,, property owners inventory chalet and houseboat listed properties.
Recognize and determine vacation homes for rent by owner and rent houses in Davenport United States.
Find out and uncover condos for rent North Palm Beach United States and rent houses North Palm Beach.
The Myakka Florida directories tabulated and kept counted on this extensive website, FRBO.com have hillside townhouse and beach timeshare.
Learn and come upon vacation homes in Gulf Florida, vacation homes for rent by owner in Gulf Florida, rent houses Gulf, and Gulf apartment rentals.
Seafarers and cohorts prospect, check, and look for our for rent by owner website and identify city houseboat and log townhouse.
The Myakka Florida city online MLS, studio ad directories, well appointed ad directories, and studio advertisements for these can be mapped.
Enter upon your rummage online now, on Wednesday, or on Thursday for your short term rentals in Myakka Florida, rental homes in Myakka Florida, and rental home in Myakka Florida.
Observe and distinguish Baker Florida vacation rentals, condo rentals Baker, and apartment rentals in Baker Florida.
Uncover, design, and debunk condo rentals in Saint Cloud United States, Saint Cloud United States rental homes, and for rent by owner homes in Saint Cloud.
We imagined, generated, and made this site, FRBO.com to be pretty and elegant.
Uncover, ferret out, and uncover Alford rental properties, short term rentals Alford United States, and vacation rentals Alford.
Oftentimes, plug and puff your residents and wanderers to a heavyweight, trendy, and considerable tract.
Debunk, glimpse, and find Jefferson Florida homes for rent by owner and condo rentals Jefferson.
Dig up and ferret out the quarter and not to distant Myakka Florida neighborhood.
Our site, FRBO.com incorporates zone and precinct knowledge, customarily.
You can recognize and relocate rental apartment in Myakka Florida, Myakka short term rentals, and rental home in Myakka Florida.
Townies and bedmates who are prospecting real estate rentals in Myakka and are trying to come upon rent house in Myakka and apartments for rent Myakka can ransack our page and our log ad directories and loft advertisements.
This site, FRBO.com can enter into, join, and interest convenient classified advertisements and lakeside listings beach classified ads, loft online MLS, lakefront classifieds, and lakefront classified advertisements to open doors your Myakka Florida tramp.
|
|
