Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:50:37.780' ,`MLSNumber` = '69081537' ,`ListAgentFullName` = 'Sherry Barker' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749169' ,`Longitude` = '-95.593909' ,`PhotoCount` = '23' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '384000.00' ,`Status` = 'Active' ,`StreetName` = 'Nova' ,`StreetNumber` = '12035' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2114' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom home with open floor plan. Fabulous updated gourmet kitchen features custom Woodmode/Brookhaven cabinetry, granite countertops, stainless oven, microwave, warming drawer and dishwasher, gas cooktop with pot filler, built-in refrigerator and large pantry. Enjoy your own relaxing, tropical paradise year-round! Home opens to enclosed patio with lovely koi pond (three fish included), a wonderful venue for entertaining (not included in sq. ft. calculation). Great backyard and patio, covered outdoor kitchen with Fire Magic grill, burner, sink, fridge and storage. Spacious living room features gas-log or wood fireplace, flanked by built-ins, French doors to enclosed patio, oversized garage with workbench and abundant storage. Neighborhood pool, park, tennis courts and clubhouse. Short distance to Robin Loop of Terry Hershey Park trails. All info per Seller.' ,`Acres` = '0.2031' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 8 BRIAR LAKE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8849' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '673' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briar Lake' ,`TaxAmount` = '7359' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691348' WHERE `Matrix_Unique_ID` = '207672989' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:35:09.997' ,`MLSNumber` = '12446805' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750207' ,`Longitude` = '-95.900952' ,`PhotoCount` = '39' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '378780.00' ,`Status` = 'Active' ,`StreetName` = 'Lemonwood' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1752' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Entertain in style and enjoy the everyday comforts of The Penmark family home plan. Begin and end each day in the perfect paradise of your Owner’s Retreat, which features a refined bathroom and a sprawling walk-in closet. Each spare bedroom provides a wonderful place for unique personalities to flourish. The chef’s specialty kitchen includes a full-function island and a walk in pantry. Your open floor plan offers an impeccable space to play host to picture-perfect memories and brilliant social gatherings. Get the most out of each day in this lovely Energy Saver!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 09 Block 02' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668691348' WHERE `Matrix_Unique_ID` = '208426929' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:57:46.937' ,`MLSNumber` = '29698144' ,`ListAgentFullName` = 'Catherine Borel' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.963287' ,`Longitude` = '-94.029197' ,`PhotoCount` = '28' ,`PostalCode` = '77705' ,`RoomCount` = '7' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Kilarney' ,`StreetNumber` = '8013' ,`StreetSuffix` = 'Drive' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Never Flooded! Rare opportunity to own a home with a garage apartment combo and a workshop situated on approximately one acre of land outside the city limits in the Nederland School District! This beautiful log home has 3481 sq ft (measured by an appraiser) of living space, a wrap-around covered porch with a circle driveway, and mature trees throughout the property. This lovely home has a large living room with soaring ceilings and a fireplace. The rooms are spacious, including the kitchen with a large work island, breakfast bar, double oven, and many cabinets! The mudroom/pantry/laundry room combo has a half bath for added convenience. The upstairs loft is full of built-in cabinets and workspace. This home will be a showplace with a few personal touches. All personal property will be removed before closing.' ,`Acres` = '1.15' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 80 81 SHAMROCK ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '50094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '152 - Nederland' ,`SchoolElementary` = 'HELENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEDERLAND HIGH SCHOOL' ,`SchoolMiddle` = 'WILSON MIDDLE SCHOOL (NEDERLAND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Shamrock Acres' ,`TaxAmount` = '5454' ,`TaxRate` = '1.9347' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691348' WHERE `Matrix_Unique_ID` = '208709658' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:54:01.493' ,`MLSNumber` = '3478936' ,`ListAgentFullName` = 'Suzan Zachariah' ,`ListOfficeName` = 'The Local Agents Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.943830' ,`Longitude` = '-95.298819' ,`PhotoCount` = '28' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder' ,`StreetNumber` = '611' ,`StreetSuffix` = 'Road' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VOTE TODAY FOR THIS HOME TO HOLD AN OPEN HOUSE. MAKE YOUR CHOICE KNOWN. New construction! Beautiful!!!There are views off the back and the front decks. The front deck has the view of Thunder Rd beach. This is a favorite of families and surfers. The front deck has a pergola for partial cover. Walk into an open living area/kichen that pops with some cabinets having glass doors. To the left are two bedrooms and a bathroom with a shower and to the right, a master bedroom with an En suite bathroom with the laundry hookups. The back deck has access off the kitchen. I love the views from the back of the big ships coming into the turning basin. From the master bedroom, you can see the Surfside Bridge. Come see, but please excuse the continued work completing the home. You can\'t beat this home with its many upgraded finishes.' ,`Acres` = '0.1205' ,`Area` = '5' ,`BuilderName` = 'Davison Gulf Coast' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 559 LOT 1 (REPLAT) (A0051 F J CALVIT)' ,`LotDesciption` = 'Water View' ,`LotSize` = '5249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Surfside Townsite' ,`TaxAmount` = '816' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668691349' WHERE `Matrix_Unique_ID` = '210504161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:30:37.720' ,`MLSNumber` = '18414964' ,`ListAgentFullName` = 'Jeff Denning' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.070563' ,`Longitude` = '-95.187739' ,`PhotoCount` = '41' ,`PostalCode` = '77345' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Echo Falls' ,`StreetNumber` = '4426' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Major updates have been done at this Family-friendly home in the last 3 years including both HVAC systems, Kitchen cabinets, both full and the half bath, Luxury Vinyl Plank flooring downstairs and on the stairs, upstairs carpet, hot water heater, 95% of the fence, & the sprinkler system. The home is ideally located close to schools, playground, community pool, shopping, & easy access to Highway 59. All bedrooms are upstairs + a small play area. The secondary bedrooms are larger than normal with nice closet space. The spacious Family room downstairs has a corner fireplace and a separate sitting room approx. 14x12\r\n. The kitchen, breakfast area and Family room all flow together. The Kitchen itself is a chef\'s delight boasting amply counter space & cabinets. Updates include granite counters, tile backsplash, SS appliances, Gas stove/range, newer cabinets plus the Luxury Vinyl Plank flooring. The back yard is private with plenty of room for possible future pool & play equipment.' ,`Acres` = '0.1701' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 7 MILLS BRANCH VILLAGE SEC 2 AMD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch' ,`TaxAmount` = '5915' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691349' WHERE `Matrix_Unique_ID` = '211589109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:48:17.803' ,`MLSNumber` = '40812713' ,`ListAgentFullName` = 'Michael Rugeley' ,`ListOfficeName` = 'Keller Williams Hou Preferred' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084092' ,`Longitude` = '-95.235144' ,`PhotoCount` = '8' ,`PostalCode` = '77365' ,`RoomCount` = '5' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcon Castle' ,`StreetNumber` = '25118' ,`StreetSuffix` = 'Lane' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful fully upgraded home located on a cul-de-sac. This New Legends Energy Star home was built in 2021 and comes fully equipped with all new appliances, bay windows, granite counters, and raised panel doors. Less than one mile to shopping centers with grocery stores and plenty of restaurants. Fenced in backyard with no back neighbors! Located near a cul-de-sac and both entrances of the Brooklyn Trails neighborhood.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Legend' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S269800 - BROOKLYN TRAILS 01, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4791' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'PORTER ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brooklyn Trails 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691349' WHERE `Matrix_Unique_ID` = '211612418' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:44:38.177' ,`MLSNumber` = '69896542' ,`ListAgentFullName` = 'Jose Soria' ,`ListOfficeName` = 'Lions Gate Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.327118' ,`Longitude` = '-95.081634' ,`PhotoCount` = '26' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Bend' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Court' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home with 3 bedrooms 2 full baths ,House is totally redone with new, 30 yr roof , flooring, tankless water heater, A/C , Cabinets , Electrical box with Breakers and more you must see this one .' ,`Acres` = '0.338' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE BEND, BLOCK 1, LOT 5, ACRES 0.338' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '14723' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'EASTSIDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Bend' ,`TaxAmount` = '1926' ,`TaxRate` = '2.5563' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691349' WHERE `Matrix_Unique_ID` = '212954073' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:05:12.583' ,`MLSNumber` = '35267984' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade' ,`StreetNumber` = '10647' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Easton floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '16/4/6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691350' WHERE `Matrix_Unique_ID` = '213055790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:15:43.227' ,`MLSNumber` = '77219830' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Texas Cali plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '3/5/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691350' WHERE `Matrix_Unique_ID` = '213120287' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:22:07.037' ,`MLSNumber` = '30297772' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '326990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2031' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '33/3/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691350' WHERE `Matrix_Unique_ID` = '213120494' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:14:31.220' ,`MLSNumber` = '22517717' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '20' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '305990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10603' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1535' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Diana Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '000-000-na' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691350' WHERE `Matrix_Unique_ID` = '213120771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:29:39.173' ,`MLSNumber` = '83720396' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Cascade Creek' ,`StreetNumber` = '10655' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Harris Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '43-4-4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691350' WHERE `Matrix_Unique_ID` = '213121406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:43:29.803' ,`MLSNumber` = '38061950' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.923655' ,`Longitude` = '-95.734967' ,`PhotoCount` = '38' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Momentous' ,`StreetNumber` = '15131' ,`StreetSuffix` = 'Path' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ll love the convenience of living in the beautiful master planned community of Bridgeland. The ample amenities and nearby shopping and dinning will make you wish you lived here sooner. Sophisticated design and easy elegance combine in The Edgeport new home plan. Enjoy the exquisite sanctuary of your Owner\'s Retreat, which features a splendid en suite bathroom and a walk-in closet. The kitchen island and open dining area offer a streamlined variety of mealtime settings. Flex your interior design skills in the limitless lifestyle potential of the upstairs retreat, the welcoming living area, and the deluxe family room. Everyday refinements include David Weekley Homes guarantees heating and cooling usage for 3 years thought the Environments For Living® program.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 03 Block 06' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1380' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Bridgeland' ,`TaxAmount` = '' ,`TaxRate` = '3.54' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668691351' WHERE `Matrix_Unique_ID` = '213373541' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:24:18.543' ,`MLSNumber` = '11628662' ,`ListAgentFullName` = 'Laura Bolieu' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.646202' ,`Longitude` = '-95.119125' ,`PhotoCount` = '45' ,`PostalCode` = '77505' ,`RoomCount` = '12' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow Bend' ,`StreetNumber` = '7715' ,`StreetSuffix` = 'Drive' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 4 bedroom 2.5 bath home located in sought after Village Grove East subdivision. 3 car detached garage nestled on a cul-de-sac. Primary suite downstairs w/double sinks and storage in the primary bath. Grand foyer,Open concept living w/high vaulted ceilings, formal dining oversized flex space situated on an oversized lot.in Deer Park ISD. Community pool and parks. Walking trails nearby and close to shopping, dining and Bltwy 8 for commute.' ,`Acres` = '0.281' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 VILLAGE GROVE EAST SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'JP DABBS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Village Grove East' ,`TaxAmount` = '8038' ,`TaxRate` = '2.8798' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691351' WHERE `Matrix_Unique_ID` = '213430271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:45:27.050' ,`MLSNumber` = '70046562' ,`ListAgentFullName` = 'Ava Sempe' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.060886' ,`Longitude` = '-95.925743' ,`PhotoCount` = '22' ,`PostalCode` = '77484' ,`RoomCount` = '6' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Dewey' ,`StreetNumber` = '2318' ,`StreetSuffix` = 'Street' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 116 year old Antique home in the Historical area of downtown Waller. The home was originally owned/built by Wallers 1st Justice of the Peace. The home has two front entrances which provides separate access for a home/office. Enter home into a formal entry. Light & Bright kitchen with a nice size pantry and appliances. 3 spacious bedrooms, 2 baths with a one being a claw foot tub. Home has been recently restored with a new roof, new pex piping throughout the entire home, fresh paint, original wood doors, cabinets and flooring. Utility room inside. 2 Car Carport and Storage Shed. A must see for anyone looking for nice piece of history, this is an Antique Jewel!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'S858900 WALLER-COLLEGE ADDITION BLK 33 LOT 1' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional,Victorian' ,`Subdivision` = 'Waller-College Add' ,`TaxAmount` = '4552' ,`TaxRate` = '2.6131' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1906' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668691351' WHERE `Matrix_Unique_ID` = '213729484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:48:45.307' ,`MLSNumber` = '40424282' ,`ListAgentFullName` = 'Tiffani Reynolds' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.814845' ,`Longitude` = '-95.765240' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '10' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Williamschase' ,`StreetNumber` = '22627' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home boasts a huge over-sized backyard perfect for outdoor play and entertainment and is located minutes from Grand Parkway 99 and I-10, right near the front of the neighborhood. Take a short 3-minute walk and enjoy the community playground and pool or continue walking towards nearby close and convenient shopping areas. Inside you’ll find 3 bedrooms, 2 and a half bathrooms, NEW CARPET, and a flex room that can serve as a game room, study, or secondary living room. The large living area offers tons of space to spread out and flows right into the kitchen. Expansive granite countertops are great for cooking large meals and entertaining your guests. Head out to the oversized backyard and enjoy the shade year-round. This one is ready for move-in and zoned to the desirable Katy ISD. Schedule your showing today!' ,`Acres` = '0.2169' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 64 BLK 3 WILLIAMSCHASE SEC 1 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '468' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WINBORN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'MORTON RANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Williamschase' ,`TaxAmount` = '4951' ,`TaxRate` = '2.4333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691351' WHERE `Matrix_Unique_ID` = '213939404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:31:11.417' ,`MLSNumber` = '77162477' ,`ListAgentFullName` = 'Kassi Weaver' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690945' ,`Longitude` = '-95.118406' ,`PhotoCount` = '47' ,`PostalCode` = '77536' ,`RoomCount` = '4' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Canterbury' ,`StreetNumber` = '2217' ,`StreetSuffix` = 'Court' ,`City` = 'Deer Park' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home sits on a 1/3 of an acre in the heart of Deer Park on a desired cul-de-sac street! This home was made for a family and custom-made upgrades geared for entertaining. 4 bedroom, 3 bath home has a great floor plan with the kitchen and breakfast area open to the family room! Primary bedroom boasts his and her walk-in closets with custom build-in cabinetry. Upstairs has 2 bedrooms and a full bath with added storage. Welcome to your very own backyard getaway with an in-ground heated pool & spa, covered patio, gorgeous landscaping and a covered deck complete with an outdoor kitchen and sitting area. Immaculate oversized garage with an outdoor bathroom is set up with entertaining in mind. Custom doors open up to the pool area with TV on swivel. Overhead garage door in the back opens up the garage area to the backyard adding more space for your next gathering. Call today to set up your private showing!' ,`Acres` = '0.3291' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 1 CANTERBURY PLACE' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14337' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'DEER PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canterbury Place' ,`TaxAmount` = '5953' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691352' WHERE `Matrix_Unique_ID` = '213998516' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214042564','1668691352','214042564','2022-11-17T06:16:38.357','29562210','Ronnie Hulquist','JLA Realty','','','29.969260','-95.204257','49','77346','10','444000.00','Active','Ebeys Landing','17418','Lane','Humble','3','1','4','3115','Single-Family','Welcome home! Located on a double cul-de-sac street with minimal traffic, this home is perfect for families with little ones or those just searching for peace & quiet. Open floor plan features hardwood floors, formal dining w/ farmhouse chandelier, large study, spacious living room w/ gas log fireplace and floor-to-ceiling windows. The island kitchen showcases granite countertops, an abundance of cabinets w/ undercabinet lighting, gas cooktop, & wine fridge, perfect for entertaining! The primary retreat has an en-suite bath w/ dual vanities, jetted garden tub, frameless glass shower, & walk-in closet truly built for two. Upstairs are 3 spacious secondary bedrooms, one with an en-suite bath while the other two share a jack & jill style. You\'ll also find an oversized game room with doors to help keep the fun contained. The large covered back porch has two ceiling fans & is prewired for surround sound. Never flooded, this home has too much to list here, schedule your showing today!','0.198','1','','','Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Atascocita South','Central Gas','1','LT 51 BLK 1 EAGLE SPRINGS SEC 28 R/P','Cul-De-Sac,Subdivision Lot','8626','Appraisal District','','825','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','29 - Humble','ATASCOCITA SPRINGS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','WEST LAKE MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','2','Traditional','Eagle Springs','9335','2.913','Water District','2008','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:40:08.460' ,`MLSNumber` = '20426023' ,`ListAgentFullName` = 'Azeez Elegbeji' ,`ListOfficeName` = 'The Elegbeji Group' ,`SellingAgentFullName` = 'Paula Lucas' ,`SellingOfficeName` = 'Keller Williams Premier RealtyKaty' ,`Latitude` = '29.722059' ,`Longitude` = '-95.866637' ,`PhotoCount` = '32' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '580000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Casen Ranch Ln' ,`StreetNumber` = '28602' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '\"Perry Home” A rare-find diamond on a CUL-DE-SAC in ultra-desirable Creek Cove at CROSS CREEK RANCH! This stunning home has a fire place to keep you warm doing the winter season, 4 bedrooms, 3 full baths, game room and study. This incredible home was lovingly cared for by the current owners and had all of the features and amenities buyers are looking for, as well as being zoned for acclaimed KATY ISD SCHOOLS.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Creek Cove at Cross Creek Ranch Sec 16, BLOCK 1, Lot 56' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'English' ,`Subdivision` = 'Creek Cove At Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691352' WHERE `Matrix_Unique_ID` = '214079368' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214124645','1668691352','214124645','2022-11-17T05:02:04.327','95464482','DJ Arsenault','Texan Realtors.com, LLC','','','30.152860','-95.400406','0','77385','7','425000.00','Active','Woodland Glen','2823','Lane','Conroe','3','0','4','2647','Single-Family','Open House Sat. 19th 2-4pm. Gorgeous brick home overlooking lake w/ wrought iron fence for unobstructed views of the water & ducks. Entry w/ 12-ft raised coffered ceilings opens to formal living room & stretches past a private guest suite w/ full bath (MIL suite or for live in nanny) & formal dining room. Family room floor to ceiling wall of windows. Open concept Kitchen for entertaining. Oversized island w/ built-in seating, Stainless appliances, 3cm granite, & Solid wood 42-in Kent Moore cabinets. Large soaking tub w/ separate glass shower, His & Hers sinks & walk-in closets. Surround sound throughout living areas & back patio. Large covered patio perfect for entertaining w/ airy lakefront views & serene waterfall sounds. Three pools, Splash pads, including dog park, Tennis court, Volleyball & Basketball courts. Zoned to amazing CISD schools, Access neighborhood through multiple routes for easy access to Nearby Shopping, Hospital, Fine dining, Movie Theatre & Grocery. Don\'t miss it!','0.167','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S612112 - IMPERIAL OAKS PARK 12, BLOCK 1, LOT 19','Cleared,Greenbelt,Subdivision Lot,Water View,Waterfront','7275','Appraisal District','','500','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','11 - Conroe','KAUFMAN ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Ranch,Traditional','Imperial Oaks Park 12','','','Public Sewer,Public Water,Water District','2010','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:29:19.677' ,`MLSNumber` = '50488840' ,`ListAgentFullName` = 'Randall Hernandez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767775' ,`Longitude` = '-95.763504' ,`PhotoCount` = '38' ,`PostalCode` = '77450' ,`RoomCount` = '10' ,`ListPrice` = '297900.00' ,`Status` = 'Active' ,`StreetName` = 'Apache Falls' ,`StreetNumber` = '1062' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1918' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home with great curb appeal in desirable Cimarron subdivision and Katy ISD. This home features a large family room with a vaulted ceiling, sliding patio doors overlooking a beautiful brick enclosed area, cozy wood burning fireplace, and plenty of natural light. The spacious kitchen includes a good sized sunny breakfast area, walk-in pantry, large windows and plenty of counter and cabinet space. Large master bedroom includes walk-in closet off master bathroom. Two good sized secondary bedrooms which share an updated hall bathroom. Updates include new roof, new HVAC, new wood-look vinyl plank flooring and carpet, new stainless steel dishwasher, new electrical panel, new garage door opener, refinished tub, tile surround and vanities, and refinished master shower. Fresh paint throughout!' ,`Acres` = '0.1763' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 12 CIMARRON SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '395' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron' ,`TaxAmount` = '3958' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691352' WHERE `Matrix_Unique_ID` = '214202722' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:13:10.447' ,`MLSNumber` = '88127877' ,`ListAgentFullName` = 'Stephen Wilhite' ,`ListOfficeName` = 'Keller Williams Realty - Clear Lake/ NASA' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.127161' ,`Longitude` = '-95.066861' ,`PhotoCount` = '48' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '364000.00' ,`Status` = 'Active' ,`StreetName` = '1st' ,`StreetNumber` = '4022' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1748' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only about a 5 minute walk or 1 minute car ride from the beach, this coastal gem positioned on a 20,000 sq. ft. lot makes the perfect vacation home or rental property. The home comes fully furnished & sleeps 11. Upstairs has 2 bedrooms & a full bathroom w/ a spacious kitchen & living room. Laundry hook-ups available up & downstairs. Sit on the covered deck & enjoy peek-a-boo views of the beach & bay, listen to the crashing waves & spot sea birds from the nearby bird sanctuary. Downstairs is a bonus area w/ 6.5 ft ceilings boasting a living room, kitchen, full bathroom, laundry room, & bedroom. The property has multiple storage units for housing your beach toys & an outdoor shower w/ sink & hot & cold water. The home is fully stocked & ready to go with EVERYTHING INCLUDED! The alarm system is wired to arm the whole house or upstairs/downstairs separately. The optional HOA provides a boat ramp & pavilion. Enjoy volleyball, ping pong, pool, or head to the beach at this chateau by the sea!' ,`Acres` = '0.4591' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR N 1/2 OF LOT 15 (15-1) BAY HARBOR' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Harbor' ,`TaxAmount` = '5566' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank,Water District' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691352' WHERE `Matrix_Unique_ID` = '214209738' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214212697','1668691353','214212697','2022-11-17T06:50:26.687','46005459','Shelby Crowe','Berkshire Hathaway HomeServices Premier Properties','','','29.551450','-95.298432','49','77584','11','390000.00','Active','Vista','3009','Lane','Pearland','2','1','4','2700','Single-Family','Welcome Home 3009 Visa Lane-over 30k in upgrades-new roof-5K+ electrical upgrades-interior 100% freshly painted-brand new washer,dryer,frig,& 5 burner range-6 low E efficiency windows-primary bath remodeled brand new 2 person shower with rain heads-glass exterior-just to name a few-tile floors down stairs-carpet bedrooms-corner fireplace/wet bar in family room over looking the kitchen/breakfast nook-formal living & dining room-open floor plan-family, breakfast nook kitchen with island-granite counter tops-laundry area in kitchen-covered patio with outdoor kitchen-detached garage with an extra room that is separate has ac make a great office-man cave- craft room-double carport attached to the garage-split floor plan upstairs -high ceilings-abundance natural light-walking distance Centennial Park-jogging paths-splash pad-playgrounds-basketball courts-tennis courts-backyard large enough for your own oasis-call for your personal showing-won\'t last long-a must see low HOA-CALL TODAY','0.184','5','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Pearland','Central Gas','1','ASHTON PARK SEC 1 (A0240 H T & B)(PEARLAND) BLK 2 LOT 31','Cleared,Subdivision Lot','8015','Appraisal District','','217','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','42 - Pearland','MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)','PEARLAND HIGH SCHOOL','PEARLAND JUNIOR HIGH SOUTH','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','2','Traditional','Ashton Park Sec 1','7573','2.5552','Public Sewer,Public Water','1999','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:57:45.533' ,`MLSNumber` = '72928007' ,`ListAgentFullName` = 'Ruben Hernandez' ,`ListOfficeName` = 'Apex Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.909827' ,`Longitude` = '-95.385402' ,`PhotoCount` = '23' ,`PostalCode` = '77060' ,`RoomCount` = '7' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Hambrick' ,`StreetNumber` = '734' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled just minutes away from Downtown Houston. This newly updated beautiful house awaits your personal touches to make it a HOME! After months of hard work, this beauty emerge. Updated with New electrical wiring, new apex plumbing, new HVAC ductwork. Fully updated baths and kitchen.' ,`Acres` = '0.127' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 5 ALDINE VILLAGE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5530' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ODOM ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Aldine Village Sec 01' ,`TaxAmount` = '2284' ,`TaxRate` = '2.1528' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691353' WHERE `Matrix_Unique_ID` = '214217337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:52:44.540' ,`MLSNumber` = '22334060' ,`ListAgentFullName` = 'Kevin McCullough' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.140730' ,`Longitude` = '-95.568592' ,`PhotoCount` = '35' ,`PostalCode` = '77375' ,`RoomCount` = '13' ,`ListPrice` = '929000.00' ,`Status` = 'Active' ,`StreetName` = 'Mayapple Blossom Pl' ,`StreetNumber` = '11' ,`StreetSuffix` = 'Place' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your family will enjoy this beautiful 5 bedroom, 2 story family home in the Smooth Stream neighborhood of Creekside Park West. This 4 year young home has a master suite & guest suite down plus a 3-car tandem garage. With a 5th bedroom added, this home has plenty of room. Wood-look tile in select areas. Soaring ceilings with open kitchen, dining and family room areas. Entertain with your island kitchen with a walk-in pantry, stainless steel appliances, granite counter tops, double-ovens, and under cabinet lighting. Master suite has large walk-in closet and dual shower heads. Second story includes a game room and media room. Comfortable, covered back patio and large backyard to enjoy some outside time. Please look for and view our 3D virtual tour displayed on this listing!' ,`Acres` = '0.253' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 36 BLK 1 THE WOODLANDS CREEKSIDE PARK WEST SEC 34 AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11019' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodlands Creekside Park West' ,`TaxAmount` = '17797' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1668691353' WHERE `Matrix_Unique_ID` = '214274153' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:32:23.953' ,`MLSNumber` = '42744525' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '369990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10619' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 44 BLK 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691353' WHERE `Matrix_Unique_ID` = '214278778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:57:40.773' ,`MLSNumber` = '60330538' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014765' ,`Longitude` = '-95.536090' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '14' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Oak' ,`StreetNumber` = '8107' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Updated Home Nestled in the beautiful Memorial Northwest for today lifestyle! Huge Lot! 2 1/2 Detached Garage! Energy Saving Home w/ Updated Roof, Radiant Attic Barrier, High-Efficiency HVAC, Insulated Doors, Insulated/Low-E Windows, Energy Saving H2O Heater & More! Owner\'s Suite & Guest Bedroom Down! Elegant Formal Living & Dining! Dramatic Family Area W/High Ceilings, Amazing Wall of Windows, Stunning Corner Fireplace, Wood Like Tile Floors lead into the Magnificent Gourmet Kitchen W/Tall White Shaker Cabinets, Soft Close Drawers & Cabinets, Gorgeous Quartz Counters, Subway Glass Backsplash, Deep Farmer Sink, 5 Burner, Double Oven Range, Huge Wrap Around Breakfast Bar & More! Owner\'s Suite W/Luxurious Spa Bathroom W/Massive Body Shower, Free Standing Soaking Tub, His & Her Private Undermount Sinks, Quartz Counters, Make Up Area & More! Upstairs Huge Game Rm, 3 Large Bedrooms, & Hollywood Bathroom W/Shaker Cabinets & Quartz Counters! No Flooding! Outstanding Amenities!' ,`Acres` = '0.2686' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 6 017*M1876900-002-006-035 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '5281' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691353' WHERE `Matrix_Unique_ID` = '214372890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:30:42.260' ,`MLSNumber` = '61325777' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '360990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10607' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691354' WHERE `Matrix_Unique_ID` = '214385556' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:47:27.353' ,`MLSNumber` = '48154664' ,`ListAgentFullName` = 'Chuck Miller' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.586848' ,`Longitude` = '-95.606928' ,`PhotoCount` = '43' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Creek Shadow' ,`StreetNumber` = '2606' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2358' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is where neighborhood charm meets opportunity in the enchanting Williams Grant subdivision. Fall in love with the exquisite character and elegance in this two story home. Recent updates include a new AC, dishwasher, and a eletrical breaker box. This spacious property (over 13,000 sqft lot per appraisal district) is complimented by majestic trees, large green space with an in-ground pool, and your very own grape vine. Enjoy a welcoming and walkable neighborhood which is a quiet gem in the midst of the city. The location is within walking distance of the Town Center shops and multiple delightful restaurants. You will appreciate close proximity to shopping, entertainment, and major intersecting roadway. Schedule an appointment to view this lovely property and buy this home in time for the Holidays.' ,`Acres` = '0.3036' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WILLIAMS GRANT SEC 1, BLOCK 5, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '730' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Grant Sec 1' ,`TaxAmount` = '6212' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691354' WHERE `Matrix_Unique_ID` = '214401585' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:33:38.690' ,`MLSNumber` = '19620341' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '390990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1322' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Floorplan. Beautiful 2 story, 2 beds down, 2 up on a water lot, no back neighbors!' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691354' WHERE `Matrix_Unique_ID` = '214408385' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:28:37.463' ,`MLSNumber` = '16303136' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '35' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '359990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2257' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Mitchell Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 40 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691354' WHERE `Matrix_Unique_ID` = '214409392' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:06:16.823' ,`MLSNumber` = '50148412' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '23' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '297990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10619' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Easton Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691354' WHERE `Matrix_Unique_ID` = '214410341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:04:04.960' ,`MLSNumber` = '70225912' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '41' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10611' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Gaven Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691355' WHERE `Matrix_Unique_ID` = '214410835' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:07:57.080' ,`MLSNumber` = '96083810' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '299990.00' ,`Status` = 'Active' ,`StreetName` = 'Great Basin' ,`StreetNumber` = '10602' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1822' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Harris Floorplan.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691355' WHERE `Matrix_Unique_ID` = '214411281' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:20:59.880' ,`MLSNumber` = '83898971' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10615' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kendall Floorplan.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 45 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691355' WHERE `Matrix_Unique_ID` = '214411631' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:27:38.683' ,`MLSNumber` = '64363411' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '30' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '339990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10618' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Midland plan is a two-story home featuring 4 bedrooms, 3 baths, and 2 car garage. The entry opens to a downstairs guest bedroom and bath with hall linen closet. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts spacious family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. A versatile loft area greets you at the top of the stairs and opens to two additional bedrooms and bath. The standard rear covered patio is located off the dining area.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Blk 5 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691355' WHERE `Matrix_Unique_ID` = '214412308' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:31:28.730' ,`MLSNumber` = '10396052' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '24' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '364990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1235' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ozark plan is a two-story home featuring 4 bedrooms, 2.5 baths, and 2 car garage. The foyer opens to a study and powder bath with linen closet. Center kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances and corner pantry. Open concept floorplan boasts large combined family room and dining area. Extra storage space under the stairs is a plus. The private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. Upstairs boasts open loft and three additional bedrooms and bath. The standard rear covered patio is located off the family room.' ,`Acres` = '0.179' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26 Blk 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691356' WHERE `Matrix_Unique_ID` = '214412615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:23:05.550' ,`MLSNumber` = '26348024' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '32' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1247' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lakeway plan is a one-story home featuring 4 bedrooms, 3 baths, and 2 car garage. The foyer opens to one guest bedroom and bath, study and entry coat closet. Kitchen includes breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large family room and separate dining/breakfast area. Two additional bedrooms and bath are situated just off the common living area. Private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Blk 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691356' WHERE `Matrix_Unique_ID` = '214412923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:16:54.657' ,`MLSNumber` = '69257283' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '324990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1251' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2032' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '>The Kingston plan is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 22 Blk 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691356' WHERE `Matrix_Unique_ID` = '214413334' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214553240','1668691356','214553240','2022-11-17T05:58:05.810','59782977','Misti Bruton','AVO Realty, LLC','','','29.921079','-98.069856','26','78666','8','550000.00','Active','Condor','451','Drive','San Marcos','2','0','3','1740','Single-Family','Perfect country living charmer tucked away on 3 acres has 3 bedrooms and 2 full baths is an easy drive to San Marcos or Wimberley and minutes to the river. Once you turn the drive on to the new gravel driveway you will immediately notice this quaint charm of this property and home. Takes some time to watch the plentiful deer track their way across the property while swinging on the covered front porch. The roof, carport and sidewalk were all updated in Oct 2022. The kitchen was completely remodeled 2 years ago and includes quartz counters, marble backsplash, a farmhouse apron sink and self-closing drawers. The upstairs primary bedroom has his and hers walk-in closets. And a nook above the stairs that could be used as an office area. In the back of the home there is a large deck, fire pit sitting area, chicken coop and raised flower bed for gardening. This home also has 2 producing peach trees, 2 pear trees, 1 plum and 1 lemon tree for you to enjoy the fruits of your labor.','3','83','','','','','Other Disclosures,Sellers Disclosure','1','','0','','Central Electric','1','FALCON-WOOD, LOT 19, ACRES 3.00','Other','130680','Appraisal District','','98','0','','0','','0','','','','','Composition','214 - San Marcos Consolidated','HERNANDEZ ELEMENTARY SCHOOL','SAN MARCOS HIGH SCHOOL','MILLER JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Falcon-Wood','4960','1.7305','Septic Tank,Well','2002','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214602847','1668691356','214602847','2022-11-17T05:16:24.860','51608445','Larry Cockman','eXp Realty, LLC','','','29.838229','-95.787704','31','77493','5','335000.00','Active','Modica','4438','Drive','Katy','2','0','4','1929','Single-Family','This almost like new home was built in 2017 and is simply incredible inside and out! Providing 1,929 square feet of living space, 4 spacious bedrooms, 2 bathrooms, wonderfully-equipped kitchen, and a bright and inviting living space! Boasting incredible attention to detail and upgrades throughout including gorgeous tile, stainless steel appliances, beautiful wood cabinetry, and modern finishes. The master bath is relaxing, featuring a spa like bath and sitting room, with so much more. After a long day, come home and relax on your extended covered patio while grilling or just enjoying your family. The community of Ventana Lakes features pools, splash pads, trails, parks, a clubhouse, schools, easy access to 99 and I-10.','0.1703','25','','','','','Sellers Disclosure','','','','Katy - North','Central Gas','1','LT 4 BLK 1 VENTANA LAKES SEC 9','Subdivision Lot','7417','Appraisal District','','850','0','','2','','0','','','','','Composition','30 - Katy','BETHKE ELEMENTARY SCHOOL','PAETOW HIGH SCHOOL','STOCKDICK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Ventana Lakes Sec 9','7045','3.2768','Public Sewer,Public Water','2017','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214657716','1668691356','214657716','2022-11-17T06:35:53.190','88942519','Ural Thompson','Coldwell Banker Realty','','','29.731261','-94.969581','18','77520','8','215000.00','Active','Gulf','110','Street','Baytown','2','1','3','1456','Single-Family','Amazingly well maintained home in the heart of Baytown. Walking distance to Lee College and Town Square. This property has extended covered parking and the garage space is easily convertible to a work space or living space. 1 Hr notice before all showings is requested.','0.1148','2','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','','Baytown/Harris County','Central Electric','0','LTS 5 & 6 BLK 31 GOOSE CREEK','Subdivision Lot','5000','Appraisal District','','','0','','1','','0','','','Gas Cooktop','','Composition','23 - Goose Creek Consolidated','CARVER ELEMENTARY SCHOOL (GOOSE CREEK)','LEE HIGH SCHOOL (GOOSE CREEK)','HORACE MANN J H','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Goose Creek','2707','2.97','Public Sewer,Public Water','1948','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214668608','1668691356','214668608','2022-11-17T06:57:46.890','30197175','Kaitlin Jaschek','Stanfield Properties','','','29.540888','-95.199738','28','77546','13','509000.00','Active','Cherry Tree','134','Lane','Friendswood','3','0','4','3351','Single-Family','Spacious, updated, & stunning open-concept single-story home where the design & details set it apart from the rest! Enter directly into the main living space that encompasses the family room with hardwood floors & a charming brick fireplace with custom built-ins, an inviting dining room, & a statement kitchen with a massive quartz island, a large fireclay farmhouse sink, updated soft-close cabinetry, matte black appliances, & leathered granite counters. The master suite is breathtaking with separate his & hers vanities & closets with built-ins and a large walk-in shower with dual shower heads & a rain-shower feature. This home boasts a unique flex space with both interior & exterior access, making it useable as a massive game room, a mother-in-law suite, or an income-producing rental space that offers a stone fireplace, a bonus kitchen, a private bath, & the 4th bedroom. Outdoors, the concrete patio overlooks the park-like yard with mature trees. It\'s a must-see in FISD!','0.2541','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','2','Friendswood','Central Gas','1','ABST 20 PERRY & AUSTIN SUR LOT 37 ENCHANTED WOODS','Subdivision Lot','11070','Appraisal District','','75','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','20 - Friendswood','WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)','FRIENDSWOOD HIGH SCHOOL','FRIENDSWOOD JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Ranch,Traditional','Enchanted Woods','9483','2.2832','Public Sewer,Public Water','1970','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:32:14.483' ,`MLSNumber` = '11888958' ,`ListAgentFullName` = 'Mishelene Baker' ,`ListOfficeName` = 'Masters Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.380188' ,`Longitude` = '-95.022326' ,`PhotoCount` = '19' ,`PostalCode` = '77568' ,`RoomCount` = '4' ,`ListPrice` = '314900.00' ,`Status` = 'Active' ,`StreetName` = 'Imperial Ridge' ,`StreetNumber` = '613' ,`StreetSuffix` = 'Court' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2627' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning home situated in the Delaney Cove community. This two story home features a first floor primary suite with a full bathroom and walk-in closet. Upstairs are the secondary bedrooms, and a bonus/flex room. All of the rooms are large enough for your big furniture and the back yard is big enough for all of the family gatherings! This one won\'t last long, make your appointment to tour today.' ,`Acres` = '0.144' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Marque' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DELANY COVE SEC 1 (2006) ABST 2, BLOCK 2, LOT 16, ACRES 0.14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6273' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Delany Cove Sec 1 2006' ,`TaxAmount` = '8633' ,`TaxRate` = '3.1135' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691357' WHERE `Matrix_Unique_ID` = '214680536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:58:51.800' ,`MLSNumber` = '53559652' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.267559' ,`Longitude` = '-95.591929' ,`PhotoCount` = '50' ,`PostalCode` = '77316' ,`RoomCount` = '14' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Pin Oak' ,`StreetNumber` = '7610' ,`StreetSuffix` = 'Street' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom Craftsman on 4.6 UNRESTRICTED Acres! 1-Story 3624 SF, 4 BD, 2 BA Main Home, 3 Car Garage w/Upstairs Bonus Room, 2 Carports w/Electricity (1 w/50amp for RV), 2 Storage Sheds + A/C Workshop (all w/Electricity), Above Ground Pool w/Deck & 720 SF 1BD, 1BA w/Golf Cart Carport + Shed. Property Has 2 Driveways Each w/Automatic Gate. Both Homes Have Their Own Septic, Utilities, & Tax Records So Land Could Be Subdivided. Gourmet Kitchen Has Kent Moore Soft Close Cabinets w/Slide Outs, Thermador Six Burner Stove + Double Oven, Pot Filler, Convection Microwave, Commercial Grade Frigidaire Refrigerator, 2 Islands + Breakfast Bar, a Lg Walk-In Pantry. Back Patio Is Outdoor Kitchen Ready w/Plumbing & Gas. LG Concrete Slab -Also Has Plumbing & Gas. Whole Home Generator, 500 Gallon Propane Tank, Tray Ceilings, Recessed Ambient Lighting, 2 sets of washer & dryers (all are included). Garage Has Extra Storage & Taller Than standard doors so large vehicles fit. 30x50 slab w/plumbing & electricity.' ,`Acres` = '4.6' ,`Area` = '39' ,`BuilderName` = 'America\'s Home Place' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'S942000 - VALLEYWOOD ACRES, LOT 100, ACRES 4.6' ,`LotDesciption` = 'Wooded' ,`LotSize` = '200376' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Salt Water,Vinyl Lined' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Ranch' ,`Subdivision` = 'Valleywood Acres' ,`TaxAmount` = '7215' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691357' WHERE `Matrix_Unique_ID` = '214734481' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:30:53.430' ,`MLSNumber` = '90590824' ,`ListAgentFullName` = 'Joseph Salas' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.296273' ,`Longitude` = '-95.483882' ,`PhotoCount` = '49' ,`PostalCode` = '77304' ,`RoomCount` = '12' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Silverstone' ,`StreetNumber` = '2610' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5103' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is unforgettable. If you don\'t believe me, come see for yourself because as soon as you drive up to the the front of this exclusive gated community, you know you\'re in for a treat. As you pull into the driveway of the property, you see the beautiful, expansive, and well manicured lot with a meticulously cared for 2-story house. You can imagine yourself sitting on the front porch watching the sun rise. Entering the front door you are greeted with the expansive grandeur of the foyer. To the right, you see the dining room with wine room. To the left, you see the beautiful wood floors of the study. Speaking of wood floors, yes, yes that is wood floor inlay with the tile. Going further into the house you see the room open up to beautiful exposed beams of the 2-story ceilings of the living room and kitchen. The kitchen\'s massive granite island with eat-in seating will give you plenty of room to host family or parties. ...TO BE CONTINUED, see you at 2610 Silverstone Way!' ,`Acres` = '1.0136' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVERSTONE 01, BLOCK 2, LOT 84' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44152' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Silverstone 01' ,`TaxAmount` = '13637' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691357' WHERE `Matrix_Unique_ID` = '214749944' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214763939','1668691357','214763939','2022-11-17T06:47:13.830','46784200','Tod Franklin','DFWCityhomes','','','26.271980','-98.300542','15','78573','9','318000.00','Active','Rabbit Run','3101','Avenue','Alton','2','1','3','1849','Single-Family','-High ceilings -Natural stone Cantera-Patio-Open Concept-Spray foam insulation throughout -Quartz countertops-Sprinkler system','0.16','85','Lozan Construction','','','','Reports Available,Seller may be subject to foreign tax and Buyer withholding per IRS','','','','','Central Electric','1','Lot Two Hunderd Five (205), SHARY ESTATES SUBDIVISION PHASE','Subdivision Lot','','','','400','0','','1','','0','','','','','Composition','748 - Mission Consolidated','HURLA M MIDKIFF ELEMENTARY SCHOOL','VETERANS MEMORIAL HIGH SCHOOL (MISSION)','RAFAEL A CANTU JUNIOR HIGH SCHOOL','Appointment Required','Appraisal','1','Contemporary/Modern','Shary Estate Phase II','','','Public Sewer,Public Water','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214765560','1668691357','214765560','2022-11-17T06:59:08.960','38316408','Jennifer Lowe','RE/MAX 1st Team','','','29.320694','-95.460496','30','77583','9','549000.00','Active','Cypress Hill','18327','Drive','Rosharon','3','0','4','2976','Single-Family','$5000 in Seller concessions to buyer. This custom built 4 bed, 3 bath, 3 car garage home located in The Oaks at Suncreek Estates is situated on 1 acre and backs up to the lake. This home offers an open floor plan with formal living and dining areas. Modern grey paint tones, granite countertops in the kitchen and all bathrooms. You will enjoy a large primary bedroom with ensuite bathroom, large secondary bedrooms also have a walk in closet. Coffered ceilings, ship lap accent walls, tall doors, a walk in pantry and gas fireplace are just a few other features in this home. Outside you will enjoy the massive covered patio which is already plumbed with gas and water for an outside kitchen, the large back yard is fully fenced with a three rail fence with 4x4 wire.','1','5','','','Electric Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Rosharon','Central Gas','1','THE OAKS AT SUNCREEK ESTATES (A0067 & A0068 & A0069) BLK 5 L','Other','43560','Appraisal District','','725','0','','3','Gas Oven','0','','','Gas Cooktop','','Composition','5 - Angleton','FRONTIER ELEMENTARY SCHOOL','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front','Appraisal District','1','Ranch','The Oaks At Suncreek Estates','8500','1.986','Aerobic','2019','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:03:07.210' ,`MLSNumber` = '16933540' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.428259' ,`Longitude` = '-95.458527' ,`PhotoCount` = '31' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '289990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1230' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Caden floorplan is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage. The long foyer leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691357' WHERE `Matrix_Unique_ID` = '214770228' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:00:30.513' ,`MLSNumber` = '49029871' ,`ListAgentFullName` = 'Marla McNeilly' ,`ListOfficeName` = 'Texas Legacy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.226878' ,`Longitude` = '-95.657867' ,`PhotoCount` = '41' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '635000.00' ,`Status` = 'Active' ,`StreetName` = 'Gable' ,`StreetNumber` = '40019' ,`StreetSuffix` = 'Circle' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom one story home tucked quietly away on 5.36 acres with 3 car garage plus separate 1 car garage/shop. Freshly painted exterior. Formal dining & study with Brazilian Koa wood floors! The kitchen is a cook\'s dream with a HUGE pantry, island, granite countertops, granite sink, under cabinet lighting, built-in appliances & abundant storage. Family room has corner woodburning fireplace, recessed lighting, tile floors and opens to kitchen. Owners retreat with new carpet offers walk in shower, dual vanities, corner jetted tub & large closet. Split floorplan. Spacious secondary bedrooms with new carpet & walk-in closets. Covered patio. Horses allowed. Low tax rate of 1.86 and private well means no water bill! With 5+acres to call your own, come and enjoy the peace and serenity of country living and call this house YOUR HOME.' ,`Acres` = '5.36' ,`Area` = '15' ,`BuilderName` = 'Design Tech Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CK RANCHETTES 07/BEV HLS, LOT 3, ACRES 5.360' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '233482' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '109' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Ck Ranchettes' ,`TaxAmount` = '8318' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691358' WHERE `Matrix_Unique_ID` = '214775178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:01:55.217' ,`MLSNumber` = '56517771' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.428259' ,`Longitude` = '-95.458527' ,`PhotoCount` = '37' ,`PostalCode` = '77583' ,`RoomCount` = '3' ,`ListPrice` = '284990.00' ,`Status` = 'Active' ,`StreetName` = 'Truckee River' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Caden floorplan is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage. The long foyer leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Blk 4 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691358' WHERE `Matrix_Unique_ID` = '214788511' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214796695','1668691358','214796695','2022-11-17T06:58:44.623','24678511','Christopher Guillotte','BHGRE Gary Greene','','','29.931182','-95.083333','20','77532','9','249999.00','Active','Parral','707','Court','Crosby','2','0','3','1840','Single-Family','EXTRA LARGE BACKYARD!! Gorgeous 3 bed 2 bath home located at the end of a quiet cul-de-sac in the desirable Newport Community. The living area is large with plenty of space to entertain for the holidays. The chef of the home will have TONS of CABINET space in the kitchen with beautiful granite countertops, trending backsplash and a great view of your expansive backyard. Large bedrooms for the kids or guests and an OWNER\'S RETREAT that is sure to please! The backyard has a great deck area for entertaining and plenty of room to create a DREAM OUTDOOR SETTING. Newport features: Newport Country Club, Pool, Gym, Tennis Courts, splash pads, hiking trails, playground, private access to Lake Houston and San Jacinto River. COME SEE TODAY!!','0.3306','1','','','Electric Dryer Connections,Washer Connections','','Corporate Listing,Mud,Sellers Disclosure','1','','','Crosby Area','Central Electric','1','LT 36 BLK 9 NEWPORT SEC 6','Cul-De-Sac,In Golf Course Community,Subdivision Lot','14400','Appraisal District','','55','0','','2','Electric Oven','0','','','Electric Range','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Newport','4770','2.7105','Public Sewer,Public Water,Water District','1991','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T05:25:25.230' ,`MLSNumber` = '73120870' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.435770' ,`Longitude` = '-95.441130' ,`PhotoCount` = '39' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '330990.00' ,`Status` = 'Active' ,`StreetName` = 'Watershed' ,`StreetNumber` = '10606' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lakeway plan is a one-story home featuring 4 bedrooms, 3 baths, and 2 car garage. The foyer opens to one guest bedroom and bath, study and entry coat closet. Kitchen includes breakfast bar with beautiful counter tops and stainless steel appliances. Open concept floorplan boasts large family room and separate dining/breakfast area. Two additional bedrooms and bath are situated just off the common living area. Private primary suite with attractive primary bath features dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Blk 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691358' WHERE `Matrix_Unique_ID` = '214799900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T06:04:51.697' ,`MLSNumber` = '38435644' ,`ListAgentFullName` = 'Cristal Yanes' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.501815' ,`Longitude` = '-95.426456' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Savannah Woods' ,`StreetNumber` = '5611' ,`StreetSuffix` = 'Lane' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2298' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 beds 2 baths Brighton home in Lakes of Savannah! Generous living room space open to formal dining, kitchen and breakfast area. Formal dining accented with attractive archways. Living room boasts with lovely wood look porcelain tile. Spacious kitchen consists of granite countertops, tile backsplash and 1 year new dishwasher and microwave. Enjoy large breakfast area. Faux window coverings throughout. Sizeable primary bedroom provides full private bathroom with relaxing soaking bathtub, separate shower and considerable walk in closet. Vanity seating incorporated in secondary bathroom. Backyard privately fenced. Community lakes, clubhouse, pool, park, splashpad. One owner! Well kept! Call for your private tour!' ,`Acres` = '0.1377' ,`Area` = '5' ,`BuilderName` = 'Brighton Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SAVANNAH MEADOWS SEC 4 (A0562 HT&BRR) BLK 4 LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '670' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'SAVANNAH LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'MANVEL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Savannah Meadows Sec 1-2-3-4-5' ,`TaxAmount` = '8388' ,`TaxRate` = '3.1908' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668691358' WHERE `Matrix_Unique_ID` = '214807285' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214837035','1668691358','214837035','2022-11-17T06:54:26.670','5111178','Janae Allnutt','JLA Realty','','','29.780155','-94.835966','0','77523','8','675000.00','Active','Majestic','5127','Drive','Baytown','3','2','5','3173','Single-Family','This stunning home located in Barbers Hill ISD on the south side is certain to check all the major boxes! This gorgeous home is situated on an acre in a cul de sac with no back or side neighbors. The exterior of the property has plenty of trees with upgraded stone around the poles of the large 40 x 60 insulated shop with a covered awning for extra parking. An amazing chef\'s dream kitchen that includes an induction range top and double JennAir oven with plenty of space and storage await you at this beautiful home. You\'ll love the oversized walk in shower and soaking tub in the primary bathroom. The open concept floor plan of this spacious 5 bedroom home boasts plenty of natural light and room for entertaining indoors and out. A gorgeous beach entry pool off the covered back patio perfect is for the hot summer days. This home in Eagle Heights with plenty of space and privacy is ready for it\'s new owners to call home today.','1.024','53','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Chambers County West','Central Gas','1','LT 43 EAGLE HEIGHTS S/D 140 X 320','Cleared,Cul-De-Sac,Subdivision Lot','44605','Appraisal District','','150','0','','2','Double Oven,Gas Oven','1','In Ground','','Electric Cooktop','','Composition','6 - Barbers Hill','BARBERS HILL SOUTH ELEMENTARY SCHOOL','BARBERS HILL HIGH SCHOOL','BARBERS HILL SOUTH MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Eagle Heights Sub','8092','1.656','Aerobic,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214887634','1668691359','214887634','2022-11-17T06:43:20.350','78827791','Robert Moore','Perry Homes Realty, LLC','','','30.065909','-95.721673','19','77377','6','461900.00','Active','Carriage Harness','20927','Way','Tomball','3','0','4','2188','Single-Family','Perry Homes New Construction! Extended entry with 12-foot ceiling leads to open kitchen, dining area and family room with 10-foot ceilings throughout. Kitchen features corner walk-in pantry and generous island with built-in seating space. Family room features wall of windows. Primary suite with 10-foot ceiling and wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. A Jack-and-Jill bath connects to bedrooms three and four. All bedrooms feature walk-in closets. Covered backyard patio. Mud room off two-car garage.','','35','Perry Homes','','','','Mud,Other Disclosures','1','','','Tomball Southwest','Central Gas','1','Lot 4_Block 1','Subdivision Lot','6075','Unknown','','975','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment','Builder','1','Traditional','Amira','','3.49','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214887697','1668691359','214887697','2022-11-17T06:55:16.450','59772272','Robert Moore','Perry Homes Realty, LLC','','','30.065909','-95.721673','19','77377','8','511900.00','Active','Carriage Harness','20923','Way','Tomball','2','1','4','2488','Single-Family','Perry Homes New Construction! Home office with French doors set at two-story entry. Two-story family room opens to kitchen and morning area. Kitchen features large walk-in pantry and generous island with built-in seating space. Family room features wall of windows. First-floor primary suite includes half bathroom, and bedroom with wall of windows. Dual sinks, garden tub, separate glass-enclosed shower and large walk-in closet in primary bath. Game room and all secondary bedrooms are upstairs. Extended covered patio. Overhead garage.','','35','Perry Homes','','','','Mud,Other Disclosures','1','','','Tomball Southwest','Central Gas','1','Lot 3_Block 1','Greenbelt,Subdivision Lot','6745','Unknown','','975','1','To Be Built/Under Construction','2','Electric Oven','0','','','Gas Cooktop','','Composition','53 - Tomball','GRAND OAKS ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','GRAND LAKES JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment','Builder','2','Traditional','Amira','','3.49','Public Sewer,Public Water','2023','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','214887743','1668691359','214887743','2022-11-17T06:58:21.413','29046936','Nimesh Patel','RE/MAX Fine Properties','','','29.756146','-95.890215','33','77423','10','355000.00','Active','Vallonea Oak','30042','','Fulshear','2','0','3','1932','Single-Family','Welcome home to the David Weekley Gladesdale plan featuring 3 bedrooms, 2 baths, a study, and large open living space, ready for immediate move-in. The Epicurean kitchen features a presentation island and ample room for food storage and meal prep. The open floor plan provides plenty of natural light throughout. The primary bedroom suite presents a serene retreat from the world that includes a deluxe bathroom and walk in closet. Enjoy your morning beverage on the back patio! Easy access to I-10.','0.1396','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Katy - Southwest','Central Gas,Zoned','1','JORDAN RANCH SEC 19, BLOCK 1, LOT 61','Subdivision Lot','6082','Appraisal District','','1050','0','','2','Convection Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','LINDSEY ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Jordan Ranch Sec 19','7281','3.1948','Public Sewer,Public Water,Water District','2020','Appraisal District'); --> New record created successfully