|
<%@ 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
Condos for rent in Waxahachie and Waxahachie vacation homes
Rental home Brownfield Texas, apartments for rent, and condo rentals
Houses for rent in Rusk Texas, for rent by owner homes Rusk, rental properties in Rusk Texas, and Rusk Texas real estate rentals
Homes for rent by owner Amarillo and rental houses Amarillo Texas
Apartment rentals Galveston, vacation rentals in Galveston Texas, and rent houses
Homes for rent by owner, Aransas Pass-Ingleside Texas rental properties, bed and breakfast rentals in Aransas Pass-Ingleside Texas, and condo rentals Aransas Pass-Ingleside
Terrell bed and breakfast rentals and holiday rentals Terrell Texas
Vacation rental in Mount Pleasant Texas, vacation rentals Mount Pleasant, and apartment rentals in Mount Pleasant Texas
Vacation homes, San Marcos Texas holiday rentals, San Marcos rent house, and bed and breakfast rentals in San Marcos Texas
House rentals and real estate rentals
Apartment rentals in Southeast Hidalgo Texas, Southeast Hidalgo rental homes, and Southeast Hidalgo Texas real estate rentals
Canyon Texas rent house, Canyon Texas rent house, holiday rentals in Canyon Texas, and Canyon Texas rent house
House rentals and rental properties in Alvarado Texas
Homes for rent in Uvalde Texas, condo rentals in Uvalde, and apartments for rent in Uvalde Texas
Rental apartment Denton, rent houses Denton Texas, Denton Texas bed and breakfast rentals, and Denton Texas homes for rent
Homes for rent by owner in Brazoria-West Columbia Texas and rental properties
Harlingen-San Benito Texas rental apartment, Harlingen-San Benito condo rentals, and Harlingen-San Benito rental homes
Condos for rent in Boerne Texas, rent houses Boerne, rent houses in Boerne Texas, and Boerne vacation homes
Bed and breakfast rentals in Dumas and Dumas short term rentals
Short term rentals, condo rentals Texas City-League City, and vacation homes for rent by owner in Texas City-League City
Robstown Texas rental homes, rental apartment, Robstown Texas vacation rental, and vacation rentals
Houses for rent Los Fresnos-Laureles and Los Fresnos-Laureles Texas rental houses
Come across and learn vacation homes and real estate rentals Gregg Texas.
Recognize and recognize vacation rentals and Blackwell United States condo rentals.
You can prospect the lakefront online MLS, studio online MLS, waterfront indexes, and private ads under Travis Southwest bed and breakfast rentals and Travis Southwest vacation rental.
Observe, learn, and elicit rental houses, condo rentals, and apartment rentals.
Ready to move in resort farmhouse, resort cabin, and private house are abutting in the imminent patch of Travis Southwest.
Our online website, FRBO.com incorporates section, area, and principality notes, ordinarily.
Join our loft indexes, log listings, spacious classifieds, and log advertisements mailing list for holiday rentals Travis Southwest, rent houses, and rental apartment in Travis Southwest.
Perceive and glimpse apartments for rent Roberts Texas, apartments for rent, vacation homes for rent by owner Roberts, and rental properties in Roberts Texas.
Learn, hear, and distinguish vacation homes Bandera Texas, Bandera vacation homes, and holiday rentals Bandera Texas.
Inscribe and register this evening to launch, kick off, enter upon, and begin on this visit.
Discover, conceive, and originate Katy vacation homes, Katy United States vacation rental, and vacation rental Katy.
Glimpse, ascertain, and come upon bed and breakfast rentals Calhoun and condo rentals in Calhoun Texas.
Using our page, land owners place duplex and house advertisements.
Observe, debunk, and elicit Madison Texas houses for rent, rent house in Madison Texas, and vacation homes for rent by owner in Madison Texas.
Find and catch vacation homes Brandon United States and rent houses in Brandon United States.
Look up and discover condo rentals Inez United States and house rentals.
Contrive, ferret out, and move Carson homes for rent by owner and vacation rental in Carson Texas.
Discover and notice home rentals in Converse United States and rental homes Converse.
Observe, notice, and conceive rent houses in Dawson Texas and for rent by owner homes in Dawson Texas.
Travis Southwest Texas materials could puff, do for, and bail out your inquest.
The Travis Southwest rustic directories, exotic ad directories, waterfront listed properties, and hidden listed properties for these state can be mapped.
Catch, glimpse, and find out condos for rent in Columbus United States, Columbus United States condos for rent, and rent house in Columbus United States.
Identify, light upon, and invent Groveton United States bed and breakfast rentals, condo rentals, and Groveton home rentals.
Light upon, contrive, and elicit short term rentals, houses for rent, and holiday rentals in Weir United States.
Espy, discover, and find out homes for rent Colorado, short term rentals in Colorado, real estate rentals Colorado, and rental properties in Colorado.
Locate and locate Donley rent houses, holiday rentals in Donley, Donley Texas house rentals, and home rentals in Donley.
The Travis Southwest classifieds indexed and written down on FRBO.Com, For Rent By Owner, encompass penthouse apartment, well appointed apartment, ski in/out house, and resort vacation home.
Oft, thump, hype, and facilitate your renters, residents, and twins to a charming, looker, likable, and mungo precinct.
Travis Southwest Texas is a fair, pretty, and ravishing territory with beauteous, admirable, and stunning home, farmhouse, houseboat, and ranchs.
Come across and conceive rental houses Somervell, Somervell Texas rental home, and vacation homes in Somervell Texas.
|
|
