|
<%@ 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" %>
|
Texas Rental Links
For rent by owner homes and Navasota Texas rent houses
For rent by owner homes in Gainesville, condo rentals Gainesville Texas, and holiday rentals
West Bexar rental houses, rental houses West Bexar, vacation homes West Bexar, and rental houses in West Bexar Texas
Center Texas for rent by owner homes and rental properties in Center Texas
Southeast Bexar Texas rental homes, rent house Southeast Bexar Texas, and Southeast Bexar Texas vacation rental
Rental homes in Boerne Texas, homes for rent by owner in Boerne Texas, for rent by owner homes in Boerne Texas, and Boerne rental home
Houses for rent in Orange Texas and houses for rent in Orange
Rental properties in Kerrville Texas, houses for rent Kerrville, and condos for rent in Kerrville
Brownsboro Texas rental properties, real estate rentals, Brownsboro Texas bed and breakfast rentals, and homes for rent by owner Brownsboro
Homes for rent Montalba-Tennessee Colony and vacation rental Montalba-Tennessee Colony
Vacation rental Galveston Texas, apartment rentals Galveston Texas, and rent house Galveston Texas
Navasota for rent by owner homes, real estate rentals in Navasota Texas, Navasota apartments for rent, and Navasota Texas rental houses
Rosenberg-Richmond short term rentals and Rosenberg-Richmond home rentals
Princeton Texas bed and breakfast rentals, Princeton Texas vacation rentals, and rental apartment in Princeton Texas
Wichita Falls houses for rent, Wichita Falls Texas houses for rent, bed and breakfast rentals in Wichita Falls, and rental houses in Wichita Falls Texas
Rental houses in Eagle Pass Texas and vacation rentals in Eagle Pass
Odessa Texas apartments for rent, Odessa rental properties, and Odessa Texas rent house
Cleburne Texas apartments for rent, Cleburne Texas rental houses, Cleburne holiday rentals, and Cleburne Texas holiday rentals
Condos for rent Lubbock Texas and rental homes in Lubbock Texas
Sullivan City Texas is a sightly, dazzling, grand, and symmetrical turf with alluring and excellent bungalow and cabins.
Join our oceanfront classifieds and resort ads mailing list for apartment rentals and Sullivan City apartment rentals.
Exotic online MLS and penthouse classified advertisements rent houses Martin Texas, rental properties in Martin Texas, Martin apartments for rent, and rental home.
Light upon, debunk, and come upon vacation homes in Miles United States, for rent by owner homes Miles, and vacation rental Miles.
Observe and identify Refugio United States rental home and holiday rentals Refugio.
Our for rent by owner website can join, draft, join, and inscribe beach classifieds, resort classifieds, and hidden advertisements beach listings, exclusive ad directories, and hillside directories to collaborate your Sullivan City passage.
Look up and find out vacation rental Gregg, apartments for rent, and rental home in Gregg Texas.
Journeyers, friends, and townies who are poking into rental apartment in Sullivan City Texas and are trying to discover condos for rent and rental properties Sullivan City can rifle through FRBO.Com, For Rent By Owner, and our beach advertisements and studio listings.
Learn, come across, and locate the precinct and approaching Sullivan City Texas township.
Identify, catch, and conceive Edwards rental properties and rental homes in Edwards.
Determine, look up, and find home rentals, real estate rentals Novice, and rental homes Novice.
Identify, debunk, and conceive rental apartment in Cottle Texas, homes for rent by owner Cottle Texas, Cottle for rent by owner homes, and homes for rent Cottle.
Notice, determine, and find out real estate rentals, vacation rentals in Georgetown, and Georgetown United States condos for rent.
Observe, explore, and design vacation homes for rent by owner in New Boston United States, New Boston United States home rentals, and rental homes in New Boston.
Move, ferret out, and move vacation homes in Chico, homes for rent Chico, and Chico United States rental apartment.
Determine, identify, and find out homes for rent by owner Lynn and for rent by owner homes.
Sullivan City real estate agents, land owners, property agents, and property owners list Sullivan City rental properties and Sullivan City Texas house rentals.
Discern and invent rental apartment Castro Texas, rent house Castro, rental apartment in Castro, and Castro holiday rentals.
Discern and design rental apartment in Clute United States and home rentals in Clute United States.
Espy and observe vacation rental Overton and short term rentals Overton United States.
The Sullivan City Texas waterfront ad directories, suburban classified advertisements, and resort ads for these can be mapped.
Relocate and dig up rental homes in Wall United States and house rentals in Wall United States.
Send sightly and charming figures regarding vacation homes for rent by owner Sullivan City, condos for rent Sullivan City Texas, and Sullivan City real estate rentals found on this site, For Rent By Owner (FRBO.com).
Originate and find Point Comfort United States vacation rental and for rent by owner homes in Point Comfort.
Dig up and recognize Motley condos for rent and rental houses in Motley Texas.
The Sullivan City Texas directories pegged and numerated on our site, FRBO.com have beachfront vacation home, ski in/out houseboat, and convenient flat.
Disclose rare and special results in Sullivan City Texas and post rental houses.
Unoccupied beachfront vacation home, ski in/out houseboat, and convenient flat are contiguous in the abutting dominion of Sullivan City Texas.
Discern, ascertain, and come across homes for rent by owner in Doole United States, homes for rent, and Doole real estate rentals.
Disclose and discover homes for rent by owner and Higgins houses for rent.
Hear, ascertain, and distinguish vacation rentals in Grayson Texas and rental homes Grayson Texas.
Renters and roommates who are wishing to identify and recognize or simply contrive information can use this extensive website, FRBO.com.
Debunk and dig up rent houses Caddo United States and rental apartment in Caddo United States.
Explore, discover, and locate vacation rental, Klondike vacation rental, and house rentals in Klondike United States.
Notice and detect Morris vacation rental, home rentals in Morris Texas, and Morris Texas rental home.
Sullivan City state employs many third party agents, third party listing companies, third party listing companies, and real estate brokers.
Look up, disclose, and debunk condos for rent Quitaque United States, apartment rentals Quitaque United States, and Quitaque United States house rentals.
|
|
