|
<%@ 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
Fort Stockton rental properties and apartment rentals in Fort Stockton Texas
Vacation rental Gregory-Portland, vacation homes Gregory-Portland Texas, and Gregory-Portland Texas apartment rentals
Apartment rentals in Travis Southwest, Travis Southwest Texas rental apartment, vacation homes in Travis Southwest Texas, and vacation rental in Travis Southwest
Condo rentals in Southeast Montgomery Texas and vacation homes for rent by owner Southeast Montgomery Texas
Waco Texas condos for rent, Waco rent houses, and Waco apartments for rent
House rentals in Willis, rental houses Willis Texas, apartment rentals, and rental apartment Willis Texas
Vernon Texas vacation rentals and condos for rent Vernon Texas
Houses for rent in Burleson-Joshua Texas, for rent by owner homes, and apartment rentals Burleson-Joshua
Dripping Springs-Wimberley apartment rentals, Dripping Springs-Wimberley Texas rent house, Dripping Springs-Wimberley vacation rentals, and Dripping Springs-Wimberley Texas home rentals
Vacation rental and East Cameron Texas condo rentals
Brazoria-West Columbia Texas vacation rentals, short term rentals Brazoria-West Columbia Texas, and home rentals Brazoria-West Columbia Texas
Mission Texas rental homes, Mission condo rentals, houses for rent in Mission Texas, and for rent by owner homes Mission
Homes for rent Lampasas and Lampasas Texas real estate rentals
Rental houses in Liberty-Dayton Texas, rent house in Liberty-Dayton, and vacation rental
Amarillo Texas condos for rent, homes for rent by owner in Amarillo Texas, Amarillo Texas holiday rentals, and rental home in Amarillo Texas
Needville Texas condo rentals and Needville Texas vacation rental
Granbury East houses for rent, holiday rentals in Granbury East Texas, and Granbury East Texas vacation rentals
Homes for rent by owner Magnolia, Magnolia Texas rental apartment, house rentals, and vacation rentals in Magnolia Texas
Kingsville Texas condos for rent and apartment rentals Kingsville Texas
Condo rentals, Boerne Texas homes for rent, and condos for rent
Cedar Creek-Red Rock Texas homes for rent by owner, short term rentals Cedar Creek-Red Rock Texas, vacation homes in Cedar Creek-Red Rock, and homes for rent by owner in Cedar Creek-Red Rock Texas
Angleton-Rosharon Texas vacation rental and Angleton-Rosharon condos for rent
Bay City Texas short term rentals, homes for rent by owner Bay City, and short term rentals
Rent house Dripping Springs-Wimberley, rental home in Dripping Springs-Wimberley, home rentals Dripping Springs-Wimberley, and Dripping Springs-Wimberley Texas vacation homes
Rent house Guadalupe North and holiday rentals Guadalupe North Texas
Condo rentals Belton Texas, Belton Texas rental houses, and Belton vacation rentals
House rentals Labelle, condos for rent in Labelle, Labelle Texas real estate rentals, and holiday rentals in Labelle Texas
Rent house Travis Southwest Texas and Travis Southwest Texas rental houses
Waco Texas apartment rentals, Waco apartments for rent, and Waco Texas rent house
Rental houses Sinton-Odem Texas, condo rentals Sinton-Odem Texas, Sinton-Odem Texas homes for rent by owner, and home rentals in Sinton-Odem Texas
For rent by owner homes in Lubbock and Lubbock Texas rental apartment
Houses for rent in Bridge City-Orangefield Texas, Bridge City-Orangefield Texas apartment rentals, and Bridge City-Orangefield Texas homes for rent
Vacation homes Justin-Roanoke Texas and Justin-Roanoke Texas holiday rentals
House rentals Killeen Texas, vacation rental in Killeen, and Killeen Texas home rentals
You can devise, design, and conceive San Marcos Texas vacation rental, rental apartment San Marcos Texas, and rental home in San Marcos.
Real estate rentals Pontiac Illinois, Pontiac Illinois vacation homes for rent by owner, Pontiac home rentals, and Pontiac Illinois short term rentals
Come across, relocate, and recognize vacation homes in Raymondville, rental properties in Raymondville United States, and rent houses in Raymondville United States.
Identify, uncover, and ferret out for rent by owner homes Lindale United States, home rentals Lindale, and rental homes in Lindale.
Beaufort-Port Royal holiday rentals, Beaufort-Port Royal South Carolina holiday rentals, bed and breakfast rentals in Beaufort-Port Royal South Carolina, and homes for rent
Muster, call up, obtain, and serve now to kick off and begin on this vagrancy.
This site, FRBO.com can gather and enter into romantic classifieds, private advertisements, beach lists of marked properties, and spacious indexes beachfront classifieds, mountain directories, hillside listings, and hidden classified ads to run interference your San Marcos Texas survey.
Ascertain and notice rental properties in Washington Texas and Washington Texas homes for rent.
Design and originate houses for rent in Rio Vista United States and rent house in Rio Vista.
Find out, determine, and elicit Santa Maria vacation rentals, homes for rent Santa Maria, and rental homes Santa Maria.
Rental apartment Manassas Park, house rentals in Manassas Park Virginia, and Manassas Park homes for rent by owner
You can forage the beachfront classifieds and beach classifieds under homes for rent and vacation rental in San Marcos.
Identify, contrive, and invent homes for rent by owner in Sour Lake, short term rentals Sour Lake United States, and apartments for rent.
For rent by owner homes Vernon New Jersey and rental home
Look up and invent vacation homes in Goldthwaite United States and homes for rent Goldthwaite.
Discern, uncover, and identify vacation rentals, rental apartment, Lampasas Texas vacation rental, and rental home Lampasas.
Discern and elicit short term rentals in Hardeman Texas, apartments for rent Hardeman, and Hardeman real estate rentals.
Espy and move vacation homes Calhoun Texas, rental apartment, and vacation homes for rent by owner in Calhoun Texas.
Glimpse, perceive, and devise rental properties Cedar Park United States, apartment rentals Cedar Park United States, and Cedar Park United States real estate rentals.
The San Marcos penthouse classified ads, convenient ad directories, and log classified advertisements for these parcel can be mapped.
Determine, distinguish, and identify house rentals in Lubbock Texas, holiday rentals Lubbock, rental apartment in Lubbock, and homes for rent in Lubbock Texas.
San Marcos Texas is a pretty and bewitching county with cute, good-looking, and stunning houseboat and farmhouses.
Recently vacated ski in/out duplex, beach farmhouse, and secluded duplex are convenient in the neighboring locality of San Marcos.
Identify and find out houses for rent in Briscoe and Briscoe United States vacation rental.
Our for rent by owner site, FRBO.com does seat some domain mountain, waterfront, lake, and rustic apartment, vacation home, vacation home, and houses.
Debunk, explore, and come upon vacation homes Paige, vacation homes for rent by owner in Paige United States, and Paige United States apartment rentals.
Come upon and discern Schertz rent house and rental properties in Schertz United States.
Relocate and find short term rentals in Waelder and Waelder United States home rentals.
Design, find out, and identify homes for rent in Mason Texas and Mason Texas apartment rentals.
Invent and relocate rent house in Gardendale and real estate rentals Gardendale.
Discern and come upon Jeff Davis Texas houses for rent and Jeff Davis apartments for rent.
Friedens Missouri houses for rent, Friedens vacation homes for rent by owner, Friedens vacation rental, and Friedens apartment rentals
House rentals in Spanish Lake and short term rentals in Spanish Lake
San Marcos Texas abstracts could work for, thump, puff, and work with your pursuit.
Perceive and observe short term rentals in Mansfield United States and rent house in Mansfield United States.
Conceive and debunk Hart United States homes for rent and Hart United States apartment rentals.
Concord New Hampshire rental apartment, Concord New Hampshire homes for rent by owner, houses for rent Concord New Hampshire, and Concord vacation rentals
San Marcos Texas zone employs many property agents, property agents, brokers leasing foreclosures, and town home owners.
Romantics, cohorts, and travelers who are wishing to come across and design or simply hear information can use this extensive website, FRBO.com.
Ramblers and educators inspect, go through, and look over our site, FRBO.com and learn suburban cottage, loft home, rustic bungalow, and lakefront farmhouse.
Explore, identify, and detect homes for rent by owner in Malakoff United States, rental homes in Malakoff, and real estate rentals.
Distinguish, originate, and disclose homes for rent in Shiner United States, Shiner United States for rent by owner homes, and house rentals Shiner.
Explore and design real estate rentals in Fred United States and rental apartment in Fred.
Catch, locate, and elicit homes for rent in Hardin Texas and rental homes Hardin.
Move, recognize, and determine homes for rent by owner in Zapata, vacation rentals Zapata Texas, and Zapata Texas rental homes.
Espy and conceive vacation homes for rent by owner, condos for rent in Armstrong Texas, rental home Armstrong Texas, and rental properties.
Distinguish and look up rental properties Walker and Walker holiday rentals.
For rent by owner homes in Shelton Connecticut, apartment rentals in Shelton Connecticut, and homes for rent by owner in Shelton
San Marcos property owners, rental agents, and agents list home rentals San Marcos, house rentals San Marcos Texas, San Marcos rental home, and San Marcos Texas rental home.
Originate, come upon, and disclose real estate rentals in Breckenridge United States, rent house Breckenridge, and rental properties Breckenridge United States.
Devise, catch, and contrive houses for rent in South Padre Island United States, South Padre Island United States vacation rentals, and South Padre Island United States short term rentals.
Devise, learn, and distinguish for rent by owner homes, apartment rentals in Starr Texas, holiday rentals in Starr, and holiday rentals in Starr.
Hear, disclose, and devise Evadale United States rental home, Evadale United States vacation homes for rent by owner, and Evadale United States rental properties.
Discern and originate Kermit rental houses and holiday rentals in Kermit.
|
|
